96: itemtype VARCHAR2(30) := 'AMSLISTG';
97: itemkey VARCHAR2(30) ;
98: itemuserkey VARCHAR2(80) ;
99:
100: l_clistheader_rec AMS_ListHeader_PVT.list_header_rec_type;
101: l_listheader_rec AMS_ListHeader_PVT.list_header_rec_type;
102: l_display_name varchar2(360);
103: l_requester_role varchar2(360);
104: l_return_status varchar2(1);
97: itemkey VARCHAR2(30) ;
98: itemuserkey VARCHAR2(80) ;
99:
100: l_clistheader_rec AMS_ListHeader_PVT.list_header_rec_type;
101: l_listheader_rec AMS_ListHeader_PVT.list_header_rec_type;
102: l_display_name varchar2(360);
103: l_requester_role varchar2(360);
104: l_return_status varchar2(1);
105:
129: Ams_Utility_pvt.debug_message('Item key : '||itemkey);
130: END IF;
131:
132: --dbms_output.put_line('Start');
133: AMS_ListHeader_PVT.Init_listheader_rec(l_listheader_rec );
134: l_listheader_rec.list_header_id := p_list_header_id;
135:
136: AMS_ListHeader_PVT.Complete_ListHeader_rec(
137: p_listheader_rec => l_listheader_rec,
132: --dbms_output.put_line('Start');
133: AMS_ListHeader_PVT.Init_listheader_rec(l_listheader_rec );
134: l_listheader_rec.list_header_id := p_list_header_id;
135:
136: AMS_ListHeader_PVT.Complete_ListHeader_rec(
137: p_listheader_rec => l_listheader_rec,
138: x_complete_rec => l_clistheader_rec
139: ) ;
140: update ams_list_headers_all
686: -- itemtype VARCHAR2(30) := 'AMSLISTG';
687: -- itemkey VARCHAR2(30) ;
688: itemuserkey VARCHAR2(80) ;
689:
690: l_clistheader_rec AMS_ListHeader_PVT.list_header_rec_type;
691: l_listheader_rec AMS_ListHeader_PVT.list_header_rec_type;
692: l_display_name varchar2(360);
693: l_requester_role varchar2(360);
694: l_return_status varchar2(1);
687: -- itemkey VARCHAR2(30) ;
688: itemuserkey VARCHAR2(80) ;
689:
690: l_clistheader_rec AMS_ListHeader_PVT.list_header_rec_type;
691: l_listheader_rec AMS_ListHeader_PVT.list_header_rec_type;
692: l_display_name varchar2(360);
693: l_requester_role varchar2(360);
694: l_return_status varchar2(1);
695: l_list_header_id number;
723: p_msg_data => 'WF_INIT_VAR: started',
724: p_msg_type => 'DEBUG'
725: );
726:
727: AMS_ListHeader_PVT.Init_listheader_rec(l_listheader_rec );
728: l_listheader_rec.list_header_id := l_list_header_id;
729:
730: AMS_ListHeader_PVT.Complete_ListHeader_rec(
731: p_listheader_rec => l_listheader_rec,
726:
727: AMS_ListHeader_PVT.Init_listheader_rec(l_listheader_rec );
728: l_listheader_rec.list_header_id := l_list_header_id;
729:
730: AMS_ListHeader_PVT.Complete_ListHeader_rec(
731: p_listheader_rec => l_listheader_rec,
732: x_complete_rec => l_clistheader_rec
733: ) ;
734: update ams_list_headers_all