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_DOCUMENT_CHECKS_PVT dependencies on PO_DRAFTS

Line 809: FROM po_drafts

805: l_wdol_attachment_exists VARCHAR2(1):='N';
806:
807: CURSOR c_not_par IS
808: SELECT 'Y'
809: FROM po_drafts
810: WHERE draft_id = l_draft_id
811: AND draft_type = 'MOD';
812:
813: l_not_par VARCHAR2(1):='N';

Line 980: FROM po_drafts

976: l_validate_pds_status VARCHAR2(1):='N';
977:
978: CURSOR c_not_par IS
979: SELECT 'Y'
980: FROM po_drafts
981: WHERE draft_id = l_draft_id
982: AND draft_type = 'MOD';
983:
984: l_not_par VARCHAR2(1):='N';

Line 1216: l_draft_sub_type PO_DRAFTS.draft_sub_type%TYPE;

1212:
1213: --FedBizOpps Project
1214: l_no_comp_reason VARCHAR2(100);
1215: is_ja_notice_posted VARCHAR2(1) := 'N';
1216: l_draft_sub_type PO_DRAFTS.draft_sub_type%TYPE;
1217: l_org_id NUMBER; -- CLM Controls Project changes
1218: -- Payment Instruction
1219: l_enable_payment_inst VARCHAR2(1);
1220: -- UCA Project CLM R4 changes Begin

Line 1382: FROM po_drafts

1378: IF p_draft_id IS NOT NULL THEN
1379: BEGIN
1380: SELECT draft_type, draft_sub_type
1381: INTO l_draft_type, l_draft_sub_type
1382: FROM po_drafts
1383: WHERE draft_id = p_draft_id;
1384: EXCEPTION
1385: WHEN OTHERS THEN
1386: l_draft_type := 'AWARD';

Line 1434: FROM po_drafts

1430: THEN
1431: IF l_draft_type in ('PAR', 'MOD') THEN
1432: SELECT clm_contract_officer
1433: INTO l_contracting_officer
1434: FROM po_drafts
1435: WHERE draft_id = p_draft_id;
1436: ELSE
1437: SELECT clm_contract_officer
1438: INTO l_contracting_officer

Line 1569: FROM po_drafts phmv

1565: p_sequence +1,
1566: FND_MESSAGE.GET_STRING('PO', 'PO_PRINT_FORM_FORMAT_INVALID'),
1567: 'PO_PRINT_FORM_FORMAT_INVALID',
1568: 'E'
1569: FROM po_drafts phmv
1570: WHERE phmv.draft_id = p_draft_id
1571: AND NOT EXISTS (
1572: SELECT 1
1573: FROM po_print_form_formats ppff

Line 14666: FROM po_drafts

14662: IF p_draft_id <> -1 THEN
14663: BEGIN
14664: SELECT draft_type
14665: INTO l_draft_type
14666: FROM po_drafts
14667: WHERE draft_id = p_draft_id;
14668: Exception
14669: When No_Data_Found Then
14670: l_draft_type := 'AWARD';

Line 16218: l_role PO_DRAFTS.owner_role%TYPE := NVL(p_role, PO_GLOBAL.g_ROLE_BUYER);

16214: l_procedure_id PO_SESSION_GT.key%TYPE;
16215: -- bug3592160 END
16216:
16217: --
16218: l_role PO_DRAFTS.owner_role%TYPE := NVL(p_role, PO_GLOBAL.g_ROLE_BUYER);
16219: l_skip_cat_upload_chk VARCHAR2(1) := NVL(p_skip_cat_upload_chk, FND_API.G_FALSE);
16220:
16221: l_update_allowed VARCHAR2(1);
16222: l_locking_applicable VARCHAR2(1);

Line 16363: PO_DRAFTS_PVT.update_permission_check

16359: l_progress := 40;
16360: IF (x_po_status_rec.updatable_flag(i) = 'Y' AND
16361: p_release_id(i) IS NULL) THEN
16362:
16363: PO_DRAFTS_PVT.update_permission_check
16364: ( p_calling_module => p_calling_module,
16365: p_po_header_id => p_header_id(i),
16366: p_role => l_role,
16367: p_skip_cat_upload_chk => l_skip_cat_upload_chk,

Line 17575: FROM po_drafts

17571: IF p_draft_id <> -1 THEN
17572: BEGIN
17573: SELECT draft_type
17574: INTO l_draft_type
17575: FROM po_drafts
17576: WHERE draft_id = p_draft_id;
17577: Exception
17578: When No_Data_Found Then
17579: l_draft_type := 'AWARD';

Line 18012: FROM po_drafts

18008: IF p_draft_id <> -1 THEN
18009: BEGIN
18010: SELECT draft_type
18011: INTO l_draft_type
18012: FROM po_drafts
18013: WHERE draft_id = p_draft_id;
18014: Exception
18015: When No_Data_Found Then
18016: l_draft_type := 'AWARD';

Line 21051: --Getting the draft id to get the draft type from po drafts

21047: -- Check 2: The sum of the distribution quantities/amounts should match the
21048: -- shipment quantity/amount.
21049: --CLM Phase 4: PAR Changes Begin.
21050:
21051: --Getting the draft id to get the draft type from po drafts
21052: SELECT draft_id
21053: INTO l_draft_id
21054: FROM po_headers_gt
21055: WHERE po_header_id = p_document_id;

Line 21065: FROM po_drafts

21061: IF l_draft_id <> -1 THEN
21062: BEGIN
21063: SELECT draft_type
21064: INTO l_draft_type
21065: FROM po_drafts
21066: WHERE draft_id = l_draft_id;
21067: EXCEPTION
21068: WHEN no_data_found THEN
21069: l_draft_type := 'AWARD';

Line 22468: mod_last_update_date PO_DRAFTS.last_update_date%type;

22464:
22465: l_return_status VARCHAR2(10) := NULL;
22466: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_genchangedesc';
22467: l_progress VARCHAR2(3) := '000';
22468: mod_last_update_date PO_DRAFTS.last_update_date%type;
22469: changedesc_gen_date PO_DRAFTS.cd_generated_date%type;
22470: changedesc_gen_flag PO_DRAFTS.cd_generated_flag%type;
22471: changedesc_edit_flag PO_DRAFTS.cd_editbyuser_flag%type;
22472: concurrent_request_id PO_DRAFTS.concurrent_reqid%type;

Line 22469: changedesc_gen_date PO_DRAFTS.cd_generated_date%type;

22465: l_return_status VARCHAR2(10) := NULL;
22466: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_genchangedesc';
22467: l_progress VARCHAR2(3) := '000';
22468: mod_last_update_date PO_DRAFTS.last_update_date%type;
22469: changedesc_gen_date PO_DRAFTS.cd_generated_date%type;
22470: changedesc_gen_flag PO_DRAFTS.cd_generated_flag%type;
22471: changedesc_edit_flag PO_DRAFTS.cd_editbyuser_flag%type;
22472: concurrent_request_id PO_DRAFTS.concurrent_reqid%type;
22473: l_err_msg_txt VARCHAR2(3000);

Line 22470: changedesc_gen_flag PO_DRAFTS.cd_generated_flag%type;

22466: l_log_head VARCHAR2(70) := 'po.plsql.PO_DOCUMENT_CHECKS_PVT.validate_genchangedesc';
22467: l_progress VARCHAR2(3) := '000';
22468: mod_last_update_date PO_DRAFTS.last_update_date%type;
22469: changedesc_gen_date PO_DRAFTS.cd_generated_date%type;
22470: changedesc_gen_flag PO_DRAFTS.cd_generated_flag%type;
22471: changedesc_edit_flag PO_DRAFTS.cd_editbyuser_flag%type;
22472: concurrent_request_id PO_DRAFTS.concurrent_reqid%type;
22473: l_err_msg_txt VARCHAR2(3000);
22474: msg_name VARCHAR2(50) := NULL;

Line 22471: changedesc_edit_flag PO_DRAFTS.cd_editbyuser_flag%type;

22467: l_progress VARCHAR2(3) := '000';
22468: mod_last_update_date PO_DRAFTS.last_update_date%type;
22469: changedesc_gen_date PO_DRAFTS.cd_generated_date%type;
22470: changedesc_gen_flag PO_DRAFTS.cd_generated_flag%type;
22471: changedesc_edit_flag PO_DRAFTS.cd_editbyuser_flag%type;
22472: concurrent_request_id PO_DRAFTS.concurrent_reqid%type;
22473: l_err_msg_txt VARCHAR2(3000);
22474: msg_name VARCHAR2(50) := NULL;
22475: msg_type VARCHAR2(50) := NULL;

Line 22472: concurrent_request_id PO_DRAFTS.concurrent_reqid%type;

22468: mod_last_update_date PO_DRAFTS.last_update_date%type;
22469: changedesc_gen_date PO_DRAFTS.cd_generated_date%type;
22470: changedesc_gen_flag PO_DRAFTS.cd_generated_flag%type;
22471: changedesc_edit_flag PO_DRAFTS.cd_editbyuser_flag%type;
22472: concurrent_request_id PO_DRAFTS.concurrent_reqid%type;
22473: l_err_msg_txt VARCHAR2(3000);
22474: msg_name VARCHAR2(50) := NULL;
22475: msg_type VARCHAR2(50) := NULL;
22476: l_isCompletedCount NUMBER := 0;

Line 22492: FROM PO_DRAFTS

22488:
22489: -- Check whether the change description is generated or not
22490: SELECT cd_generated_flag, concurrent_reqid
22491: INTO changedesc_gen_flag, concurrent_request_id
22492: FROM PO_DRAFTS
22493: WHERE DRAFT_ID = p_draft_id;
22494:
22495: PO_DEBUG.debug_var(l_log_head,l_progress,'changedesc_gen_flag', changedesc_gen_flag);
22496: PO_DEBUG.debug_var(l_log_head,l_progress,'concurrent_request_id', concurrent_request_id);

Line 22511: FROM po_drafts

22507: ELSE
22508: --fetch the change description generation date and edit by user flag value
22509: SELECT cd_generated_date, cd_editbyuser_flag
22510: INTO changedesc_gen_date, changedesc_edit_flag
22511: FROM po_drafts
22512: WHERE draft_id = p_draft_id;
22513:
22514: PO_DEBUG.debug_var(l_log_head,l_progress,'changedesc_gen_date', changedesc_gen_date);
22515: PO_DEBUG.debug_var(l_log_head,l_progress,'changedesc_edit_flag', changedesc_edit_flag);

Line 26577: po_drafts pod

26573: Nvl(pod.changed_amt,0)
26574: END) changed_amt -- Bug 16713804
26575: INTO l_okc_doc_type,l_changed_amt
26576: FROM po_headers_draft_all phda, po_headers_all phd,
26577: po_drafts pod
26578: WHERE phda.po_header_id = p_document_id
26579: AND phd.po_header_id = phda.po_header_id
26580: AND phda.draft_id = p_draft_id
26581: AND pod.draft_id = phda.draft_id;