APPS.GMS_PO_API_GRP dependencies on GMS_AWARD_DISTRIBUTIONS

Line 94: INSERT into gms_award_distributions

90: return ;
91: END IF ;
92:
93: FORALL i in p_interface_obj.distribution_id.FIRST..p_interface_obj.distribution_id.LAST
94: INSERT into gms_award_distributions
95: ( award_set_id ,
96: adl_line_num,
97: funding_pattern_id,
98: distribution_value ,

Line 184: from gms_award_distributions

180: fnd_global.user_id , --created_by ,
181: SYSDATE, --creation_date ,
182: last_update_login ,
183: billable_flag
184: from gms_award_distributions
185: where award_set_id = p_interface_obj.award_set_id_in(i)
186: and adl_line_num = 1 ;
187:
188: FOR i in 1..p_interface_obj.distribution_id.count LOOP

Line 192: from gms_award_distributions

188: FOR i in 1..p_interface_obj.distribution_id.count LOOP
189:
190: select award_set_id
191: into l_dummy
192: from gms_award_distributions
193: where po_distribution_id = p_interface_obj.distribution_id(i)
194: and document_type = 'PO'
195: and adl_status = 'A'
196: and fc_status = 'N' ;

Line 248: l_adls_rec gms_award_distributions%ROWTYPE;

244: p_project_id IN NUMBER,
245: p_task_id IN NUMBER,
246: p_award_set_id IN NUMBER ) is
247:
248: l_adls_rec gms_award_distributions%ROWTYPE;
249: l_cursor_found boolean ;
250: l_msg_count NUMBER ;
251: l_msg_data varchar2(2000) ;
252: l_return_status varchar2(1) ;

Line 257: from gms_award_distributions

253: l_api_name varchar2(50) := 'create_copy_doc_adl' ;
254:
255: cursor c_adl is
256: select *
257: from gms_award_distributions
258: where award_set_id = p_award_set_id
259: and adl_line_num = 1 ;
260: begin
261: -- Standrad call to check API compatibility.

Line 651: gms_award_distributions adl

647:
648: cursor c1 is
649: select awd.award_number
650: from gms_awards_all awd,
651: gms_award_distributions adl
652: where adl.award_id = awd.award_id
653: and adl.award_set_id = p_award_set_id
654: and adl.adl_line_num = 1 ;
655: begin

Line 1138: l_adl_rec gms_award_distributions%ROWTYPE;

1134: l_msg_count NUMBER ;
1135: l_msg_data varchar2(2000) ;
1136: l_return_status varchar2(1) := fnd_api.G_RET_STS_SUCCESS;
1137: l_api_name varchar2(50) := 'create_pdoi_adls' ;
1138: l_adl_rec gms_award_distributions%ROWTYPE;
1139: l_gms_enabled BOOLEAN ;
1140:
1141: BEGIN
1142: --

Line 1252: gms_award_distributions adl

1248:
1249: select awd.award_number
1250: into l_award_number
1251: from gms_awards_all awd,
1252: gms_award_distributions adl
1253: where adl.award_set_id = p_award_set_id
1254: and adl.award_id = awd.award_id
1255: and adl.adl_line_num = 1 ;
1256:

Line 1294: l_adl_rec gms_award_distributions%ROWTYPE ;

1290: p_award_number in varchar2,
1291: p_po_distribution_id in number,
1292: x_award_set_id_out out nocopy number ) is
1293:
1294: l_adl_rec gms_award_distributions%ROWTYPE ;
1295: l_award_id gms_awards_all.award_id%TYPE ;
1296: l_msg_count number ;
1297: l_msg_data varchar2(2000) ;
1298: l_return_status varchar2(1) ;

Line 1420: l_adl_rec gms_award_distributions%ROWTYPE ;

1416: p_award_number in varchar2,
1417: p_po_distribution_id in number,
1418: x_award_set_id_out out nocopy number ) is
1419:
1420: l_adl_rec gms_award_distributions%ROWTYPE ;
1421: l_create_flag varchar2(1) ;
1422: l_update_flag varchar2(1) ;
1423: l_award_set_id_out number ;
1424: l_award_id gms_awards_all.award_id%TYPE ;

Line 1472: from gms_award_distributions

1468: created_by,
1469: creation_date,
1470: last_update_login,
1471: billable_flag
1472: from gms_award_distributions
1473: where award_set_id = p_award_set_id_in
1474: and document_type = 'PO'
1475: and po_distribution_id = p_po_distribution_id
1476: and adl_line_num = 1 ;

Line 1699: delete from gms_award_distributions

1695: END IF ;
1696:
1697: IF p_po_distribution_id is NULL THEN
1698:
1699: delete from gms_award_distributions
1700: where award_set_id = p_award_set_id_in
1701: and document_type = 'PO'
1702: and adl_line_num = 1
1703: and po_distribution_id is NULL ;

Line 1705: delete from gms_award_distributions

1701: and document_type = 'PO'
1702: and adl_line_num = 1
1703: and po_distribution_id is NULL ;
1704: ELSE
1705: delete from gms_award_distributions
1706: where award_set_id = p_award_set_id_in
1707: and document_type = 'PO'
1708: and adl_line_num = 1
1709: and po_distribution_id = p_po_distribution_id ;