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 PO_CLOSEOUT_DETAILS

Line 1333: FROM po_closeout_details

1329: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------');
1330:
1331: SELECT check_list_required
1332: INTO l_checklist_req
1333: FROM po_closeout_details
1334: WHERE reference_doc_id = p_req_id
1335: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_MASS;
1336:
1337: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_checklist_req ' || l_checklist_req);

Line 1364: FROM PO_CLOSEOUT_DETAILS

1360:
1361: fnd_file.put_line(FND_FILE.LOG, 'Processing started for the document: ' || l_doc_num);
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;

Line 1380: INTO PO_CLOSEOUT_DETAILS (

1376: fnd_file.put_line(FND_FILE.LOG, 'Initiating closeout process for this award ');
1377:
1378: BEGIN
1379: INSERT
1380: INTO PO_CLOSEOUT_DETAILS (
1381: closeout_id,
1382: closeout_doc_type,
1383: reference_doc_id,
1384: check_list_required,

Line 1428: (SELECT PO_CLOSEOUT_DETAILS_S.NEXTVAL,

1424: aco_signed_date,
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,

Line 1475: FROM PO_CLOSEOUT_DETAILS

1471: aco_signed_date,
1472: pco_signed_date,
1473: checklist_signed_date,
1474: is_reopened
1475: FROM PO_CLOSEOUT_DETAILS
1476: WHERE reference_doc_id = p_req_id
1477: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_MASS);
1478:
1479: l_progress := 20;

Line 1480: fnd_file.put_line(FND_FILE.LOG, 'New record has been added to the PO_CLOSEOUT_DETAILS table for this award.');

1476: WHERE reference_doc_id = p_req_id
1477: AND closeout_doc_type = PO_CLOSEOUT_PVT.g_CLOSEOUT_TYPE_MASS);
1478:
1479: l_progress := 20;
1480: fnd_file.put_line(FND_FILE.LOG, 'New record has been added to the PO_CLOSEOUT_DETAILS table for this award.');
1481:
1482:
1483: IF l_checklist_req = 'Y' THEN
1484: fnd_file.put_line(FND_FILE.LOG, 'Contract creation process has been started for the award ' || l_doc_num);

Line 1805: FROM po_closeout_details

1801: IF p_chk_list_req = 'Y' THEN
1802:
1803: SELECT reference_doc_id,null,null
1804: BULK COLLECT INTO l_document_id_tbl,l_document_num_tbl, l_mod_doc_id_tbl
1805: FROM po_closeout_details
1806: WHERE closeout_doc_type = 'MASS'
1807: AND reference_doc_id = p_req_id
1808: AND NOT EXISTS (SELECT 'Tasks not available'
1809: FROM okc_rep_contract_usages orcu, okc_deliverables del

Line 2277: FROM po_closeout_details pcd

2273: OR user_document_status IS NULL)
2274: )
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: )

Line 2782: UPDATE po_closeout_details

2778: itemkey => itemkey,
2779: aname => 'ACO_REMARKS');
2780:
2781: l_progress := 12;
2782: UPDATE po_closeout_details
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

Line 2809: UPDATE po_closeout_details

2805: aname => 'PCO_REMARKS');
2806:
2807: l_progress := 14;
2808:
2809: UPDATE po_closeout_details
2810: SET closeout_date = nvl(Nvl(l_pco_signed_date,aco_signed_date), sysdate),
2811: pco_signer_name = l_pco_singer_name,
2812: pco_signed_date = Nvl(l_pco_signed_date, sysdate),
2813: pco_remarks = l_pco_remarks,

Line 3353: update PO_CLOSEOUT_DETAILS

3349:
3350: IF (l_return_status = fnd_api.g_ret_sts_success AND l_task_status = 'COMPLETED') THEN
3351: resultout := wf_engine.eng_completed || ':' || 'COMPLETED' ;
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

Line 3895: FROM PO_CLOSEOUT_DETAILS

3891: check_list_signer_id, aco_signer_id, pco_signer_id, aco_remarks, pco_remarks
3892: INTO l_document_id, l_chklist_req, l_ccs_req, l_chklist_sign_req, l_ccs_sign_req,
3893: l_aco_sign_type, l_pco_sign_type, l_chklist_signer, l_admin_signer,
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 ;

Line 4117: UPDATE po_closeout_details

4113:
4114: -- If the workflow is launced again for this document. This is the case when its launched after completing all the tasks from business event
4115: IF ('PHYSICAL_COMPLETE' = l_clm_closeout_status) THEN
4116:
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;

Line 4142: UPDATE po_closeout_details

4138: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_user_id ' || l_user_id);
4139: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_resp_id ' || l_resp_id);
4140: PO_CLOSEOUT_PVT.Log( d_module, l_progress, 'l_appl_id ' || l_appl_id);
4141:
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;

Line 4250: FROM po_closeout_details

4246: IF ( l_session_resp_id IS NULL OR l_session_user_id IS NULL ) THEN
4247:
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;

Line 4519: AND A.ENTITY_NAME = 'PO_CLOSEOUT_DETAILS'

4515: FND_LOBS L,
4516: FND_DOCUMENTS D,
4517: FND_ATTACHED_DOCUMENTS A
4518: WHERE D.DOCUMENT_ID = A.DOCUMENT_ID
4519: AND A.ENTITY_NAME = 'PO_CLOSEOUT_DETAILS'
4520: AND D.MEDIA_ID = L.FILE_ID
4521: AND D.FILE_NAME LIKE '%'||l_pdf_type||'.pdf'
4522: AND A.PK1_VALUE =l_document_id ;
4523:

Line 4685: FROM po_closeout_details

4681: l_document_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype, itemkey => p_itemkey, aname => 'DOCUMENT_ID');
4682:
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;

Line 4807: UPDATE po_closeout_details

4803: l_document_id := wf_engine.GetItemAttrNumber (itemtype => itemtype, itemkey => itemkey, aname => 'DOCUMENT_ID');
4804:
4805: PO_CLOSEOUT_PVT.Log( d_module, d_position, 'l_document_id ' || l_document_id);
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: