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;
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);
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;
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;
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;
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);