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 21: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

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
22: , x_tbl_index IN OUT NOCOPY NUMBER)
23: IS
24: select_str varchar2(10000);
25: where_str varchar2(10000);

Line 997: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

993:
994:
995: PROCEDURE add_orgs(
996: x_node_value IN OUT NOCOPY NUMBER
997: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
998: , x_tbl_index IN OUT NOCOPY NUMBER
999: ) IS
1000: query_str VARCHAR2(10000);
1001: query_hdl NUMBER;

Line 4981: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

4977:
4978: -- Add status nodes for the given parameters
4979: PROCEDURE add_statuses(
4980: x_node_value IN OUT NOCOPY NUMBER
4981: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
4982: , x_tbl_index IN OUT NOCOPY NUMBER
4983: ) IS
4984: query_str VARCHAR2(10000);
4985: query_hdl NUMBER;

Line 6187: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

6183: END add_statuses;
6184:
6185: PROCEDURE add_subs(
6186: x_node_value IN OUT NOCOPY NUMBER
6187: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
6188: , x_tbl_index IN OUT NOCOPY NUMBER
6189: ) IS
6190: query_str VARCHAR2(10000);
6191: query_hdl NUMBER;

Line 7512: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

7508: END add_subs;
7509:
7510: PROCEDURE add_locs(
7511: x_node_value IN OUT NOCOPY NUMBER
7512: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
7513: , x_tbl_index IN OUT NOCOPY NUMBER
7514: ) IS
7515: query_str VARCHAR2(10000);
7516: query_hdl NUMBER;

Line 8765: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

8761: END add_locs;
8762:
8763: PROCEDURE add_cgs(
8764: x_node_value IN OUT NOCOPY NUMBER
8765: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
8766: , x_tbl_index IN OUT NOCOPY NUMBER
8767: ) IS
8768: query_str VARCHAR2(10000);
8769: query_hdl NUMBER;

Line 10138: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

10134:
10135: PROCEDURE add_lpns(
10136: /* , inv_mwb_globals.g_inserted_under_org IN VARCHAR2 DEFAULT 'N'*/
10137: x_node_value IN OUT NOCOPY NUMBER
10138: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
10139: , x_tbl_index IN OUT NOCOPY NUMBER
10140: ) IS
10141: query_str VARCHAR2(8000);
10142: query_hdl NUMBER;

Line 11184: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

11180:
11181: PROCEDURE add_items(
11182: /*, inv_mwb_globals.g_inserted_under_org IN VARCHAR2 DEFAULT 'N'*/
11183: x_node_value IN OUT NOCOPY NUMBER
11184: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
11185: , x_tbl_index IN OUT NOCOPY NUMBER
11186: ) IS
11187: query_str VARCHAR2(10000);
11188: subquery_str varchar2(3000);

Line 13801: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

13797: END add_items;
13798:
13799: PROCEDURE add_revs(
13800: x_node_value IN OUT NOCOPY NUMBER
13801: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
13802: , x_tbl_index IN OUT NOCOPY NUMBER
13803: ) IS
13804: query_str VARCHAR2(10000);
13805: query_hdl NUMBER;

Line 15322: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

15318: END add_revs;
15319:
15320: PROCEDURE add_lots(
15321: x_node_value IN OUT NOCOPY NUMBER
15322: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
15323: , x_tbl_index IN OUT NOCOPY NUMBER
15324: ) IS
15325: query_str VARCHAR2(10000);
15326: query_hdl NUMBER;

Line 16971: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

16967: END add_lots;
16968:
16969: PROCEDURE add_serials(
16970: x_node_value IN OUT NOCOPY NUMBER
16971: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
16972: , x_tbl_index IN OUT NOCOPY NUMBER
16973: ) IS
16974: query_str VARCHAR2(10000);
16975: query_hdl NUMBER;

Line 18015: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type

18011: -- NSRIVAST, INVCONV, Start
18012: -- Procedure to give grade nodes for view by Grade
18013: PROCEDURE add_grades (
18014: x_node_value IN OUT NOCOPY NUMBER
18015: , x_node_tbl IN OUT NOCOPY fnd_apptree.node_tbl_type
18016: , x_tbl_index IN OUT NOCOPY NUMBER
18017: ) IS
18018:
18019: query_str VARCHAR2(10000);