APPS.PO_COPYDOC_S1 dependencies on PO_DISTRIBUTIONS_ALL

Line 2022: l_award_id PO_DISTRIBUTIONS_ALL.award_id%TYPE := NULL;

2018:
2019: --
2020: l_msg_buf VARCHAR2(2000);
2021: l_gms_po_interface_obj gms_po_interface_type;
2022: l_award_id PO_DISTRIBUTIONS_ALL.award_id%TYPE := NULL;
2023: --
2024:
2025: BEGIN
2026:

Line 3333: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;

3329: l_line_id PO_LINES_ALL.po_line_id%TYPE;
3330: l_line_num PO_LINES_ALL.line_num%TYPE;
3331: l_line_location_id PO_LINE_LOCATIONS_ALL.line_location_id%TYPE;
3332: l_shipment_num PO_LINE_LOCATIONS_ALL.shipment_num%TYPE;
3333: l_distribution_type PO_DISTRIBUTIONS_ALL.distribution_type%TYPE;
3334:
3335: BEGIN
3336:
3337: l_progress := '000';

Line 4794: UPDATE PO_DISTRIBUTIONS_ALL

4790: ELSIF p_level = 'DISTRIBUTION' THEN
4791:
4792: IF PO_CLM_CLO_UTIL.Isclminstalled THEN
4793:
4794: UPDATE PO_DISTRIBUTIONS_ALL
4795: SET uda_template_id = x_po_distribution_rec.uda_template_id,
4796: clm_misc_loa = x_po_distribution_rec.clm_misc_loa,
4797: clm_defence_funding = x_po_distribution_rec.clm_defence_funding,
4798: clm_fms_case_number = x_po_distribution_rec.clm_fms_case_number,

Line 4811: FROM po_distributions_all

4807: END IF;
4808:
4809: SELECT UDA_TEMPLATE_ID
4810: INTO l_template_id
4811: FROM po_distributions_all
4812: WHERE PO_DISTRIBUTION_ID = p_from_pk_value;
4813:
4814: IF l_template_id IS NULL THEN
4815: RETURN;