APPS.GMS_PO_API2_GRP dependencies on GMS_AWARD_DISTRIBUTIONS

Line 188: INSERT into gms_award_distributions

184: return ;
185: END IF ;
186:
187: FORALL i in p_interface_obj.distribution_id.FIRST..p_interface_obj.distribution_id.LAST
188: INSERT into gms_award_distributions
189: ( award_set_id ,
190: adl_line_num,
191: funding_pattern_id,
192: distribution_value ,

Line 278: from gms_award_distributions

274: fnd_global.user_id , --created_by ,
275: SYSDATE, --creation_date ,
276: last_update_login ,
277: billable_flag
278: from gms_award_distributions
279: where award_set_id = p_interface_obj.award_set_id_in(i)
280: and adl_line_num = 1 ;
281:
282: FOR i in 1..p_interface_obj.distribution_id.count LOOP

Line 286: from gms_award_distributions

282: FOR i in 1..p_interface_obj.distribution_id.count LOOP
283:
284: select award_set_id
285: into l_dummy
286: from gms_award_distributions
287: where po_distribution_id = p_interface_obj.distribution_id(i)
288: and document_type = 'PO'
289: and adl_status = 'A'
290: and fc_status = 'N' ;

Line 552: delete from gms_award_distributions adl

548: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
549: -- Program logic begins here
550: IF p_in_rec.entity_ids.COUNT > 0 THEN
551: FORALL i in p_in_rec.entity_ids.first.. p_in_rec.entity_ids.last
552: delete from gms_award_distributions adl
553: where ( award_set_id , po_distribution_id) in
554: ( select pod.award_id, po_distribution_id
555: from po_distributions_all pod
556: where pod.po_header_id = p_in_rec.entity_ids(i)

Line 636: from gms_awards_all awd, gms_award_distributions adl

632: l_count := l_index ;
633:
634: select awd.award_number
635: into l_award_number
636: from gms_awards_all awd, gms_award_distributions adl
637: where adl.award_set_id = l_award_set_id
638: and adl.award_id = awd.award_id ;
639:
640: x_award_num_tbl(l_index) := l_award_number ;