APPS.PO_FED_FIELD_FUNCTIONS dependencies on PO_REQUISITION_HEADERS_ALL

Line 657: UPDATE PO_REQUISITION_HEADERS_ALL

653: END IF;
654:
655: IF p_HiddenAddType = 'ISSUING_OFFICE' THEN
656:
657: UPDATE PO_REQUISITION_HEADERS_ALL
658: SET CLM_ISSUING_OFFICE = x_location,
659: CLM_COTR_CONTACT = x_contact_id
660: WHERE REQUISITION_HEADER_ID = p_header_id;
661:

Line 666: UPDATE PO_REQUISITION_HEADERS_ALL

662: END IF;
663:
664: IF p_HiddenAddType = 'COTR_OFFICE' THEN
665:
666: UPDATE PO_REQUISITION_HEADERS_ALL
667: SET CLM_COTR_OFFICE = x_location,
668: CLM_COTR_CONTACT = x_contact_id
669: WHERE REQUISITION_HEADER_ID = p_header_id;
670:

Line 675: UPDATE PO_REQUISITION_HEADERS_ALL

671: END IF;
672:
673: IF p_HiddenAddType = 'REQ_OFFICE' THEN
674:
675: UPDATE PO_REQUISITION_HEADERS_ALL
676: SET CLM_REQ_OFFICE = x_location,
677: CLM_REQ_CONTACT = x_contact_id
678: WHERE REQUISITION_HEADER_ID = p_header_id;
679:

Line 684: UPDATE PO_REQUISITION_HEADERS_ALL

680: END IF;
681:
682: IF p_HiddenAddType = 'ASSIST_OFFICE' THEN
683:
684: UPDATE PO_REQUISITION_HEADERS_ALL
685: SET CLM_ASSIST_OFFICE = x_location,
686: CLM_ASSIST_CONTACT = x_contact_id
687: WHERE REQUISITION_HEADER_ID = p_header_id;
688:

Line 1103: UPDATE PO_REQUISITION_HEADERS_ALL

1099: WHERE LOOKUP_TYPE = 'PO_CLM_CUSTOMER_PROJECT_CODE'
1100: AND LOOKUP_CODE = p_cust_proj_code;
1101: END IF;
1102:
1103: UPDATE PO_REQUISITION_HEADERS_ALL
1104: SET CLM_PRIORITY_CODE = p_priority
1105: WHERE REQUISITION_HEADER_ID = p_header_id;
1106:
1107: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1592: UPDATE PO_REQUISITION_HEADERS_ALL

1588:
1589:
1590: BEGIN
1591:
1592: UPDATE PO_REQUISITION_HEADERS_ALL
1593: SET SUGGESTED_AWARD_NO = p_suggest_aw_no
1594: WHERE REQUISITION_HEADER_ID = p_header_id;
1595:
1596: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3647: FROM po_requisition_headers_all

3643: END IF;
3644: END IF;
3645:
3646: select nvl(clm_mipr_type, 'NONE') into l_mipr_type
3647: FROM po_requisition_headers_all
3648: WHERE requisition_header_id = p_header_id AND ROWNUM = 1;
3649:
3650: IF l_mipr_type = 'MIPR_OTHERS' THEN
3651: IF p_acceptance_status IS NULL THEN