APPS.GMS_AWARDS_DIST_PKG dependencies on PO_DISTRIBUTIONS_ALL

Line 245: update po_distributions_all

241: -- Need to update the Distribution line with the
242: -- new award_set_id
243: -- ----------------------------------------------
244: IF p_doc_type = 'PO' THEN
245: update po_distributions_all
246: set award_id = x_new_award_set_id
247: where po_distribution_id = p_dist_id
248: and award_id = p_award_set_id
249: and exists ( select 'X'

Line 1145: FROM po_distributions_all pod,

1141: pod.creation_date creation_date,
1142: pod.last_updated_by last_updated_by,
1143: pod.created_by created_by,
1144: nvl(pod.last_update_login,0) last_update_login
1145: FROM po_distributions_all pod,
1146: pa_projects_all p,
1147: gms_project_types gpt
1148: WHERE pod.po_header_id = p_header_id
1149: AND pod.project_id = p.project_id

Line 1166: po_distributions_all pod

1162: WHERE adl.document_type = 'PO'
1163: AND adl.adl_status = 'I'
1164: AND adl.award_set_id in ( SELECT adl2.award_set_id
1165: FROM gms_award_distributions adl2,
1166: po_distributions_all pod
1167: WHERE pod.po_header_Id = p_header_id
1168: AND pod.award_id is not null
1169: AND adl2.award_set_id = pod.award_id
1170: AND adl2.po_distribution_id =pod.po_distribution_id

Line 1184: po_distributions_all pod

1180: WHERE adl.document_type = 'PO'
1181: AND adl.adl_status = 'A'
1182: AND adl.award_set_id in (SELECT adl2.award_set_id
1183: FROM gms_award_distributions adl2,
1184: po_distributions_all pod
1185: WHERE pod.po_header_id = p_header_id
1186: AND pod.award_id is not null
1187: AND adl2.award_set_id <> pod.award_id
1188: AND adl2.po_distribution_id =pod.po_distribution_id

Line 1197: UPDATE po_distributions_all pod

1193: -- ==================================================
1194: -- Update award_id to NULL for non sponsored
1195: -- projects.
1196: -- =================================================
1197: UPDATE po_distributions_all pod
1198: SET award_id = NULL
1199: WHERE pod.po_header_id = p_header_id
1200: AND pod.award_id is not NULL
1201: AND pod.po_distribution_id in ( SELECT pod2.po_distribution_id

Line 1202: FROM po_distributions_all pod2,

1198: SET award_id = NULL
1199: WHERE pod.po_header_id = p_header_id
1200: AND pod.award_id is not NULL
1201: AND pod.po_distribution_id in ( SELECT pod2.po_distribution_id
1202: FROM po_distributions_all pod2,
1203: pa_projects_all p,
1204: gms_project_types gpt
1205: WHERE pod2.po_header_id = p_header_id
1206: AND pod2.project_id = p.project_id

Line 1318: UPDATE po_distributions_all

1314: -- Update po distribution with the award set id.
1315: -- End of comment.
1316:
1317: FORALL k in l_distribution_id.FIRST..l_distribution_id.LAST
1318: UPDATE po_distributions_all
1319: SET award_id = l_new_award_set_id(k)
1320: WHERE po_header_id = p_header_id
1321: AND po_distribution_id = l_distribution_id(k) ;
1322: