[Home] [Help]
90: l_stmt_num := 20;
91: if (i_cost_hook = 1) then
92: select count(*)
93: into l_txn_cost_exists
94: from mtl_cst_actual_cost_details
95: where transaction_id = i_txn_id
96: and organization_id = i_org_id
97: and actual_cost >= 0;
98:
348: else
349: if (l_debug = 'Y') then
350: FND_FILE.PUT_LINE(FND_FILE.LOG,'Scrap transaction inserts into MCACD');
351: end if;
352: insert into mtl_cst_actual_cost_details (
353: transaction_id,
354: organization_id,
355: layer_id,
356: cost_element_id,
742: i_req_id,
743: i_prg_appl_id,
744: i_prg_id,
745: sysdate
746: from mtl_cst_actual_cost_details mcacd
747: where mcacd.organization_id = i_org_id
748: and mcacd.transaction_id = i_txn_id
749: and mcacd.user_entered = 'Y';
750:
999: i_req_id,
1000: i_prg_appl_id,
1001: i_prg_id,
1002: sysdate
1003: FROM cst_inv_layer_cost_details cilcd,mtl_cst_actual_cost_details mcacd
1004: where mcacd.organization_id (+) = i_org_id
1005: and mcacd.transaction_id(+) = i_txn_id
1006: and cilcd.inv_layer_id = i_cur_layer_id
1007: and cilcd.cost_element_id = mcacd.cost_element_id (+)
1029: i_req_id,
1030: i_prg_appl_id,
1031: i_prg_id,
1032: sysdate
1033: FROM cst_inv_layer_cost_details cilcd,mtl_cst_actual_cost_details mcacd
1034: where mcacd.organization_id = i_org_id
1035: and mcacd.transaction_id = i_txn_id
1036: and cilcd.inv_layer_id(+) = i_cur_layer_id
1037: and cilcd.cost_element_id(+) = mcacd.cost_element_id
1405:
1406: IF (l_count > 0) THEN
1407: l_stmt_num := 10;
1408: INSERT
1409: INTO mtl_cst_actual_cost_details (
1410: transaction_id,
1411: organization_id,
1412: layer_id,
1413: cost_element_id,
1464:
1465: IF (l_count > 0) THEN
1466: l_stmt_num := 20;
1467: INSERT
1468: INTO mtl_cst_actual_cost_details (
1469: transaction_id,
1470: organization_id,
1471: layer_id,
1472: cost_element_id,
1514: WHERE layer_id = i_layer_id;
1515: ELSE
1516: l_stmt_num := 25;
1517: INSERT
1518: INTO mtl_cst_actual_cost_details (
1519: transaction_id,
1520: organization_id,
1521: layer_id,
1522: cost_element_id,
2390: from cst_layer_cost_details
2391: where layer_id = i_layer_id;
2392:
2393: if (l_count > 0) then
2394: insert into mtl_cst_actual_cost_details (
2395: transaction_id,
2396: organization_id,
2397: layer_id,
2398: cost_element_id,
2438: 'N'
2439: from cst_layer_cost_details clcd
2440: where layer_id = i_layer_id;
2441: else
2442: insert into mtl_cst_actual_cost_details (
2443: transaction_id,
2444: organization_id,
2445: layer_id,
2446: cost_element_id,
2559:
2560: IF (l_count > 0) THEN
2561: l_stmt_num := 22;
2562: INSERT
2563: INTO mtl_cst_actual_cost_details (
2564: transaction_id,
2565: organization_id,
2566: layer_id,
2567: cost_element_id,
2611:
2612: else
2613: l_stmt_num := 23;
2614: INSERT
2615: INTO mtl_cst_actual_cost_details (
2616: transaction_id,
2617: organization_id,
2618: layer_id,
2619: cost_element_id,
4251:
4252: if (i_txn_action_id <> 30) then
4253:
4254: l_stmt_num := 10;
4255: update mtl_cst_actual_cost_details mcacd
4256: set (prior_cost,
4257: new_cost,
4258: variance_amount,
4259: payback_variance_amount,
4276: and mcacd.layer_id = i_layer_id
4277: and mcacd.transaction_action_id = i_txn_action_id;
4278:
4279: l_stmt_num := 12;
4280: insert into mtl_cst_actual_cost_details (
4281: transaction_id,
4282: organization_id,
4283: layer_id,
4284: cost_element_id,
4335: and mclacd.organization_id = i_org_id
4336: and mclacd.layer_id = i_layer_id
4337: and not exists
4338: (select 'MCACD does not exist'
4339: from mtl_cst_actual_cost_details mcacd
4340: where mcacd.transaction_id = i_txn_id
4341: and mcacd.organization_id = i_org_id
4342: and mcacd.layer_id = i_layer_id
4343: and mcacd.cost_element_id = mclacd.cost_element_id
4350: -- is updated.
4351:
4352: l_stmt_num := 15;
4353:
4354: update mtl_cst_actual_cost_details mcacd
4355: set prior_cost =
4356: (select clcd.item_cost
4357: from cst_layer_cost_details clcd
4358: where clcd.layer_id = i_layer_id
4371:
4372: -- Insert missing cost elements into mcacd (bug 2987309)
4373: l_stmt_num := 17;
4374: INSERT
4375: INTO mtl_cst_actual_cost_details (
4376: transaction_id,
4377: organization_id,
4378: layer_id,
4379: cost_element_id,
4421: FROM cst_layer_cost_details CLCD
4422: WHERE layer_id = i_layer_id
4423: AND NOT EXISTS(
4424: SELECT 'this detail is not in MCACD already'
4425: FROM mtl_cst_actual_cost_details MCACD
4426: WHERE MCACD.transaction_id = i_txn_id
4427: AND MCACD.organization_id = i_org_id
4428: AND MCACD.layer_id = i_layer_id
4429: AND MCACD.cost_element_id = CLCD.cost_element_id
4581: ** Update MCACD with new cost **
4582: ********************************************************************/
4583: l_stmt_num := 35;
4584:
4585: update mtl_cst_actual_cost_details mcacd
4586: set new_cost =
4587: (select clcd.item_cost
4588: from cst_layer_cost_details clcd
4589: where clcd.layer_id = i_layer_id
4997: end if; */ --removed for bug #4005770
4998:
4999: /************************************************************************
5000: ** Delete from cst_inv_layer_cost_details and insert the new rows **
5001: ** from mtl_cst_actual_cost_details. **
5002: ***********************************************************************/
5003: l_stmt_num := 30;
5004:
5005: Delete from cst_inv_layer_cost_details
6015: l_stmt_num := 20;
6016:
6017: select count(*)
6018: into l_ele_exist
6019: from mtl_cst_actual_cost_details
6020: where transaction_id = i_txn_id
6021: and organization_id = i_org_id;
6022:
6023: if (l_ele_exist = 0) then
6176: l_stmt_num := 60;
6177:
6178: select nvl(sum(variance_amount),0)
6179: into l_var
6180: from mtl_cst_actual_cost_details cacd
6181: where transaction_id = i_txn_id
6182: and organization_id = i_org_id;
6183:
6184: if (l_var <> 0) then
6212: end if;
6213:
6214: end if;
6215:
6216: UPDATE mtl_cst_actual_cost_details
6217: SET transaction_costed_date = sysdate
6218: WHERE transaction_id = i_txn_id
6219: AND transaction_costed_date IS NULL;
6220: