APPS.INV_CG_UPGRADE dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 2017: FROM MTL_CYCLE_COUNT_ENTRIES

2013: select
2014: rowid
2015: , subinventory
2016: , locator_id
2017: FROM MTL_CYCLE_COUNT_ENTRIES
2018: where organization_id = l_organization_id
2019: and cost_group_id is null;
2020:
2021: --/*

Line 2056: l_table_name := 'mtl_cycle_count_entries';

2052: -- loop
2053: -- l_organization_id := c2.organization_id;
2054: -- */
2055:
2056: l_table_name := 'mtl_cycle_count_entries';
2057:
2058: /* Bug 4235102 fix */
2059: /* If there is atleast one record with a costgroup upgrade not needed */
2060: BEGIN

Line 2064: MTL_CYCLE_COUNT_ENTRIES

2060: BEGIN
2061: SELECT cost_group_id
2062: INTO l_check_cost_group_id
2063: FROM
2064: MTL_CYCLE_COUNT_ENTRIES
2065: WHERE
2066: organization_id = l_organization_id
2067: AND ROWNUM=1;
2068: EXCEPTION

Line 2145: update mtl_cycle_count_entries

2141: , p_organization_id => l_organization_id
2142: , p_subinventory => l_subinventory_code);
2143: end if;
2144:
2145: update mtl_cycle_count_entries
2146: set
2147: cost_group_id = l_cost_group_id
2148: where rowid = l_rowid;
2149:

Line 2173: update mtl_cycle_count_entries

2169: , p_subinventory => l_subinventory_code);
2170: END IF;
2171:
2172: if (l_cost_group_id > 0) then
2173: update mtl_cycle_count_entries
2174: set cost_group_id = l_cost_group_id
2175: where rowid = l_rowid;
2176:
2177: end if;

Line 2205: l_return_err := 'mtl_cycle_count_entries cost group upgrade:'|| l_msg_data;

2201:
2202: l_msg_data := replace(l_msg_data,chr(0),' ');
2203:
2204:
2205: l_return_err := 'mtl_cycle_count_entries cost group upgrade:'|| l_msg_data;
2206:
2207: INS_ERROR( p_table_name => l_table_name,
2208: p_ROWID => l_rowid_info,
2209: p_org_id => l_organization_id,

Line 2229: l_return_err := 'mtl_cycle_count_entries cost group upgrade:'|| l_msg_data;

2225: );
2226:
2227: l_msg_data := replace(l_msg_data,chr(0),' ');
2228:
2229: l_return_err := 'mtl_cycle_count_entries cost group upgrade:'|| l_msg_data;
2230:
2231:
2232: INS_ERROR( p_table_name => l_table_name,
2233: p_ROWID => l_rowid_info,

Line 2259: l_return_err := 'mtl_cycle_count_entries cost group upgrade:'||

2255: p_ROWID => l_rowid_info,
2256: p_org_id => l_organization_id,
2257: p_error_msg => l_msg_data,
2258: p_proc_name => l_procedure_name);
2259: l_return_err := 'mtl_cycle_count_entries cost group upgrade:'||
2260: substr(sqlerrm,1,55);
2261: raise_application_error(-20000,l_return_err);
2262:
2263: end INVMCCESB;