DBA Data[Home] [Help]

APPS.BSC_DIMENSION_EDIT dependencies on BSC_EDIT_VLIST

Line 558: l_fklist in BSC_EDIT_VLIST,

554: end;
555:
556: procedure insertNormalRowNWM(l_dim_table in varchar2,
557: l_user_code in varchar2, l_name in varchar2, l_parentcount in number,
558: l_fklist in BSC_EDIT_VLIST,
559: l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,
560: l_message out nocopy varchar2) is
561: TYPE curcode IS REF CURSOR;
562: cv curcode;

Line 559: l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,

555:
556: procedure insertNormalRowNWM(l_dim_table in varchar2,
557: l_user_code in varchar2, l_name in varchar2, l_parentcount in number,
558: l_fklist in BSC_EDIT_VLIST,
559: l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,
560: l_message out nocopy varchar2) is
561: TYPE curcode IS REF CURSOR;
562: cv curcode;
563: l_stmt varchar2(5000);

Line 621: l_fklist in BSC_EDIT_VLIST,

617: end insertNormalRowNWM;
618:
619: procedure updateNormalRowNWM(l_dim_table in varchar2, l_code in number,
620: l_user_code in varchar2, l_name in varchar2,l_parentcount in number,
621: l_fklist in BSC_EDIT_VLIST,
622: l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,
623: l_message out nocopy varchar2
624: )is
625: TYPE curcode IS REF CURSOR;

Line 622: l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,

618:
619: procedure updateNormalRowNWM(l_dim_table in varchar2, l_code in number,
620: l_user_code in varchar2, l_name in varchar2,l_parentcount in number,
621: l_fklist in BSC_EDIT_VLIST,
622: l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,
623: l_message out nocopy varchar2
624: )is
625: TYPE curcode IS REF CURSOR;
626: cv curcode;

Line 680: l_fklist in BSC_EDIT_VLIST,

676: end updateNormalRowNWM;
677:
678: procedure saveNormalRowNWM(l_dim_table in varchar2, l_code in number,
679: l_user_code in varchar2, l_name in varchar2, l_parentcount in number,
680: l_fklist in BSC_EDIT_VLIST,
681: l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,
682: l_message out nocopy varchar2) is
683: l_code_number number;
684: l_fkcode_number number;

Line 681: l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,

677:
678: procedure saveNormalRowNWM(l_dim_table in varchar2, l_code in number,
679: l_user_code in varchar2, l_name in varchar2, l_parentcount in number,
680: l_fklist in BSC_EDIT_VLIST,
681: l_fkvaluelist in BSC_EDIT_VLIST, l_fkuservaluelist in BSC_EDIT_VLIST,
682: l_message out nocopy varchar2) is
683: l_code_number number;
684: l_fkcode_number number;
685: l_name2 varchar2(2000);