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

Line 743: l_modification_number PO_DRAFTS.modification_number%TYPE;

739: --CLM PR Amendment
740: l_federal_flag VARCHAR2(1) := 'N';
741: l_conformed_header_id NUMBER;
742: l_clm_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
743: l_modification_number PO_DRAFTS.modification_number%TYPE;
744: /* Mod Project */
745: l_is_mod VARCHAR2(1) := 'N';
746: l_ame_approval_id NUMBER;
747: l_document_id_temp NUMBER;

Line 761: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE;

757:
758: emp_user_id NUMBER; -- Bug 14078118
759: l_org_id NUMBER; -- CLM Controls Project
760: -- PAR Project : Approval
761: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE;
762: BEGIN
763: x_progress := 'PO_REQAPPROVAL_INIT1.Start_WF_Process: at beginning of Start_WF_Process';
764: IF (g_po_wf_debug = 'Y') THEN
765: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);

Line 868: FROM po_drafts

864: IF DraftId <> -1 THEN
865: -- PAR Project : Approval
866: SELECT draft_type
867: INTO l_draft_type
868: FROM po_drafts
869: WHERE draft_id = DraftID;
870: ELSE
871: l_draft_type := NULL;
872: END IF;

Line 910: po_drafts pd

906: phda.ame_transaction_type
907: INTO l_ame_approval_id,
908: l_ame_transaction_type
909: FROM po_headers_draft_all phda,
910: po_drafts pd
911: WHERE phda.po_header_id = DocumentID
912: AND phda.draft_id = DraftID
913: AND phda.draft_id = pd.draft_id;
914:

Line 1110: FROM po_drafts

1106: IF DraftID <> -1 THEN
1107: BEGIN
1108: SELECT modification_number
1109: INTO l_modification_number
1110: FROM po_drafts
1111: WHERE draft_id = DraftID;
1112: EXCEPTION
1113: WHEN no_data_found THEN
1114: l_modification_number := NULL;

Line 1318: FROM po_drafts

1314: ELSE
1315: BEGIN
1316: SELECT CLM_CONTRACT_OFFICER
1317: INTO l_clm_contract_officer
1318: FROM po_drafts
1319: WHERE draft_id = DraftID;
1320:
1321: EXCEPTION
1322: WHEN no_data_found THEN

Line 1626: UPDATE po_drafts

1622: last_update_login = fnd_global.login_id,
1623: last_update_date = sysdate
1624: WHERE po_header_id = DocumentID;
1625: ELSE
1626: UPDATE po_drafts
1627: SET STATUS = 'IN PROCESS',
1628: last_updated_by = fnd_global.user_id,
1629: last_update_login = fnd_global.login_id,
1630: last_update_date = sysdate

Line 2377: -- accordingly in the MODUPDATED_AFTERCDGENERATED column of po_drafts table

2373: End If;
2374: -- Bug 9906656 issue fix
2375: -- For SGD project, check whether modification document updated after
2376: -- generating the change description and set the value 'Y' or 'N'
2377: -- accordingly in the MODUPDATED_AFTERCDGENERATED column of po_drafts table
2378: IF l_draft_id <> -1 THEN
2379: SetModUpdateAfterCDGenFlag(l_draft_id);
2380: END IF;
2381: -- CLM Aprvl

Line 2488: FROM po_drafts

2484: ELSIF l_doc_type IN ('PO', 'PA') THEN
2485: IF l_draft_id <> -1 AND l_draft_id IS NOT NULL THEN
2486: SELECT NVL(status,'DRAFT')
2487: INTO l_auth_stat
2488: FROM po_drafts
2489: WHERE draft_id = l_draft_id;
2490: ELSE
2491: SELECT NVL(authorization_status,'INCOMPLETE')
2492: INTO l_auth_stat

Line 5077: UPDATE Po_Drafts SET STATUS = p_auth_status WHERE draft_id = l_draft_id;

5073: submit_date = DECODE(p_auth_status, 'INCOMPLETE', to_date(NULL),submit_date) ,
5074: pending_signature_flag = DECODE(l_pending_signature_flag, 'Y', DECODE(acceptance_required_flag, 'S', 'Y', 'N'), pending_signature_flag)
5075: WHERE po_header_id = l_po_header_id
5076: AND draft_id = l_draft_id;
5077: UPDATE Po_Drafts SET STATUS = p_auth_status WHERE draft_id = l_draft_id;
5078: END IF; -- Mod Project
5079: END IF;
5080: COMMIT;
5081: EXCEPTION

Line 5359: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval

5355: l_draft_id NUMBER := p_draft_id; --Mod Project
5356: l_doc_id NUMBER := p_doc_id; --Mod Project
5357: l_doc_subtype VARCHAR2(25) := p_doc_subtype;--Mod Project
5358: l_transaction_type po_doc_style_headers.ame_transaction_type%TYPE;
5359: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE; -- PAR Approval
5360: CURSOR action_hist_cursor(doc_id NUMBER , doc_type VARCHAR2)
5361: IS
5362: SELECT MAX(sequence_num)
5363: FROM po_action_history

Line 8713: PO_DRAFTS_PVT.unlock_document ( p_po_header_id => p_po_header_id );

8709: p_po_header_id IN NUMBER )
8710: IS
8711: PRAGMA AUTONOMOUS_TRANSACTION;
8712: BEGIN
8713: PO_DRAFTS_PVT.unlock_document ( p_po_header_id => p_po_header_id );
8714: COMMIT;
8715: END unlock_document;
8716: --
8717: --

Line 8929: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE;

8925: l_itemtype OUT NOCOPY VARCHAR2,
8926: l_workflow_process OUT NOCOPY VARCHAR2,
8927: l_ame_transaction_type OUT NOCOPY VARCHAR2)
8928: IS
8929: l_draft_type PO_DRAFTS.DRAFT_TYPE%TYPE;
8930: l_progress VARCHAR2(1000);
8931: BEGIN
8932: l_progress := 'PO_REQAPPROVAL_INIT1.get_wf_attrs_from_docstyle DocumentId ' || DocumentId || ' and DraftId ' || DraftId;
8933:

Line 8937: FROM po_drafts

8933:
8934: IF DraftId <> -1 THEN
8935: SELECT draft_type
8936: INTO l_draft_type
8937: FROM po_drafts
8938: WHERE document_id = DocumentId
8939: AND draft_id = DraftId;
8940: ELSE
8941: l_draft_type := NULL;

Line 8991: mod_last_update_date PO_DRAFTS.last_update_date%type;

8987: p_draft_id IN NUMBER) -- SGD Project
8988: IS
8989: pragma AUTONOMOUS_TRANSACTION;
8990: x_progress VARCHAR2(3):= '000';
8991: mod_last_update_date PO_DRAFTS.last_update_date%type;
8992: changedesc_gen_date PO_DRAFTS.cd_generated_date%type;
8993: BEGIN
8994: x_progress := '001';
8995: --fetch the change description generation date and edit by user flag value

Line 8992: changedesc_gen_date PO_DRAFTS.cd_generated_date%type;

8988: IS
8989: pragma AUTONOMOUS_TRANSACTION;
8990: x_progress VARCHAR2(3):= '000';
8991: mod_last_update_date PO_DRAFTS.last_update_date%type;
8992: changedesc_gen_date PO_DRAFTS.cd_generated_date%type;
8993: BEGIN
8994: x_progress := '001';
8995: --fetch the change description generation date and edit by user flag value
8996: SELECT cd_generated_date

Line 8998: FROM po_drafts

8994: x_progress := '001';
8995: --fetch the change description generation date and edit by user flag value
8996: SELECT cd_generated_date
8997: INTO changedesc_gen_date
8998: FROM po_drafts
8999: WHERE draft_id = p_draft_id;
9000:
9001: x_progress := '002';
9002: --find the latest date of the modification document

Line 9006: UPDATE po_drafts

9002: --find the latest date of the modification document
9003: mod_last_update_date := PO_CORE_S.get_last_update_date_for_mod(p_draft_id);
9004: x_progress := '003';
9005: IF( mod_last_update_date > changedesc_gen_date) THEN
9006: UPDATE po_drafts
9007: SET modupdated_aftercdgenerated = 'Y'
9008: WHERE draft_id = p_draft_id;
9009: ELSE
9010: UPDATE po_drafts

Line 9010: UPDATE po_drafts

9006: UPDATE po_drafts
9007: SET modupdated_aftercdgenerated = 'Y'
9008: WHERE draft_id = p_draft_id;
9009: ELSE
9010: UPDATE po_drafts
9011: SET modupdated_aftercdgenerated = 'N'
9012: WHERE draft_id = p_draft_id;
9013: END IF;
9014: COMMIT;