APPS.INV_CG_UPGRADE dependencies on INV_SUB_CG_UTIL

Line 413: l_cost_group_id := inv_sub_cg_util.get_cg_from_org(

409:
410: l_secondary_inventory := c1.secondary_inventory;
411: if ( p_cost_method = 2 ) then
412: if ( l_org_cost_group_id is null )then
413: l_cost_group_id := inv_sub_cg_util.get_cg_from_org(
414: x_return_status => l_return_status
415: , x_msg_count => l_msg_count
416: , x_msg_data => l_msg_data
417: , p_organization_id => l_organization_id);

Line 439: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

435: end if;
436: else
437:
438: if (l_secondary_inventory is not null) then
439: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
440: x_return_status => l_return_status
441: , x_msg_count => l_msg_count
442: , x_msg_data => l_msg_data
443: , p_organization_id => l_organization_id

Line 453: l_cost_group_id := inv_sub_cg_util.get_cg_from_org(

449: where rowid = l_rowid;
450: end if;
451: else
452: if ( l_org_cost_group_id is null ) then
453: l_cost_group_id := inv_sub_cg_util.get_cg_from_org(
454: x_return_status => l_return_status
455: , x_msg_count => l_msg_count
456: , x_msg_data => l_msg_data
457: , p_organization_id => l_organization_id);

Line 1167: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

1163: when NO_DATA_FOUND then
1164: l_cost_group_id := 1;
1165: end;
1166: else
1167: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
1168: x_return_status => l_return_status
1169: , x_msg_count => l_msg_count
1170: , x_msg_data => l_msg_data
1171: , p_organization_id => l_organization_id

Line 1185: l_org_cost_group_id := inv_sub_cg_util.get_cg_from_org(

1181:
1182: else
1183: IF ( p_cost_method = 2 ) THEN /*average costing org */
1184: IF ( l_org_cost_group_id IS NULL ) then
1185: l_org_cost_group_id := inv_sub_cg_util.get_cg_from_org(
1186: x_return_status => l_return_status
1187: , x_msg_count => l_msg_count
1188: , x_msg_data => l_msg_data
1189: , p_organization_id => l_organization_id);

Line 1196: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

1192: ELSE
1193: l_cost_group_id := l_org_cost_group_id ;
1194: END IF;
1195: ELSE /* standard costing */
1196: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
1197: x_return_status => l_return_status
1198: , x_msg_count => l_msg_count
1199: , x_msg_data => l_msg_data
1200: , p_organization_id => l_organization_id

Line 1576: l_cost_group_id := inv_sub_cg_util.get_cg_from_org(

1572: */
1573: if (l_cost_group_id is null and l_project_id is null) then
1574: if ( p_cost_method = 2 ) then
1575: if ( l_org_cost_group_id is null ) then
1576: l_cost_group_id := inv_sub_cg_util.get_cg_from_org(
1577: x_return_status => l_return_status
1578: , x_msg_count => l_msg_count
1579: , x_msg_data => l_msg_data
1580: , p_organization_id => l_organization_id);

Line 1586: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

1582: else
1583: l_cost_group_id := l_org_cost_group_id ;
1584: end if;
1585: else
1586: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
1587: x_return_status => l_return_status
1588: , x_msg_count => l_msg_count
1589: , x_msg_data => l_msg_data
1590: , p_organization_id => l_organization_id

Line 1600: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

1596: end if;
1597:
1598:
1599: if (l_cost_group_id is null and l_project_id is NOT null and p_cost_method = 1) then
1600: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
1601: x_return_status => l_return_status
1602: , x_msg_count => l_msg_count
1603: , x_msg_data => l_msg_data
1604: , p_organization_id => l_organization_id

Line 1624: l_transfer_cost_group_id := inv_sub_cg_util.get_cg_from_org(

1620: (l_transfer_organization_id > 0) and
1621: (l_transfer_subinventory is not null) and
1622: (l_to_project_id is null) then
1623: if ( p_cost_method = 2) then
1624: l_transfer_cost_group_id := inv_sub_cg_util.get_cg_from_org(
1625: x_return_status => l_return_status
1626: , x_msg_count => l_msg_count
1627: , x_msg_data => l_msg_data
1628: , p_organization_id => l_transfer_organization_id);

Line 1630: l_transfer_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

1626: , x_msg_count => l_msg_count
1627: , x_msg_data => l_msg_data
1628: , p_organization_id => l_transfer_organization_id);
1629: else
1630: l_transfer_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
1631: x_return_status => l_return_status
1632: , x_msg_count => l_msg_count
1633: , x_msg_data => l_msg_data
1634: , p_organization_id => l_transfer_organization_id

Line 1648: l_transfer_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

1644: select primary_cost_method into l_transfer_cost_method
1645: from mtl_parameters where organization_id = l_transfer_organization_id ;
1646:
1647: if ( l_transfer_cost_method = 1 ) then
1648: l_transfer_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
1649: x_return_status => l_return_status
1650: , x_msg_count => l_msg_count
1651: , x_msg_data => l_msg_data
1652: , p_organization_id => l_transfer_organization_id

Line 1708: l_ms_cost_group_id := inv_sub_cg_util.get_cg_from_org(

1704: --
1705: if l_intransit_owning_org_id = l_organization_id then
1706: if ( p_cost_method = 2 ) then
1707: if ( l_org_cost_group_id is null ) then
1708: l_ms_cost_group_id := inv_sub_cg_util.get_cg_from_org(
1709: x_return_status => l_return_status
1710: , x_msg_count => l_msg_count
1711: , x_msg_data => l_msg_data
1712: , p_organization_id => l_organization_id);

Line 1718: l_ms_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

1714: else
1715: l_ms_cost_group_id := l_org_cost_group_id ;
1716: end if;
1717: else
1718: l_ms_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
1719: x_return_status => l_return_status
1720: , x_msg_count => l_msg_count
1721: , x_msg_data => l_msg_data
1722: , p_organization_id => l_organization_id

Line 1726: l_ms_cost_group_id := inv_sub_cg_util.get_cg_from_org(

1722: , p_organization_id => l_organization_id
1723: , p_subinventory => l_subinventory_code);
1724: end if;
1725: else
1726: l_ms_cost_group_id := inv_sub_cg_util.get_cg_from_org(
1727: x_return_status => l_return_status
1728: , x_msg_count => l_msg_count
1729: , x_msg_data => l_msg_data
1730: , p_organization_id => l_intransit_owning_org_id);

Line 2137: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

2133: when NO_DATA_FOUND then
2134: l_cost_group_id := 1;
2135: end;
2136: else
2137: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
2138: x_return_status => l_return_status
2139: , x_msg_count => l_msg_count
2140: , x_msg_data => l_msg_data
2141: , p_organization_id => l_organization_id

Line 2153: l_org_cost_group_id := inv_sub_cg_util.get_cg_from_org(

2149:
2150: else
2151: IF ( p_cost_method = 2 ) THEN /*average costing org */
2152: IF ( l_org_cost_group_id IS NULL ) then
2153: l_org_cost_group_id := inv_sub_cg_util.get_cg_from_org(
2154: x_return_status => l_return_status
2155: , x_msg_count => l_msg_count
2156: , x_msg_data => l_msg_data
2157: , p_organization_id => l_organization_id);

Line 2164: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

2160: ELSE
2161: l_cost_group_id := l_org_cost_group_id ;
2162: END IF;
2163: ELSE /* standard costing */
2164: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
2165: x_return_status => l_return_status
2166: , x_msg_count => l_msg_count
2167: , x_msg_data => l_msg_data
2168: , p_organization_id => l_organization_id

Line 2426: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

2422: when NO_DATA_FOUND then
2423: l_cost_group_id := 1;
2424: end;
2425: else
2426: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
2427: x_return_status => l_return_status
2428: , x_msg_count => l_msg_count
2429: , x_msg_data => l_msg_data
2430: , p_organization_id => l_organization_id

Line 2442: l_org_cost_group_id := inv_sub_cg_util.get_cg_from_org(

2438:
2439: else
2440: IF ( p_cost_method = 2 ) THEN /*average costing org */
2441: IF ( l_org_cost_group_id IS NULL ) then
2442: l_org_cost_group_id := inv_sub_cg_util.get_cg_from_org(
2443: x_return_status => l_return_status
2444: , x_msg_count => l_msg_count
2445: , x_msg_data => l_msg_data
2446: , p_organization_id => l_organization_id);

Line 2453: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

2449: ELSE
2450: l_cost_group_id := l_org_cost_group_id ;
2451: END IF;
2452: ELSE /* standard costing */
2453: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
2454: x_return_status => l_return_status
2455: , x_msg_count => l_msg_count
2456: , x_msg_data => l_msg_data
2457: , p_organization_id => l_organization_id

Line 2713: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

2709: when NO_DATA_FOUND then
2710: l_cost_group_id := 1;
2711: end;
2712: else
2713: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
2714: x_return_status => l_return_status
2715: , x_msg_count => l_msg_count
2716: , x_msg_data => l_msg_data
2717: , p_organization_id => l_organization_id

Line 2729: l_org_cost_group_id := inv_sub_cg_util.get_cg_from_org(

2725:
2726: else
2727: IF ( p_cost_method = 2 ) THEN /*average costing org */
2728: IF ( l_org_cost_group_id IS NULL ) then
2729: l_org_cost_group_id := inv_sub_cg_util.get_cg_from_org(
2730: x_return_status => l_return_status
2731: , x_msg_count => l_msg_count
2732: , x_msg_data => l_msg_data
2733: , p_organization_id => l_organization_id);

Line 2740: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(

2736: ELSE
2737: l_cost_group_id := l_org_cost_group_id ;
2738: END IF;
2739: ELSE /* standard costing */
2740: l_cost_group_id := inv_sub_cg_util.get_cg_from_sub(
2741: x_return_status => l_return_status
2742: , x_msg_count => l_msg_count
2743: , x_msg_data => l_msg_data
2744: , p_organization_id => l_organization_id