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: --
67: -- Moved code for updating of item description and category to

Line 73: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL

69: /*PROCEDURE synch_item_description
70: (
71: p_type IN VARCHAR2
72: , p_po_header_id IN NUMBER DEFAULT NULL
73: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL
74: , p_reqexpress_name IN VARCHAR2 DEFAULT NULL
75: , p_org_id IN NUMBER DEFAULT NULL
76: );
77:

Line 83: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL

79: PROCEDURE synch_item_category
80: (
81: p_type IN VARCHAR2
82: , p_po_header_id IN NUMBER DEFAULT NULL
83: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL
84: , p_reqexpress_name IN VARCHAR2 DEFAULT NULL
85: , p_org_id IN NUMBER DEFAULT NULL
86: );*/
87: -- Forward function declarations: End

Line 145: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL

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

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

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

Line 557: p_po_header_ids IN PO_TBL_NUMBER

553: --End of Comments
554: --------------------------------------------------------------------------------
555: PROCEDURE populate_sessiongt_for_pa
556: (
557: p_po_header_ids IN PO_TBL_NUMBER
558: )
559: IS
560: l_api_name CONSTANT VARCHAR2(30) := 'populate_sessiongt_for_pa';
561: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;

Line 1260: p_po_header_ids IN PO_TBL_NUMBER

1256: --End of Comments
1257: --------------------------------------------------------------------------------
1258: PROCEDURE populate_sessiongt_for_orgs
1259: (
1260: p_po_header_ids IN PO_TBL_NUMBER
1261: )
1262: IS
1263: l_api_name CONSTANT VARCHAR2(30) := 'populate_sessiongt_for_orgs';
1264: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;

Line 1491: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL

1487: /*PROCEDURE synch_item_description
1488: (
1489: p_type IN VARCHAR2
1490: , p_po_header_id IN NUMBER DEFAULT NULL
1491: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL
1492: , p_reqexpress_name IN VARCHAR2 DEFAULT NULL
1493: , p_org_id IN NUMBER DEFAULT NULL
1494: )
1495: IS

Line 1500: l_po_line_id_list PO_TBL_NUMBER;

1496: l_api_name CONSTANT VARCHAR2(30) := 'synch_item_description';
1497: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1498: l_progress VARCHAR2(3) := '000';
1499:
1500: l_po_line_id_list PO_TBL_NUMBER;
1501: l_item_description_list PO_TBL_VARCHAR240;
1502: l_created_lang_list PO_TBL_VARCHAR5;
1503:
1504: l_req_template_name_list PO_TBL_VARCHAR25;

Line 1505: l_req_template_line_num_list PO_TBL_NUMBER;

1501: l_item_description_list PO_TBL_VARCHAR240;
1502: l_created_lang_list PO_TBL_VARCHAR5;
1503:
1504: l_req_template_name_list PO_TBL_VARCHAR25;
1505: l_req_template_line_num_list PO_TBL_NUMBER;
1506: l_req_template_org_id_list PO_TBL_NUMBER;
1507:
1508: l_key PO_SESSION_GT.key%TYPE;
1509: l_base_lang FND_LANGUAGES.language_code%TYPE;

Line 1506: l_req_template_org_id_list PO_TBL_NUMBER;

1502: l_created_lang_list PO_TBL_VARCHAR5;
1503:
1504: l_req_template_name_list PO_TBL_VARCHAR25;
1505: l_req_template_line_num_list PO_TBL_NUMBER;
1506: l_req_template_org_id_list PO_TBL_NUMBER;
1507:
1508: l_key PO_SESSION_GT.key%TYPE;
1509: l_base_lang FND_LANGUAGES.language_code%TYPE;
1510: BEGIN

Line 1669: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL

1665: PROCEDURE synch_item_category
1666: (
1667: p_type IN VARCHAR2
1668: , p_po_header_id IN NUMBER DEFAULT NULL
1669: , p_po_header_ids IN PO_TBL_NUMBER DEFAULT NULL
1670: , p_reqexpress_name IN VARCHAR2 DEFAULT NULL
1671: , p_org_id IN NUMBER DEFAULT NULL
1672: )
1673: IS

Line 1678: l_po_line_id_list PO_TBL_NUMBER;

1674: l_api_name CONSTANT VARCHAR2(30) := 'synch_item_category';
1675: l_log_head CONSTANT VARCHAR2(100) := g_log_head || l_api_name;
1676: l_progress VARCHAR2(3) := '000';
1677:
1678: l_po_line_id_list PO_TBL_NUMBER;
1679: l_category_id_list PO_TBL_VARCHAR240;
1680: l_new_ip_category_id NUMBER;
1681: l_old_ip_category_id_list PO_TBL_NUMBER;
1682:

Line 1681: l_old_ip_category_id_list PO_TBL_NUMBER;

1677:
1678: l_po_line_id_list PO_TBL_NUMBER;
1679: l_category_id_list PO_TBL_VARCHAR240;
1680: l_new_ip_category_id NUMBER;
1681: l_old_ip_category_id_list PO_TBL_NUMBER;
1682:
1683: l_req_template_name_list PO_TBL_VARCHAR25;
1684: l_req_template_line_num_list PO_TBL_NUMBER;
1685: l_req_template_org_id_list PO_TBL_NUMBER;

Line 1684: l_req_template_line_num_list PO_TBL_NUMBER;

1680: l_new_ip_category_id NUMBER;
1681: l_old_ip_category_id_list PO_TBL_NUMBER;
1682:
1683: l_req_template_name_list PO_TBL_VARCHAR25;
1684: l_req_template_line_num_list PO_TBL_NUMBER;
1685: l_req_template_org_id_list PO_TBL_NUMBER;
1686:
1687: l_key PO_SESSION_GT.key%TYPE;
1688: BEGIN

Line 1685: l_req_template_org_id_list PO_TBL_NUMBER;

1681: l_old_ip_category_id_list PO_TBL_NUMBER;
1682:
1683: l_req_template_name_list PO_TBL_VARCHAR25;
1684: l_req_template_line_num_list PO_TBL_NUMBER;
1685: l_req_template_org_id_list PO_TBL_NUMBER;
1686:
1687: l_key PO_SESSION_GT.key%TYPE;
1688: BEGIN
1689: IF g_debug_stmt THEN PO_DEBUG.debug_begin(l_log_head); END IF;