New scripts added to sql4oracle.com

20 January 2010
By

New scripts for generating prototypes of procedure calls is added. The scripts will generate the declare, assign and procedure call.

 

example of generated script:

 

-- *****************************************************************************
-- Oracle PROC script
-- *****************************************************************************
-- copyright 2008 -
www.thomaslundqvist.dk
-- *****************************************************************************
-- package       FND_FLEX_APIS
-- procedure     GET_QUALIFIER_SEGNUM
-- overload      0
-- extract date  20-jan-2010 23:25
-- *****************************************************************************

declare
APPL_ID                                 NUMBER;
KEY_FLEX_CODE                           VARCHAR2(2000);
STRUCTURE_NUMBER                        NUMBER;
FLEX_QUAL_NAME                          VARCHAR2(2000);
SEGMENT_NUMBER                          NUMBER;
BEGIN
--
-- APPL_ID := 0;
-- KEY_FLEX_CODE := '';
-- STRUCTURE_NUMBER := 0;
-- FLEX_QUAL_NAME := '';
--
FND_FLEX_APIS.GET_QUALIFIER_SEGNUM
(APPL_ID                                  => APPL_ID
,KEY_FLEX_CODE                            => KEY_FLEX_CODE
,STRUCTURE_NUMBER                         => STRUCTURE_NUMBER
,FLEX_QUAL_NAME                           => FLEX_QUAL_NAME
,SEGMENT_NUMBER                           => SEGMENT_NUMBER
);
--
end;
/

 Download page

Leave a Reply

Tags