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 FND_APPTREE

Line 12: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

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
13: , x_tbl_index IN OUT NOCOPY NUMBER)
14: IS
15: select_str varchar2(10000);
16: where_str varchar2(10000);

Line 1276: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

1272:
1273:
1274: PROCEDURE add_orgs(
1275: x_node_value IN OUT NOCOPY NUMBER
1276: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
1277: , x_tbl_index IN OUT NOCOPY NUMBER
1278: ) IS
1279: query_str VARCHAR2(10000);
1280: query_hdl NUMBER;

Line 5959: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

5955:
5956: -- Add status nodes for the given parameters
5957: PROCEDURE add_statuses(
5958: x_node_value IN OUT NOCOPY NUMBER
5959: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
5960: , x_tbl_index IN OUT NOCOPY NUMBER
5961: ) IS
5962: query_str VARCHAR2(10000);
5963: query_hdl NUMBER;

Line 7374: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

7370: END add_statuses;
7371:
7372: PROCEDURE add_subs(
7373: x_node_value IN OUT NOCOPY NUMBER
7374: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
7375: , x_tbl_index IN OUT NOCOPY NUMBER
7376: ) IS
7377: query_str VARCHAR2(10000);
7378: query_hdl NUMBER;

Line 8947: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

8943: END add_subs;
8944:
8945: PROCEDURE add_locs(
8946: x_node_value IN OUT NOCOPY NUMBER
8947: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
8948: , x_tbl_index IN OUT NOCOPY NUMBER
8949: ) IS
8950: query_str VARCHAR2(10000);
8951: query_hdl NUMBER;

Line 10448: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

10444: END add_locs;
10445:
10446: PROCEDURE add_cgs(
10447: x_node_value IN OUT NOCOPY NUMBER
10448: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
10449: , x_tbl_index IN OUT NOCOPY NUMBER
10450: ) IS
10451: query_str VARCHAR2(10000);
10452: query_hdl NUMBER;

Line 12063: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

12059:
12060: PROCEDURE add_lpns(
12061: /* , inv_mwb_globals.g_inserted_under_org IN VARCHAR2 DEFAULT 'N'*/
12062: x_node_value IN OUT NOCOPY NUMBER
12063: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
12064: , x_tbl_index IN OUT NOCOPY NUMBER
12065: ) IS
12066: query_str VARCHAR2(8000);
12067: query_hdl NUMBER;

Line 13291: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

13287:
13288: PROCEDURE add_items(
13289: /*, inv_mwb_globals.g_inserted_under_org IN VARCHAR2 DEFAULT 'N'*/
13290: x_node_value IN OUT NOCOPY NUMBER
13291: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
13292: , x_tbl_index IN OUT NOCOPY NUMBER
13293: ) IS
13294: query_str VARCHAR2(10000);
13295: subquery_str varchar2(3000);

Line 16427: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

16423: END add_items;
16424:
16425: PROCEDURE add_revs(
16426: x_node_value IN OUT NOCOPY NUMBER
16427: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
16428: , x_tbl_index IN OUT NOCOPY NUMBER
16429: ) IS
16430: query_str VARCHAR2(10000);
16431: query_hdl NUMBER;

Line 18270: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

18266: END add_revs;
18267:
18268: PROCEDURE add_lots(
18269: x_node_value IN OUT NOCOPY NUMBER
18270: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
18271: , x_tbl_index IN OUT NOCOPY NUMBER
18272: ) IS
18273: query_str VARCHAR2(10000);
18274: query_hdl NUMBER;

Line 20241: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

20237: END add_lots;
20238:
20239: PROCEDURE add_serials(
20240: x_node_value IN OUT NOCOPY NUMBER
20241: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
20242: , x_tbl_index IN OUT NOCOPY NUMBER
20243: ) IS
20244: query_str VARCHAR2(10000);
20245: query_hdl NUMBER;

Line 21506: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

21502: -- NSRIVAST, INVCONV, Start
21503: -- Procedure to give grade nodes for view by Grade
21504: PROCEDURE add_grades (
21505: x_node_value IN OUT NOCOPY NUMBER
21506: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
21507: , x_tbl_index IN OUT NOCOPY NUMBER
21508: ) IS
21509:
21510: query_str VARCHAR2(10000);