2030: , mpacdt.insertion_flag
2031: , mpacdt.transaction_costed_date
2032: , DECODE(cpitt.txn_type,1,8,2,9) txn_category -- bug 7674673 fix
2033: , SYSDATE
2034: , FND_GLOBAL.user_id
2035: , SYSDATE
2036: , FND_GLOBAL.user_id
2037: , FND_GLOBAL.conc_request_id
2038: , FND_GLOBAL.prog_appl_id
2032: , DECODE(cpitt.txn_type,1,8,2,9) txn_category -- bug 7674673 fix
2033: , SYSDATE
2034: , FND_GLOBAL.user_id
2035: , SYSDATE
2036: , FND_GLOBAL.user_id
2037: , FND_GLOBAL.conc_request_id
2038: , FND_GLOBAL.prog_appl_id
2039: , FND_GLOBAL.conc_program_id
2040: , SYSDATE
2033: , SYSDATE
2034: , FND_GLOBAL.user_id
2035: , SYSDATE
2036: , FND_GLOBAL.user_id
2037: , FND_GLOBAL.conc_request_id
2038: , FND_GLOBAL.prog_appl_id
2039: , FND_GLOBAL.conc_program_id
2040: , SYSDATE
2041: , FND_GLOBAL.login_id
2034: , FND_GLOBAL.user_id
2035: , SYSDATE
2036: , FND_GLOBAL.user_id
2037: , FND_GLOBAL.conc_request_id
2038: , FND_GLOBAL.prog_appl_id
2039: , FND_GLOBAL.conc_program_id
2040: , SYSDATE
2041: , FND_GLOBAL.login_id
2042: FROM MTL_PAC_ACT_CST_DTL_TEMP mpacdt
2035: , SYSDATE
2036: , FND_GLOBAL.user_id
2037: , FND_GLOBAL.conc_request_id
2038: , FND_GLOBAL.prog_appl_id
2039: , FND_GLOBAL.conc_program_id
2040: , SYSDATE
2041: , FND_GLOBAL.login_id
2042: FROM MTL_PAC_ACT_CST_DTL_TEMP mpacdt
2043: ,CST_PAC_INTERORG_TXNS_TMP cpitt
2037: , FND_GLOBAL.conc_request_id
2038: , FND_GLOBAL.prog_appl_id
2039: , FND_GLOBAL.conc_program_id
2040: , SYSDATE
2041: , FND_GLOBAL.login_id
2042: FROM MTL_PAC_ACT_CST_DTL_TEMP mpacdt
2043: ,CST_PAC_INTERORG_TXNS_TMP cpitt
2044: WHERE mpacdt.pac_period_id = p_pac_period_id
2045: AND mpacdt.inventory_item_id = p_inventory_item_id
2178: -- Update cpicd with new cost, new buy cost, new make cost
2179: -- ========================================================
2180: UPDATE cst_pac_item_cost_details cpicd
2181: SET last_update_date = SYSDATE
2182: ,last_updated_by = FND_GLOBAL.user_id
2183: ,last_update_login = FND_GLOBAL.login_id
2184: ,request_id = FND_GLOBAL.conc_request_id
2185: ,program_application_id = FND_GLOBAL.prog_appl_id
2186: ,program_id = FND_GLOBAL.conc_program_id
2179: -- ========================================================
2180: UPDATE cst_pac_item_cost_details cpicd
2181: SET last_update_date = SYSDATE
2182: ,last_updated_by = FND_GLOBAL.user_id
2183: ,last_update_login = FND_GLOBAL.login_id
2184: ,request_id = FND_GLOBAL.conc_request_id
2185: ,program_application_id = FND_GLOBAL.prog_appl_id
2186: ,program_id = FND_GLOBAL.conc_program_id
2187: ,program_update_date = SYSDATE
2180: UPDATE cst_pac_item_cost_details cpicd
2181: SET last_update_date = SYSDATE
2182: ,last_updated_by = FND_GLOBAL.user_id
2183: ,last_update_login = FND_GLOBAL.login_id
2184: ,request_id = FND_GLOBAL.conc_request_id
2185: ,program_application_id = FND_GLOBAL.prog_appl_id
2186: ,program_id = FND_GLOBAL.conc_program_id
2187: ,program_update_date = SYSDATE
2188: ,item_cost = l_item_cost
2181: SET last_update_date = SYSDATE
2182: ,last_updated_by = FND_GLOBAL.user_id
2183: ,last_update_login = FND_GLOBAL.login_id
2184: ,request_id = FND_GLOBAL.conc_request_id
2185: ,program_application_id = FND_GLOBAL.prog_appl_id
2186: ,program_id = FND_GLOBAL.conc_program_id
2187: ,program_update_date = SYSDATE
2188: ,item_cost = l_item_cost
2189: ,item_balance = l_item_balance
2182: ,last_updated_by = FND_GLOBAL.user_id
2183: ,last_update_login = FND_GLOBAL.login_id
2184: ,request_id = FND_GLOBAL.conc_request_id
2185: ,program_application_id = FND_GLOBAL.prog_appl_id
2186: ,program_id = FND_GLOBAL.conc_program_id
2187: ,program_update_date = SYSDATE
2188: ,item_cost = l_item_cost
2189: ,item_balance = l_item_balance
2190: WHERE cpicd.cost_layer_id = mpacd_idx.cost_layer_id
2221: (SELECT mpacd_idx.cost_layer_id,
2222: mpacd_idx.cost_element_id,
2223: mpacd_idx.level_type,
2224: sysdate,
2225: FND_GLOBAL.user_id,
2226: sysdate,
2227: FND_GLOBAL.user_id,
2228: FND_GLOBAL.login_id,
2229: FND_GLOBAL.conc_request_id,
2223: mpacd_idx.level_type,
2224: sysdate,
2225: FND_GLOBAL.user_id,
2226: sysdate,
2227: FND_GLOBAL.user_id,
2228: FND_GLOBAL.login_id,
2229: FND_GLOBAL.conc_request_id,
2230: FND_GLOBAL.prog_appl_id,
2231: FND_GLOBAL.conc_program_id,
2224: sysdate,
2225: FND_GLOBAL.user_id,
2226: sysdate,
2227: FND_GLOBAL.user_id,
2228: FND_GLOBAL.login_id,
2229: FND_GLOBAL.conc_request_id,
2230: FND_GLOBAL.prog_appl_id,
2231: FND_GLOBAL.conc_program_id,
2232: sysdate,
2225: FND_GLOBAL.user_id,
2226: sysdate,
2227: FND_GLOBAL.user_id,
2228: FND_GLOBAL.login_id,
2229: FND_GLOBAL.conc_request_id,
2230: FND_GLOBAL.prog_appl_id,
2231: FND_GLOBAL.conc_program_id,
2232: sysdate,
2233: l_item_cost,
2226: sysdate,
2227: FND_GLOBAL.user_id,
2228: FND_GLOBAL.login_id,
2229: FND_GLOBAL.conc_request_id,
2230: FND_GLOBAL.prog_appl_id,
2231: FND_GLOBAL.conc_program_id,
2232: sysdate,
2233: l_item_cost,
2234: 0,
2227: FND_GLOBAL.user_id,
2228: FND_GLOBAL.login_id,
2229: FND_GLOBAL.conc_request_id,
2230: FND_GLOBAL.prog_appl_id,
2231: FND_GLOBAL.conc_program_id,
2232: sysdate,
2233: l_item_cost,
2234: 0,
2235: 0,
2277: ,unburdened_cost
2278: ,burden_cost
2279: ) =
2280: (SELECT
2281: FND_GLOBAL.user_id
2282: , SYSDATE
2283: , FND_GLOBAL.login_id
2284: , FND_GLOBAL.conc_request_id
2285: , FND_GLOBAL.prog_appl_id
2279: ) =
2280: (SELECT
2281: FND_GLOBAL.user_id
2282: , SYSDATE
2283: , FND_GLOBAL.login_id
2284: , FND_GLOBAL.conc_request_id
2285: , FND_GLOBAL.prog_appl_id
2286: , FND_GLOBAL.conc_program_id
2287: , SYSDATE
2280: (SELECT
2281: FND_GLOBAL.user_id
2282: , SYSDATE
2283: , FND_GLOBAL.login_id
2284: , FND_GLOBAL.conc_request_id
2285: , FND_GLOBAL.prog_appl_id
2286: , FND_GLOBAL.conc_program_id
2287: , SYSDATE
2288: , SUM(DECODE(level_type,2,DECODE(cost_element_id,1,item_cost,0),0))
2281: FND_GLOBAL.user_id
2282: , SYSDATE
2283: , FND_GLOBAL.login_id
2284: , FND_GLOBAL.conc_request_id
2285: , FND_GLOBAL.prog_appl_id
2286: , FND_GLOBAL.conc_program_id
2287: , SYSDATE
2288: , SUM(DECODE(level_type,2,DECODE(cost_element_id,1,item_cost,0),0))
2289: , SUM(DECODE(level_type,2,DECODE(cost_element_id,2,item_cost,0),0))
2282: , SYSDATE
2283: , FND_GLOBAL.login_id
2284: , FND_GLOBAL.conc_request_id
2285: , FND_GLOBAL.prog_appl_id
2286: , FND_GLOBAL.conc_program_id
2287: , SYSDATE
2288: , SUM(DECODE(level_type,2,DECODE(cost_element_id,1,item_cost,0),0))
2289: , SUM(DECODE(level_type,2,DECODE(cost_element_id,2,item_cost,0),0))
2290: , SUM(DECODE(level_type,2,DECODE(cost_element_id,3,item_cost,0),0))
2339: ,p_cost_type_id => p_cost_type_id
2340: ,p_cost_group_id => p_cost_group_id
2341: ,p_inventory_item_id => p_inventory_item_id
2342: ,p_end_date => p_end_date
2343: ,p_user_id => FND_GLOBAL.user_id
2344: ,p_login_id => FND_GLOBAL.login_id
2345: ,p_req_id => FND_GLOBAL.conc_request_id
2346: ,p_prg_id => FND_GLOBAL.conc_program_id
2347: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2340: ,p_cost_group_id => p_cost_group_id
2341: ,p_inventory_item_id => p_inventory_item_id
2342: ,p_end_date => p_end_date
2343: ,p_user_id => FND_GLOBAL.user_id
2344: ,p_login_id => FND_GLOBAL.login_id
2345: ,p_req_id => FND_GLOBAL.conc_request_id
2346: ,p_prg_id => FND_GLOBAL.conc_program_id
2347: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2348: );
2341: ,p_inventory_item_id => p_inventory_item_id
2342: ,p_end_date => p_end_date
2343: ,p_user_id => FND_GLOBAL.user_id
2344: ,p_login_id => FND_GLOBAL.login_id
2345: ,p_req_id => FND_GLOBAL.conc_request_id
2346: ,p_prg_id => FND_GLOBAL.conc_program_id
2347: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2348: );
2349: ELSE
2342: ,p_end_date => p_end_date
2343: ,p_user_id => FND_GLOBAL.user_id
2344: ,p_login_id => FND_GLOBAL.login_id
2345: ,p_req_id => FND_GLOBAL.conc_request_id
2346: ,p_prg_id => FND_GLOBAL.conc_program_id
2347: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2348: );
2349: ELSE
2350: FOR cost_group_idx IN cost_group_cur(p_inventory_item_id
2343: ,p_user_id => FND_GLOBAL.user_id
2344: ,p_login_id => FND_GLOBAL.login_id
2345: ,p_req_id => FND_GLOBAL.conc_request_id
2346: ,p_prg_id => FND_GLOBAL.conc_program_id
2347: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2348: );
2349: ELSE
2350: FOR cost_group_idx IN cost_group_cur(p_inventory_item_id
2351: ,p_pac_period_id)
2354: ,p_cost_type_id => p_cost_type_id
2355: ,p_cost_group_id => cost_group_idx.cost_group_id
2356: ,p_inventory_item_id => p_inventory_item_id
2357: ,p_end_date => p_end_date
2358: ,p_user_id => FND_GLOBAL.user_id
2359: ,p_login_id => FND_GLOBAL.login_id
2360: ,p_req_id => FND_GLOBAL.conc_request_id
2361: ,p_prg_id => FND_GLOBAL.conc_program_id
2362: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2355: ,p_cost_group_id => cost_group_idx.cost_group_id
2356: ,p_inventory_item_id => p_inventory_item_id
2357: ,p_end_date => p_end_date
2358: ,p_user_id => FND_GLOBAL.user_id
2359: ,p_login_id => FND_GLOBAL.login_id
2360: ,p_req_id => FND_GLOBAL.conc_request_id
2361: ,p_prg_id => FND_GLOBAL.conc_program_id
2362: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2363: );
2356: ,p_inventory_item_id => p_inventory_item_id
2357: ,p_end_date => p_end_date
2358: ,p_user_id => FND_GLOBAL.user_id
2359: ,p_login_id => FND_GLOBAL.login_id
2360: ,p_req_id => FND_GLOBAL.conc_request_id
2361: ,p_prg_id => FND_GLOBAL.conc_program_id
2362: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2363: );
2364: END LOOP;
2357: ,p_end_date => p_end_date
2358: ,p_user_id => FND_GLOBAL.user_id
2359: ,p_login_id => FND_GLOBAL.login_id
2360: ,p_req_id => FND_GLOBAL.conc_request_id
2361: ,p_prg_id => FND_GLOBAL.conc_program_id
2362: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2363: );
2364: END LOOP;
2365: END IF;
2358: ,p_user_id => FND_GLOBAL.user_id
2359: ,p_login_id => FND_GLOBAL.login_id
2360: ,p_req_id => FND_GLOBAL.conc_request_id
2361: ,p_prg_id => FND_GLOBAL.conc_program_id
2362: ,p_prg_appid => FND_GLOBAL.prog_appl_id
2363: );
2364: END LOOP;
2365: END IF;
2366: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2442: SET process_status = p_phase_status
2443: ,process_date = SYSDATE
2444: ,process_upto_date = decode(p_phase_status,4,p_period_end_date,NULL)
2445: ,last_update_date = SYSDATE
2446: ,last_updated_by = FND_GLOBAL.user_id
2447: ,request_id = FND_GLOBAL.conc_request_id
2448: ,program_application_id = FND_GLOBAL.prog_appl_id
2449: ,program_id = FND_GLOBAL.conc_program_id
2450: ,program_update_date = SYSDATE
2443: ,process_date = SYSDATE
2444: ,process_upto_date = decode(p_phase_status,4,p_period_end_date,NULL)
2445: ,last_update_date = SYSDATE
2446: ,last_updated_by = FND_GLOBAL.user_id
2447: ,request_id = FND_GLOBAL.conc_request_id
2448: ,program_application_id = FND_GLOBAL.prog_appl_id
2449: ,program_id = FND_GLOBAL.conc_program_id
2450: ,program_update_date = SYSDATE
2451: ,last_update_login = FND_GLOBAL.login_id
2444: ,process_upto_date = decode(p_phase_status,4,p_period_end_date,NULL)
2445: ,last_update_date = SYSDATE
2446: ,last_updated_by = FND_GLOBAL.user_id
2447: ,request_id = FND_GLOBAL.conc_request_id
2448: ,program_application_id = FND_GLOBAL.prog_appl_id
2449: ,program_id = FND_GLOBAL.conc_program_id
2450: ,program_update_date = SYSDATE
2451: ,last_update_login = FND_GLOBAL.login_id
2452: WHERE pac_period_id = p_period_id
2445: ,last_update_date = SYSDATE
2446: ,last_updated_by = FND_GLOBAL.user_id
2447: ,request_id = FND_GLOBAL.conc_request_id
2448: ,program_application_id = FND_GLOBAL.prog_appl_id
2449: ,program_id = FND_GLOBAL.conc_program_id
2450: ,program_update_date = SYSDATE
2451: ,last_update_login = FND_GLOBAL.login_id
2452: WHERE pac_period_id = p_period_id
2453: AND cost_group_id = l_cost_group_id
2447: ,request_id = FND_GLOBAL.conc_request_id
2448: ,program_application_id = FND_GLOBAL.prog_appl_id
2449: ,program_id = FND_GLOBAL.conc_program_id
2450: ,program_update_date = SYSDATE
2451: ,last_update_login = FND_GLOBAL.login_id
2452: WHERE pac_period_id = p_period_id
2453: AND cost_group_id = l_cost_group_id
2454: AND process_phase = 5;
2455:
2563: ,process_upto_date = decode(p_phase_status,4,p_period_end_date,
2564: 5,p_period_end_date,
2565: 3,p_period_end_date,NULL)
2566: ,last_update_date = SYSDATE
2567: ,last_updated_by = FND_GLOBAL.user_id
2568: ,request_id = FND_GLOBAL.conc_request_id
2569: ,program_application_id = FND_GLOBAL.prog_appl_id
2570: ,program_id = FND_GLOBAL.conc_program_id
2571: ,program_update_date = SYSDATE
2564: 5,p_period_end_date,
2565: 3,p_period_end_date,NULL)
2566: ,last_update_date = SYSDATE
2567: ,last_updated_by = FND_GLOBAL.user_id
2568: ,request_id = FND_GLOBAL.conc_request_id
2569: ,program_application_id = FND_GLOBAL.prog_appl_id
2570: ,program_id = FND_GLOBAL.conc_program_id
2571: ,program_update_date = SYSDATE
2572: ,last_update_login = FND_GLOBAL.login_id
2565: 3,p_period_end_date,NULL)
2566: ,last_update_date = SYSDATE
2567: ,last_updated_by = FND_GLOBAL.user_id
2568: ,request_id = FND_GLOBAL.conc_request_id
2569: ,program_application_id = FND_GLOBAL.prog_appl_id
2570: ,program_id = FND_GLOBAL.conc_program_id
2571: ,program_update_date = SYSDATE
2572: ,last_update_login = FND_GLOBAL.login_id
2573: WHERE pac_period_id = p_period_id
2566: ,last_update_date = SYSDATE
2567: ,last_updated_by = FND_GLOBAL.user_id
2568: ,request_id = FND_GLOBAL.conc_request_id
2569: ,program_application_id = FND_GLOBAL.prog_appl_id
2570: ,program_id = FND_GLOBAL.conc_program_id
2571: ,program_update_date = SYSDATE
2572: ,last_update_login = FND_GLOBAL.login_id
2573: WHERE pac_period_id = p_period_id
2574: AND cost_group_id = l_cost_group_id
2568: ,request_id = FND_GLOBAL.conc_request_id
2569: ,program_application_id = FND_GLOBAL.prog_appl_id
2570: ,program_id = FND_GLOBAL.conc_program_id
2571: ,program_update_date = SYSDATE
2572: ,last_update_login = FND_GLOBAL.login_id
2573: WHERE pac_period_id = p_period_id
2574: AND cost_group_id = l_cost_group_id
2575: AND process_phase = 7;
2576:
4048: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000) THEN
4049: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4050: ,i_cost_group_id => p_cost_group_id
4051: ,i_txn_category => l_txn_category
4052: ,i_user_id => FND_GLOBAL.user_id
4053: ,i_login_id => FND_GLOBAL.login_id
4054: ,i_request_id => FND_GLOBAL.conc_request_id
4055: ,i_prog_id => FND_GLOBAL.conc_program_id
4056: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4049: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4050: ,i_cost_group_id => p_cost_group_id
4051: ,i_txn_category => l_txn_category
4052: ,i_user_id => FND_GLOBAL.user_id
4053: ,i_login_id => FND_GLOBAL.login_id
4054: ,i_request_id => FND_GLOBAL.conc_request_id
4055: ,i_prog_id => FND_GLOBAL.conc_program_id
4056: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4057: ,o_err_num => l_error_num
4050: ,i_cost_group_id => p_cost_group_id
4051: ,i_txn_category => l_txn_category
4052: ,i_user_id => FND_GLOBAL.user_id
4053: ,i_login_id => FND_GLOBAL.login_id
4054: ,i_request_id => FND_GLOBAL.conc_request_id
4055: ,i_prog_id => FND_GLOBAL.conc_program_id
4056: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4057: ,o_err_num => l_error_num
4058: ,o_err_code => l_error_code
4051: ,i_txn_category => l_txn_category
4052: ,i_user_id => FND_GLOBAL.user_id
4053: ,i_login_id => FND_GLOBAL.login_id
4054: ,i_request_id => FND_GLOBAL.conc_request_id
4055: ,i_prog_id => FND_GLOBAL.conc_program_id
4056: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4057: ,o_err_num => l_error_num
4058: ,o_err_code => l_error_code
4059: ,o_err_msg => l_error_msg
4052: ,i_user_id => FND_GLOBAL.user_id
4053: ,i_login_id => FND_GLOBAL.login_id
4054: ,i_request_id => FND_GLOBAL.conc_request_id
4055: ,i_prog_id => FND_GLOBAL.conc_program_id
4056: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4057: ,o_err_num => l_error_num
4058: ,o_err_code => l_error_code
4059: ,o_err_msg => l_error_msg
4060: );
4087: , i_pac_rates_id => p_pac_rates_id
4088: , i_process_group => 1
4089: , i_master_org_id => p_master_org_id
4090: , i_uom_control => p_uom_control
4091: , i_user_id => FND_GLOBAL.user_id
4092: , i_login_id => FND_GLOBAL.login_id
4093: , i_request_id => FND_GLOBAL.conc_request_id
4094: , i_prog_id => FND_GLOBAL.conc_program_id
4095: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4088: , i_process_group => 1
4089: , i_master_org_id => p_master_org_id
4090: , i_uom_control => p_uom_control
4091: , i_user_id => FND_GLOBAL.user_id
4092: , i_login_id => FND_GLOBAL.login_id
4093: , i_request_id => FND_GLOBAL.conc_request_id
4094: , i_prog_id => FND_GLOBAL.conc_program_id
4095: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4096: , i_txn_category => l_txn_category
4089: , i_master_org_id => p_master_org_id
4090: , i_uom_control => p_uom_control
4091: , i_user_id => FND_GLOBAL.user_id
4092: , i_login_id => FND_GLOBAL.login_id
4093: , i_request_id => FND_GLOBAL.conc_request_id
4094: , i_prog_id => FND_GLOBAL.conc_program_id
4095: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4096: , i_txn_category => l_txn_category
4097: , i_transfer_price_pd => l_group1_interorg_tab(i).transfer_price
4090: , i_uom_control => p_uom_control
4091: , i_user_id => FND_GLOBAL.user_id
4092: , i_login_id => FND_GLOBAL.login_id
4093: , i_request_id => FND_GLOBAL.conc_request_id
4094: , i_prog_id => FND_GLOBAL.conc_program_id
4095: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4096: , i_txn_category => l_txn_category
4097: , i_transfer_price_pd => l_group1_interorg_tab(i).transfer_price
4098: , o_err_num => l_error_num
4091: , i_user_id => FND_GLOBAL.user_id
4092: , i_login_id => FND_GLOBAL.login_id
4093: , i_request_id => FND_GLOBAL.conc_request_id
4094: , i_prog_id => FND_GLOBAL.conc_program_id
4095: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4096: , i_txn_category => l_txn_category
4097: , i_transfer_price_pd => l_group1_interorg_tab(i).transfer_price
4098: , o_err_num => l_error_num
4099: , o_err_code => l_error_code
4274: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
4275: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4276: ,i_cost_group_id => p_cost_group_id
4277: ,i_txn_category => l_txn_category
4278: ,i_user_id => FND_GLOBAL.user_id
4279: ,i_login_id => FND_GLOBAL.login_id
4280: ,i_request_id => FND_GLOBAL.conc_request_id
4281: ,i_prog_id => FND_GLOBAL.conc_program_id
4282: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4275: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4276: ,i_cost_group_id => p_cost_group_id
4277: ,i_txn_category => l_txn_category
4278: ,i_user_id => FND_GLOBAL.user_id
4279: ,i_login_id => FND_GLOBAL.login_id
4280: ,i_request_id => FND_GLOBAL.conc_request_id
4281: ,i_prog_id => FND_GLOBAL.conc_program_id
4282: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4283: ,o_err_num => l_error_num
4276: ,i_cost_group_id => p_cost_group_id
4277: ,i_txn_category => l_txn_category
4278: ,i_user_id => FND_GLOBAL.user_id
4279: ,i_login_id => FND_GLOBAL.login_id
4280: ,i_request_id => FND_GLOBAL.conc_request_id
4281: ,i_prog_id => FND_GLOBAL.conc_program_id
4282: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4283: ,o_err_num => l_error_num
4284: ,o_err_code => l_error_code
4277: ,i_txn_category => l_txn_category
4278: ,i_user_id => FND_GLOBAL.user_id
4279: ,i_login_id => FND_GLOBAL.login_id
4280: ,i_request_id => FND_GLOBAL.conc_request_id
4281: ,i_prog_id => FND_GLOBAL.conc_program_id
4282: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4283: ,o_err_num => l_error_num
4284: ,o_err_code => l_error_code
4285: ,o_err_msg => l_error_msg
4278: ,i_user_id => FND_GLOBAL.user_id
4279: ,i_login_id => FND_GLOBAL.login_id
4280: ,i_request_id => FND_GLOBAL.conc_request_id
4281: ,i_prog_id => FND_GLOBAL.conc_program_id
4282: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4283: ,o_err_num => l_error_num
4284: ,o_err_code => l_error_code
4285: ,o_err_msg => l_error_msg
4286: );
4310: ,i_cost_group_id => p_cost_group_id
4311: ,i_cost_type_id => p_cost_type_id
4312: ,i_low_level_code => p_low_level_code
4313: ,i_item_id => p_inventory_item_id
4314: ,i_user_id => FND_GLOBAL.user_id
4315: ,i_login_id => FND_GLOBAL.login_id
4316: ,i_request_id => FND_GLOBAL.conc_request_id
4317: ,i_prog_id => FND_GLOBAL.conc_program_id
4318: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4311: ,i_cost_type_id => p_cost_type_id
4312: ,i_low_level_code => p_low_level_code
4313: ,i_item_id => p_inventory_item_id
4314: ,i_user_id => FND_GLOBAL.user_id
4315: ,i_login_id => FND_GLOBAL.login_id
4316: ,i_request_id => FND_GLOBAL.conc_request_id
4317: ,i_prog_id => FND_GLOBAL.conc_program_id
4318: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4319: ,o_err_num => l_error_num
4312: ,i_low_level_code => p_low_level_code
4313: ,i_item_id => p_inventory_item_id
4314: ,i_user_id => FND_GLOBAL.user_id
4315: ,i_login_id => FND_GLOBAL.login_id
4316: ,i_request_id => FND_GLOBAL.conc_request_id
4317: ,i_prog_id => FND_GLOBAL.conc_program_id
4318: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4319: ,o_err_num => l_error_num
4320: ,o_err_code => l_error_code
4313: ,i_item_id => p_inventory_item_id
4314: ,i_user_id => FND_GLOBAL.user_id
4315: ,i_login_id => FND_GLOBAL.login_id
4316: ,i_request_id => FND_GLOBAL.conc_request_id
4317: ,i_prog_id => FND_GLOBAL.conc_program_id
4318: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4319: ,o_err_num => l_error_num
4320: ,o_err_code => l_error_code
4321: ,o_err_msg => l_error_msg
4314: ,i_user_id => FND_GLOBAL.user_id
4315: ,i_login_id => FND_GLOBAL.login_id
4316: ,i_request_id => FND_GLOBAL.conc_request_id
4317: ,i_prog_id => FND_GLOBAL.conc_program_id
4318: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4319: ,o_err_num => l_error_num
4320: ,o_err_code => l_error_code
4321: ,o_err_msg => l_error_msg
4322: );
4372: CSTPPWAC.update_item_cppb (i_pac_period_id => p_period_id,
4373: i_cost_group_id => p_cost_group_id,
4374: i_txn_category => l_txn_category,
4375: i_item_id => p_inventory_item_id,
4376: i_user_id => FND_GLOBAL.user_id,
4377: i_login_id => FND_GLOBAL.login_id,
4378: i_request_id => FND_GLOBAL.conc_request_id,
4379: i_prog_id => FND_GLOBAL.conc_program_id,
4380: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
4373: i_cost_group_id => p_cost_group_id,
4374: i_txn_category => l_txn_category,
4375: i_item_id => p_inventory_item_id,
4376: i_user_id => FND_GLOBAL.user_id,
4377: i_login_id => FND_GLOBAL.login_id,
4378: i_request_id => FND_GLOBAL.conc_request_id,
4379: i_prog_id => FND_GLOBAL.conc_program_id,
4380: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
4381: o_err_num => l_error_num,
4374: i_txn_category => l_txn_category,
4375: i_item_id => p_inventory_item_id,
4376: i_user_id => FND_GLOBAL.user_id,
4377: i_login_id => FND_GLOBAL.login_id,
4378: i_request_id => FND_GLOBAL.conc_request_id,
4379: i_prog_id => FND_GLOBAL.conc_program_id,
4380: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
4381: o_err_num => l_error_num,
4382: o_err_code => l_error_code,
4375: i_item_id => p_inventory_item_id,
4376: i_user_id => FND_GLOBAL.user_id,
4377: i_login_id => FND_GLOBAL.login_id,
4378: i_request_id => FND_GLOBAL.conc_request_id,
4379: i_prog_id => FND_GLOBAL.conc_program_id,
4380: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
4381: o_err_num => l_error_num,
4382: o_err_code => l_error_code,
4383: o_err_msg => l_error_msg );
4376: i_user_id => FND_GLOBAL.user_id,
4377: i_login_id => FND_GLOBAL.login_id,
4378: i_request_id => FND_GLOBAL.conc_request_id,
4379: i_prog_id => FND_GLOBAL.conc_program_id,
4380: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
4381: o_err_num => l_error_num,
4382: o_err_code => l_error_code,
4383: o_err_msg => l_error_msg );
4384:
4521: IF (CSTPPINV.l_item_id_tbl.COUNT >= 1000) THEN
4522: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4523: ,i_cost_group_id => p_cost_group_id
4524: ,i_txn_category => l_txn_category
4525: ,i_user_id => FND_GLOBAL.user_id
4526: ,i_login_id => FND_GLOBAL.login_id
4527: ,i_request_id => FND_GLOBAL.conc_request_id
4528: ,i_prog_id => FND_GLOBAL.conc_program_id
4529: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4522: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4523: ,i_cost_group_id => p_cost_group_id
4524: ,i_txn_category => l_txn_category
4525: ,i_user_id => FND_GLOBAL.user_id
4526: ,i_login_id => FND_GLOBAL.login_id
4527: ,i_request_id => FND_GLOBAL.conc_request_id
4528: ,i_prog_id => FND_GLOBAL.conc_program_id
4529: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4530: ,o_err_num => l_error_num
4523: ,i_cost_group_id => p_cost_group_id
4524: ,i_txn_category => l_txn_category
4525: ,i_user_id => FND_GLOBAL.user_id
4526: ,i_login_id => FND_GLOBAL.login_id
4527: ,i_request_id => FND_GLOBAL.conc_request_id
4528: ,i_prog_id => FND_GLOBAL.conc_program_id
4529: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4530: ,o_err_num => l_error_num
4531: ,o_err_code => l_error_code
4524: ,i_txn_category => l_txn_category
4525: ,i_user_id => FND_GLOBAL.user_id
4526: ,i_login_id => FND_GLOBAL.login_id
4527: ,i_request_id => FND_GLOBAL.conc_request_id
4528: ,i_prog_id => FND_GLOBAL.conc_program_id
4529: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4530: ,o_err_num => l_error_num
4531: ,o_err_code => l_error_code
4532: ,o_err_msg => l_error_msg
4525: ,i_user_id => FND_GLOBAL.user_id
4526: ,i_login_id => FND_GLOBAL.login_id
4527: ,i_request_id => FND_GLOBAL.conc_request_id
4528: ,i_prog_id => FND_GLOBAL.conc_program_id
4529: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4530: ,o_err_num => l_error_num
4531: ,o_err_code => l_error_code
4532: ,o_err_msg => l_error_msg
4533: );
4560: , i_pac_rates_id => p_pac_rates_id
4561: , i_process_group => 2
4562: , i_master_org_id => p_master_org_id
4563: , i_uom_control => p_uom_control
4564: , i_user_id => FND_GLOBAL.user_id
4565: , i_login_id => FND_GLOBAL.login_id
4566: , i_request_id => FND_GLOBAL.conc_request_id
4567: , i_prog_id => FND_GLOBAL.conc_program_id
4568: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4561: , i_process_group => 2
4562: , i_master_org_id => p_master_org_id
4563: , i_uom_control => p_uom_control
4564: , i_user_id => FND_GLOBAL.user_id
4565: , i_login_id => FND_GLOBAL.login_id
4566: , i_request_id => FND_GLOBAL.conc_request_id
4567: , i_prog_id => FND_GLOBAL.conc_program_id
4568: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4569: , i_txn_category => l_txn_category
4562: , i_master_org_id => p_master_org_id
4563: , i_uom_control => p_uom_control
4564: , i_user_id => FND_GLOBAL.user_id
4565: , i_login_id => FND_GLOBAL.login_id
4566: , i_request_id => FND_GLOBAL.conc_request_id
4567: , i_prog_id => FND_GLOBAL.conc_program_id
4568: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4569: , i_txn_category => l_txn_category
4570: , i_transfer_price_pd => l_group2_interorg_tab(i).transfer_price
4563: , i_uom_control => p_uom_control
4564: , i_user_id => FND_GLOBAL.user_id
4565: , i_login_id => FND_GLOBAL.login_id
4566: , i_request_id => FND_GLOBAL.conc_request_id
4567: , i_prog_id => FND_GLOBAL.conc_program_id
4568: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4569: , i_txn_category => l_txn_category
4570: , i_transfer_price_pd => l_group2_interorg_tab(i).transfer_price
4571: , o_err_num => l_error_num
4564: , i_user_id => FND_GLOBAL.user_id
4565: , i_login_id => FND_GLOBAL.login_id
4566: , i_request_id => FND_GLOBAL.conc_request_id
4567: , i_prog_id => FND_GLOBAL.conc_program_id
4568: , i_prog_appl_id => FND_GLOBAL.prog_appl_id
4569: , i_txn_category => l_txn_category
4570: , i_transfer_price_pd => l_group2_interorg_tab(i).transfer_price
4571: , o_err_num => l_error_num
4572: , o_err_code => l_error_code
4739: IF (CSTPPINV.l_item_id_tbl.COUNT > 0) THEN
4740: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4741: ,i_cost_group_id => p_cost_group_id
4742: ,i_txn_category => l_txn_category
4743: ,i_user_id => FND_GLOBAL.user_id
4744: ,i_login_id => FND_GLOBAL.login_id
4745: ,i_request_id => FND_GLOBAL.conc_request_id
4746: ,i_prog_id => FND_GLOBAL.conc_program_id
4747: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4740: CSTPPWAC.insert_into_cppb(i_pac_period_id => p_period_id
4741: ,i_cost_group_id => p_cost_group_id
4742: ,i_txn_category => l_txn_category
4743: ,i_user_id => FND_GLOBAL.user_id
4744: ,i_login_id => FND_GLOBAL.login_id
4745: ,i_request_id => FND_GLOBAL.conc_request_id
4746: ,i_prog_id => FND_GLOBAL.conc_program_id
4747: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4748: ,o_err_num => l_error_num
4741: ,i_cost_group_id => p_cost_group_id
4742: ,i_txn_category => l_txn_category
4743: ,i_user_id => FND_GLOBAL.user_id
4744: ,i_login_id => FND_GLOBAL.login_id
4745: ,i_request_id => FND_GLOBAL.conc_request_id
4746: ,i_prog_id => FND_GLOBAL.conc_program_id
4747: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4748: ,o_err_num => l_error_num
4749: ,o_err_code => l_error_code
4742: ,i_txn_category => l_txn_category
4743: ,i_user_id => FND_GLOBAL.user_id
4744: ,i_login_id => FND_GLOBAL.login_id
4745: ,i_request_id => FND_GLOBAL.conc_request_id
4746: ,i_prog_id => FND_GLOBAL.conc_program_id
4747: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4748: ,o_err_num => l_error_num
4749: ,o_err_code => l_error_code
4750: ,o_err_msg => l_error_msg
4743: ,i_user_id => FND_GLOBAL.user_id
4744: ,i_login_id => FND_GLOBAL.login_id
4745: ,i_request_id => FND_GLOBAL.conc_request_id
4746: ,i_prog_id => FND_GLOBAL.conc_program_id
4747: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4748: ,o_err_num => l_error_num
4749: ,o_err_code => l_error_code
4750: ,o_err_msg => l_error_msg
4751: );
4766: CSTPPWAC.update_item_cppb(i_pac_period_id => p_period_id
4767: ,i_cost_group_id => p_cost_group_id
4768: ,i_txn_category => l_txn_category
4769: ,i_item_id => p_inventory_item_id
4770: ,i_user_id => FND_GLOBAL.user_id
4771: ,i_login_id => FND_GLOBAL.login_id
4772: ,i_request_id => FND_GLOBAL.conc_request_id
4773: ,i_prog_id => FND_GLOBAL.conc_program_id
4774: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4767: ,i_cost_group_id => p_cost_group_id
4768: ,i_txn_category => l_txn_category
4769: ,i_item_id => p_inventory_item_id
4770: ,i_user_id => FND_GLOBAL.user_id
4771: ,i_login_id => FND_GLOBAL.login_id
4772: ,i_request_id => FND_GLOBAL.conc_request_id
4773: ,i_prog_id => FND_GLOBAL.conc_program_id
4774: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4775: ,o_err_num => l_error_num
4768: ,i_txn_category => l_txn_category
4769: ,i_item_id => p_inventory_item_id
4770: ,i_user_id => FND_GLOBAL.user_id
4771: ,i_login_id => FND_GLOBAL.login_id
4772: ,i_request_id => FND_GLOBAL.conc_request_id
4773: ,i_prog_id => FND_GLOBAL.conc_program_id
4774: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4775: ,o_err_num => l_error_num
4776: ,o_err_code => l_error_code
4769: ,i_item_id => p_inventory_item_id
4770: ,i_user_id => FND_GLOBAL.user_id
4771: ,i_login_id => FND_GLOBAL.login_id
4772: ,i_request_id => FND_GLOBAL.conc_request_id
4773: ,i_prog_id => FND_GLOBAL.conc_program_id
4774: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4775: ,o_err_num => l_error_num
4776: ,o_err_code => l_error_code
4777: ,o_err_msg => l_error_msg
4770: ,i_user_id => FND_GLOBAL.user_id
4771: ,i_login_id => FND_GLOBAL.login_id
4772: ,i_request_id => FND_GLOBAL.conc_request_id
4773: ,i_prog_id => FND_GLOBAL.conc_program_id
4774: ,i_prog_appl_id => FND_GLOBAL.prog_appl_id
4775: ,o_err_num => l_error_num
4776: ,o_err_code => l_error_code
4777: ,o_err_msg => l_error_msg
4778: );
5941: i_cost_group_id => l_optimal_cg_idx.cost_group_id,
5942: i_cost_type_id => p_cost_type_id,
5943: i_low_level_code => t_low_level_code,
5944: i_item_id => l_inventory_item_id,
5945: i_user_id => FND_GLOBAL.user_id,
5946: i_login_id => FND_GLOBAL.login_id,
5947: i_request_id => FND_GLOBAL.conc_request_id,
5948: i_prog_id => FND_GLOBAL.conc_program_id,
5949: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
5942: i_cost_type_id => p_cost_type_id,
5943: i_low_level_code => t_low_level_code,
5944: i_item_id => l_inventory_item_id,
5945: i_user_id => FND_GLOBAL.user_id,
5946: i_login_id => FND_GLOBAL.login_id,
5947: i_request_id => FND_GLOBAL.conc_request_id,
5948: i_prog_id => FND_GLOBAL.conc_program_id,
5949: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
5950: o_err_num => l_error_num,
5943: i_low_level_code => t_low_level_code,
5944: i_item_id => l_inventory_item_id,
5945: i_user_id => FND_GLOBAL.user_id,
5946: i_login_id => FND_GLOBAL.login_id,
5947: i_request_id => FND_GLOBAL.conc_request_id,
5948: i_prog_id => FND_GLOBAL.conc_program_id,
5949: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
5950: o_err_num => l_error_num,
5951: o_err_code => l_error_code,
5944: i_item_id => l_inventory_item_id,
5945: i_user_id => FND_GLOBAL.user_id,
5946: i_login_id => FND_GLOBAL.login_id,
5947: i_request_id => FND_GLOBAL.conc_request_id,
5948: i_prog_id => FND_GLOBAL.conc_program_id,
5949: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
5950: o_err_num => l_error_num,
5951: o_err_code => l_error_code,
5952: o_err_msg => l_error_msg);
5945: i_user_id => FND_GLOBAL.user_id,
5946: i_login_id => FND_GLOBAL.login_id,
5947: i_request_id => FND_GLOBAL.conc_request_id,
5948: i_prog_id => FND_GLOBAL.conc_program_id,
5949: i_prog_appl_id => FND_GLOBAL.prog_appl_id,
5950: o_err_num => l_error_num,
5951: o_err_code => l_error_code,
5952: o_err_msg => l_error_msg);
5953: