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.

[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on PO_HEADERS_DRAFT_ALL

Line 2474: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE; --CLM Apprvl

2470: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2471: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2472: l_signature_required BOOLEAN;
2473: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2474: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE; --CLM Apprvl
2475:
2476: BEGIN
2477:
2478: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress);

Line 2713: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;

2709: l_preparer_user_name WF_USERS.name%TYPE;
2710: l_original_recipient WF_NOTIFICATIONS.original_recipient%type;
2711: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;
2712: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2713: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
2714:
2715: BEGIN
2716:
2717: IF (funcmode = 'RESPOND') THEN

Line 2759: UPDATE po_headers_draft_all

2755:
2756: --Bug11068447 . If the KO signature notification is forwarded or transferred to a new contracting officer then the document must be updated with the new KO.
2757: IF l_draft_id <> -1 THEN
2758:
2759: UPDATE po_headers_draft_all
2760: SET clm_contract_officer = l_contracting_officer
2761: WHERE po_header_id = l_document_id
2762: AND draft_id = l_draft_id
2763: AND clm_contract_officer <> l_contracting_officer;

Line 2825: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;

2821: l_preparer_user_name WF_USERS.name%TYPE;
2822: l_original_recipient WF_NOTIFICATIONS.original_recipient%type;
2823: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;
2824: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2825: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
2826:
2827: BEGIN
2828:
2829: IF (funcmode = 'RESPOND') THEN

Line 2871: UPDATE po_headers_draft_all

2867:
2868: --Bug11068447 . If the KO signature notification is forwarded or transferred to a new contracting officer then the document must be updated with the new KO.
2869: IF l_draft_id <> -1 THEN
2870:
2871: UPDATE po_headers_draft_all
2872: SET clm_contract_officer = l_contracting_officer
2873: WHERE po_header_id = l_document_id
2874: AND draft_id = l_draft_id
2875: AND clm_contract_officer <> l_contracting_officer;

Line 3191: UPDATE PO_HEADERS_DRAFT_ALL

3187: -- SQL Why :To move the document from the PRE-APPROVED status
3188: -- SQL Join:po_header_id
3189: -- CLM Apprvl . The draft table needs to be updated if it is a modification document
3190: if p_draft_id is not null and p_draft_id <> -1 then
3191: UPDATE PO_HEADERS_DRAFT_ALL
3192: SET pending_signature_flag = 'N',
3193: --acceptance_required_flag = 'N',
3194: acceptance_due_date = Null,
3195: last_updated_by = FND_GLOBAL.user_id,

Line 4269: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;

4265:
4266: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
4267: l_document_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
4268: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4269: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4270: l_progress VARCHAR2(300);
4271: l_doc_string VARCHAR2(200);
4272: l_preparer_user_name WF_USERS.name%TYPE;
4273: l_is_doc_signed VARCHAR2(1);

Line 4403: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;

4399:
4400: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
4401: l_document_subtype PO_DOCUMENT_TYPES.document_subtype%TYPE;
4402: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4403: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4404: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
4405: l_acceptance_mode VARCHAR2(30);
4406:
4407: BEGIN

Line 4630: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;

4626: l_doc_string VARCHAR2(200);
4627: l_preparer_user_name WF_USERS.name%TYPE;
4628: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
4629: l_revision PO_HEADERS_ALL.revision_num%TYPE;
4630: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4631: l_ko_user_name FND_USER.user_name%TYPE;
4632: l_return_status VARCHAR2(1);
4633: l_online_report_id NUMBER;
4634: l_user_id po_lines.last_updated_by%TYPE := -1;

Line 4900: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;

4896: l_api_name VARCHAR2(30) := 'check_warrant_for_ko';
4897: l_log_head VARCHAR2(100) := g_pkg_name || '.' || l_api_name;
4898: l_warning varchar2(2000) := null;
4899: l_forward_to_username varchar2(25) := null;
4900: l_draft_id PO_HEADERS_DRAFT_ALL.draft_id%TYPE;
4901: l_ko_user_name FND_USER.user_name%TYPE;
4902: l_document_id PO_HEADERs_ALL.po_header_id%TYPE;
4903: l_return_status VARCHAR2(1);
4904: l_online_report_id NUMBER;

Line 4973: UPDATE po_headers_draft_all

4969:
4970: --Bug11068447 . If the KO signature notification is forwarded or transferred to a new contracting officer then the document must be updated with the new KO.
4971: IF l_draft_id <> -1 THEN
4972:
4973: UPDATE po_headers_draft_all
4974: SET clm_contract_officer = l_contracting_officer
4975: WHERE po_header_id = l_document_id
4976: AND draft_id = l_draft_id
4977: AND clm_contract_officer <> l_contracting_officer;

Line 5031: UPDATE po_headers_draft_all

5027: --the KO sign is initiated in case of mods.
5028: ELSE
5029: IF l_draft_id <> -1 AND l_draft_id IS NOT NULL
5030: THEN
5031: UPDATE po_headers_draft_all
5032: SET pending_signature_flag = 'C'
5033: WHERE po_header_id = l_document_id
5034: AND draft_id = l_draft_id;
5035: commit;