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 1125: FROM po_distributions_all pod,

1121: pod.creation_date creation_date,
1122: pod.last_updated_by last_updated_by,
1123: pod.created_by created_by,
1124: nvl(pod.last_update_login,0) last_update_login
1125: FROM po_distributions_all pod,
1126: pa_projects_all p,
1127: gms_project_types gpt
1128: WHERE pod.po_header_id = p_header_id
1129: AND pod.project_id = p.project_id

Line 1146: po_distributions_all pod

1142: WHERE adl.document_type = 'PO'
1143: AND adl.adl_status = 'I'
1144: AND adl.award_set_id in ( SELECT adl2.award_set_id
1145: FROM gms_award_distributions adl2,
1146: po_distributions_all pod
1147: WHERE pod.po_header_Id = p_header_id
1148: AND pod.award_id is not null
1149: AND adl2.award_set_id = pod.award_id
1150: AND adl2.po_distribution_id =pod.po_distribution_id

Line 1164: po_distributions_all pod

1160: WHERE adl.document_type = 'PO'
1161: AND adl.adl_status = 'A'
1162: AND adl.award_set_id in (SELECT adl2.award_set_id
1163: FROM gms_award_distributions adl2,
1164: po_distributions_all pod
1165: WHERE pod.po_header_id = p_header_id
1166: AND pod.award_id is not null
1167: AND adl2.award_set_id <> pod.award_id
1168: AND adl2.po_distribution_id =pod.po_distribution_id

Line 1177: UPDATE po_distributions_all pod

1173: -- ==================================================
1174: -- Update award_id to NULL for non sponsored
1175: -- projects.
1176: -- =================================================
1177: UPDATE po_distributions_all pod
1178: SET award_id = NULL
1179: WHERE pod.po_header_id = p_header_id
1180: AND pod.award_id is not NULL
1181: AND pod.po_distribution_id in ( SELECT pod2.po_distribution_id

Line 1182: FROM po_distributions_all pod2,

1178: SET award_id = NULL
1179: WHERE pod.po_header_id = p_header_id
1180: AND pod.award_id is not NULL
1181: AND pod.po_distribution_id in ( SELECT pod2.po_distribution_id
1182: FROM po_distributions_all pod2,
1183: pa_projects_all p,
1184: gms_project_types gpt
1185: WHERE pod2.po_header_id = p_header_id
1186: AND pod2.project_id = p.project_id

Line 1298: UPDATE po_distributions_all

1294: -- Update po distribution with the award set id.
1295: -- End of comment.
1296:
1297: FORALL k in l_distribution_id.FIRST..l_distribution_id.LAST
1298: UPDATE po_distributions_all
1299: SET award_id = l_new_award_set_id(k)
1300: WHERE po_header_id = p_header_id
1301: AND po_distribution_id = l_distribution_id(k) ;
1302: