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_CLOSEOUT_PVT dependencies on DUAL

Line 106: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN

102:
103: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_doc_id ' || p_doc_id);
104: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'p_closeout_type ' || p_closeout_type);
105:
106: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN
107: SELECT type_lookup_code,revision_num,clm_document_number,org_id,vendor_id, vendor_contact_id,vendor_site_id
108: INTO l_po_doc_type, l_rev_number, l_doc_num,l_org_id,l_vendor_id, l_vendor_contact_id,l_vendor_site_id
109: FROM PO_HEADERS_ALL
110: WHERE po_header_id = p_doc_id;

Line 172: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN

168: l_contract_parties(1).party_role_txt := 'Internal';
169: l_contract_parties(1).party_name_txt := l_org_name;
170: l_contract_parties(1).party_index := 1;
171:
172: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN
173: SELECT pv.vendor_name
174: INTO l_vendor_name
175: FROM po_vendors pv
176: WHERE pv.vendor_id = l_vendor_id;

Line 303: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN

299:
300: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_doc_id ' || p_doc_id);
301: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'p_closeout_type ' || p_closeout_type);
302:
303: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN
304: SELECT type_lookup_code,revision_num,clm_document_number
305: INTO l_po_doc_type, l_rev_number, l_doc_num
306: FROM PO_HEADERS_ALL
307: WHERE po_header_id = p_doc_id;

Line 1366: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;

1362: SELECT Count(reference_doc_id)
1363: INTO l_closeout_doc_count
1364: FROM PO_CLOSEOUT_DETAILS
1365: WHERE reference_doc_id = l_doc_id
1366: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
1367:
1368: l_progress := 10;
1369: IF l_closeout_doc_count > 0 THEN
1370: retcode := '1';

Line 1429: PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL,

1425: pco_signed_date,
1426: checklist_signed_date,
1427: is_reopened)
1428: (SELECT PO_CLOSEOUT_DETAILS_S.NEXTVAL,
1429: PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL,
1430: l_doc_id,
1431: check_list_required,
1432: ccs_required,
1433: check_list_sign_required,

Line 1865: FROM dual;

1861: SELECT Decode(l_module_status, 'with errors',
1862: 'with errors',
1863: 'with warnings')
1864: INTO l_module_status
1865: FROM dual;
1866: ELSE
1867: l_excep_type := c_result_type_FAILURE;
1868: l_fail_count := l_fail_count + 1;
1869: l_module_status := 'with errors';

Line 2279: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL

2275: --Award should not any draft closeout details
2276: AND NOT EXISTS(SELECT 1
2277: FROM po_closeout_details pcd
2278: WHERE pcd.reference_doc_id = ph.po_header_id
2279: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL
2280: AND Nvl(pcd.incloseout,'N') = 'Y'
2281: )
2282: ORDER BY ph.last_update_date)
2283: WHERE ROWNUM<11;

Line 2627: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN

2623: l_progress := 20;
2624:
2625: IF l_contract_id IS NOT NULL THEN
2626: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Contract exists ');
2627: IF g_CLOSEOUT_TYPE_INDIVIDUAL = p_closeout_type THEN
2628: SELECT type_lookup_code, clm_document_number
2629: INTO l_po_doc_type, l_doc_num
2630: FROM PO_HEADERS_ALL
2631: WHERE po_header_id = p_doc_id;

Line 2787: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;

2783: SET aco_signer_name = l_aco_singer_name,
2784: aco_signed_date = Nvl(l_aco_signed_date, sysdate),
2785: aco_remarks = l_aco_remarks
2786: WHERE reference_doc_id = l_document_id
2787: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
2788:
2789: l_progress := 13;
2790:
2791: ELSIF (l_closeout_status = 'CLOSED_OUT') THEN

Line 2816: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;

2812: pco_signed_date = Nvl(l_pco_signed_date, sysdate),
2813: pco_remarks = l_pco_remarks,
2814: incloseout = 'C' -- Completed
2815: WHERE reference_doc_id = l_document_id
2816: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
2817:
2818: l_progress := 15;
2819:
2820: select clm_document_number,type_lookup_code, Decode(type_lookup_code, 'STANDARD', 'PO', 'PA')

Line 3356: and closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;

3352: --When a document is reopened and If the tasks are already completed, workflow will directly initiates the signing process
3353: update PO_CLOSEOUT_DETAILS
3354: set incloseout = 'W'
3355: where reference_doc_id = l_document_id
3356: and closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
3357: ELSIF (l_return_status = fnd_api.g_ret_sts_success AND l_task_status = 'INITIATED') THEN
3358: resultout := wf_engine.eng_completed || ':' || 'ACTIVATED' ;
3359: ELSIF (l_return_status = fnd_api.g_ret_sts_error OR l_return_status = fnd_api.g_ret_sts_unexp_error) THEN
3360: resultout := wf_engine.eng_completed || ':' || 'ERROR' ;

Line 3898: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL

3894: l_cntr_signer,l_aco_remarks, l_pco_remarks
3895: FROM PO_CLOSEOUT_DETAILS
3896: WHERE reference_doc_id = p_doc_id
3897: AND incloseout = 'Y'
3898: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL
3899: FOR UPDATE ;
3900:
3901: EXCEPTION
3902: WHEN No_Data_Found THEN

Line 4106: p_closeout_type => PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL,

4102: l_progress := 40;
4103:
4104: IF l_chklist_req <> 'Y' THEN
4105: PO_CLOSEOUT_PVT.delete_contract(p_doc_id => p_doc_id,
4106: p_closeout_type => PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL,
4107: x_return_status => x_return_status,
4108: x_return_msg => l_msg_data);
4109: l_progress := 45;
4110: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'Delete contract status ' || x_return_status);

Line 4121: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;

4117: UPDATE po_closeout_details
4118: SET incloseout = 'W' -- Workflow
4119: WHERE reference_doc_id = p_doc_id
4120: AND incloseout = 'Y'
4121: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
4122:
4123: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'Updated incloseout to W '||SQL%ROWCOUNT);
4124:
4125: -- Set the REVALIDATE_DOCUMENT to Y, as this is invoked from business event after all tasks has been completed and it needs revalidation.

Line 4146: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;

4142: UPDATE po_closeout_details
4143: SET attribute15 = l_user_id||':'||l_resp_id||':'||l_appl_id
4144: WHERE reference_doc_id = p_doc_id
4145: AND incloseout = 'Y'
4146: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
4147:
4148: END IF;
4149:
4150: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4252: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;

4248: SELECT ATTRIBUTE15
4249: INTO l_context_ids
4250: FROM po_closeout_details
4251: WHERE reference_doc_id = l_document_id
4252: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
4253:
4254: l_counter := 0;
4255:
4256: FOR context_cur IN

Line 4258: SELECT regexp_substr(l_context_ids,'[^:]+', 1, LEVEL) internal_id FROM dual

4254: l_counter := 0;
4255:
4256: FOR context_cur IN
4257: (
4258: SELECT regexp_substr(l_context_ids,'[^:]+', 1, LEVEL) internal_id FROM dual
4259: CONNECT BY regexp_substr(l_context_ids, '[^:]+', 1, LEVEL) IS NOT NULL
4260:
4261: ) LOOP
4262: l_counter := l_counter +1;

Line 4687: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;

4683: SELECT ATTRIBUTE15
4684: INTO l_context_ids
4685: FROM po_closeout_details
4686: WHERE reference_doc_id = l_document_id
4687: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
4688:
4689: l_counter := 0;
4690:
4691: FOR cont_cur IN

Line 4693: SELECT regexp_substr(l_context_ids,'[^:]+', 1, LEVEL) internal_id FROM dual

4689: l_counter := 0;
4690:
4691: FOR cont_cur IN
4692: (
4693: SELECT regexp_substr(l_context_ids,'[^:]+', 1, LEVEL) internal_id FROM dual
4694: CONNECT BY regexp_substr(l_context_ids, '[^:]+', 1, LEVEL) IS NOT NULL
4695:
4696: ) LOOP
4697: l_counter := l_counter +1;

Line 4810: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;

4806:
4807: UPDATE po_closeout_details
4808: SET checklist_signed_date = SYSDATE
4809: WHERE reference_doc_id = l_document_id
4810: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_INDIVIDUAL;
4811:
4812: END IF;
4813:
4814: IF (PO_LOG.d_proc) THEN PO_LOG.proc_end(d_module); END IF;