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.segment1%TYPE;

78: actid IN NUMBER,
79: funcmode IN VARCHAR2,
80: resultout OUT NOCOPY VARCHAR2) IS
81:
82: l_document_number PO_HEADERS_ALL.segment1%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.segment1%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.segment1%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: BEGIN
102:
103: IF (g_po_wf_debug = 'Y') THEN

Line 208: FROM po_headers_all poh

204:
205: BEGIN
206: SELECT NVL(poh.conterms_exist_flag,'N')
207: INTO l_conterms_exist
208: FROM po_headers_all poh
209: WHERE poh.po_header_id = l_document_id;
210: EXCEPTION
211: WHEN others THEN
212: null; --In case of any exception, document from OKC_CONTRACT_DOCS

Line 299: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

295: document IN OUT NOCOPY CLOB,
296: document_type IN OUT NOCOPY VARCHAR2) IS
297:
298: l_msgbody VARCHAR2(32000);
299: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
300: l_buyer_name FND_USER.user_name%TYPE;
301: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
302: l_supplier_response VARCHAR2(20);
303: l_item_type WF_ITEMS.item_type%TYPE;

Line 309: l_orgid PO_HEADERS_ALL.org_id%TYPE;

305: l_firstcolon NUMBER;
306: l_secondcolon NUMBER;
307: l_amount NUMBER;
308: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
309: l_orgid PO_HEADERS_ALL.org_id%TYPE;
310: l_doc_string VARCHAR2(200);
311: l_preparer_user_name WF_USERS.name%TYPE;
312: l_progress VARCHAR2(300);
313: l_doc_display_name PO_DOCUMENT_TYPES.type_name%TYPE;

Line 515: l_document_number PO_HEADERS_ALL.segment1%TYPE;

511: l_response VARCHAR2(20);
512: l_supplier_response VARCHAR2(20);
513: l_event_name VARCHAR2(50);
514: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
515: l_document_number PO_HEADERS_ALL.segment1%TYPE;
516: l_orgid PO_HEADERS_ALL.org_id%TYPE;
517: l_revision PO_HEADERS_ALL.revision_num%TYPE;
518: l_return_status VARCHAR2(1);
519: l_msg_count NUMBER;

Line 516: l_orgid PO_HEADERS_ALL.org_id%TYPE;

512: l_supplier_response VARCHAR2(20);
513: l_event_name VARCHAR2(50);
514: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
515: l_document_number PO_HEADERS_ALL.segment1%TYPE;
516: l_orgid PO_HEADERS_ALL.org_id%TYPE;
517: l_revision PO_HEADERS_ALL.revision_num%TYPE;
518: l_return_status VARCHAR2(1);
519: l_msg_count NUMBER;
520: l_msg_data VARCHAR2(2000);

Line 517: l_revision PO_HEADERS_ALL.revision_num%TYPE;

513: l_event_name VARCHAR2(50);
514: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
515: l_document_number PO_HEADERS_ALL.segment1%TYPE;
516: l_orgid PO_HEADERS_ALL.org_id%TYPE;
517: l_revision PO_HEADERS_ALL.revision_num%TYPE;
518: l_return_status VARCHAR2(1);
519: l_msg_count NUMBER;
520: l_msg_data VARCHAR2(2000);
521: l_progress VARCHAR2(300);

Line 761: -- PO_HEADERS_ALL

757: --Pre-reqs:
758: -- None.
759: --Modifies:
760: -- PO_ACCEPTANCES
761: -- PO_HEADERS_ALL
762: -- PO_LINE_LOCATIONS_ALL
763: -- PO_ACTION_HISTORY
764: --Locks:
765: -- None.

Line 792: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

788: actid IN NUMBER,
789: funcmode IN VARCHAR2,
790: resultout OUT NOCOPY VARCHAR2) IS
791:
792: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
793: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
794: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
795: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
796: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

Line 796: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

792: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
793: l_document_type_code PO_DOCUMENT_TYPES.document_type_code%TYPE;
794: l_document_sub_type_code PO_DOCUMENT_TYPES.document_subtype%TYPE;
795: l_erecord_id PO_ACCEPTANCES.erecord_id%TYPE;
796: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
797: l_employee_id PO_ACCEPTANCES.employee_id%TYPE;
798: l_user_id NUMBER;
799: l_acceptance_note PO_ACCEPTANCES.note%TYPE;
800: l_role PO_ACCEPTANCES.role%TYPE;

Line 917: FROM PO_HEADERS_ALL

913: SELECT wf_item_type,
914: wf_item_key
915: INTO l_po_itemtype,
916: l_po_itemkey
917: FROM PO_HEADERS_ALL
918: WHERE po_header_id = l_document_id;
919:
920: -- Bug 4417522: Removed this profile option
921: -- Get the Profile value for the PO: Auto-approve PO after buyer's eSignature

Line 1113: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

1109: actid IN NUMBER,
1110: funcmode IN VARCHAR2,
1111: resultout OUT NOCOPY VARCHAR2) IS
1112:
1113: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1114: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1115: l_progress VARCHAR2(300);
1116: l_doc_string VARCHAR2(200);
1117: l_preparer_user_name WF_USERS.name%TYPE;

Line 1114: l_document_number PO_HEADERS_ALL.segment1%TYPE;

1110: funcmode IN VARCHAR2,
1111: resultout OUT NOCOPY VARCHAR2) IS
1112:
1113: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1114: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1115: l_progress VARCHAR2(300);
1116: l_doc_string VARCHAR2(200);
1117: l_preparer_user_name WF_USERS.name%TYPE;
1118: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

Line 1119: l_revision PO_HEADERS_ALL.revision_num%TYPE;

1115: l_progress VARCHAR2(300);
1116: l_doc_string VARCHAR2(200);
1117: l_preparer_user_name WF_USERS.name%TYPE;
1118: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1119: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1120:
1121: BEGIN
1122:
1123: IF (g_po_wf_debug = 'Y') THEN

Line 1220: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

1216: actid IN NUMBER,
1217: funcmode IN VARCHAR2,
1218: resultout OUT NOCOPY VARCHAR2) IS
1219:
1220: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1221: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1222: l_progress VARCHAR2(300);
1223: l_doc_string VARCHAR2(200);
1224: l_preparer_user_name WF_USERS.name%TYPE;

Line 1221: l_document_number PO_HEADERS_ALL.segment1%TYPE;

1217: funcmode IN VARCHAR2,
1218: resultout OUT NOCOPY VARCHAR2) IS
1219:
1220: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1221: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1222: l_progress VARCHAR2(300);
1223: l_doc_string VARCHAR2(200);
1224: l_preparer_user_name WF_USERS.name%TYPE;
1225: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

Line 1226: l_revision PO_HEADERS_ALL.revision_num%TYPE;

1222: l_progress VARCHAR2(300);
1223: l_doc_string VARCHAR2(200);
1224: l_preparer_user_name WF_USERS.name%TYPE;
1225: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1226: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1227:
1228: BEGIN
1229:
1230: IF (g_po_wf_debug = 'Y') THEN

Line 1325: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

1321: document IN OUT NOCOPY CLOB,
1322: document_type IN OUT NOCOPY VARCHAR2) IS
1323:
1324: l_msgbody VARCHAR2(32000);
1325: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1326: l_buyer_name FND_USER.user_name%TYPE;
1327: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1328: l_item_type WF_ITEMS.item_type%TYPE;
1329: l_item_key WF_ITEMS.item_key%TYPE;

Line 1333: l_document_number PO_HEADERS_ALL.segment1%TYPE;

1329: l_item_key WF_ITEMS.item_key%TYPE;
1330: l_firstcolon NUMBER;
1331: l_secondcolon NUMBER;
1332: l_amount NUMBER;
1333: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1334: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1335: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1336: l_supplier_displayname WF_LOCAL_ROLES.display_name%TYPE;
1337: l_supplier_username WF_LOCAL_ROLES.name%TYPE;

Line 1335: l_revision PO_HEADERS_ALL.revision_num%TYPE;

1331: l_secondcolon NUMBER;
1332: l_amount NUMBER;
1333: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1334: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1335: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1336: l_supplier_displayname WF_LOCAL_ROLES.display_name%TYPE;
1337: l_supplier_username WF_LOCAL_ROLES.name%TYPE;
1338: l_supplier_org PO_VENDORS.vendor_name%TYPE;
1339: l_supplier_userid WF_LOCAL_ROLES.orig_system_id%TYPE;

Line 1341: l_orgid PO_HEADERS_ALL.org_id%TYPE;

1337: l_supplier_username WF_LOCAL_ROLES.name%TYPE;
1338: l_supplier_org PO_VENDORS.vendor_name%TYPE;
1339: l_supplier_userid WF_LOCAL_ROLES.orig_system_id%TYPE;
1340: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1341: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1342: l_doc_string VARCHAR2(200);
1343: l_preparer_user_name WF_USERS.name%TYPE;
1344: l_progress VARCHAR2(300);
1345: l_binding_exception EXCEPTION;

Line 1574: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

1570: actid IN NUMBER,
1571: funcmode IN VARCHAR2,
1572: resultout OUT NOCOPY VARCHAR2) IS
1573:
1574: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1575: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1576: l_progress VARCHAR2(300);
1577: l_doc_string VARCHAR2(200);
1578: l_preparer_user_name WF_USERS.name%TYPE;

Line 1575: l_document_number PO_HEADERS_ALL.segment1%TYPE;

1571: funcmode IN VARCHAR2,
1572: resultout OUT NOCOPY VARCHAR2) IS
1573:
1574: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1575: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1576: l_progress VARCHAR2(300);
1577: l_doc_string VARCHAR2(200);
1578: l_preparer_user_name WF_USERS.name%TYPE;
1579: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

Line 1580: l_revision PO_HEADERS_ALL.revision_num%TYPE;

1576: l_progress VARCHAR2(300);
1577: l_doc_string VARCHAR2(200);
1578: l_preparer_user_name WF_USERS.name%TYPE;
1579: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1580: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1581:
1582: BEGIN
1583:
1584: IF (g_po_wf_debug = 'Y') THEN

Line 1681: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

1677: document IN OUT NOCOPY CLOB,
1678: document_type IN OUT NOCOPY VARCHAR2) IS
1679:
1680: l_msgbody VARCHAR2(32000);
1681: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1682: l_buyer_name FND_USER.user_name%TYPE;
1683: l_msgtext FND_NEW_MESSAGES.message_text%TYPE;
1684: l_buyer_response VARCHAR2(20);
1685: l_item_type WF_ITEMS.item_type%TYPE;

Line 1690: l_document_number PO_HEADERS_ALL.segment1%TYPE;

1686: l_item_key WF_ITEMS.item_key%TYPE;
1687: l_firstcolon NUMBER;
1688: l_secondcolon NUMBER;
1689: l_amount NUMBER;
1690: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1691: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1692: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1693: l_supplier_name FND_USER.user_name%TYPE;
1694: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;

Line 1692: l_revision PO_HEADERS_ALL.revision_num%TYPE;

1688: l_secondcolon NUMBER;
1689: l_amount NUMBER;
1690: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1691: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1692: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1693: l_supplier_name FND_USER.user_name%TYPE;
1694: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1695: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1696: l_doc_string VARCHAR2(200);

Line 1695: l_orgid PO_HEADERS_ALL.org_id%TYPE;

1691: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;
1692: l_revision PO_HEADERS_ALL.revision_num%TYPE;
1693: l_supplier_name FND_USER.user_name%TYPE;
1694: l_buyer_org HR_LEGAL_ENTITIES.name%TYPE;
1695: l_orgid PO_HEADERS_ALL.org_id%TYPE;
1696: l_doc_string VARCHAR2(200);
1697: l_preparer_user_name WF_USERS.name%TYPE;
1698: l_progress VARCHAR2(300);
1699: l_binding_exception EXCEPTION;

Line 1922: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

1918: actid IN NUMBER,
1919: funcmode IN VARCHAR2,
1920: resultout OUT NOCOPY VARCHAR2) IS
1921:
1922: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1923: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1924: l_progress VARCHAR2(300);
1925: l_doc_string VARCHAR2(200);
1926: l_preparer_user_name WF_USERS.name%TYPE;

Line 1923: l_document_number PO_HEADERS_ALL.segment1%TYPE;

1919: funcmode IN VARCHAR2,
1920: resultout OUT NOCOPY VARCHAR2) IS
1921:
1922: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
1923: l_document_number PO_HEADERS_ALL.segment1%TYPE;
1924: l_progress VARCHAR2(300);
1925: l_doc_string VARCHAR2(200);
1926: l_preparer_user_name WF_USERS.name%TYPE;
1927: l_doc_display_name FND_NEW_MESSAGES.message_text%TYPE;

Line 1928: l_revision PO_HEADERS_ALL.revision_num%TYPE;

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

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

2023: funcmode IN VARCHAR2,
2024: resultout OUT NOCOPY VARCHAR2) IS
2025:
2026: l_req_signature VARCHAR2(1);
2027: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2028: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2029: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2030: l_progress VARCHAR2(300);
2031: l_doc_string VARCHAR2(200);

Line 2029: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

2025:
2026: l_req_signature VARCHAR2(1);
2027: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2028: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2029: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2030: l_progress VARCHAR2(300);
2031: l_doc_string VARCHAR2(200);
2032: l_preparer_user_name WF_USERS.name%TYPE;
2033:

Line 2113: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;

2109: l_log_head VARCHAR2(100) := g_pkg_name || '.' || l_api_name;
2110: l_progress VARCHAR2(3);
2111:
2112: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2113: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2114: l_signature_required BOOLEAN;
2115: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2116:
2117: BEGIN

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

2111:
2112: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE;
2113: l_document_id PO_HEADERS_ALL.po_header_id%TYPE;
2114: l_signature_required BOOLEAN;
2115: l_acceptance_flag PO_HEADERS_ALL.acceptance_required_flag%TYPE := 'N';
2116:
2117: BEGIN
2118:
2119: l_progress:='000'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress);

Line 2143: FROM po_headers_all

2139: IF ( l_document_type <> 'RELEASE' )
2140: THEN
2141: SELECT acceptance_required_flag
2142: INTO l_acceptance_flag
2143: FROM po_headers_all
2144: WHERE po_header_id = l_document_id;
2145: END IF;
2146:
2147: l_progress:='030'; PO_WF_DEBUG_PKG.insert_debug(p_itemtype,p_itemkey,l_log_head||':'||l_progress||' Acceptance Required Flag = '||l_acceptance_flag);

Line 2387: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;

2383: ) IS
2384:
2385: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_PO_DETAILS'; -- Bug 3602512
2386:
2387: l_approved_flag PO_HEADERS_ALL.approved_flag%TYPE;
2388: l_return_status VARCHAR2(1);
2389: l_msg_count NUMBER;
2390: l_msg_data VARCHAR2(2000);
2391:

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

2434: */
2435: -- Bug 3616320 END
2436: END IF;
2437:
2438: -- SQL What:Updates PO_HEADERS_ALL table and sets the Authorization status
2439: -- to 'APPROVED' or 'REJECTED'
2440: -- SQL Why :To move the document from the PRE-APPROVED status
2441: -- SQL Join:po_header_id
2442:

Line 2443: UPDATE PO_HEADERS_ALL

2439: -- to 'APPROVED' or 'REJECTED'
2440: -- SQL Why :To move the document from the PRE-APPROVED status
2441: -- SQL Join:po_header_id
2442:
2443: UPDATE PO_HEADERS_ALL
2444: SET authorization_status = p_status,
2445: approved_flag = l_approved_flag,
2446: pending_signature_flag = 'N',
2447: acceptance_required_flag = 'N',

Line 2875: l_current_org PO_HEADERS_ALL.org_id%TYPE;

2871: p_revision_num IN NUMBER,
2872: x_erecord_exist OUT NOCOPY VARCHAR2,
2873: x_pending_signature OUT NOCOPY VARCHAR2)
2874: IS
2875: l_current_org PO_HEADERS_ALL.org_id%TYPE;
2876: l_doc_org PO_HEADERS_ALL.org_id%TYPE;
2877: BEGIN
2878:
2879: l_current_org := PO_GA_PVT.get_current_org;

Line 2876: l_doc_org PO_HEADERS_ALL.org_id%TYPE;

2872: x_erecord_exist OUT NOCOPY VARCHAR2,
2873: x_pending_signature OUT NOCOPY VARCHAR2)
2874: IS
2875: l_current_org PO_HEADERS_ALL.org_id%TYPE;
2876: l_doc_org PO_HEADERS_ALL.org_id%TYPE;
2877: BEGIN
2878:
2879: l_current_org := PO_GA_PVT.get_current_org;
2880: l_doc_org := PO_GA_PVT.get_org_id(p_po_header_id);

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

2886: -- If the document is not 'release' and if the pending_signature_flag is 'Y',
2887: -- PO_SIGNATURE parameter should be set to 'Y' which allows inserts in the
2888: -- Aceptances form. Otherwise Acceptances form is called in the view only mode
2889: BEGIN
2890: -- SQL What: Selects the Pending_Signature_Flag from the PO_HEADERS_ALL table
2891: -- SQL Why : To find out if the document has pending signatures or not
2892: -- SQL Join: PO_HEADER_ID
2893:
2894: -- Bug 3677988: inserts in acceptances form should not be allowed for PO on hold

Line 2899: FROM PO_HEADERS_ALL

2895: -- This is facilitated by checking for user_hold_flag <> 'Y'.
2896:
2897: SELECT NVL(pending_signature_flag,'N')
2898: INTO x_pending_signature
2899: FROM PO_HEADERS_ALL
2900: WHERE po_header_id = p_po_header_id
2901: AND nvl(user_hold_flag, 'N') <> 'Y';
2902:
2903: EXCEPTION

Line 2941: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY

2937: --Name: Post_Forms_Commit
2938: --Pre-reqs:
2939: -- None.
2940: --Modifies:
2941: -- PO_HEADERS_ALL, PO_LINE_LOCATIONS_ALL, PO_ACTION_HISTORY
2942: --Locks:
2943: -- None.
2944: --Function:
2945: -- Checks the logic for completion of signatures and updates PO tables

Line 2975: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

2971: l_buyer_accepted_count PLS_INTEGER := 0;
2972: l_buyer_rejected_count PLS_INTEGER := 0;
2973: l_supplier_accepted_count PLS_INTEGER := 0;
2974: l_supplier_rejected_count PLS_INTEGER := 0;
2975: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
2976: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2977: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
2978: l_po_itemkey WF_ITEMS.item_key%TYPE;
2979: l_po_itemtype WF_ITEMS.item_type%TYPE;

Line 2976: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;

2972: l_buyer_rejected_count PLS_INTEGER := 0;
2973: l_supplier_accepted_count PLS_INTEGER := 0;
2974: l_supplier_rejected_count PLS_INTEGER := 0;
2975: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
2976: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2977: l_object_code PO_ACTION_HISTORY.object_type_code%TYPE := NULL;
2978: l_po_itemkey WF_ITEMS.item_key%TYPE;
2979: l_po_itemtype WF_ITEMS.item_type%TYPE;
2980: l_itemkey WF_ITEMS.item_key%TYPE;

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

3015: Null;
3016: END;
3017:
3018: BEGIN
3019: -- SQL What :selects the type_lookup_code and agent_id from PO_HEADERS_ALL
3020: -- SQL Why :To pass it po_action_history row handler for inserting a row
3021: -- SQL Join :PO_HEADER_ID
3022:
3023: -- bug 3568077

Line 3043: FROM PO_HEADERS_ALL

3039: l_object_code,
3040: l_agent_id,
3041: l_po_itemtype,
3042: l_po_itemkey
3043: FROM PO_HEADERS_ALL
3044: WHERE Po_Header_Id = p_po_header_id;
3045: EXCEPTION
3046: WHEN NO_DATA_FOUND THEN
3047: RAISE l_binding_exception;

Line 3374: -- PO_HEADERS_ALL

3370: --Pre-reqs:
3371: -- This code should be called when we have already revised the document and
3372: -- updated the revision_num and revised_date field.
3373: --Modifies:
3374: -- PO_HEADERS_ALL
3375: --Locks:
3376: -- None.
3377: --Function:
3378: -- This function checks if there is atleast one signed revision

Line 3410: UPDATE PO_HEADERS_ALL POH

3406: PO_LOG.stmt(d_module,d_pos,'l_was_sign_reqd',l_was_sign_reqd);
3407: END IF;
3408:
3409: IF l_was_sign_reqd THEN
3410: UPDATE PO_HEADERS_ALL POH
3411: SET POH.acceptance_required_flag = 'S'
3412: WHERE POH.po_header_id = p_document_id;
3413: x_if_acc_flag_updated := 'Y';
3414: END IF;

Line 3436: -- PO_HEADERS_ALL

3432: --Name: if_rev_and_signed_set_acc_flag
3433: --Pre-reqs:
3434: -- None.
3435: --Modifies:
3436: -- PO_HEADERS_ALL
3437: --Locks:
3438: -- None.
3439: --Function:
3440: -- Updates the acceptance_required_field to 'S' if the revision number in the

Line 3463: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

3459: x_if_acc_flag_updated OUT NOCOPY VARCHAR2)
3460: IS
3461: d_module CONSTANT VARCHAR2(70) := 'po.plsql.PO_SIGNATURE_PVT.if_rev_and_signed_set_acc_flag';
3462: d_pos NUMBER := 0;
3463: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
3464: BEGIN
3465: SELECT revision_num
3466: INTO l_revision_num
3467: FROM po_headers_all

Line 3467: FROM po_headers_all

3463: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
3464: BEGIN
3465: SELECT revision_num
3466: INTO l_revision_num
3467: FROM po_headers_all
3468: WHERE po_header_id = p_document_id;
3469:
3470: d_pos := 10;
3471: