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.INV_MWB_TREE1 dependencies on INV_MWB_TREE1

Line 1: PACKAGE BODY inv_mwb_tree1 AS

1: PACKAGE BODY inv_mwb_tree1 AS
2: /* $Header: INVMWTRB.pls 120.63.12020000.3 2013/01/14 02:54:32 xzhixong ship $ */
3:
4:
5: -- Controlled: 0 Don't Care, 1 No, 2 Yes

Line 8: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MWB_TREE1';

4:
5: -- Controlled: 0 Don't Care, 1 No, 2 Yes
6: -- Add organization nodes for the given parameters
7:
8: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MWB_TREE1';
9:
10: PROCEDURE add_document_numbers(
11: x_node_value IN OUT NOCOPY NUMBER
12: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

Line 13254: item := ' (' || inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id ))|| ')'; -- Bug 6350236

13250: DBMS_SQL.column_value(query_hdl, 3, item_id);
13251: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'outside if loop to add lpns before query' );
13252: IF item_id IS NOT NULL
13253: AND item_id <> 0 THEN
13254: item := ' (' || inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id ))|| ')'; -- Bug 6350236
13255: ELSE
13256: item := '';
13257: END IF;
13258: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'outside if loop to add lpns' );

Line 13548: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )); -- Bug 6350236

13544:
13545: IF j >= inv_mwb_globals.g_tree_node_low_value THEN
13546: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
13547: x_node_tbl(i).DEPTH := 1;
13548: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )); -- Bug 6350236
13549: x_node_tbl(i).icon := 'inv_item';
13550: x_node_tbl(i).VALUE := TO_CHAR(item_id);
13551: x_node_tbl(i).TYPE := 'ITEM';
13552: i := i + 1;

Line 13880: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )); -- Bug 6350236

13876:
13877: IF j >= inv_mwb_globals.g_tree_node_low_value THEN
13878: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
13879: x_node_tbl(i).DEPTH := 1;
13880: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )); -- Bug 6350236
13881: x_node_tbl(i).icon := 'inv_item';
13882: x_node_tbl(i).VALUE := TO_CHAR(item_id);
13883: x_node_tbl(i).TYPE := 'ITEM';
13884: i := i + 1;

Line 14238: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )); -- Bug 6350236

14234:
14235: IF j >= inv_mwb_globals.g_tree_node_low_value THEN
14236: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
14237: x_node_tbl(i).DEPTH := 1;
14238: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )); -- Bug 6350236
14239: x_node_tbl(i).icon := 'inv_item';
14240: x_node_tbl(i).VALUE := TO_CHAR(item_id);
14241: x_node_tbl(i).TYPE := 'ITEM';
14242: i := i + 1;

Line 14531: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )); -- Bug 6350236

14527:
14528: IF j >= inv_mwb_globals.g_tree_node_low_value THEN
14529: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
14530: x_node_tbl(i).DEPTH := 1;
14531: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )); -- Bug 6350236
14532: x_node_tbl(i).icon := 'inv_item';
14533: x_node_tbl(i).VALUE := TO_CHAR(item_id);
14534: x_node_tbl(i).TYPE := 'ITEM';
14535: i := i + 1;

Line 16401: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )); -- Bug 6350236

16397:
16398: IF j >= inv_mwb_globals.g_tree_node_low_value THEN
16399: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
16400: x_node_tbl(i).DEPTH := 1;
16401: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )); -- Bug 6350236
16402: x_node_tbl(i).icon := 'inv_item';
16403: x_node_tbl(i).VALUE := TO_CHAR(item_id);
16404: x_node_tbl(i).TYPE := 'ITEM';
16405: i := i + 1;

Line 16715: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(l_item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )) || '-' || rev; -- Bug 6350236

16711: IF j >= inv_mwb_globals.g_tree_node_low_value AND
16712: rev IS NOT NULL THEN
16713: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
16714: x_node_tbl(i).DEPTH := 1;
16715: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(l_item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )) || '-' || rev; -- Bug 6350236
16716: x_node_tbl(i).icon := 'inv_revi';
16717: x_node_tbl(i).VALUE := rev;
16718: x_node_tbl(i).TYPE := 'REV';
16719: i := i + 1;

Line 18244: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(l_item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )) || '-' || rev; -- Bug 6350236

18240: IF j >= inv_mwb_globals.g_tree_node_low_value AND
18241: rev IS NOT NULL THEN
18242: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
18243: x_node_tbl(i).DEPTH := 1;
18244: x_node_tbl(i).label := inv_mwb_tree1.GET_ITEM(l_item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id )) || '-' || rev; -- Bug 6350236
18245: x_node_tbl(i).icon := 'inv_revi';
18246: x_node_tbl(i).VALUE := rev;
18247: x_node_tbl(i).TYPE := 'REV';
18248: i := i + 1;

Line 22473: END inv_mwb_tree1;

22469: WHEN OTHERS THEN
22470: RETURN NULL;
22471: END GET_ITEM; -- Bug 6350236 Ending
22472:
22473: END inv_mwb_tree1;