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

Line 421: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

417: d_api_name CONSTANT VARCHAR2(30) := 'populate_draft_info';
418: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
419: d_position NUMBER;
420:
421: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
422: l_quote_type_lookup_code PO_HEADERS_ALL.quote_type_lookup_code%TYPE;
423:
424:
425: BEGIN

Line 422: l_quote_type_lookup_code PO_HEADERS_ALL.quote_type_lookup_code%TYPE;

418: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
419: d_position NUMBER;
420:
421: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
422: l_quote_type_lookup_code PO_HEADERS_ALL.quote_type_lookup_code%TYPE;
423:
424:
425: BEGIN
426:

Line 436: -- exists in PO_HEADERS_ALL

432: x_draft_info.draft_id := p_draft_id;
433: x_draft_info.po_header_id := p_po_header_id;
434:
435: -- SQL What: Check whether po_header_id specified already
436: -- exists in PO_HEADERS_ALL
437: -- SQL Why: Need to see whether it is a new document being created
438: SELECT NVL(MAX(FND_API.G_FALSE), FND_API.G_TRUE)
439: INTO x_draft_info.new_document
440: FROM po_headers_all POH

Line 440: FROM po_headers_all POH

436: -- exists in PO_HEADERS_ALL
437: -- SQL Why: Need to see whether it is a new document being created
438: SELECT NVL(MAX(FND_API.G_FALSE), FND_API.G_TRUE)
439: INTO x_draft_info.new_document
440: FROM po_headers_all POH
441: WHERE POH.po_header_id = p_po_header_id;
442:
443: IF (x_draft_info.new_document = FND_API.G_TRUE) THEN
444: d_position := 10;

Line 464: FROM PO_HEADERS_ALL PHA

460: NVL(PHA.global_agreement_flag, 'N')
461: INTO l_type_lookup_code,
462: l_quote_type_lookup_code,
463: x_draft_info.ga_flag
464: FROM PO_HEADERS_ALL PHA
465: WHERE PHA.po_header_id = p_po_header_id;
466: END IF;
467:
468: d_position := 30;

Line 860: FROM po_headers_all

856: SELECT lock_owner_role,
857: lock_owner_user_id
858: INTO x_lock_owner_role,
859: x_lock_owner_user_id
860: FROM po_headers_all
861: WHERE po_header_id = p_po_header_id;
862:
863: IF (PO_LOG.d_proc) THEN
864: PO_LOG.proc_end(d_module);

Line 912: UPDATE po_headers_all

908: END IF;
909:
910: --SQL What: update lock owner role and lock owner id
911: --SQL Why: This is what this procedure is doing
912: UPDATE po_headers_all
913: SET lock_owner_role = p_role,
914: lock_owner_user_id = p_role_user_id
915: WHERE po_header_id = p_po_header_id;
916:

Line 980: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;

976: l_upload_requestor_role_id PO_DRAFTS.owner_user_id%TYPE;
977: l_upload_job_number NUMBER;
978: l_upload_status_display VARCHAR2(80);
979:
980: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
981: l_supplier_auth_enabled PO_HEADERS_ALL.supplier_auth_enabled_flag%TYPE;
982: l_cat_admin_auth_enabled PO_HEADERS_ALL.cat_admin_auth_enabled_flag%TYPE;
983: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
984: l_current_lock_owner_id PO_HEADERS_ALL.lock_owner_user_id%TYPE;

Line 981: l_supplier_auth_enabled PO_HEADERS_ALL.supplier_auth_enabled_flag%TYPE;

977: l_upload_job_number NUMBER;
978: l_upload_status_display VARCHAR2(80);
979:
980: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
981: l_supplier_auth_enabled PO_HEADERS_ALL.supplier_auth_enabled_flag%TYPE;
982: l_cat_admin_auth_enabled PO_HEADERS_ALL.cat_admin_auth_enabled_flag%TYPE;
983: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
984: l_current_lock_owner_id PO_HEADERS_ALL.lock_owner_user_id%TYPE;
985:

Line 982: l_cat_admin_auth_enabled PO_HEADERS_ALL.cat_admin_auth_enabled_flag%TYPE;

978: l_upload_status_display VARCHAR2(80);
979:
980: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
981: l_supplier_auth_enabled PO_HEADERS_ALL.supplier_auth_enabled_flag%TYPE;
982: l_cat_admin_auth_enabled PO_HEADERS_ALL.cat_admin_auth_enabled_flag%TYPE;
983: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
984: l_current_lock_owner_id PO_HEADERS_ALL.lock_owner_user_id%TYPE;
985:
986: l_updatable_state VARCHAR2(1); -- bug5532550

Line 983: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;

979:
980: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
981: l_supplier_auth_enabled PO_HEADERS_ALL.supplier_auth_enabled_flag%TYPE;
982: l_cat_admin_auth_enabled PO_HEADERS_ALL.cat_admin_auth_enabled_flag%TYPE;
983: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
984: l_current_lock_owner_id PO_HEADERS_ALL.lock_owner_user_id%TYPE;
985:
986: l_updatable_state VARCHAR2(1); -- bug5532550
987: BEGIN

Line 984: l_current_lock_owner_id PO_HEADERS_ALL.lock_owner_user_id%TYPE;

980: l_authorization_status PO_HEADERS_ALL.authorization_status%TYPE;
981: l_supplier_auth_enabled PO_HEADERS_ALL.supplier_auth_enabled_flag%TYPE;
982: l_cat_admin_auth_enabled PO_HEADERS_ALL.cat_admin_auth_enabled_flag%TYPE;
983: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
984: l_current_lock_owner_id PO_HEADERS_ALL.lock_owner_user_id%TYPE;
985:
986: l_updatable_state VARCHAR2(1); -- bug5532550
987: BEGIN
988:

Line 1169: FROM po_headers_all

1165: d_position := 55;
1166:
1167: SELECT NVL(authorization_status, 'INCOMPLETE')
1168: INTO l_authorization_status
1169: FROM po_headers_all
1170: WHERE po_header_id = p_po_header_id;
1171:
1172: -- do not allow document update by non-buyer role if
1173: -- document is not in INCOMPLETE or APPROVED status

Line 1547: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

1543: d_position NUMBER;
1544:
1545: l_applicable VARCHAR2(1) := FND_API.G_TRUE;
1546:
1547: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
1548: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1549: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
1550: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
1551:

Line 1548: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

1544:
1545: l_applicable VARCHAR2(1) := FND_API.G_TRUE;
1546:
1547: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
1548: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1549: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
1550: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
1551:
1552: BEGIN

Line 1549: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;

1545: l_applicable VARCHAR2(1) := FND_API.G_TRUE;
1546:
1547: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
1548: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1549: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
1550: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
1551:
1552: BEGIN
1553:

Line 1550: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;

1546:
1547: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
1548: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1549: l_approved_date PO_HEADERS_ALL.approved_date%TYPE;
1550: l_current_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
1551:
1552: BEGIN
1553:
1554: d_position := 0;

Line 1570: FROM po_headers_all

1566: INTO l_type_lookup_code,
1567: l_ga_flag,
1568: l_approved_date,
1569: l_current_lock_owner_role
1570: FROM po_headers_all
1571: WHERE po_header_id = p_po_header_id;
1572:
1573: -- locking is applicable only for global blanket agreement
1574: IF (NOT (l_type_lookup_code = 'BLANKET' AND l_ga_flag = 'Y')) THEN

Line 1621: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;

1617: d_position NUMBER;
1618:
1619: l_applicable VARCHAR2(1) := FND_API.G_TRUE;
1620:
1621: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
1622: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1623: BEGIN
1624: d_position := 0;
1625:

Line 1622: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

1618:
1619: l_applicable VARCHAR2(1) := FND_API.G_TRUE;
1620:
1621: l_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
1622: l_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1623: BEGIN
1624: d_position := 0;
1625:
1626: IF (PO_LOG.d_proc) THEN

Line 1637: FROM po_headers_all

1633: SELECT type_lookup_code,
1634: NVL(global_agreement_flag, 'N')
1635: INTO l_type_lookup_code,
1636: l_ga_flag
1637: FROM po_headers_all
1638: WHERE po_header_id = p_po_header_id;
1639:
1640: d_position := 10;
1641:

Line 2292: FROM po_headers_all

2288: END IF;
2289:
2290: SELECT supplier_auth_enabled_flag
2291: INTO l_supplier_auth_enabled_flag
2292: FROM po_headers_all
2293: WHERE po_header_id = p_po_header_id;
2294:
2295: return l_supplier_auth_enabled_flag;
2296:

Line 2344: UPDATE po_headers_all

2340: IF (PO_LOG.d_proc) THEN
2341: PO_LOG.proc_begin(d_module);
2342: END IF;
2343:
2344: UPDATE po_headers_all
2345: SET supplier_auth_enabled_flag
2346: = p_supplier_auth_enabled_flag
2347: WHERE po_header_id = p_po_header_id;
2348:

Line 2398: FROM po_headers_all

2394: END IF;
2395:
2396: SELECT cat_admin_auth_enabled_flag
2397: INTO l_cat_admin_auth_enable_flag
2398: FROM po_headers_all
2399: WHERE po_header_id = p_po_header_id;
2400:
2401: return l_cat_admin_auth_enable_flag;
2402:

Line 2450: UPDATE po_headers_all

2446: IF (PO_LOG.d_proc) THEN
2447: PO_LOG.proc_begin(d_module);
2448: END IF;
2449:
2450: UPDATE po_headers_all
2451: SET cat_admin_auth_enabled_flag
2452: = p_cat_admin_auth_enable_flag
2453: WHERE po_header_id = p_po_header_id;
2454:

Line 2602: l_org_id PO_HEADERS_ALL.org_id%TYPE;

2598: d_api_name CONSTANT VARCHAR2(30) := 'unlock_document_and_send_notif';
2599: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2600: d_position NUMBER;
2601:
2602: l_org_id PO_HEADERS_ALL.org_id%TYPE;
2603: l_segment1 PO_HEADERS_ALL.segment1%TYPE;
2604: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
2605:
2606: BEGIN

Line 2603: l_segment1 PO_HEADERS_ALL.segment1%TYPE;

2599: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2600: d_position NUMBER;
2601:
2602: l_org_id PO_HEADERS_ALL.org_id%TYPE;
2603: l_segment1 PO_HEADERS_ALL.segment1%TYPE;
2604: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
2605:
2606: BEGIN
2607:

Line 2604: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

2600: d_position NUMBER;
2601:
2602: l_org_id PO_HEADERS_ALL.org_id%TYPE;
2603: l_segment1 PO_HEADERS_ALL.segment1%TYPE;
2604: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
2605:
2606: BEGIN
2607:
2608: d_position := 0;

Line 2621: FROM po_headers_all

2617: revision_num
2618: INTO l_org_id,
2619: l_segment1,
2620: l_revision_num
2621: FROM po_headers_all
2622: WHERE po_header_id = p_po_header_id;
2623:
2624: unlock_document_and_send_notif
2625: ( p_commit => p_commit,

Line 2691: l_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;

2687: l_agreement_info FND_NEW_MESSAGES.message_text%type := NULL;
2688: l_doc_style_name PO_DOC_STYLE_LINES_TL.display_name%type := NULL;
2689: l_ou_name HR_OPERATING_UNITS.name%type := NULL;
2690:
2691: l_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
2692: l_lock_owner_user_id PO_HEADERS_ALL.lock_owner_user_id%TYPE;
2693:
2694: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2695: BEGIN

Line 2692: l_lock_owner_user_id PO_HEADERS_ALL.lock_owner_user_id%TYPE;

2688: l_doc_style_name PO_DOC_STYLE_LINES_TL.display_name%type := NULL;
2689: l_ou_name HR_OPERATING_UNITS.name%type := NULL;
2690:
2691: l_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
2692: l_lock_owner_user_id PO_HEADERS_ALL.lock_owner_user_id%TYPE;
2693:
2694: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2695: BEGIN
2696:

Line 2694: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;

2690:
2691: l_lock_owner_role PO_HEADERS_ALL.lock_owner_role%TYPE;
2692: l_lock_owner_user_id PO_HEADERS_ALL.lock_owner_user_id%TYPE;
2693:
2694: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
2695: BEGIN
2696:
2697: IF (PO_LOG.d_proc) THEN
2698: PO_LOG.proc_begin(d_module,'p_commit',p_commit);

Line 2755: FROM po_headers_all

2751: -- bug5249393
2752: -- The notification from is always the buyer
2753: SELECT agent_id
2754: INTO l_agent_id
2755: FROM po_headers_all
2756: WHERE po_header_id = p_po_header_id;
2757:
2758: -- bug5090429
2759: -- Changed the signature of the API

Line 2829: FROM po_headers_all POH

2825: PO_GLOBAL.g_role_CAT_ADMIN)) THEN
2826:
2827: SELECT 1
2828: INTO l_dummy
2829: FROM po_headers_all POH
2830: WHERE POH.po_header_id = p_po_header_id
2831: AND NVL(cancel_flag, 'N') = 'N'
2832: AND NVL(closed_code, 'OPEN') NOT IN ('CLOSED', 'FINALLY CLOSED')
2833: AND NVL(frozen_flag, 'N') <> 'Y'

Line 2971: l_orig_revision_num PO_HEADERS_ALL.revision_num%TYPE;

2967: d_api_name CONSTANT VARCHAR2(30) := 'set_new_revision';
2968: d_module CONSTANT VARCHAR2(2000) := d_pkg_name || d_api_name || '.';
2969: d_position NUMBER;
2970:
2971: l_orig_revision_num PO_HEADERS_ALL.revision_num%TYPE;
2972: l_rev_check_level_tbl rev_check_level_tbl_type;
2973: l_index NUMBER := 0;
2974: l_new_revision_num PO_HEADERS_ALL.revision_num%TYPE;
2975: l_return_status VARCHAR2(1);

Line 2974: l_new_revision_num PO_HEADERS_ALL.revision_num%TYPE;

2970:
2971: l_orig_revision_num PO_HEADERS_ALL.revision_num%TYPE;
2972: l_rev_check_level_tbl rev_check_level_tbl_type;
2973: l_index NUMBER := 0;
2974: l_new_revision_num PO_HEADERS_ALL.revision_num%TYPE;
2975: l_return_status VARCHAR2(1);
2976: l_message VARCHAR2(2000);
2977:
2978: BEGIN

Line 2990: FROM po_headers_all PH

2986: END IF;
2987:
2988: SELECT PH.revision_num
2989: INTO l_orig_revision_num
2990: FROM po_headers_all PH
2991: WHERE PH.po_header_id = p_draft_info.po_header_id;
2992:
2993: d_position := 10;
2994: -- determine which level(s) do we need to check for revision change

Line 3056: UPDATE po_headers_all

3052:
3053: IF (l_orig_revision_num <> l_new_revision_num) THEN
3054: d_position := 90;
3055:
3056: UPDATE po_headers_all
3057: SET revision_num = l_new_revision_num,
3058: revised_date = SYSDATE
3059: WHERE po_header_id = p_draft_info.po_header_id;
3060: