APPS.INV_CG_UPGRADE dependencies on MTL_ONHAND_QUANTITIES

Line 1046: from mtl_onhand_quantities

1042: , subinventory_code
1043: , locator_id
1044: , project_id
1045: , task_id
1046: from mtl_onhand_quantities
1047: where organization_id = l_organization_id
1048: and cost_group_id is null;
1049:
1050: --/*

Line 1085: l_table_name := 'mtl_onhand_quantities';

1081: -- loop
1082: -- l_organization_id := c2.organization_id;
1083: -- */
1084:
1085: l_table_name := 'mtl_onhand_quantities';
1086:
1087: /* Bug 4235102 fix */
1088: /* If there is atleast one record with a costgroup upgrade not needed */
1089: BEGIN

Line 1093: mtl_onhand_quantities

1089: BEGIN
1090: SELECT cost_group_id
1091: INTO l_check_cost_group_id
1092: FROM
1093: mtl_onhand_quantities
1094: WHERE
1095: organization_id = l_organization_id
1096: AND ROWNUM=1;
1097: EXCEPTION

Line 1175: update mtl_onhand_quantities

1171: , p_organization_id => l_organization_id
1172: , p_subinventory => l_subinventory_code);
1173: end if;
1174:
1175: update mtl_onhand_quantities
1176: set
1177: cost_group_id = l_cost_group_id
1178: , project_id = v_project_id
1179: , task_id = v_task_id

Line 1205: update mtl_onhand_quantities

1201: , p_subinventory => l_subinventory_code);
1202: END IF;
1203:
1204: if (l_cost_group_id > 0) then
1205: update mtl_onhand_quantities
1206: set cost_group_id = l_cost_group_id
1207: where rowid = l_rowid;
1208:
1209: end if;

Line 1237: l_return_err := 'mtl_onhand_quantities cost group upgrade:'|| l_msg_data;

1233:
1234: l_msg_data := replace(l_msg_data,chr(0),' ');
1235:
1236:
1237: l_return_err := 'mtl_onhand_quantities cost group upgrade:'|| l_msg_data;
1238:
1239: INS_ERROR( p_table_name => l_table_name,
1240: p_ROWID => l_rowid_info,
1241: p_org_id => l_organization_id,

Line 1261: l_return_err := 'mtl_onhand_quantities cost group upgrade:'|| l_msg_data;

1257: );
1258:
1259: l_msg_data := replace(l_msg_data,chr(0),' ');
1260:
1261: l_return_err := 'mtl_onhand_quantities cost group upgrade:'|| l_msg_data;
1262:
1263:
1264: INS_ERROR( p_table_name => l_table_name,
1265: p_ROWID => l_rowid_info,

Line 1291: l_return_err := 'mtl_onhand_quantities cost group upgrade:'||

1287: p_ROWID => l_rowid_info,
1288: p_org_id => l_organization_id,
1289: p_error_msg => l_msg_data,
1290: p_proc_name => l_procedure_name);
1291: l_return_err := 'mtl_onhand_quantities cost group upgrade:'||
1292: substr(sqlerrm,1,55);
1293: raise_application_error(-20000,l_return_err);
1294:
1295: end INVMOQSB;