APPS.PO_FED_FIELD_FUNCTIONS dependencies on PO_HEADERS_DRAFT_ALL

Line 743: UPDATE PO_HEADERS_DRAFT_ALL

739:
740:
741: IF(p_draft_id = -1 ) THEN
742: IF p_HiddenAddType = 'ISSUING_OFFICE' THEN
743: UPDATE PO_HEADERS_DRAFT_ALL
744: SET CLM_ISSUING_OFFICE = x_location
745: WHERE PO_HEADER_ID = p_header_id
746: AND DRAFT_ID = XPD_DRAFT_ID;
747: END IF;

Line 749: UPDATE PO_HEADERS_DRAFT_ALL

745: WHERE PO_HEADER_ID = p_header_id
746: AND DRAFT_ID = XPD_DRAFT_ID;
747: END IF;
748: IF p_HiddenAddType = 'COTR_OFFICE' THEN
749: UPDATE PO_HEADERS_DRAFT_ALL
750: SET CLM_COTR_OFFICE = x_location,
751: CLM_COTR_CONTACT = x_contact_id
752: WHERE PO_HEADER_ID = p_header_id
753: AND DRAFT_ID = XPD_DRAFT_ID;

Line 757: UPDATE PO_HEADERS_DRAFT_ALL

753: AND DRAFT_ID = XPD_DRAFT_ID;
754: END IF;
755: ELSE
756: IF p_HiddenAddType = 'ISSUING_OFFICE' THEN
757: UPDATE PO_HEADERS_DRAFT_ALL
758: SET CLM_ISSUING_OFFICE = x_location
759: WHERE PO_HEADER_ID = p_header_id
760: AND DRAFT_ID = XPD_DRAFT_ID;
761: END IF;

Line 763: UPDATE PO_HEADERS_DRAFT_ALL

759: WHERE PO_HEADER_ID = p_header_id
760: AND DRAFT_ID = XPD_DRAFT_ID;
761: END IF;
762: IF p_HiddenAddType = 'COTR_OFFICE' THEN
763: UPDATE PO_HEADERS_DRAFT_ALL
764: SET CLM_COTR_OFFICE = x_location,
765: CLM_COTR_CONTACT = x_contact_id
766: WHERE PO_HEADER_ID = p_header_id
767: AND DRAFT_ID = XPD_DRAFT_ID;

Line 770: UPDATE PO_HEADERS_DRAFT_ALL

766: WHERE PO_HEADER_ID = p_header_id
767: AND DRAFT_ID = XPD_DRAFT_ID;
768: END IF;
769: IF p_HiddenAddType = 'MOD_ADMIN_OFFICE' THEN
770: UPDATE PO_HEADERS_DRAFT_ALL
771: SET CLM_MOD_ADMIN_OFFICE = x_location
772: WHERE PO_HEADER_ID = p_header_id
773: AND DRAFT_ID = XPD_DRAFT_ID;
774: END IF;

Line 776: UPDATE PO_HEADERS_DRAFT_ALL

772: WHERE PO_HEADER_ID = p_header_id
773: AND DRAFT_ID = XPD_DRAFT_ID;
774: END IF;
775: IF p_HiddenAddType = 'MOD_ISSUING_OFFICE' THEN
776: UPDATE PO_HEADERS_DRAFT_ALL
777: SET CLM_MOD_ISSUING_OFFICE = x_location
778: WHERE PO_HEADER_ID = p_header_id
779: AND DRAFT_ID = XPD_DRAFT_ID;
780: END IF;

Line 782: UPDATE PO_HEADERS_DRAFT_ALL

778: WHERE PO_HEADER_ID = p_header_id
779: AND DRAFT_ID = XPD_DRAFT_ID;
780: END IF;
781: IF p_HiddenAddType = 'REQ_OFFICE' THEN
782: UPDATE PO_HEADERS_DRAFT_ALL
783: SET CLM_REQ_OFFICE = x_location
784: WHERE PO_HEADER_ID = p_header_id
785: AND DRAFT_ID = XPD_DRAFT_ID;
786: END IF;

Line 1138: UPDATE PO_HEADERS_DRAFT_ALL

1134:
1135:
1136: BEGIN
1137:
1138: UPDATE PO_HEADERS_DRAFT_ALL
1139: SET CLM_PRIORITY_CODE = p_priority
1140: WHERE PO_HEADER_ID = p_header_id
1141: AND Draft_id = XPD_DRAFT_ID;
1142:

Line 2731: FROM po_headers_draft_all

2727:
2728: ELSE
2729: SELECT vendor_id,vendor_site_id,vendor_contact_id
2730: INTO l_supplier_id,l_supplier_site_id,l_contact_id
2731: FROM po_headers_draft_all
2732: WHERE po_header_id = l_po_header_id
2733: AND draft_id = draft_id;
2734:
2735: END IF;