eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_PDOI_POSTPROC_PVT dependencies on PO_HEADERS_ALL

Line 1099: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

1095: d_position NUMBER;
1096:
1097:
1098: l_approval_method VARCHAR2(30);
1099: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
1100:
1101: l_fund_reserve_result VARCHAR2(1);
1102: l_return_status VARCHAR2(1);
1103: l_need_to_encumber VARCHAR2(1);

Line 1338: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

1334: l_approval_method VARCHAR2(30);
1335: l_return_status VARCHAR2(1);
1336: l_doc_info PO_PDOI_PARAMS.doc_info_rec_type;
1337:
1338: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
1339:
1340: l_need_to_create_src_rules VARCHAR2(1);
1341: l_lines src_rule_lines_rec_type;
1342: BEGIN

Line 1791: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

1787: d_api_name CONSTANT VARCHAR2(30) := 'create_standard_po';
1788: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
1789: d_position NUMBER;
1790:
1791: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
1792: l_approval_method VARCHAR2(30);
1793: l_need_to_encumber VARCHAR2(1);
1794: l_fund_reserve_result VARCHAR2(1);
1795: l_return_status VARCHAR2(1);

Line 1866: FROM PO_HEADERS_ALL

1862: d_position := 30;
1863: BEGIN
1864: SELECT ORG_ID
1865: INTO l_org_id
1866: FROM PO_HEADERS_ALL
1867: WHERE PO_HEADER_ID = p_doc_rec.PHI_PO_HEADER_ID;
1868: EXCEPTION
1869: WHEN NO_DATA_FOUND THEN
1870: l_org_id := NULL;

Line 2248: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;

2244: d_position NUMBER;
2245:
2246:
2247: l_approval_method VARCHAR2(30);
2248: l_new_auth_status PO_HEADERS_ALL.authorization_status%TYPE;
2249: l_update_auth_status VARCHAR2(1);
2250:
2251: --ACRN proj
2252: l_int_header_id NUMBER;

Line 2298: FROM PO_HEADERS_ALL

2294: -- ACRN proj start
2295: BEGIN
2296: SELECT ORG_ID
2297: INTO l_org_id
2298: FROM PO_HEADERS_ALL
2299: WHERE PO_HEADER_ID = p_doc_rec.PHI_PO_HEADER_ID;
2300: EXCEPTION
2301: WHEN NO_DATA_FOUND THEN
2302: l_org_id := NULL;

Line 2562: UPDATE po_headers_all

2558: IF (PO_LOG.d_stmt) THEN
2559: PO_LOG.stmt(d_module, d_position, 'l_expiration_date', l_expiration_date);
2560: END IF;
2561:
2562: UPDATE po_headers_all
2563: SET start_date = NVL(start_date, l_expiration_date),
2564: end_date = l_expiration_date,
2565: last_updated_by = FND_GLOBAL.user_id,
2566: last_update_date = SYSDATE

Line 2604: l_document_num PO_HEADERS_ALL.segment1%TYPE;

2600: d_api_name CONSTANT VARCHAR2(30) := 'assign_document_number';
2601: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
2602: d_position NUMBER;
2603:
2604: l_document_num PO_HEADERS_ALL.segment1%TYPE;
2605:
2606: BEGIN
2607:
2608: d_position := 0;

Line 2864: FROM po_headers_all

2860: SELECT vendor_id,
2861: vendor_site_id
2862: INTO l_vendor_id,
2863: l_vendor_site_id
2864: FROM po_headers_all
2865: WHERE po_header_id = p_doc_rec.po_header_id;
2866:
2867: FOR i IN 1..p_lines.po_line_id_tbl.COUNT LOOP
2868: d_position := 30;

Line 3200: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;

3196: d_api_name CONSTANT VARCHAR2(30) := 'update_document_status';
3197: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3198: d_position NUMBER;
3199:
3200: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
3201: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
3202:
3203: BEGIN
3204:

Line 3201: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;

3197: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';
3198: d_position NUMBER;
3199:
3200: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
3201: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
3202:
3203: BEGIN
3204:
3205: d_position := 0;

Line 3249: UPDATE po_headers_all

3245: PO_LOG.stmt(d_module, d_position, 'l_approved_date', l_approved_date);
3246: END IF;
3247:
3248: d_position := 10;
3249: UPDATE po_headers_all
3250: SET authorization_status = p_auth_status,
3251: approved_flag = l_approved_flag,
3252: approved_date = DECODE(l_approved_date,
3253: FND_API.G_MISS_DATE, approved_date,

Line 3533: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;

3529:
3530: l_doc_type VARCHAR2(30);
3531: l_doc_subtype VARCHAR2(30);
3532:
3533: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
3534: l_default_method VARCHAR2(30);
3535: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;
3536: l_fax_number VARCHAR2(100);
3537: l_document_num PO_HEADERS_ALL.segment1%TYPE;

Line 3537: l_document_num PO_HEADERS_ALL.segment1%TYPE;

3533: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
3534: l_default_method VARCHAR2(30);
3535: l_email_address PO_VENDOR_SITES_ALL.email_address%TYPE;
3536: l_fax_number VARCHAR2(100);
3537: l_document_num PO_HEADERS_ALL.segment1%TYPE;
3538:
3539: l_email_flag VARCHAR2(1) := 'N';
3540: l_fax_flag VARCHAR2(1) := 'N';
3541: l_print_flag VARCHAR2(1) := 'N';

Line 3585: update po_headers_all

3581: END IF;
3582: END IF;
3583: --<<8686214 start>>
3584: BEGIN
3585: update po_headers_all
3586: set SUPPLIER_NOTIF_METHOD = nvl(l_default_method,'NONE'),
3587: EMAIL_ADDRESS = l_email_address,
3588: FAX = l_fax_number
3589: where po_header_id = p_doc_rec.po_header_id;

Line 3622: UPDATE po_headers_all

3618: d_position := 20;
3619:
3620: --CLM PDOI Integration : Need to update AME info for approval
3621: IF Nvl(PO_PDOI_PARAMS.g_request.clm_flag,'N') = 'Y' THEN
3622: UPDATE po_headers_all
3623: SET AME_TRANSACTION_TYPE = ( SELECT AME_TRANSACTION_TYPE FROM po_doc_style_headers
3624: WHERE style_id = p_doc_rec.style_id
3625: ),
3626: AME_APPROVAL_ID = PO_AME_APPROVALS_S.NEXTVAL

Line 4206: --Update the template_id to po_headers_all

4202: IF (PO_LOG.d_stmt) THEN
4203: PO_LOG.stmt(d_module, d_position,'l_template_id was null in postproc: ' || l_template_id);
4204: END IF;
4205:
4206: --Update the template_id to po_headers_all
4207: UPDATE po_headers_draft_all SET
4208: uda_template_id = l_template_id
4209: WHERE po_header_id = p_po_header_id
4210: AND Nvl(draft_id,-1) = p_draft_id;

Line 4560: FROM PO_HEADERS_ALL

4556:
4557: BEGIN
4558: SELECT ORG_ID
4559: INTO l_org_id
4560: FROM PO_HEADERS_ALL
4561: WHERE PO_HEADER_ID = p_po_header_id;
4562: EXCEPTION
4563: WHEN NO_DATA_FOUND THEN
4564: l_org_id := NULL;

Line 4637: FROM po_headers_all

4633: PO_LOG.proc_begin(d_module);
4634: END IF;
4635:
4636: SELECT uda_template_id INTO l_template_id
4637: FROM po_headers_all
4638: WHERE po_header_id = p_doc_rec.po_header_id
4639: AND Nvl(draft_id,-1) = -1;
4640:
4641: IF (PO_LOG.d_stmt) THEN

Line 4651: --Check if doc_numbering record exists in po_headers_all_ext_b

4647: IF (PO_LOG.d_stmt) THEN
4648: PO_LOG.stmt(d_module, d_position, 'l_source_org_owned : ' || l_source_org_owned);
4649: END IF;
4650:
4651: --Check if doc_numbering record exists in po_headers_all_ext_b
4652: SELECT Count(attr_group_id)
4653: INTO l_count
4654: FROM po_headers_all_ext_b
4655: WHERE po_header_id = p_doc_rec.po_header_id

Line 4654: FROM po_headers_all_ext_b

4650:
4651: --Check if doc_numbering record exists in po_headers_all_ext_b
4652: SELECT Count(attr_group_id)
4653: INTO l_count
4654: FROM po_headers_all_ext_b
4655: WHERE po_header_id = p_doc_rec.po_header_id
4656: AND Nvl(draft_id,-1) = -1
4657: AND UDA_TEMPLATE_ID = l_template_id
4658: AND ATTR_GROUP_ID = ( SELECT ATTRIBUTE_GROUP_ID FROM po_uda_ag_template_usages

Line 4666: PO_LOG.stmt(d_module, d_position, 'l_count to indicate whether doc_numbering record exists in po_headers_all_ext_b: ' || l_count);

4662: AND ATTRIBUTE2 = l_source_org_owned
4663: AND ATTRIBUTE3 = 'DEFAULT'
4664: );
4665: IF (PO_LOG.d_stmt) THEN
4666: PO_LOG.stmt(d_module, d_position, 'l_count to indicate whether doc_numbering record exists in po_headers_all_ext_b: ' || l_count);
4667: END IF;
4668: --Default doc number only if user has not input any data in uda_interface table
4669: IF l_count = 0
4670: THEN

Line 4687: UPDATE po_headers_all SET

4683: END IF;
4684:
4685: l_delimiter := PO_DOC_NUMBERING_PKG.GET_DELIMITER_FOR_DOC (p_doc_rec.po_header_id, -1);
4686: --Stamp the clm doc number
4687: UPDATE po_headers_all SET
4688: CLM_DOCUMENT_NUMBER = l_doc_number,
4689: SEGMENT1 = (SELECT REPLACE(l_doc_number, l_delimiter, '')
4690: FROM po_headers_all_ext_b
4691: WHERE po_header_id = p_doc_rec.po_header_id

Line 4690: FROM po_headers_all_ext_b

4686: --Stamp the clm doc number
4687: UPDATE po_headers_all SET
4688: CLM_DOCUMENT_NUMBER = l_doc_number,
4689: SEGMENT1 = (SELECT REPLACE(l_doc_number, l_delimiter, '')
4690: FROM po_headers_all_ext_b
4691: WHERE po_header_id = p_doc_rec.po_header_id
4692: AND Nvl(draft_id,-1) = -1
4693: AND UDA_TEMPLATE_ID = l_template_id
4694: AND ATTR_GROUP_ID = ( SELECT ATTRIBUTE_GROUP_ID FROM po_uda_ag_template_usages