[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,
2389: from cst_layer_cost_details
2390: where layer_id = i_layer_id;
2391:
2392: if (l_count > 0) then
2393: insert into mtl_cst_actual_cost_details (
2394: transaction_id,
2395: organization_id,
2396: layer_id,
2397: cost_element_id,
2437: 'N'
2438: from cst_layer_cost_details clcd
2439: where layer_id = i_layer_id;
2440: else
2441: insert into mtl_cst_actual_cost_details (
2442: transaction_id,
2443: organization_id,
2444: layer_id,
2445: cost_element_id,
2558:
2559: IF (l_count > 0) THEN
2560: l_stmt_num := 22;
2561: INSERT
2562: INTO mtl_cst_actual_cost_details (
2563: transaction_id,
2564: organization_id,
2565: layer_id,
2566: cost_element_id,
2610:
2611: else
2612: l_stmt_num := 23;
2613: INSERT
2614: INTO mtl_cst_actual_cost_details (
2615: transaction_id,
2616: organization_id,
2617: layer_id,
2618: cost_element_id,
4229:
4230: if (i_txn_action_id <> 30) then
4231:
4232: l_stmt_num := 10;
4233: update mtl_cst_actual_cost_details mcacd
4234: set (prior_cost,
4235: new_cost,
4236: variance_amount,
4237: payback_variance_amount,
4254: and mcacd.layer_id = i_layer_id
4255: and mcacd.transaction_action_id = i_txn_action_id;
4256:
4257: l_stmt_num := 12;
4258: insert into mtl_cst_actual_cost_details (
4259: transaction_id,
4260: organization_id,
4261: layer_id,
4262: cost_element_id,
4313: and mclacd.organization_id = i_org_id
4314: and mclacd.layer_id = i_layer_id
4315: and not exists
4316: (select 'MCACD does not exist'
4317: from mtl_cst_actual_cost_details mcacd
4318: where mcacd.transaction_id = i_txn_id
4319: and mcacd.organization_id = i_org_id
4320: and mcacd.layer_id = i_layer_id
4321: and mcacd.cost_element_id = mclacd.cost_element_id
4328: -- is updated.
4329:
4330: l_stmt_num := 15;
4331:
4332: update mtl_cst_actual_cost_details mcacd
4333: set prior_cost =
4334: (select clcd.item_cost
4335: from cst_layer_cost_details clcd
4336: where clcd.layer_id = i_layer_id
4349:
4350: -- Insert missing cost elements into mcacd (bug 2987309)
4351: l_stmt_num := 17;
4352: INSERT
4353: INTO mtl_cst_actual_cost_details (
4354: transaction_id,
4355: organization_id,
4356: layer_id,
4357: cost_element_id,
4399: FROM cst_layer_cost_details CLCD
4400: WHERE layer_id = i_layer_id
4401: AND NOT EXISTS(
4402: SELECT 'this detail is not in MCACD already'
4403: FROM mtl_cst_actual_cost_details MCACD
4404: WHERE MCACD.transaction_id = i_txn_id
4405: AND MCACD.organization_id = i_org_id
4406: AND MCACD.layer_id = i_layer_id
4407: AND MCACD.cost_element_id = CLCD.cost_element_id
4477: ** Update MCACD with new cost **
4478: ********************************************************************/
4479: l_stmt_num := 35;
4480:
4481: update mtl_cst_actual_cost_details mcacd
4482: set new_cost =
4483: (select clcd.item_cost
4484: from cst_layer_cost_details clcd
4485: where clcd.layer_id = i_layer_id
4893: end if; */ --removed for bug #4005770
4894:
4895: /************************************************************************
4896: ** Delete from cst_inv_layer_cost_details and insert the new rows **
4897: ** from mtl_cst_actual_cost_details. **
4898: ***********************************************************************/
4899: l_stmt_num := 30;
4900:
4901: Delete from cst_inv_layer_cost_details
5911: l_stmt_num := 20;
5912:
5913: select count(*)
5914: into l_ele_exist
5915: from mtl_cst_actual_cost_details
5916: where transaction_id = i_txn_id
5917: and organization_id = i_org_id;
5918:
5919: if (l_ele_exist = 0) then
6071: l_stmt_num := 60;
6072:
6073: select nvl(sum(variance_amount),0)
6074: into l_var
6075: from mtl_cst_actual_cost_details cacd
6076: where transaction_id = i_txn_id
6077: and organization_id = i_org_id;
6078:
6079: if (l_var <> 0) then
6107: end if;
6108:
6109: end if;
6110:
6111: UPDATE mtl_cst_actual_cost_details
6112: SET transaction_costed_date = sysdate
6113: WHERE transaction_id = i_txn_id
6114: AND transaction_costed_date IS NULL;
6115: