DBA Data[Home] [Help]

APPS.AMS_LIST_WF dependencies on AMS_LISTHEADER_PVT

Line 100: l_clistheader_rec AMS_ListHeader_PVT.list_header_rec_type;

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

Line 101: l_listheader_rec AMS_ListHeader_PVT.list_header_rec_type;

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:

Line 133: AMS_ListHeader_PVT.Init_listheader_rec(l_listheader_rec );

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,

Line 136: AMS_ListHeader_PVT.Complete_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

Line 690: l_clistheader_rec AMS_ListHeader_PVT.list_header_rec_type;

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

Line 691: l_listheader_rec AMS_ListHeader_PVT.list_header_rec_type;

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;

Line 727: AMS_ListHeader_PVT.Init_listheader_rec(l_listheader_rec );

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,

Line 730: AMS_ListHeader_PVT.Complete_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