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_CATALOG_INDEX_PVT dependencies on PO_TBL_NUMBER

Line 17: p_po_header_ids IN PO_TBL_NUMBER

13: -- Forward function declarations: Start
14:
15: PROCEDURE populate_sessiongt_for_pa
16: (
17: p_po_header_ids IN PO_TBL_NUMBER
18: );
19:
20: PROCEDURE populate_sessiongt_for_quote
21: (

Line 63: p_po_header_ids IN PO_TBL_NUMBER

59: );
60:
61: PROCEDURE populate_sessiongt_for_orgs
62: (
63: p_po_header_ids IN PO_TBL_NUMBER
64: );
65:
66: PROCEDURE synch_item_description
67: (

Line 70: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL

66: PROCEDURE synch_item_description
67: (
68: p_type IN VARCHAR2
69: , p_po_header_id IN NUMBER DEFAULT NULL
70: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL
71: , p_reqexpress_name IN VARCHAR2 DEFAULT NULL
72: , p_org_id IN NUMBER DEFAULT NULL
73: );
74:

Line 80: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL

76: PROCEDURE synch_item_category
77: (
78: p_type IN VARCHAR2
79: , p_po_header_id IN NUMBER DEFAULT NULL
80: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL
81: , p_reqexpress_name IN VARCHAR2 DEFAULT NULL
82: , p_org_id IN NUMBER DEFAULT NULL
83: );
84: -- Forward function declarations: End

Line 142: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL

138: PROCEDURE rebuild_index
139: (
140: p_type IN VARCHAR2
141: , p_po_header_id IN NUMBER DEFAULT NULL
142: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL
143: , p_reqexpress_name IN VARCHAR2 DEFAULT NULL
144: , p_org_id IN NUMBER DEFAULT NULL
145: )
146: IS

Line 151: l_po_header_ids PO_TBL_NUMBER := PO_TBL_NUMBER(1);

147: l_api_name CONSTANT VARCHAR2(30) := 'rebuild_index';
148: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
149: l_progress VARCHAR2(3) := '000';
150:
151: l_po_header_ids PO_TBL_NUMBER := PO_TBL_NUMBER(1);
152: BEGIN
153:
154: -- Log the input parameters into debug logs
155: IF g_debug_stmt THEN

Line 549: p_po_header_ids IN PO_TBL_NUMBER

545: --End of Comments
546: --------------------------------------------------------------------------------
547: PROCEDURE populate_sessiongt_for_pa
548: (
549: p_po_header_ids IN PO_TBL_NUMBER
550: )
551: IS
552: l_api_name CONSTANT VARCHAR2(30) := 'populate_sessiongt_for_pa';
553: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;

Line 1224: p_po_header_ids IN PO_TBL_NUMBER

1220: --End of Comments
1221: --------------------------------------------------------------------------------
1222: PROCEDURE populate_sessiongt_for_orgs
1223: (
1224: p_po_header_ids IN PO_TBL_NUMBER
1225: )
1226: IS
1227: l_api_name CONSTANT VARCHAR2(30) := 'populate_sessiongt_for_orgs';
1228: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;

Line 1453: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL

1449: PROCEDURE synch_item_description
1450: (
1451: p_type IN VARCHAR2
1452: , p_po_header_id IN NUMBER DEFAULT NULL
1453: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL
1454: , p_reqexpress_name IN VARCHAR2 DEFAULT NULL
1455: , p_org_id IN NUMBER DEFAULT NULL
1456: )
1457: IS

Line 1462: l_po_line_id_list PO_TBL_NUMBER;

1458: l_api_name CONSTANT VARCHAR2(30) := 'synch_item_description';
1459: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1460: l_progress VARCHAR2(3) := '000';
1461:
1462: l_po_line_id_list PO_TBL_NUMBER;
1463: l_item_description_list PO_TBL_VARCHAR240;
1464: l_created_lang_list PO_TBL_VARCHAR5;
1465:
1466: l_req_template_name_list PO_TBL_VARCHAR25;

Line 1467: l_req_template_line_num_list PO_TBL_NUMBER;

1463: l_item_description_list PO_TBL_VARCHAR240;
1464: l_created_lang_list PO_TBL_VARCHAR5;
1465:
1466: l_req_template_name_list PO_TBL_VARCHAR25;
1467: l_req_template_line_num_list PO_TBL_NUMBER;
1468: l_req_template_org_id_list PO_TBL_NUMBER;
1469:
1470: l_key PO_SESSION_GT.key%TYPE;
1471: l_base_lang FND_LANGUAGES.language_code%TYPE;

Line 1468: l_req_template_org_id_list PO_TBL_NUMBER;

1464: l_created_lang_list PO_TBL_VARCHAR5;
1465:
1466: l_req_template_name_list PO_TBL_VARCHAR25;
1467: l_req_template_line_num_list PO_TBL_NUMBER;
1468: l_req_template_org_id_list PO_TBL_NUMBER;
1469:
1470: l_key PO_SESSION_GT.key%TYPE;
1471: l_base_lang FND_LANGUAGES.language_code%TYPE;
1472: BEGIN

Line 1631: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL

1627: PROCEDURE synch_item_category
1628: (
1629: p_type IN VARCHAR2
1630: , p_po_header_id IN NUMBER DEFAULT NULL
1631: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL
1632: , p_reqexpress_name IN VARCHAR2 DEFAULT NULL
1633: , p_org_id IN NUMBER DEFAULT NULL
1634: )
1635: IS

Line 1640: l_po_line_id_list PO_TBL_NUMBER;

1636: l_api_name CONSTANT VARCHAR2(30) := 'synch_item_category';
1637: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1638: l_progress VARCHAR2(3) := '000';
1639:
1640: l_po_line_id_list PO_TBL_NUMBER;
1641: l_category_id_list PO_TBL_VARCHAR240;
1642: l_new_ip_category_id NUMBER;
1643: l_old_ip_category_id_list PO_TBL_NUMBER;
1644:

Line 1643: l_old_ip_category_id_list PO_TBL_NUMBER;

1639:
1640: l_po_line_id_list PO_TBL_NUMBER;
1641: l_category_id_list PO_TBL_VARCHAR240;
1642: l_new_ip_category_id NUMBER;
1643: l_old_ip_category_id_list PO_TBL_NUMBER;
1644:
1645: l_req_template_name_list PO_TBL_VARCHAR25;
1646: l_req_template_line_num_list PO_TBL_NUMBER;
1647: l_req_template_org_id_list PO_TBL_NUMBER;

Line 1646: l_req_template_line_num_list PO_TBL_NUMBER;

1642: l_new_ip_category_id NUMBER;
1643: l_old_ip_category_id_list PO_TBL_NUMBER;
1644:
1645: l_req_template_name_list PO_TBL_VARCHAR25;
1646: l_req_template_line_num_list PO_TBL_NUMBER;
1647: l_req_template_org_id_list PO_TBL_NUMBER;
1648:
1649: l_key PO_SESSION_GT.key%TYPE;
1650: BEGIN

Line 1647: l_req_template_org_id_list PO_TBL_NUMBER;

1643: l_old_ip_category_id_list PO_TBL_NUMBER;
1644:
1645: l_req_template_name_list PO_TBL_VARCHAR25;
1646: l_req_template_line_num_list PO_TBL_NUMBER;
1647: l_req_template_org_id_list PO_TBL_NUMBER;
1648:
1649: l_key PO_SESSION_GT.key%TYPE;
1650: BEGIN
1651: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;