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.48.12010000.2 2008/11/10 11:31:54 ksaripal ship $ */
3:
4:
5: -- Controlled: 0 Don't Care, 1 No, 2 Yes

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

13: END IF;
14: COMMIT;
15: end; */
16:
17: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_MWB_TREE1';
18:
19: PROCEDURE add_document_numbers(
20: x_node_value IN OUT NOCOPY NUMBER
21: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

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

11143: DBMS_SQL.column_value(query_hdl, 3, item_id);
11144: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'outside if loop to add lpns before query' );
11145: IF item_id IS NOT NULL
11146: AND item_id <> 0 THEN
11147: item := ' (' || inv_mwb_tree1.GET_ITEM(item_id, NVL(inv_mwb_globals.g_tree_organization_id, inv_mwb_globals.g_organization_id ))|| ')'; -- Bug 6350236
11148: ELSE
11149: item := '';
11150: END IF;
11151: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'outside if loop to add lpns' );

Line 11410: 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

11406:
11407: IF j >= inv_mwb_globals.g_tree_node_low_value THEN
11408: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
11409: x_node_tbl(i).DEPTH := 1;
11410: 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
11411: x_node_tbl(i).icon := 'inv_item';
11412: x_node_tbl(i).VALUE := TO_CHAR(item_id);
11413: x_node_tbl(i).TYPE := 'ITEM';
11414: i := i + 1;

Line 11664: 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

11660:
11661: IF j >= inv_mwb_globals.g_tree_node_low_value THEN
11662: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
11663: x_node_tbl(i).DEPTH := 1;
11664: 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
11665: x_node_tbl(i).icon := 'inv_item';
11666: x_node_tbl(i).VALUE := TO_CHAR(item_id);
11667: x_node_tbl(i).TYPE := 'ITEM';
11668: i := i + 1;

Line 11941: 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

11937:
11938: IF j >= inv_mwb_globals.g_tree_node_low_value THEN
11939: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
11940: x_node_tbl(i).DEPTH := 1;
11941: 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
11942: x_node_tbl(i).icon := 'inv_item';
11943: x_node_tbl(i).VALUE := TO_CHAR(item_id);
11944: x_node_tbl(i).TYPE := 'ITEM';
11945: i := i + 1;

Line 12153: 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

12149:
12150: IF j >= inv_mwb_globals.g_tree_node_low_value THEN
12151: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
12152: x_node_tbl(i).DEPTH := 1;
12153: 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
12154: x_node_tbl(i).icon := 'inv_item';
12155: x_node_tbl(i).VALUE := TO_CHAR(item_id);
12156: x_node_tbl(i).TYPE := 'ITEM';
12157: i := i + 1;

Line 13775: 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

13771:
13772: IF j >= inv_mwb_globals.g_tree_node_low_value THEN
13773: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
13774: x_node_tbl(i).DEPTH := 1;
13775: 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
13776: x_node_tbl(i).icon := 'inv_item';
13777: x_node_tbl(i).VALUE := TO_CHAR(item_id);
13778: x_node_tbl(i).TYPE := 'ITEM';
13779: i := i + 1;

Line 14010: 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

14006: IF j >= inv_mwb_globals.g_tree_node_low_value AND
14007: rev IS NOT NULL THEN
14008: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
14009: x_node_tbl(i).DEPTH := 1;
14010: 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
14011: x_node_tbl(i).icon := 'inv_revi';
14012: x_node_tbl(i).VALUE := rev;
14013: x_node_tbl(i).TYPE := 'REV';
14014: i := i + 1;

Line 15296: 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

15292: IF j >= inv_mwb_globals.g_tree_node_low_value AND
15293: rev IS NOT NULL THEN
15294: x_node_tbl(i).state := inv_mwb_globals.g_tree_node_state;
15295: x_node_tbl(i).DEPTH := 1;
15296: 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
15297: x_node_tbl(i).icon := 'inv_revi';
15298: x_node_tbl(i).VALUE := rev;
15299: x_node_tbl(i).TYPE := 'REV';
15300: i := i + 1;

Line 18918: END inv_mwb_tree1;

18914: WHEN OTHERS THEN
18915: RETURN NULL;
18916: END GET_ITEM; -- Bug 6350236 Ending
18917:
18918: END inv_mwb_tree1;