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_CACHE

Line 1315: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

1311: END IF;
1312:
1313: -- Getting the default org status id
1314: if (inv_mwb_globals.g_organization_id is not null) then
1315: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
1316: l_default_status_id := inv_cache.org_rec.default_status_id;
1317: end if;
1318: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
1319: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 1316: l_default_status_id := inv_cache.org_rec.default_status_id;

1312:
1313: -- Getting the default org status id
1314: if (inv_mwb_globals.g_organization_id is not null) then
1315: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
1316: l_default_status_id := inv_cache.org_rec.default_status_id;
1317: end if;
1318: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
1319: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1320: l_default_status_id := inv_cache.org_rec.default_status_id;

Line 1319: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

1315: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
1316: l_default_status_id := inv_cache.org_rec.default_status_id;
1317: end if;
1318: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
1319: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1320: l_default_status_id := inv_cache.org_rec.default_status_id;
1321: end if;
1322: end if;
1323: -- End Onhand Material Status Support

Line 1320: l_default_status_id := inv_cache.org_rec.default_status_id;

1316: l_default_status_id := inv_cache.org_rec.default_status_id;
1317: end if;
1318: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
1319: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1320: l_default_status_id := inv_cache.org_rec.default_status_id;
1321: end if;
1322: end if;
1323: -- End Onhand Material Status Support
1324:

Line 5986: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

5982: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
5983:
5984: -- Onhand Material Status Support
5985: if (inv_mwb_globals.g_organization_id is not null) then
5986: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
5987: l_default_status_id := inv_cache.org_rec.default_status_id;
5988: end if;
5989: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
5990: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 5987: l_default_status_id := inv_cache.org_rec.default_status_id;

5983:
5984: -- Onhand Material Status Support
5985: if (inv_mwb_globals.g_organization_id is not null) then
5986: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
5987: l_default_status_id := inv_cache.org_rec.default_status_id;
5988: end if;
5989: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
5990: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
5991: l_default_status_id := inv_cache.org_rec.default_status_id;

Line 5990: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

5986: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
5987: l_default_status_id := inv_cache.org_rec.default_status_id;
5988: end if;
5989: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
5990: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
5991: l_default_status_id := inv_cache.org_rec.default_status_id;
5992: end if;
5993: end if;
5994:

Line 5991: l_default_status_id := inv_cache.org_rec.default_status_id;

5987: l_default_status_id := inv_cache.org_rec.default_status_id;
5988: end if;
5989: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
5990: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
5991: l_default_status_id := inv_cache.org_rec.default_status_id;
5992: end if;
5993: end if;
5994:
5995: -- NSRIVAST, INVCONV, Start

Line 7399: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

7395: END IF;
7396:
7397: -- Onhand Material Status Support
7398: if (inv_mwb_globals.g_organization_id is not null) then
7399: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
7400: l_default_status_id := inv_cache.org_rec.default_status_id;
7401: end if;
7402: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
7403: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 7400: l_default_status_id := inv_cache.org_rec.default_status_id;

7396:
7397: -- Onhand Material Status Support
7398: if (inv_mwb_globals.g_organization_id is not null) then
7399: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
7400: l_default_status_id := inv_cache.org_rec.default_status_id;
7401: end if;
7402: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
7403: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
7404: l_default_status_id := inv_cache.org_rec.default_status_id;

Line 7403: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

7399: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
7400: l_default_status_id := inv_cache.org_rec.default_status_id;
7401: end if;
7402: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
7403: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
7404: l_default_status_id := inv_cache.org_rec.default_status_id;
7405: end if;
7406: end if;
7407:

Line 7404: l_default_status_id := inv_cache.org_rec.default_status_id;

7400: l_default_status_id := inv_cache.org_rec.default_status_id;
7401: end if;
7402: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
7403: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
7404: l_default_status_id := inv_cache.org_rec.default_status_id;
7405: end if;
7406: end if;
7407:
7408: -- NSRIVAST, INVCONV, Start

Line 8974: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

8970: END IF;
8971:
8972: -- Onhand Material Status Support
8973: if (inv_mwb_globals.g_organization_id is not null) then
8974: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
8975: l_default_status_id := inv_cache.org_rec.default_status_id;
8976: end if;
8977: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
8978: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 8975: l_default_status_id := inv_cache.org_rec.default_status_id;

8971:
8972: -- Onhand Material Status Support
8973: if (inv_mwb_globals.g_organization_id is not null) then
8974: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
8975: l_default_status_id := inv_cache.org_rec.default_status_id;
8976: end if;
8977: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
8978: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
8979: l_default_status_id := inv_cache.org_rec.default_status_id;

Line 8978: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

8974: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
8975: l_default_status_id := inv_cache.org_rec.default_status_id;
8976: end if;
8977: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
8978: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
8979: l_default_status_id := inv_cache.org_rec.default_status_id;
8980: end if;
8981: end if;
8982:

Line 8979: l_default_status_id := inv_cache.org_rec.default_status_id;

8975: l_default_status_id := inv_cache.org_rec.default_status_id;
8976: end if;
8977: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
8978: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
8979: l_default_status_id := inv_cache.org_rec.default_status_id;
8980: end if;
8981: end if;
8982:
8983: -- NSRIVAST, INVCONV, Start

Line 10472: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

10468: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
10469:
10470: -- Onhand Material Status Support
10471: if (inv_mwb_globals.g_organization_id is not null) then
10472: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
10473: l_default_status_id := inv_cache.org_rec.default_status_id;
10474: end if;
10475: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
10476: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 10473: l_default_status_id := inv_cache.org_rec.default_status_id;

10469:
10470: -- Onhand Material Status Support
10471: if (inv_mwb_globals.g_organization_id is not null) then
10472: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
10473: l_default_status_id := inv_cache.org_rec.default_status_id;
10474: end if;
10475: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
10476: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
10477: l_default_status_id := inv_cache.org_rec.default_status_id;

Line 10476: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

10472: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
10473: l_default_status_id := inv_cache.org_rec.default_status_id;
10474: end if;
10475: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
10476: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
10477: l_default_status_id := inv_cache.org_rec.default_status_id;
10478: end if;
10479: end if;
10480:

Line 10477: l_default_status_id := inv_cache.org_rec.default_status_id;

10473: l_default_status_id := inv_cache.org_rec.default_status_id;
10474: end if;
10475: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
10476: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
10477: l_default_status_id := inv_cache.org_rec.default_status_id;
10478: end if;
10479: end if;
10480:
10481: -- NSRIVAST, INVCONV, Start

Line 12094: IF (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) THEN

12090: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered'||inv_mwb_globals.g_inserted_under_org);
12091:
12092: /* LPN Status Project */
12093: IF (inv_mwb_globals.g_organization_id IS NOT NULL) THEN
12094: IF (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) THEN
12095: l_default_status_id := inv_cache.org_rec.default_status_id;
12096: END IF;
12097: ELSIF (inv_mwb_globals.g_tree_organization_id IS NOT NULL) THEN
12098: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

Line 12095: l_default_status_id := inv_cache.org_rec.default_status_id;

12091:
12092: /* LPN Status Project */
12093: IF (inv_mwb_globals.g_organization_id IS NOT NULL) THEN
12094: IF (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) THEN
12095: l_default_status_id := inv_cache.org_rec.default_status_id;
12096: END IF;
12097: ELSIF (inv_mwb_globals.g_tree_organization_id IS NOT NULL) THEN
12098: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
12099: l_default_status_id := inv_cache.org_rec.default_status_id;

Line 12098: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

12094: IF (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) THEN
12095: l_default_status_id := inv_cache.org_rec.default_status_id;
12096: END IF;
12097: ELSIF (inv_mwb_globals.g_tree_organization_id IS NOT NULL) THEN
12098: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
12099: l_default_status_id := inv_cache.org_rec.default_status_id;
12100: END IF;
12101: END IF;
12102:

Line 12099: l_default_status_id := inv_cache.org_rec.default_status_id;

12095: l_default_status_id := inv_cache.org_rec.default_status_id;
12096: END IF;
12097: ELSIF (inv_mwb_globals.g_tree_organization_id IS NOT NULL) THEN
12098: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
12099: l_default_status_id := inv_cache.org_rec.default_status_id;
12100: END IF;
12101: END IF;
12102:
12103: IF inv_mwb_globals.g_tree_doc_type_id IS NOT NULL THEN -- If add_lpn called from node_expanded of document number.

Line 13327: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

13323: END IF;
13324:
13325: -- Onhand Material Status Support
13326: if (inv_mwb_globals.g_organization_id is not null) then
13327: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
13328: l_default_status_id := inv_cache.org_rec.default_status_id;
13329: end if;
13330: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
13331: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 13328: l_default_status_id := inv_cache.org_rec.default_status_id;

13324:
13325: -- Onhand Material Status Support
13326: if (inv_mwb_globals.g_organization_id is not null) then
13327: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
13328: l_default_status_id := inv_cache.org_rec.default_status_id;
13329: end if;
13330: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
13331: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
13332: l_default_status_id := inv_cache.org_rec.default_status_id;

Line 13331: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

13327: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
13328: l_default_status_id := inv_cache.org_rec.default_status_id;
13329: end if;
13330: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
13331: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
13332: l_default_status_id := inv_cache.org_rec.default_status_id;
13333: end if;
13334: end if;
13335:

Line 13332: l_default_status_id := inv_cache.org_rec.default_status_id;

13328: l_default_status_id := inv_cache.org_rec.default_status_id;
13329: end if;
13330: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
13331: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
13332: l_default_status_id := inv_cache.org_rec.default_status_id;
13333: end if;
13334: end if;
13335:
13336: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered with node type : '||inv_mwb_globals.g_tree_node_type );

Line 16454: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

16450: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
16451:
16452: -- Onhand Material Status Support
16453: if (inv_mwb_globals.g_organization_id is not null) then
16454: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
16455: l_default_status_id := inv_cache.org_rec.default_status_id;
16456: end if;
16457: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
16458: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 16455: l_default_status_id := inv_cache.org_rec.default_status_id;

16451:
16452: -- Onhand Material Status Support
16453: if (inv_mwb_globals.g_organization_id is not null) then
16454: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
16455: l_default_status_id := inv_cache.org_rec.default_status_id;
16456: end if;
16457: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
16458: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
16459: l_default_status_id := inv_cache.org_rec.default_status_id;

Line 16458: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

16454: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
16455: l_default_status_id := inv_cache.org_rec.default_status_id;
16456: end if;
16457: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
16458: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
16459: l_default_status_id := inv_cache.org_rec.default_status_id;
16460: end if;
16461: end if;
16462:

Line 16459: l_default_status_id := inv_cache.org_rec.default_status_id;

16455: l_default_status_id := inv_cache.org_rec.default_status_id;
16456: end if;
16457: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
16458: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
16459: l_default_status_id := inv_cache.org_rec.default_status_id;
16460: end if;
16461: end if;
16462:
16463: IF inv_mwb_globals.g_tree_doc_type_id IS NOT NULL THEN -- If add_item called from node_expanded of inbound lpn number.

Line 18309: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

18305: END IF;
18306:
18307: -- Onhand Material Status Support
18308: if (inv_mwb_globals.g_organization_id is not null) then
18309: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
18310: l_default_status_id := inv_cache.org_rec.default_status_id;
18311: end if;
18312: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
18313: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 18310: l_default_status_id := inv_cache.org_rec.default_status_id;

18306:
18307: -- Onhand Material Status Support
18308: if (inv_mwb_globals.g_organization_id is not null) then
18309: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
18310: l_default_status_id := inv_cache.org_rec.default_status_id;
18311: end if;
18312: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
18313: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
18314: l_default_status_id := inv_cache.org_rec.default_status_id;

Line 18313: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

18309: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
18310: l_default_status_id := inv_cache.org_rec.default_status_id;
18311: end if;
18312: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
18313: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
18314: l_default_status_id := inv_cache.org_rec.default_status_id;
18315: end if;
18316: end if;
18317:

Line 18314: l_default_status_id := inv_cache.org_rec.default_status_id;

18310: l_default_status_id := inv_cache.org_rec.default_status_id;
18311: end if;
18312: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
18313: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
18314: l_default_status_id := inv_cache.org_rec.default_status_id;
18315: end if;
18316: end if;
18317:
18318: -- If add_item called from node_expanded of inbound lpn number.

Line 20282: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

20278: END IF;
20279:
20280: -- Onhand Material Status Support
20281: if (inv_mwb_globals.g_organization_id is not null) then
20282: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
20283: l_default_status_id := inv_cache.org_rec.default_status_id;
20284: end if;
20285: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
20286: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

Line 20283: l_default_status_id := inv_cache.org_rec.default_status_id;

20279:
20280: -- Onhand Material Status Support
20281: if (inv_mwb_globals.g_organization_id is not null) then
20282: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
20283: l_default_status_id := inv_cache.org_rec.default_status_id;
20284: end if;
20285: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
20286: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
20287: l_default_status_id := inv_cache.org_rec.default_status_id;

Line 20286: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

20282: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
20283: l_default_status_id := inv_cache.org_rec.default_status_id;
20284: end if;
20285: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
20286: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
20287: l_default_status_id := inv_cache.org_rec.default_status_id;
20288: end if;
20289: end if;
20290:

Line 20287: l_default_status_id := inv_cache.org_rec.default_status_id;

20283: l_default_status_id := inv_cache.org_rec.default_status_id;
20284: end if;
20285: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
20286: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
20287: l_default_status_id := inv_cache.org_rec.default_status_id;
20288: end if;
20289: end if;
20290:
20291: