DBA Data[Home] [Help]

APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on PO_R12_CAT_UPG_PVT

Line 8: g_err_num NUMBER := PO_R12_CAT_UPG_PVT.g_application_err_num;

4: g_pkg_name CONSTANT VARCHAR2(30) := 'PO_R12_CAT_UPG_FINAL_GRP';
5: g_module_prefix CONSTANT VARCHAR2(100) := 'po.plsql.' || g_pkg_name || '.';
6:
7: g_debug BOOLEAN := PO_R12_CAT_UPG_DEBUG.is_logging_enabled;
8: g_err_num NUMBER := PO_R12_CAT_UPG_PVT.g_application_err_num;
9:
10: -- BEGIN: Forward function declarations
11:
12: PROCEDURE create_action_history_batch

Line 110: WHERE POH.created_by = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER

106: SELECT POH.po_header_id
107: , POH.agent_id
108: , POH.org_id
109: FROM PO_HEADERS_ALL POH
110: WHERE POH.created_by = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER
111: AND POH.authorization_status = 'IN PROCESS'
112: AND POH.rowid between l_start_rowid and l_end_rowid; --Bug#5156673
113:
114: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

Line 401: PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER, -- created_by = -12

397: 1, -- sequence_num
398: sysdate, -- last_update_date
399: FND_GLOBAL.user_id, -- last_updated_by
400: sysdate, -- creation_date
401: PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER, -- created_by = -12
402: 'APPROVE', -- action_code
403: sysdate, -- action_date
404: p_agent_ids(i), -- employee_id
405: NULL, -- approval_path_id

Line 2721: AND GBPA.created_by = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER

2717: GBPA.po_header_id
2718: FROM PO_HEADERS_ALL GBPA,
2719: PO_HEADERS_ALL CPA
2720: WHERE GBPA.type_lookup_code = 'BLANKET'
2721: AND GBPA.created_by = PO_R12_CAT_UPG_PVT.g_R12_UPGRADE_USER
2722: AND GBPA.authorization_status = 'IN PROCESS'
2723: AND GBPA.cpa_reference IS NOT NULL
2724: AND CPA.po_header_id = GBPA.cpa_reference
2725: ORDER BY GBPA.cpa_reference, GBPA.org_id, GBPA.po_header_id;