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 1036: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

1032: END IF;
1033:
1034: -- Getting the default org status id
1035: if (inv_mwb_globals.g_organization_id is not null) then
1036: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
1037: l_default_status_id := inv_cache.org_rec.default_status_id;
1038: end if;
1039: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
1040: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

1033:
1034: -- Getting the default org status id
1035: if (inv_mwb_globals.g_organization_id is not null) then
1036: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
1037: l_default_status_id := inv_cache.org_rec.default_status_id;
1038: end if;
1039: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
1040: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1041: l_default_status_id := inv_cache.org_rec.default_status_id;

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

1036: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
1037: l_default_status_id := inv_cache.org_rec.default_status_id;
1038: end if;
1039: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
1040: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1041: l_default_status_id := inv_cache.org_rec.default_status_id;
1042: end if;
1043: end if;
1044: -- End Onhand Material Status Support

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

1037: l_default_status_id := inv_cache.org_rec.default_status_id;
1038: end if;
1039: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
1040: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
1041: l_default_status_id := inv_cache.org_rec.default_status_id;
1042: end if;
1043: end if;
1044: -- End Onhand Material Status Support
1045:

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

5004: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
5005:
5006: -- Onhand Material Status Support
5007: if (inv_mwb_globals.g_organization_id is not null) then
5008: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
5009: l_default_status_id := inv_cache.org_rec.default_status_id;
5010: end if;
5011: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
5012: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

5005:
5006: -- Onhand Material Status Support
5007: if (inv_mwb_globals.g_organization_id is not null) then
5008: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
5009: l_default_status_id := inv_cache.org_rec.default_status_id;
5010: end if;
5011: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
5012: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
5013: l_default_status_id := inv_cache.org_rec.default_status_id;

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

5008: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
5009: l_default_status_id := inv_cache.org_rec.default_status_id;
5010: end if;
5011: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
5012: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
5013: l_default_status_id := inv_cache.org_rec.default_status_id;
5014: end if;
5015: end if;
5016:

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

5009: l_default_status_id := inv_cache.org_rec.default_status_id;
5010: end if;
5011: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
5012: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
5013: l_default_status_id := inv_cache.org_rec.default_status_id;
5014: end if;
5015: end if;
5016:
5017: -- NSRIVAST, INVCONV, Start

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

6208: END IF;
6209:
6210: -- Onhand Material Status Support
6211: if (inv_mwb_globals.g_organization_id is not null) then
6212: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
6213: l_default_status_id := inv_cache.org_rec.default_status_id;
6214: end if;
6215: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
6216: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

6209:
6210: -- Onhand Material Status Support
6211: if (inv_mwb_globals.g_organization_id is not null) then
6212: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
6213: l_default_status_id := inv_cache.org_rec.default_status_id;
6214: end if;
6215: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
6216: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
6217: l_default_status_id := inv_cache.org_rec.default_status_id;

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

6212: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
6213: l_default_status_id := inv_cache.org_rec.default_status_id;
6214: end if;
6215: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
6216: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
6217: l_default_status_id := inv_cache.org_rec.default_status_id;
6218: end if;
6219: end if;
6220:

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

6213: l_default_status_id := inv_cache.org_rec.default_status_id;
6214: end if;
6215: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
6216: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
6217: l_default_status_id := inv_cache.org_rec.default_status_id;
6218: end if;
6219: end if;
6220:
6221: -- NSRIVAST, INVCONV, Start

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

7535: END IF;
7536:
7537: -- Onhand Material Status Support
7538: if (inv_mwb_globals.g_organization_id is not null) then
7539: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
7540: l_default_status_id := inv_cache.org_rec.default_status_id;
7541: end if;
7542: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
7543: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

7536:
7537: -- Onhand Material Status Support
7538: if (inv_mwb_globals.g_organization_id is not null) then
7539: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
7540: l_default_status_id := inv_cache.org_rec.default_status_id;
7541: end if;
7542: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
7543: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
7544: l_default_status_id := inv_cache.org_rec.default_status_id;

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

7539: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
7540: l_default_status_id := inv_cache.org_rec.default_status_id;
7541: end if;
7542: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
7543: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
7544: l_default_status_id := inv_cache.org_rec.default_status_id;
7545: end if;
7546: end if;
7547:

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

7540: l_default_status_id := inv_cache.org_rec.default_status_id;
7541: end if;
7542: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
7543: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
7544: l_default_status_id := inv_cache.org_rec.default_status_id;
7545: end if;
7546: end if;
7547:
7548: -- NSRIVAST, INVCONV, Start

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

8785: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
8786:
8787: -- Onhand Material Status Support
8788: if (inv_mwb_globals.g_organization_id is not null) then
8789: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
8790: l_default_status_id := inv_cache.org_rec.default_status_id;
8791: end if;
8792: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
8793: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

8786:
8787: -- Onhand Material Status Support
8788: if (inv_mwb_globals.g_organization_id is not null) then
8789: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
8790: l_default_status_id := inv_cache.org_rec.default_status_id;
8791: end if;
8792: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
8793: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
8794: l_default_status_id := inv_cache.org_rec.default_status_id;

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

8789: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
8790: l_default_status_id := inv_cache.org_rec.default_status_id;
8791: end if;
8792: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
8793: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
8794: l_default_status_id := inv_cache.org_rec.default_status_id;
8795: end if;
8796: end if;
8797:

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

8790: l_default_status_id := inv_cache.org_rec.default_status_id;
8791: end if;
8792: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
8793: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
8794: l_default_status_id := inv_cache.org_rec.default_status_id;
8795: end if;
8796: end if;
8797:
8798: -- NSRIVAST, INVCONV, Start

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

10165: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered'||inv_mwb_globals.g_inserted_under_org);
10166:
10167: /* LPN Status Project */
10168: IF (inv_mwb_globals.g_organization_id IS NOT NULL) THEN
10169: IF (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) THEN
10170: l_default_status_id := inv_cache.org_rec.default_status_id;
10171: END IF;
10172: ELSIF (inv_mwb_globals.g_tree_organization_id IS NOT NULL) THEN
10173: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN

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

10166:
10167: /* LPN Status Project */
10168: IF (inv_mwb_globals.g_organization_id IS NOT NULL) THEN
10169: IF (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) THEN
10170: l_default_status_id := inv_cache.org_rec.default_status_id;
10171: END IF;
10172: ELSIF (inv_mwb_globals.g_tree_organization_id IS NOT NULL) THEN
10173: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
10174: l_default_status_id := inv_cache.org_rec.default_status_id;

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

10169: IF (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) THEN
10170: l_default_status_id := inv_cache.org_rec.default_status_id;
10171: END IF;
10172: ELSIF (inv_mwb_globals.g_tree_organization_id IS NOT NULL) THEN
10173: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
10174: l_default_status_id := inv_cache.org_rec.default_status_id;
10175: END IF;
10176: END IF;
10177:

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

10170: l_default_status_id := inv_cache.org_rec.default_status_id;
10171: END IF;
10172: ELSIF (inv_mwb_globals.g_tree_organization_id IS NOT NULL) THEN
10173: IF (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) THEN
10174: l_default_status_id := inv_cache.org_rec.default_status_id;
10175: END IF;
10176: END IF;
10177:
10178: IF inv_mwb_globals.g_tree_doc_type_id IS NOT NULL THEN -- If add_lpn called from node_expanded of document number.

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

11216: END IF;
11217:
11218: -- Onhand Material Status Support
11219: if (inv_mwb_globals.g_organization_id is not null) then
11220: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
11221: l_default_status_id := inv_cache.org_rec.default_status_id;
11222: end if;
11223: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
11224: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

11217:
11218: -- Onhand Material Status Support
11219: if (inv_mwb_globals.g_organization_id is not null) then
11220: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
11221: l_default_status_id := inv_cache.org_rec.default_status_id;
11222: end if;
11223: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
11224: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
11225: l_default_status_id := inv_cache.org_rec.default_status_id;

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

11220: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
11221: l_default_status_id := inv_cache.org_rec.default_status_id;
11222: end if;
11223: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
11224: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
11225: l_default_status_id := inv_cache.org_rec.default_status_id;
11226: end if;
11227: end if;
11228:

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

11221: l_default_status_id := inv_cache.org_rec.default_status_id;
11222: end if;
11223: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
11224: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
11225: l_default_status_id := inv_cache.org_rec.default_status_id;
11226: end if;
11227: end if;
11228:
11229: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered with node type : '||inv_mwb_globals.g_tree_node_type );

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

13824: inv_mwb_globals.print_msg( g_pkg_name, l_procedure_name, 'Entered' );
13825:
13826: -- Onhand Material Status Support
13827: if (inv_mwb_globals.g_organization_id is not null) then
13828: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
13829: l_default_status_id := inv_cache.org_rec.default_status_id;
13830: end if;
13831: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
13832: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

13825:
13826: -- Onhand Material Status Support
13827: if (inv_mwb_globals.g_organization_id is not null) then
13828: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
13829: l_default_status_id := inv_cache.org_rec.default_status_id;
13830: end if;
13831: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
13832: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
13833: l_default_status_id := inv_cache.org_rec.default_status_id;

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

13828: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
13829: l_default_status_id := inv_cache.org_rec.default_status_id;
13830: end if;
13831: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
13832: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
13833: l_default_status_id := inv_cache.org_rec.default_status_id;
13834: end if;
13835: end if;
13836:

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

13829: l_default_status_id := inv_cache.org_rec.default_status_id;
13830: end if;
13831: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
13832: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
13833: l_default_status_id := inv_cache.org_rec.default_status_id;
13834: end if;
13835: end if;
13836:
13837: 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 15361: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then

15357: END IF;
15358:
15359: -- Onhand Material Status Support
15360: if (inv_mwb_globals.g_organization_id is not null) then
15361: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
15362: l_default_status_id := inv_cache.org_rec.default_status_id;
15363: end if;
15364: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
15365: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

15358:
15359: -- Onhand Material Status Support
15360: if (inv_mwb_globals.g_organization_id is not null) then
15361: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
15362: l_default_status_id := inv_cache.org_rec.default_status_id;
15363: end if;
15364: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
15365: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
15366: l_default_status_id := inv_cache.org_rec.default_status_id;

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

15361: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
15362: l_default_status_id := inv_cache.org_rec.default_status_id;
15363: end if;
15364: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
15365: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
15366: l_default_status_id := inv_cache.org_rec.default_status_id;
15367: end if;
15368: end if;
15369:

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

15362: l_default_status_id := inv_cache.org_rec.default_status_id;
15363: end if;
15364: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
15365: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
15366: l_default_status_id := inv_cache.org_rec.default_status_id;
15367: end if;
15368: end if;
15369:
15370: -- If add_item called from node_expanded of inbound lpn number.

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

17008: END IF;
17009:
17010: -- Onhand Material Status Support
17011: if (inv_mwb_globals.g_organization_id is not null) then
17012: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
17013: l_default_status_id := inv_cache.org_rec.default_status_id;
17014: end if;
17015: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
17016: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then

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

17009:
17010: -- Onhand Material Status Support
17011: if (inv_mwb_globals.g_organization_id is not null) then
17012: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
17013: l_default_status_id := inv_cache.org_rec.default_status_id;
17014: end if;
17015: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
17016: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
17017: l_default_status_id := inv_cache.org_rec.default_status_id;

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

17012: if (inv_cache.set_org_rec(inv_mwb_globals.g_organization_id)) then
17013: l_default_status_id := inv_cache.org_rec.default_status_id;
17014: end if;
17015: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
17016: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
17017: l_default_status_id := inv_cache.org_rec.default_status_id;
17018: end if;
17019: end if;
17020:

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

17013: l_default_status_id := inv_cache.org_rec.default_status_id;
17014: end if;
17015: elsif (inv_mwb_globals.g_tree_organization_id is not null) then
17016: if (inv_cache.set_org_rec(inv_mwb_globals.g_tree_organization_id)) then
17017: l_default_status_id := inv_cache.org_rec.default_status_id;
17018: end if;
17019: end if;
17020:
17021: