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_SIGNATURE_PVT dependencies on PO_HEADERS_ALL

Line 18: -- po_headers_all and po_vendors

14:
15:
16: --Cursor to select the PO details to be used in the notification message bodies
17: -- SQL What:selects the PO details and the vendor details from
18: -- po_headers_all and po_vendors
19: -- SQL Why :To show the details in the Notifications of the Document
20: -- Signature Process.
21: -- SQL Join: PO_HEADER_ID, VENDOR_ID
22:

Line 36: FROM PO_HEADERS_ALL PHA,

32: HRL_S.location_code ship_to_location,
33: DECODE(PHA.vendor_contact_id, NULL, NULL,
34: VC.last_name||', '||VC.first_name) vendor_contact,
35: PHA.blanket_total_amount
36: FROM PO_HEADERS_ALL PHA,
37: PO_VENDORS VO,
38: PO_VENDOR_CONTACTS VC,
39: HR_LOCATIONS_ALL_TL HRL_S,
40: HR_LOCATIONS_ALL_TL HRL_B

Line 82: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

78: actid IN NUMBER,
79: funcmode IN VARCHAR2,
80: resultout OUT NOCOPY VARCHAR2) IS
81:
82: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
83: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
84: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
85: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
86: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;

Line 84: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;

80: resultout OUT NOCOPY VARCHAR2) IS
81:
82: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
83: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
84: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
85: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
86: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
87: l_revision PO_HEADERS_ALL.revision_num%TYPE;
88: l_orgid PO_HEADERS_ALL.org_id%TYPE;

Line 85: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

81:
82: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
83: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
84: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
85: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
86: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
87: l_revision PO_HEADERS_ALL.revision_num%TYPE;
88: l_orgid PO_HEADERS_ALL.org_id%TYPE;
89: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;

Line 87: l_revision PO_HEADERS_ALL.revision_num%TYPE;

83: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
84: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
85: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
86: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
87: l_revision PO_HEADERS_ALL.revision_num%TYPE;
88: l_orgid PO_HEADERS_ALL.org_id%TYPE;
89: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
90: l_username FND_USER.user_name%TYPE;
91: l_user_display_name FND_USER.description%TYPE;

Line 88: l_orgid PO_HEADERS_ALL.org_id%TYPE;

84: l_document_subtype PO_HEADERS_ALL.type_lookup_code%TYPE;
85: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
86: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
87: l_revision PO_HEADERS_ALL.revision_num%TYPE;
88: l_orgid PO_HEADERS_ALL.org_id%TYPE;
89: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
90: l_username FND_USER.user_name%TYPE;
91: l_user_display_name FND_USER.description%TYPE;
92: l_progress VARCHAR2(300);

Line 89: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;

85: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
86: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;
87: l_revision PO_HEADERS_ALL.revision_num%TYPE;
88: l_orgid PO_HEADERS_ALL.org_id%TYPE;
89: l_preparer_id PO_HEADERS_ALL.agent_id%TYPE;
90: l_username FND_USER.user_name%TYPE;
91: l_user_display_name FND_USER.description%TYPE;
92: l_progress VARCHAR2(300);
93: l_vendor_name PO_VENDORS.vendor_name%TYPE;

Line 99: l_conterms_exist PO_HEADERS_ALL.conterms_exist_flag%type;

95: l_preparer_user_name WF_USERS.name%TYPE;
96: l_binding_exception EXCEPTION;
97: -- Forward port of bug 3897526. Display PDF attachment even when PO
98: -- has no terms
99: l_conterms_exist PO_HEADERS_ALL.conterms_exist_flag%type;
100: l_sign_attachments_value VARCHAR2(300);
101: --CLM Apprvl
102: l_draft_id NUMBER := -1;
103: l_supplier_user_name VARCHAR2(30);

Line 105: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;

101: --CLM Apprvl
102: l_draft_id NUMBER := -1;
103: l_supplier_user_name VARCHAR2(30);
104: l_esigner_exists VARCHAR2(1);
105: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
106: BEGIN
107:
108: IF (g_po_wf_debug = 'Y') THEN
109: l_progress := 'PO_SIGNATURE_PVT.Set_Startup_Values: 01';

Line 229: -- CLM Apprvl: Modified the table from po_headers_all to po_headers_merge_v and included draft_id check

225: -- category CONTRACT. See Bug 3897511.
226: -- : Signature notification should show the PDF document
227: -- for PO without contract terms as well
228:
229: -- CLM Apprvl: Modified the table from po_headers_all to po_headers_merge_v and included draft_id check
230:
231: BEGIN
232: SELECT NVL(poh.conterms_exist_flag,'N')
233: INTO l_conterms_exist

Line 304: FROM po_headers_all poh

300:
301: BEGIN
302: SELECT wf_item_key
303: INTO l_po_itemkey
304: FROM po_headers_all poh
305: WHERE poh.po_header_id = l_document_id;
306: EXCEPTION
307: WHEN others THEN
308: null;

Line 372: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

368: document IN OUT NOCOPY CLOB,
369: document_type IN OUT NOCOPY VARCHAR2) IS
370:
371: l_msgbody VARCHAR2(32000);
372: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
373: l_buyer_name FND_USER.user_name%TYPE;
374: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
375: l_supplier_response VARCHAR2(20);
376: l_item_type WF_ITEMS.item_type%TYPE;

Line 382: l_orgid PO_HEADERS_ALL.org_id%TYPE;

378: l_firstcolon NUMBER;
379: l_secondcolon NUMBER;
380: l_amount NUMBER;
381: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
382: l_orgid PO_HEADERS_ALL.org_id%TYPE;
383: l_doc_string VARCHAR2(200);
384: l_preparer_user_name WF_USERS.name%TYPE;
385: l_progress VARCHAR2(300);
386: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;

Line 394: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE; --bug11713924

390: x_legalentity_info xle_utilities_grp.LegalEntity_Rec;
391: x_return_status VARCHAR2(20) ;
392: x_msg_count NUMBER ;
393: x_msg_data VARCHAR2(4000) ;
394: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE; --bug11713924
395: l_supplier_change_note varchar2(320); --multi-mod
396: BEGIN
397:
398: l_firstcolon := instr(document_id, ':');

Line 603: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

599: l_supplier_response VARCHAR2(20);
600: l_ko_response VARCHAR2(20);
601: l_event_name VARCHAR2(50);
602: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
603: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
604: l_orgid PO_HEADERS_ALL.org_id%TYPE;
605: l_revision PO_HEADERS_ALL.revision_num%TYPE;
606: l_return_status VARCHAR2(1);
607: l_msg_count NUMBER;

Line 604: l_orgid PO_HEADERS_ALL.org_id%TYPE;

600: l_ko_response VARCHAR2(20);
601: l_event_name VARCHAR2(50);
602: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
603: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
604: l_orgid PO_HEADERS_ALL.org_id%TYPE;
605: l_revision PO_HEADERS_ALL.revision_num%TYPE;
606: l_return_status VARCHAR2(1);
607: l_msg_count NUMBER;
608: l_msg_data VARCHAR2(2000);

Line 605: l_revision PO_HEADERS_ALL.revision_num%TYPE;

601: l_event_name VARCHAR2(50);
602: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
603: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
604: l_orgid PO_HEADERS_ALL.org_id%TYPE;
605: l_revision PO_HEADERS_ALL.revision_num%TYPE;
606: l_return_status VARCHAR2(1);
607: l_msg_count NUMBER;
608: l_msg_data VARCHAR2(2000);
609: l_progress VARCHAR2(300);

Line 889: -- PO_HEADERS_ALL

885: --Pre-reqs:
886: -- None.
887: --Modifies:
888: -- PO_ACCEPTANCES
889: -- PO_HEADERS_ALL
890: -- PO_LINE_LOCATIONS_ALL
891: -- PO_ACTION_HISTORY
892: --Locks:
893: -- None.

Line 920: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

916: actid IN NUMBER,
917: funcmode IN VARCHAR2,
918: resultout OUT NOCOPY VARCHAR2) IS
919:
920: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
921: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
922: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
923: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
924: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

Line 924: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

920: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
921: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
922: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
923: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
924: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
925: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
926: l_user_id NUMBER;
927: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
928: l_role PO_ACCEPTANCES.role%TYPE;

Line 1035: PO_HEADERS_ALL poh

1031: BEGIN
1032: SELECT pvc.first_name||' '||pvc.last_name vendor_contact_name
1033: INTO l_vendor_contact_name
1034: FROM PO_VENDOR_CONTACTS pvc,
1035: PO_HEADERS_ALL poh
1036: WHERE pvc.vendor_contact_id = poh.vendor_contact_id
1037: AND pvc.vendor_site_id = poh.vendor_site_id
1038: AND poh.po_header_id = l_document_id;
1039: EXCEPTION

Line 1164: FROM PO_HEADERS_ALL

1160: SELECT wf_item_type,
1161: wf_item_key
1162: INTO l_po_itemtype,
1163: l_po_itemkey
1164: FROM PO_HEADERS_ALL
1165: WHERE po_header_id = l_document_id;
1166: end if;
1167:
1168:

Line 1417: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

1413: actid IN NUMBER,
1414: funcmode IN VARCHAR2,
1415: resultout OUT NOCOPY VARCHAR2) IS
1416:
1417: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1418: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE; -- for clm documents l_document_number should be of clm_document_number types
1419: l_progress VARCHAR2(300);
1420: l_doc_string VARCHAR2(200);
1421: l_preparer_user_name WF_USERS.name%TYPE;

Line 1418: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE; -- for clm documents l_document_number should be of clm_document_number types

1414: funcmode IN VARCHAR2,
1415: resultout OUT NOCOPY VARCHAR2) IS
1416:
1417: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1418: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE; -- for clm documents l_document_number should be of clm_document_number types
1419: l_progress VARCHAR2(300);
1420: l_doc_string VARCHAR2(200);
1421: l_preparer_user_name WF_USERS.name%TYPE;
1422: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

Line 1423: l_revision PO_HEADERS_ALL.revision_num%TYPE;

1419: l_progress VARCHAR2(300);
1420: l_doc_string VARCHAR2(200);
1421: l_preparer_user_name WF_USERS.name%TYPE;
1422: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1423: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1424: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
1425: BEGIN
1426:
1427: IF (g_po_wf_debug = 'Y') THEN

Line 1424: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;

1420: l_doc_string VARCHAR2(200);
1421: l_preparer_user_name WF_USERS.name%TYPE;
1422: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1423: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1424: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
1425: BEGIN
1426:
1427: IF (g_po_wf_debug = 'Y') THEN
1428: l_progress := 'PO_SIGNATURE_PVT.set_accepted_supplier_response: 01';

Line 1490: FROM po_headers_all poh

1486:
1487: -- PO AME Project : Changes made for Multiple E-signatures
1488: SELECT wf_item_key
1489: INTO l_po_itemkey
1490: FROM po_headers_all poh
1491: WHERE poh.po_header_id = l_document_id;
1492:
1493: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => l_po_itemkey, aname => 'SUPPLIER_RESPONSE', avalue => 'ACCEPTED');
1494:

Line 1544: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

1540: actid IN NUMBER,
1541: funcmode IN VARCHAR2,
1542: resultout OUT NOCOPY VARCHAR2) IS
1543:
1544: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1545: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
1546: l_progress VARCHAR2(300);
1547: l_doc_string VARCHAR2(200);
1548: l_preparer_user_name WF_USERS.name%TYPE;

Line 1545: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

1541: funcmode IN VARCHAR2,
1542: resultout OUT NOCOPY VARCHAR2) IS
1543:
1544: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1545: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
1546: l_progress VARCHAR2(300);
1547: l_doc_string VARCHAR2(200);
1548: l_preparer_user_name WF_USERS.name%TYPE;
1549: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

Line 1550: l_revision PO_HEADERS_ALL.revision_num%TYPE;

1546: l_progress VARCHAR2(300);
1547: l_doc_string VARCHAR2(200);
1548: l_preparer_user_name WF_USERS.name%TYPE;
1549: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1550: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1551: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
1552:
1553: BEGIN
1554:

Line 1551: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;

1547: l_doc_string VARCHAR2(200);
1548: l_preparer_user_name WF_USERS.name%TYPE;
1549: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1550: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1551: l_po_itemkey PO_HEADERS_ALL.wf_item_key%TYPE;
1552:
1553: BEGIN
1554:
1555: IF (g_po_wf_debug = 'Y') THEN

Line 1617: FROM po_headers_all poh

1613: END IF;
1614: -- PO AME Project : Changes made for Multiple E-signatures
1615: SELECT wf_item_key
1616: INTO l_po_itemkey
1617: FROM po_headers_all poh
1618: WHERE poh.po_header_id = l_document_id;
1619:
1620: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype, itemkey => l_po_itemkey, aname => 'SUPPLIER_RESPONSE', avalue => 'REJECTED');
1621:

Line 1668: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

1664: document IN OUT NOCOPY CLOB,
1665: document_type IN OUT NOCOPY VARCHAR2) IS
1666:
1667: l_msgbody VARCHAR2(32000);
1668: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1669: l_buyer_name FND_USER.user_name%TYPE;
1670: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1671: l_item_type WF_ITEMS.item_type%TYPE;
1672: l_item_key WF_ITEMS.item_key%TYPE;

Line 1676: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

1672: l_item_key WF_ITEMS.item_key%TYPE;
1673: l_firstcolon NUMBER;
1674: l_secondcolon NUMBER;
1675: l_amount NUMBER;
1676: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
1677: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1678: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1679: l_supplier_displayname WF_LOCAL_ROLES.display_name%TYPE;
1680: l_supplier_username WF_LOCAL_ROLES.name%TYPE;

Line 1678: l_revision PO_HEADERS_ALL.revision_num%TYPE;

1674: l_secondcolon NUMBER;
1675: l_amount NUMBER;
1676: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
1677: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1678: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1679: l_supplier_displayname WF_LOCAL_ROLES.display_name%TYPE;
1680: l_supplier_username WF_LOCAL_ROLES.name%TYPE;
1681: l_supplier_org PO_VENDORS.vendor_name%TYPE;
1682: l_supplier_userid WF_LOCAL_ROLES.orig_system_id%TYPE;

Line 1684: l_orgid PO_HEADERS_ALL.org_id%TYPE;

1680: l_supplier_username WF_LOCAL_ROLES.name%TYPE;
1681: l_supplier_org PO_VENDORS.vendor_name%TYPE;
1682: l_supplier_userid WF_LOCAL_ROLES.orig_system_id%TYPE;
1683: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1684: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1685: l_doc_string VARCHAR2(200);
1686: l_preparer_user_name WF_USERS.name%TYPE;
1687: l_progress VARCHAR2(300);
1688: l_binding_exception EXCEPTION;

Line 1918: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

1914: actid IN NUMBER,
1915: funcmode IN VARCHAR2,
1916: resultout OUT NOCOPY VARCHAR2) IS
1917:
1918: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1919: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
1920: l_progress VARCHAR2(300);
1921: l_doc_string VARCHAR2(200);
1922: l_preparer_user_name WF_USERS.name%TYPE;

Line 1919: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

1915: funcmode IN VARCHAR2,
1916: resultout OUT NOCOPY VARCHAR2) IS
1917:
1918: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1919: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
1920: l_progress VARCHAR2(300);
1921: l_doc_string VARCHAR2(200);
1922: l_preparer_user_name WF_USERS.name%TYPE;
1923: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

Line 1924: l_revision PO_HEADERS_ALL.revision_num%TYPE;

1920: l_progress VARCHAR2(300);
1921: l_doc_string VARCHAR2(200);
1922: l_preparer_user_name WF_USERS.name%TYPE;
1923: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1924: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1925:
1926: BEGIN
1927:
1928: IF (g_po_wf_debug = 'Y') THEN

Line 2032: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

2028: document IN OUT NOCOPY CLOB,
2029: document_type IN OUT NOCOPY VARCHAR2) IS
2030:
2031: l_msgbody VARCHAR2(32000);
2032: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2033: l_buyer_name FND_USER.user_name%TYPE;
2034: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
2035: l_buyer_response VARCHAR2(20);
2036: l_item_type WF_ITEMS.item_type%TYPE;

Line 2041: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

2037: l_item_key WF_ITEMS.item_key%TYPE;
2038: l_firstcolon NUMBER;
2039: l_secondcolon NUMBER;
2040: l_amount NUMBER;
2041: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
2042: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
2043: l_revision PO_HEADERS_ALL.revision_num%TYPE;
2044: l_supplier_name FND_USER.user_name%TYPE;
2045: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;

Line 2043: l_revision PO_HEADERS_ALL.revision_num%TYPE;

2039: l_secondcolon NUMBER;
2040: l_amount NUMBER;
2041: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
2042: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
2043: l_revision PO_HEADERS_ALL.revision_num%TYPE;
2044: l_supplier_name FND_USER.user_name%TYPE;
2045: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
2046: l_orgid PO_HEADERS_ALL.org_id%TYPE;
2047: l_doc_string VARCHAR2(200);

Line 2046: l_orgid PO_HEADERS_ALL.org_id%TYPE;

2042: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
2043: l_revision PO_HEADERS_ALL.revision_num%TYPE;
2044: l_supplier_name FND_USER.user_name%TYPE;
2045: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
2046: l_orgid PO_HEADERS_ALL.org_id%TYPE;
2047: l_doc_string VARCHAR2(200);
2048: l_preparer_user_name WF_USERS.name%TYPE;
2049: l_progress VARCHAR2(300);
2050: l_binding_exception EXCEPTION;

Line 2273: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

2269: actid IN NUMBER,
2270: funcmode IN VARCHAR2,
2271: resultout OUT NOCOPY VARCHAR2) IS
2272:
2273: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2274: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
2275: l_progress VARCHAR2(300);
2276: l_doc_string VARCHAR2(200);
2277: l_preparer_user_name WF_USERS.name%TYPE;

Line 2274: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

2270: funcmode IN VARCHAR2,
2271: resultout OUT NOCOPY VARCHAR2) IS
2272:
2273: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2274: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
2275: l_progress VARCHAR2(300);
2276: l_doc_string VARCHAR2(200);
2277: l_preparer_user_name WF_USERS.name%TYPE;
2278: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

Line 2279: l_revision PO_HEADERS_ALL.revision_num%TYPE;

2275: l_progress VARCHAR2(300);
2276: l_doc_string VARCHAR2(200);
2277: l_preparer_user_name WF_USERS.name%TYPE;
2278: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
2279: l_revision PO_HEADERS_ALL.revision_num%TYPE;
2280:
2281: BEGIN
2282:
2283: IF (g_po_wf_debug = 'Y') THEN

Line 2385: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';

2381: funcmode IN VARCHAR2,
2382: resultout OUT NOCOPY VARCHAR2) IS
2383:
2384: l_req_signature VARCHAR2(1);
2385: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2386: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2387: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2388: l_progress VARCHAR2(300);
2389: l_doc_string VARCHAR2(200);

Line 2387: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

2383:
2384: l_req_signature VARCHAR2(1);
2385: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2386: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2387: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2388: l_progress VARCHAR2(300);
2389: l_doc_string VARCHAR2(200);
2390: l_preparer_user_name WF_USERS.name%TYPE;
2391:

Line 2471: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

2467: l_log_head VARCHAR2(100) := g_pkg_name || '.' || l_api_name;
2468: l_progress VARCHAR2(3);
2469:
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:

Line 2473: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';

2469:
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:

Line 2711: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;

2707: l_progress VARCHAR2(300);
2708: l_doc_string VARCHAR2(200);
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

Line 2712: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

2708: l_doc_string VARCHAR2(200);
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:

Line 2766: UPDATE po_headers_all

2762: AND draft_id = l_draft_id
2763: AND clm_contract_officer <> l_contracting_officer;
2764: ELSE
2765:
2766: UPDATE po_headers_all
2767: SET clm_contract_officer = l_contracting_officer
2768: WHERE po_header_id = l_document_id
2769: AND clm_contract_officer <> l_contracting_officer;
2770: END IF;

Line 2823: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;

2819: l_progress VARCHAR2(300);
2820: l_doc_string VARCHAR2(200);
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

Line 2824: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

2820: l_doc_string VARCHAR2(200);
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:

Line 2878: UPDATE po_headers_all

2874: AND draft_id = l_draft_id
2875: AND clm_contract_officer <> l_contracting_officer;
2876: ELSE
2877:
2878: UPDATE po_headers_all
2879: SET clm_contract_officer = l_contracting_officer
2880: WHERE po_header_id = l_document_id
2881: AND clm_contract_officer <> l_contracting_officer;
2882: END IF;

Line 2937: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;

2933: ) IS
2934:
2935: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PO_DETAILS'; -- Bug 3602512
2936:
2937: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
2938: l_return_status VARCHAR2(1);
2939: l_msg_count NUMBER;
2940: l_msg_data VARCHAR2(2000);
2941: l_ret_sts VARCHAR2(1); --bug 13507482

Line 2987: -- SQL What:Updates PO_HEADERS_ALL table and sets the Authorization status

2983: -- PO_DOCUMENT_REVISION_GRP.Check_New_Revision()
2984:
2985: END IF;
2986:
2987: -- SQL What:Updates PO_HEADERS_ALL table and sets the Authorization status
2988: -- to 'APPROVED' or 'REJECTED'
2989: -- SQL Why :To move the document from the PRE-APPROVED status
2990: -- SQL Join:po_header_id
2991:

Line 2992: UPDATE PO_HEADERS_ALL

2988: -- to 'APPROVED' or 'REJECTED'
2989: -- SQL Why :To move the document from the PRE-APPROVED status
2990: -- SQL Join:po_header_id
2991:
2992: UPDATE PO_HEADERS_ALL
2993: SET authorization_status = p_status,
2994: approved_flag = l_approved_flag,
2995: pending_signature_flag = 'N',
2996: acceptance_required_flag = 'N',

Line 3173: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;

3169: pragma AUTONOMOUS_TRANSACTION; --bug 9924585 making this an autonomous transaction
3170:
3171: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PO_DETAILS'; -- Bug 3602512
3172:
3173: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
3174: l_return_status VARCHAR2(1);
3175: l_msg_count NUMBER;
3176: l_msg_data VARCHAR2(2000);
3177:

Line 3185: -- SQL What:Updates PO_HEADERS_ALL table and sets the Authorization status

3181: ELSIF (p_status = 'APPROVED') THEN
3182: l_approved_flag := 'Y';
3183: END IF;
3184:
3185: -- SQL What:Updates PO_HEADERS_ALL table and sets the Authorization status
3186: -- to 'APPROVED' or 'REJECTED'
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

Line 3201: UPDATE PO_HEADERS_ALL

3197: last_update_date = sysdate
3198: WHERE po_header_id = p_po_header_id
3199: AND draft_id = p_draft_id;
3200: else
3201: UPDATE PO_HEADERS_ALL
3202: SET pending_signature_flag = 'N',
3203: acceptance_required_flag = 'N',
3204: acceptance_due_date = Null,
3205: last_updated_by = FND_GLOBAL.user_id,

Line 3618: l_current_org PO_HEADERS_ALL.org_id%TYPE;

3614: p_revision_num IN NUMBER,
3615: x_erecord_exist OUT NOCOPY VARCHAR2,
3616: x_pending_signature OUT NOCOPY VARCHAR2)
3617: IS
3618: l_current_org PO_HEADERS_ALL.org_id%TYPE;
3619: l_doc_org PO_HEADERS_ALL.org_id%TYPE;
3620: BEGIN
3621:
3622: l_current_org := PO_GA_PVT.get_current_org;

Line 3619: l_doc_org PO_HEADERS_ALL.org_id%TYPE;

3615: x_erecord_exist OUT NOCOPY VARCHAR2,
3616: x_pending_signature OUT NOCOPY VARCHAR2)
3617: IS
3618: l_current_org PO_HEADERS_ALL.org_id%TYPE;
3619: l_doc_org PO_HEADERS_ALL.org_id%TYPE;
3620: BEGIN
3621:
3622: l_current_org := PO_GA_PVT.get_current_org;
3623: l_doc_org := PO_GA_PVT.get_org_id(p_po_header_id);

Line 3633: -- SQL What: Selects the Pending_Signature_Flag from the PO_HEADERS_ALL table

3629: -- If the document is not 'release' and if the pending_signature_flag is 'Y',
3630: -- PO_SIGNATURE parameter should be set to 'Y' which allows inserts in the
3631: -- Aceptances form. Otherwise Acceptances form is called in the view only mode
3632: BEGIN
3633: -- SQL What: Selects the Pending_Signature_Flag from the PO_HEADERS_ALL table
3634: -- SQL Why : To find out if the document has pending signatures or not
3635: -- SQL Join: PO_HEADER_ID
3636:
3637: -- Bug 3677988: inserts in acceptances form should not be allowed for PO on hold

Line 3642: FROM PO_HEADERS_ALL

3638: -- This is facilitated by checking for user_hold_flag <> 'Y'.
3639:
3640: SELECT NVL(pending_signature_flag,'N')
3641: INTO x_pending_signature
3642: FROM PO_HEADERS_ALL
3643: WHERE po_header_id = p_po_header_id
3644: AND nvl(user_hold_flag, 'N') <> 'Y';
3645:
3646: EXCEPTION

Line 3684: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY

3680: --Name: Post_Forms_Commit
3681: --Pre-reqs:
3682: -- None.
3683: --Modifies:
3684: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY
3685: --Locks:
3686: -- None.
3687: --Function:
3688: -- Checks the logic for completion of signatures and updates PO tables

Line 3718: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

3714: l_buyer_accepted_count PLS_INTEGER := 0;
3715: l_buyer_rejected_count PLS_INTEGER := 0;
3716: l_supplier_accepted_count PLS_INTEGER := 0;
3717: l_supplier_rejected_count PLS_INTEGER := 0;
3718: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3719: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
3720: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
3721: l_po_itemkey WF_ITEMS.item_key%TYPE;
3722: l_po_itemtype WF_ITEMS.item_type%TYPE;

Line 3719: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;

3715: l_buyer_rejected_count PLS_INTEGER := 0;
3716: l_supplier_accepted_count PLS_INTEGER := 0;
3717: l_supplier_rejected_count PLS_INTEGER := 0;
3718: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
3719: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
3720: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
3721: l_po_itemkey WF_ITEMS.item_key%TYPE;
3722: l_po_itemtype WF_ITEMS.item_type%TYPE;
3723: l_itemkey WF_ITEMS.item_key%TYPE;

Line 3762: -- SQL What :selects the type_lookup_code and agent_id from PO_HEADERS_ALL

3758: Null;
3759: END;
3760:
3761: BEGIN
3762: -- SQL What :selects the type_lookup_code and agent_id from PO_HEADERS_ALL
3763: -- SQL Why :To pass it po_action_history row handler for inserting a row
3764: -- SQL Join :PO_HEADER_ID
3765:
3766: -- bug 3568077

Line 3786: FROM PO_HEADERS_ALL

3782: l_object_code,
3783: l_agent_id,
3784: l_po_itemtype,
3785: l_po_itemkey
3786: FROM PO_HEADERS_ALL
3787: WHERE Po_Header_Id = p_po_header_id;
3788: EXCEPTION
3789: WHEN NO_DATA_FOUND THEN
3790: RAISE l_binding_exception;

Line 4117: -- PO_HEADERS_ALL

4113: --Pre-reqs:
4114: -- This code should be called when we have already revised the document and
4115: -- updated the revision_num and revised_date field.
4116: --Modifies:
4117: -- PO_HEADERS_ALL
4118: --Locks:
4119: -- None.
4120: --Function:
4121: -- This function checks if there is atleast one signed revision

Line 4153: UPDATE PO_HEADERS_ALL POH

4149: PO_LOG.stmt(d_module,d_pos,'l_was_sign_reqd',l_was_sign_reqd);
4150: END IF;
4151:
4152: IF l_was_sign_reqd THEN
4153: UPDATE PO_HEADERS_ALL POH
4154: SET POH.acceptance_required_flag = 'S'
4155: WHERE POH.po_header_id = p_document_id;
4156: x_if_acc_flag_updated := 'Y';
4157: END IF;

Line 4179: -- PO_HEADERS_ALL

4175: --Name: if_rev_and_signed_set_acc_flag
4176: --Pre-reqs:
4177: -- None.
4178: --Modifies:
4179: -- PO_HEADERS_ALL
4180: --Locks:
4181: -- None.
4182: --Function:
4183: -- Updates the acceptance_required_field to 'S' if the revision number in the

Line 4206: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

4202: x_if_acc_flag_updated OUT NOCOPY VARCHAR2)
4203: IS
4204: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.if_rev_and_signed_set_acc_flag';
4205: d_pos NUMBER := 0;
4206: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
4207: BEGIN
4208: SELECT revision_num
4209: INTO l_revision_num
4210: FROM po_headers_all

Line 4210: FROM po_headers_all

4206: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
4207: BEGIN
4208: SELECT revision_num
4209: INTO l_revision_num
4210: FROM po_headers_all
4211: WHERE po_header_id = p_document_id;
4212:
4213: d_pos := 10;
4214:

Line 4268: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

4264: resultout OUT NOCOPY VARCHAR2) IS
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;

Line 4402: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

4398: l_progress VARCHAR2(3);
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:

Line 4404: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';

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
4408:

Line 4623: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

4619: actid IN NUMBER,
4620: funcmode IN VARCHAR2,
4621: resultout OUT NOCOPY VARCHAR2) IS
4622:
4623: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4624: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
4625: l_progress VARCHAR2(300);
4626: l_doc_string VARCHAR2(200);
4627: l_preparer_user_name WF_USERS.name%TYPE;

Line 4624: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

4620: funcmode IN VARCHAR2,
4621: resultout OUT NOCOPY VARCHAR2) IS
4622:
4623: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4624: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
4625: l_progress VARCHAR2(300);
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;

Line 4629: l_revision PO_HEADERS_ALL.revision_num%TYPE;

4625: l_progress VARCHAR2(300);
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;

Line 4637: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;

4633: l_online_report_id NUMBER;
4634: l_user_id po_lines.last_updated_by%TYPE := -1;
4635: l_login_id po_lines.last_update_login%TYPE := -1;
4636: l_sequence po_online_report_text.sequence%TYPE :=0;
4637: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;
4638:
4639: BEGIN
4640:
4641: IF (g_po_wf_debug = 'Y') THEN

Line 4788: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

4784: actid IN NUMBER,
4785: funcmode IN VARCHAR2,
4786: resultout OUT NOCOPY VARCHAR2) IS
4787:
4788: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4789: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
4790: l_progress VARCHAR2(300);
4791: l_doc_string VARCHAR2(200);
4792: l_preparer_user_name WF_USERS.name%TYPE;

Line 4789: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;

4785: funcmode IN VARCHAR2,
4786: resultout OUT NOCOPY VARCHAR2) IS
4787:
4788: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
4789: l_document_number PO_HEADERS_ALL.clm_document_number%TYPE;
4790: l_progress VARCHAR2(300);
4791: l_doc_string VARCHAR2(200);
4792: l_preparer_user_name WF_USERS.name%TYPE;
4793: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

Line 4794: l_revision PO_HEADERS_ALL.revision_num%TYPE;

4790: l_progress VARCHAR2(300);
4791: l_doc_string VARCHAR2(200);
4792: l_preparer_user_name WF_USERS.name%TYPE;
4793: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
4794: l_revision PO_HEADERS_ALL.revision_num%TYPE;
4795:
4796: BEGIN
4797:
4798: IF (g_po_wf_debug = 'Y') THEN

Line 4902: l_document_id PO_HEADERs_ALL.po_header_id%TYPE;

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;
4905: l_user_id po_lines.last_updated_by%TYPE := -1;
4906: l_login_id po_lines.last_update_login%TYPE := -1;

Line 4908: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;

4904: l_online_report_id NUMBER;
4905: l_user_id po_lines.last_updated_by%TYPE := -1;
4906: l_login_id po_lines.last_update_login%TYPE := -1;
4907: l_sequence po_online_report_text.sequence%TYPE :=0;
4908: l_contracting_officer po_headers_all.clm_contract_officer%TYPE;
4909: l_progress VARCHAR2(300);
4910: BEGIN
4911:
4912:

Line 4980: UPDATE po_headers_all

4976: AND draft_id = l_draft_id
4977: AND clm_contract_officer <> l_contracting_officer;
4978: ELSE
4979:
4980: UPDATE po_headers_all
4981: SET clm_contract_officer = l_contracting_officer
4982: WHERE po_header_id = l_document_id
4983: AND clm_contract_officer <> l_contracting_officer;
4984: END IF;

Line 5021: UPDATE po_headers_all

5017: );
5018: END IF;
5019: -- Set the pending_signature_flag to 'C' when the KO sign is initiated.
5020: IF l_draft_id = -1 THEN
5021: UPDATE po_headers_all
5022: SET pending_signature_flag = 'C'
5023: WHERE po_header_id = l_document_id;
5024:
5025: commit;