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_AME_WF_PVT dependencies on PO_HEADERS

Line 733: l_userkey PO_HEADERS_ALL.SEGMENT1%TYPE;

729: l_esigner_exists VARCHAR2(1);
730: l_api_name VARCHAR2(500) := 'launch_parallel_approval';
731: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
732: l_owner_user_name fnd_user.user_name%TYPE;
733: l_userkey PO_HEADERS_ALL.SEGMENT1%TYPE;
734:
735: BEGIN
736:
737: IF (funcmode <> wf_engine.eng_run) THEN

Line 2991: l_document_subtype po_headers.type_lookup_code%TYPE;

2987: funcmode IN VARCHAR2,
2988: resultout OUT NOCOPY VARCHAR2)
2989: IS
2990: l_document_id NUMBER;
2991: l_document_subtype po_headers.type_lookup_code%TYPE;
2992: l_header_id NUMBER;
2993: l_document_type po_headers.type_lookup_code%TYPE;
2994: l_revision_num NUMBER;
2995: l_request_id NUMBER;

Line 2993: l_document_type po_headers.type_lookup_code%TYPE;

2989: IS
2990: l_document_id NUMBER;
2991: l_document_subtype po_headers.type_lookup_code%TYPE;
2992: l_header_id NUMBER;
2993: l_document_type po_headers.type_lookup_code%TYPE;
2994: l_revision_num NUMBER;
2995: l_request_id NUMBER;
2996: l_conterm_exists po_headers_all.conterms_exist_flag%TYPE;
2997: l_authorization_status VARCHAR2(25);

Line 2996: l_conterm_exists po_headers_all.conterms_exist_flag%TYPE;

2992: l_header_id NUMBER;
2993: l_document_type po_headers.type_lookup_code%TYPE;
2994: l_revision_num NUMBER;
2995: l_request_id NUMBER;
2996: l_conterm_exists po_headers_all.conterms_exist_flag%TYPE;
2997: l_authorization_status VARCHAR2(25);
2998: l_progress VARCHAR2(200);
2999: l_withterms VARCHAR2(1);
3000: l_set_lang BOOLEAN;

Line 3160: l_document_id po_headers.po_header_id%TYPE;

3156: actid IN NUMBER,
3157: funcmode IN VARCHAR2,
3158: resultout OUT NOCOPY VARCHAR2)
3159: IS
3160: l_document_id po_headers.po_header_id%TYPE;
3161: l_revision_num po_headers.revision_num%TYPE;
3162: l_document_subtype po_headers.type_lookup_code%TYPE;
3163: l_document_type po_headers.type_lookup_code%TYPE;
3164: l_territory fnd_languages.nls_territory%type;

Line 3161: l_revision_num po_headers.revision_num%TYPE;

3157: funcmode IN VARCHAR2,
3158: resultout OUT NOCOPY VARCHAR2)
3159: IS
3160: l_document_id po_headers.po_header_id%TYPE;
3161: l_revision_num po_headers.revision_num%TYPE;
3162: l_document_subtype po_headers.type_lookup_code%TYPE;
3163: l_document_type po_headers.type_lookup_code%TYPE;
3164: l_territory fnd_languages.nls_territory%type;
3165: l_language_code fnd_languages.language_code%type;

Line 3162: l_document_subtype po_headers.type_lookup_code%TYPE;

3158: resultout OUT NOCOPY VARCHAR2)
3159: IS
3160: l_document_id po_headers.po_header_id%TYPE;
3161: l_revision_num po_headers.revision_num%TYPE;
3162: l_document_subtype po_headers.type_lookup_code%TYPE;
3163: l_document_type po_headers.type_lookup_code%TYPE;
3164: l_territory fnd_languages.nls_territory%type;
3165: l_language_code fnd_languages.language_code%type;
3166: l_supp_lang po_vendor_sites_all.language%TYPE;

Line 3163: l_document_type po_headers.type_lookup_code%TYPE;

3159: IS
3160: l_document_id po_headers.po_header_id%TYPE;
3161: l_revision_num po_headers.revision_num%TYPE;
3162: l_document_subtype po_headers.type_lookup_code%TYPE;
3163: l_document_type po_headers.type_lookup_code%TYPE;
3164: l_territory fnd_languages.nls_territory%type;
3165: l_language_code fnd_languages.language_code%type;
3166: l_supp_lang po_vendor_sites_all.language%TYPE;
3167: l_language fnd_languages.nls_language%type;

Line 3168: l_authorization_status po_headers.authorization_status%TYPE;

3164: l_territory fnd_languages.nls_territory%type;
3165: l_language_code fnd_languages.language_code%type;
3166: l_supp_lang po_vendor_sites_all.language%TYPE;
3167: l_language fnd_languages.nls_language%type;
3168: l_authorization_status po_headers.authorization_status%TYPE;
3169: l_header_id po_headers.po_header_id%TYPE;
3170: l_with_terms VARCHAR2(1);
3171: l_request_id NUMBER;
3172: l_set_lang BOOLEAN;

Line 3169: l_header_id po_headers.po_header_id%TYPE;

3165: l_language_code fnd_languages.language_code%type;
3166: l_supp_lang po_vendor_sites_all.language%TYPE;
3167: l_language fnd_languages.nls_language%type;
3168: l_authorization_status po_headers.authorization_status%TYPE;
3169: l_header_id po_headers.po_header_id%TYPE;
3170: l_with_terms VARCHAR2(1);
3171: l_request_id NUMBER;
3172: l_set_lang BOOLEAN;
3173: l_progress VARCHAR2(100);

Line 3195: WHERE ( (ad.pk1_value = TO_CHAR(l_po_header_id) AND ad.entity_name = 'PO_HEADERS') OR

3191: fnd_attached_documents ad,
3192: fnd_doc_category_usages dcu,
3193: fnd_attachment_functions af,
3194: fnd_lobs fl
3195: WHERE ( (ad.pk1_value = TO_CHAR(l_po_header_id) AND ad.entity_name = 'PO_HEADERS') OR
3196: (ad.pk1_value = (SELECT To_Char(vendor_id)
3197: FROM po_headers_all
3198: WHERE po_header_id = l_po_header_id) AND ad.entity_name = 'PO_VENDORS') OR
3199: (ad.pk1_value IN (SELECT To_Char(po_line_id)

Line 3197: FROM po_headers_all

3193: fnd_attachment_functions af,
3194: fnd_lobs fl
3195: WHERE ( (ad.pk1_value = TO_CHAR(l_po_header_id) AND ad.entity_name = 'PO_HEADERS') OR
3196: (ad.pk1_value = (SELECT To_Char(vendor_id)
3197: FROM po_headers_all
3198: WHERE po_header_id = l_po_header_id) AND ad.entity_name = 'PO_VENDORS') OR
3199: (ad.pk1_value IN (SELECT To_Char(po_line_id)
3200: FROM po_lines_all
3201: WHERE po_header_id = l_po_header_id ) AND ad.entity_name = 'PO_LINES') OR

Line 3205: AND from_header_id IS NOT NULL ) AND ad.entity_name = 'PO_HEADERS') OR

3201: WHERE po_header_id = l_po_header_id ) AND ad.entity_name = 'PO_LINES') OR
3202: (ad.pk1_value IN (SELECT To_Char(from_header_id)
3203: FROM po_lines_all
3204: WHERE po_header_id = l_po_header_id
3205: AND from_header_id IS NOT NULL ) AND ad.entity_name = 'PO_HEADERS') OR
3206: (ad.pk1_value IN (SELECT To_Char(from_line_id)
3207: FROM po_lines_all
3208: WHERE po_header_id = l_po_header_id
3209: AND from_line_id IS NOT NULL ) AND ad.entity_name = 'PO_LINES') OR

Line 3261: FROM po_vendor_sites_all pv, po_headers_all ph

3257:
3258: BEGIN
3259: SELECT pv.language
3260: INTO l_supp_lang
3261: FROM po_vendor_sites_all pv, po_headers_all ph
3262: WHERE ph.po_header_id = l_header_id
3263: AND ph.vendor_site_id = pv.vendor_site_id;
3264: EXCEPTION
3265: WHEN NO_DATA_FOUND THEN

Line 3359: WHERE ( (ad.pk1_value = TO_CHAR(l_document_id) AND ad.entity_name = 'PO_HEADERS') OR

3355: fnd_attached_documents ad,
3356: fnd_doc_category_usages dcu,
3357: fnd_attachment_functions af,
3358: fnd_lobs fl
3359: WHERE ( (ad.pk1_value = TO_CHAR(l_document_id) AND ad.entity_name = 'PO_HEADERS') OR
3360: --
3361: (ad.pk1_value = TO_CHAR((SELECT vendor_id
3362: FROM po_headers_all
3363: WHERE po_header_id = l_document_id))

Line 3362: FROM po_headers_all

3358: fnd_lobs fl
3359: WHERE ( (ad.pk1_value = TO_CHAR(l_document_id) AND ad.entity_name = 'PO_HEADERS') OR
3360: --
3361: (ad.pk1_value = TO_CHAR((SELECT vendor_id
3362: FROM po_headers_all
3363: WHERE po_header_id = l_document_id))
3364: AND ad.entity_name = 'PO_VENDORS') OR
3365: --
3366: (ad.pk1_value IN (SELECT po_line_id

Line 3374: AND from_header_id IS NOT NULL) AND ad.entity_name = 'PO_HEADERS') OR

3370: --
3371: (ad.pk1_value IN (SELECT from_header_id
3372: FROM po_lines_all
3373: WHERE po_header_id = l_document_id
3374: AND from_header_id IS NOT NULL) AND ad.entity_name = 'PO_HEADERS') OR
3375: --
3376: (ad.pk1_value IN (SELECT from_line_id
3377: FROM po_lines_all
3378: WHERE po_header_id = l_document_id

Line 4524: UPDATE po_headers_all

4520: p_token => l_progress,
4521: p_message => 'Updating authorization status of ' || p_document_id);
4522: END IF;
4523:
4524: UPDATE po_headers_all
4525: SET authorization_status = decode(approved_date, NULL, 'INCOMPLETE',
4526: 'REQUIRES REAPPROVAL'),
4527: wf_item_type = p_item_type,
4528: wf_item_key = p_item_key,

Line 4686: l_document_number po_headers_all.segment1%TYPE;

4682: l_emp_user_name VARCHAR2(100);
4683: l_emp_disp_name VARCHAR2(240);
4684: l_supplier_contact_id NUMBER;
4685: l_acceptance_id NUMBER;
4686: l_document_number po_headers_all.segment1%TYPE;
4687: l_doc_type_disp VARCHAR2(240);
4688: l_notification_id NUMBER;
4689: l_supp_contact_email VARCHAR2(200);
4690: l_supp_contact_user_name VARCHAR2(100);

Line 4703: FROM po_headers_all

4699: WHERE poh1.object_id = p_po_header_id
4700: AND poh1.action_code = 'SUBMIT')
4701: UNION
4702: SELECT agent_id
4703: FROM po_headers_all
4704: WHERE po_header_id = p_po_header_id;
4705:
4706: emp_rc employee_to_send_notif%ROWTYPE;
4707:

Line 4722: FROM po_headers_all

4718: END IF;
4719:
4720: SELECT segment1
4721: INTO l_document_number
4722: FROM po_headers_all
4723: WHERE po_header_id = p_document_id;
4724:
4725: l_progress := '001';
4726:

Line 4781: po_headers_all poh

4777:
4778: SELECT psc.user_name
4779: INTO l_supp_contact_user_name
4780: FROM po_supplier_contacts_val_v psc,
4781: po_headers_all poh
4782: WHERE psc.vendor_contact_id= poh.vendor_contact_id
4783: AND psc.vendor_site_id= poh.vendor_site_id
4784: AND po_header_id=p_document_id;
4785:

Line 4900: FROM po_headers_all

4896: -- to all approvers is selected in the style
4897:
4898: SELECT wf_item_type, wf_item_key
4899: INTO l_item_type,l_item_key
4900: FROM po_headers_all
4901: WHERE po_header_id = p_document_id;
4902:
4903: l_progress := '001';
4904:

Line 5012: po_headers_all poh

5008: BEGIN
5009: SELECT nvl(SEND_WITHDRW_NOTF_FLAG,'N')
5010: INTO l_send_notf_flag
5011: FROM po_doc_style_headers ds,
5012: po_headers_all poh
5013: WHERE poh.po_header_id = p_document_id
5014: AND poh.style_id = ds.style_id;
5015: EXCEPTION
5016: when others then

Line 5612: l_document_id PO_HEADERS.po_header_id%TYPE;

5608: l_notif_id NUMBER;
5609: l_erecord_id NUMBER;
5610: l_doc_parameters PO_ERECORDS_PVT.Params_tbl_type;
5611: l_sig_parameters PO_ERECORDS_PVT.Params_tbl_type;
5612: l_document_id PO_HEADERS.po_header_id%TYPE;
5613: l_user_name FND_USER.user_name%TYPE;
5614: l_requester FND_USER.user_name%TYPE;
5615: l_esigner_response VARCHAR2(20);
5616: l_response VARCHAR2(20);

Line 5619: l_document_number PO_HEADERS_ALL.segment1%TYPE;

5615: l_esigner_response VARCHAR2(20);
5616: l_response VARCHAR2(20);
5617: l_event_name VARCHAR2(50);
5618: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
5619: l_document_number PO_HEADERS_ALL.segment1%TYPE;
5620: l_orgid PO_HEADERS_ALL.org_id%TYPE;
5621: l_revision PO_HEADERS_ALL.revision_num%TYPE;
5622: l_return_status VARCHAR2(1);
5623: l_msg_count NUMBER;

Line 5620: l_orgid PO_HEADERS_ALL.org_id%TYPE;

5616: l_response VARCHAR2(20);
5617: l_event_name VARCHAR2(50);
5618: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
5619: l_document_number PO_HEADERS_ALL.segment1%TYPE;
5620: l_orgid PO_HEADERS_ALL.org_id%TYPE;
5621: l_revision PO_HEADERS_ALL.revision_num%TYPE;
5622: l_return_status VARCHAR2(1);
5623: l_msg_count NUMBER;
5624: l_msg_data VARCHAR2(2000);

Line 5621: l_revision PO_HEADERS_ALL.revision_num%TYPE;

5617: l_event_name VARCHAR2(50);
5618: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
5619: l_document_number PO_HEADERS_ALL.segment1%TYPE;
5620: l_orgid PO_HEADERS_ALL.org_id%TYPE;
5621: l_revision PO_HEADERS_ALL.revision_num%TYPE;
5622: l_return_status VARCHAR2(1);
5623: l_msg_count NUMBER;
5624: l_msg_data VARCHAR2(2000);
5625: l_doc_string VARCHAR2(200);

Line 5865: -- This procedures update pending_signature_flag in po_headers_all

5861: --Locks:
5862: -- None.
5863: --Function:
5864: -- Workflow activity PL/SQL handler.
5865: -- This procedures update pending_signature_flag in po_headers_all
5866: -- to 'E' if there are esigners and supplier signature is not required.
5867: --Parameters:
5868: --IN:
5869: -- Standard workflow IN parameters

Line 5887: -- + Update po_headers_all with pending_signature_flag = E which signifies there are

5883: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
5884: PRAGMA AUTONOMOUS_TRANSACTION;
5885: BEGIN
5886: -- Logic :
5887: -- + Update po_headers_all with pending_signature_flag = E which signifies there are
5888: -- post approvers/ e-sigenrs for this PO.
5889: IF (g_po_wf_debug = 'Y') THEN
5890: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001');
5891: END IF;

Line 5893: UPDATE po_headers_all

5889: IF (g_po_wf_debug = 'Y') THEN
5890: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 001');
5891: END IF;
5892:
5893: UPDATE po_headers_all
5894: SET pending_signature_flag='E'
5895: WHERE po_header_id = p_po_header_id
5896: AND NVL(acceptance_required_flag,'N') <>'S';
5897:

Line 5945: -- + Update po_headers_all status to APPROVED and corresponding fields.

5941: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
5942:
5943: BEGIN
5944: -- Logic :
5945: -- + Update po_headers_all status to APPROVED and corresponding fields.
5946: -- + Update po_line_locations_all for approved flag
5947:
5948: IF (g_po_wf_debug = 'Y') THEN
5949: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key, l_log_head || ' 001');

Line 5963: UPDATE po_headers poh

5959: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key, l_log_head || ' 002 Updating status for Userid-' || l_user_id
5960: || ' LoginId-' || l_login_id || ' and DocumentId' || p_document_id);
5961: END IF;
5962:
5963: UPDATE po_headers poh
5964: SET poh.authorization_status = po_document_action_pvt.g_doc_status_approved
5965: ,poh.approved_flag = 'Y'
5966: ,poh.approved_date = sysdate
5967: ,poh.last_update_date = sysdate

Line 5976: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key, l_log_head || ' 003 : After updating po_headers_all ');

5972: ,acceptance_due_date = Null
5973: WHERE poh.po_header_id = p_document_id;
5974:
5975: IF (g_po_wf_debug = 'Y') THEN
5976: PO_WF_DEBUG_PKG.insert_debug(p_item_type,p_item_key, l_log_head || ' 003 : After updating po_headers_all ');
5977: END IF;
5978:
5979: UPDATE po_line_locations_all poll
5980: SET poll.approved_flag = 'Y'

Line 6039: l_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;

6035: l_msg_count NUMBER;
6036: l_msg_data VARCHAR2(2000);
6037: l_acceptance_date DATE;
6038: x_error_msg VARCHAR2(2000);
6039: l_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
6040: l_binding_exception EXCEPTION;
6041: l_progress VARCHAR2(3);
6042: BEGIN
6043: -- Logic :

Line 6193: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;

6189: l_document_id NUMBER;
6190: l_api_name VARCHAR2(500) := 'trigger_approval_workflow';
6191: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
6192: l_result VARCHAR2(1);
6193: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
6194:
6195: BEGIN
6196:
6197: -- Logic :

Line 6213: FROM po_headers_all poh

6209:
6210: -- Fetch PO approval workflow item key from pbase table.
6211: SELECT wf_item_key
6212: INTO l_po_itemkey
6213: FROM po_headers_all poh
6214: WHERE poh.po_header_id = l_document_id;
6215:
6216: -- Completes the Blocked Activities in the PO Approval process
6217: PO_SIGNATURE_PVT.Complete_Block_Activities(p_itemkey => l_po_itemkey,