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_R12_CAT_UPG_FINAL_GRP dependencies on PO_R12_CAT_UPG_TYPES

Line 14: p_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

10: -- BEGIN: Forward function declarations
11:
12: PROCEDURE create_action_history_batch
13: (
14: p_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
15: p_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
16: );
17:
18: PROCEDURE archive_gbpa_bulk

Line 15: p_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

11:
12: PROCEDURE create_action_history_batch
13: (
14: p_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
15: p_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
16: );
17:
18: PROCEDURE archive_gbpa_bulk
19: (

Line 21: p_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

17:
18: PROCEDURE archive_gbpa_bulk
19: (
20: p_batch_size NUMBER,
21: p_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
22: );
23:
24: -- END: Forward function declarations
25:

Line 114: l_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

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;
115: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
116: l_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
117: l_key PO_SESSION_GT.key%TYPE;
118: l_current_batch NUMBER; -- Bug 5468308: Track the progress of the script

Line 115: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

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;
115: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
116: l_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
117: l_key PO_SESSION_GT.key%TYPE;
118: l_current_batch NUMBER; -- Bug 5468308: Track the progress of the script
119: BEGIN

Line 116: l_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

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;
115: l_org_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
116: l_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
117: l_key PO_SESSION_GT.key%TYPE;
118: l_current_batch NUMBER; -- Bug 5468308: Track the progress of the script
119: BEGIN
120: l_progress := '010';

Line 347: p_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,

343: --End of Comments
344: --------------------------------------------------------------------------------
345: PROCEDURE create_action_history_batch
346: (
347: p_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
348: p_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
349: )
350: IS
351: l_api_name CONSTANT VARCHAR2(30) := 'create_action_history_batch';

Line 348: p_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

344: --------------------------------------------------------------------------------
345: PROCEDURE create_action_history_batch
346: (
347: p_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER,
348: p_agent_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
349: )
350: IS
351: l_api_name CONSTANT VARCHAR2(30) := 'create_action_history_batch';
352: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 463: p_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

459: --------------------------------------------------------------------------------
460: PROCEDURE archive_gbpa_bulk
461: (
462: p_batch_size NUMBER,
463: p_po_header_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
464: )
465: IS
466: l_api_name CONSTANT VARCHAR2(30) := 'archive_gbpa_bulk';
467: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 470: l_po_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

466: l_api_name CONSTANT VARCHAR2(30) := 'archive_gbpa_bulk';
467: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;
468: l_progress VARCHAR2(3) := '000';
469:
470: l_po_line_ids PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
471: l_start_index NUMBER;
472: l_end_index NUMBER;
473: l_end_index_tmp NUMBER;
474: l_last_batch_flag VARCHAR2(1);

Line 2413: , p_gbpa_header_id_list IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

2409: --------------------------------------------------------------------------------
2410: PROCEDURE prepare_long_text
2411: (
2412: p_cpa_header_id IN NUMBER
2413: , p_gbpa_header_id_list IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
2414: , x_long_text IN OUT NOCOPY LONG
2415: )
2416: IS
2417: l_api_name CONSTANT VARCHAR2(30) := 'prepare_long_text';

Line 2523: , p_gbpa_header_id_list IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER

2519: PROCEDURE create_attachment
2520: (
2521: p_cpa_header_id IN NUMBER
2522: , p_cpa_org_id IN NUMBER
2523: , p_gbpa_header_id_list IN PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER
2524: )
2525: IS
2526: l_api_name CONSTANT VARCHAR2(30) := 'create_attachment';
2527: l_log_head CONSTANT VARCHAR2(100) := g_module_prefix || l_api_name;

Line 2730: l_cpa_reference_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2726:
2727: l_cpa_reference NUMBER;
2728: l_cpa_org_id NUMBER;
2729: l_po_header_id NUMBER;
2730: l_cpa_reference_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2731: l_po_header_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2732:
2733: l_prev_cpa_reference NUMBER;
2734: l_count NUMBER;

Line 2731: l_po_header_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;

2727: l_cpa_reference NUMBER;
2728: l_cpa_org_id NUMBER;
2729: l_po_header_id NUMBER;
2730: l_cpa_reference_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2731: l_po_header_id_list PO_R12_CAT_UPG_TYPES.PO_TBL_NUMBER;
2732:
2733: l_prev_cpa_reference NUMBER;
2734: l_count NUMBER;
2735: l_current_batch NUMBER; -- Bug 5468308: Track the progress of the script