APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_HEADERS_ALL

Line 968: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

964: d_position NUMBER;
965:
966:
967: l_approval_method VARCHAR2(30);
968: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
969:
970: l_fund_reserve_result VARCHAR2(1);
971: l_return_status VARCHAR2(1);
972: l_need_to_encumber VARCHAR2(1);

Line 1176: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

1172: l_approval_method VARCHAR2(30);
1173: l_return_status VARCHAR2(1);
1174: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;
1175:
1176: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
1177:
1178: l_need_to_create_src_rules VARCHAR2(1);
1179: l_lines src_rule_lines_rec_type;
1180: BEGIN

Line 1607: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

1603: d_api_name CONSTANT VARCHAR2(30) := 'create_standard_po';
1604: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1605: d_position NUMBER;
1606:
1607: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
1608: l_approval_method VARCHAR2(30);
1609: l_need_to_encumber VARCHAR2(1);
1610: l_fund_reserve_result VARCHAR2(1);
1611: l_return_status VARCHAR2(1);

Line 1809: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

1805: d_position NUMBER;
1806:
1807:
1808: l_approval_method VARCHAR2(30);
1809: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
1810: l_update_auth_status VARCHAR2(1);
1811:
1812: l_need_to_encumber VARCHAR2(1);
1813: l_fund_reserve_result VARCHAR2(1);

Line 1987: UPDATE po_headers_all

1983: IF (PO_LOG.d_stmt) THEN
1984: PO_LOG.stmt(d_module, d_position, 'l_expiration_date', l_expiration_date);
1985: END IF;
1986:
1987: UPDATE po_headers_all
1988: SET start_date = NVL(start_date, l_expiration_date),
1989: end_date = l_expiration_date,
1990: last_updated_by = FND_GLOBAL.user_id,
1991: last_update_date = SYSDATE

Line 2029: l_document_num PO_HEADERS_ALL.segment1%TYPE;

2025: d_api_name CONSTANT VARCHAR2(30) := 'assign_document_number';
2026: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2027: d_position NUMBER;
2028:
2029: l_document_num PO_HEADERS_ALL.segment1%TYPE;
2030:
2031: BEGIN
2032:
2033: d_position := 0;

Line 2286: FROM po_headers_all

2282: SELECT vendor_id,
2283: vendor_site_id
2284: INTO l_vendor_id,
2285: l_vendor_site_id
2286: FROM po_headers_all
2287: WHERE po_header_id = p_doc_rec.po_header_id;
2288:
2289: FOR i IN 1..p_lines.po_line_id_tbl.COUNT LOOP
2290: d_position := 30;

Line 2610: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;

2606: d_api_name CONSTANT VARCHAR2(30) := 'update_document_status';
2607: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2608: d_position NUMBER;
2609:
2610: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
2611: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
2612:
2613: BEGIN
2614:

Line 2611: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;

2607: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2608: d_position NUMBER;
2609:
2610: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
2611: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
2612:
2613: BEGIN
2614:
2615: d_position := 0;

Line 2654: UPDATE po_headers_all

2650: PO_LOG.stmt(d_module, d_position, 'l_approved_date', l_approved_date);
2651: END IF;
2652:
2653: d_position := 10;
2654: UPDATE po_headers_all
2655: SET authorization_status = p_auth_status,
2656: approved_flag = l_approved_flag,
2657: approved_date = DECODE(l_approved_date,
2658: FND_API.G_MISS_DATE, approved_date,

Line 2938: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;

2934:
2935: l_doc_type VARCHAR2(30);
2936: l_doc_subtype VARCHAR2(30);
2937:
2938: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2939: l_default_method VARCHAR2(30);
2940: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;
2941: l_fax_number VARCHAR2(100);
2942: l_document_num PO_HEADERS_ALL.segment1%TYPE;

Line 2942: l_document_num PO_HEADERS_ALL.segment1%TYPE;

2938: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2939: l_default_method VARCHAR2(30);
2940: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;
2941: l_fax_number VARCHAR2(100);
2942: l_document_num PO_HEADERS_ALL.segment1%TYPE;
2943:
2944: l_email_flag VARCHAR2(1) := 'N';
2945: l_fax_flag VARCHAR2(1) := 'N';
2946: l_print_flag VARCHAR2(1) := 'N';