[Home] [Help]
266: */
267:
268: l_stmt_num := 40;
269:
270: CSTPLENG.layer_cost_update(
271: i_org_id,
272: i_txn_id,
273: i_layer_id,
274: i_cost_type,
499: /* Changes for VMI. Adding planning transfer transaction */
500: if (i_txn_action_id NOT IN (2,5,3,12,21,28,55)) then
501: l_stmt_num := 80;
502:
503: l_new_cost := CSTPLENG.compute_layer_actual_cost(
504: i_org_id,
505: i_cost_method,
506: i_txn_id,
507: i_layer_id,
616: end if;
617:
618: if (i_org_id = i_txn_org_id or i_txn_action_id <> 3 or l_to_std_exp <> 1) then
619: l_stmt_num := 104;
620: CSTPLENG.calc_layer_average_cost (i_org_id,
621: i_txn_id,
622: l_layer_id,
623: i_cost_type,
624: i_item_id,
1241: Intransit shipment, FOB shipment from non-std to LIFO
1242: Intransit receipt, FOB receipt from non-std to LIFO
1243: */
1244: if ((l_to_method IN (5,6)) and (l_from_method <> 1 or i_txn_action_id = 3)) then
1245: CSTPLENG.create_layers(
1246: i_org_id,
1247: i_txn_id,
1248: l_to_layer,
1249: i_item_id,
1281: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer send org: (consume layers) ...');
1282: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
1283: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
1284: if (l_from_method IN (5,6)) then
1285: CSTPLENG.consume_layers(
1286: i_org_id,
1287: i_txn_id,
1288: l_from_layer,
1289: i_item_id,
1814: if(o_interorg_rec=1 and i_txn_action_id <> 3) then
1815: FND_FILE.PUT_LINE(FND_FILE.LOG,'Creating layers when sending org is std costing org');
1816:
1817: -- Fix for bug 1872444
1818: -- Populate l_to_layer before calling CSTPLENG.create_layers
1819: -- for direct interorg transactions
1820: -- Also, the second argument was changed from i_txn_id to
1821: -- l_txn_update_id
1822:
1830: fnd_file.put_line(fnd_file.log, 'Calling createlayers for the std org' || i_org_id || ': interorg rec : '|| o_interorg_rec || ':txn_update_id :'|| l_txn_update_id );
1831: end if;
1832:
1833:
1834: CSTPLENG.create_layers(
1835: i_org_id,
1836: l_txn_update_id,
1837: l_to_layer,
1838: i_item_id,
3304: INTO l_src_id
3305: FROM mtl_material_transactions
3306: WHERE transaction_id = i_txn_id;
3307: l_stmt_num :=88;
3308: l_src_number := CSTPLENG.GET_SOURCE_NUMBER(i_txn_id,i_txn_src_type,l_src_id);
3309: l_stmt_num :=89;
3310: INSERT
3311: INTO cst_inv_layers (
3312: layer_id,
3403: end if;
3404:
3405: l_stmt_num := 90;
3406:
3407: l_new_cost := CSTPLENG.compute_layer_actual_cost(
3408: i_org_id,
3409: i_cost_method,
3410: i_txn_id,
3411: l_from_layer, --i_layer_id,
3488: l_no_update_qty := 0;
3489: end if;
3490:
3491: l_stmt_num := 95;
3492: CSTPLENG.calc_layer_average_cost(
3493: i_org_id,
3494: i_txn_id,
3495: l_from_layer,
3496: i_cost_type,
3673: -- create inventory layer
3674:
3675: l_stmt_num := 120;
3676:
3677: CSTPLENG.create_layers(
3678: i_org_id,
3679: i_txn_id,
3680: l_to_layer,
3681: i_item_id,
3709: end if;
3710:
3711: l_stmt_num := 125;
3712:
3713: CSTPLENG.calc_layer_average_cost(
3714: i_org_id,
3715: i_txn_id,
3716: l_to_layer,
3717: i_cost_type,
3834: -- create inventory layer
3835:
3836: l_stmt_num := 140;
3837:
3838: CSTPLENG.create_layers(
3839: i_org_id,
3840: i_txn_id,
3841: l_to_layer,
3842: i_item_id,
3870: end if;
3871:
3872: l_stmt_num := 150;
3873:
3874: CSTPLENG.calc_layer_average_cost(
3875: i_org_id,
3876: i_txn_id,
3877: l_to_layer,
3878: i_cost_type,
4513: OR (i_txn_action_id = 21 and i_org_id = i_txn_org_id and i_fob_point = 1)) then
4514:
4515: if (l_from_method IN (5,6)) then
4516: l_stmt_num := 50;
4517: CSTPLENG.consume_layers(
4518: i_org_id,
4519: i_txn_id,
4520: l_from_layer,
4521: i_item_id,
4631: --
4632: -- Bug 5391121: we need to create layers
4633: -- if (l_to_method IN (5,6) or (i_txn_action_id = 3))
4634: -- then
4635: CSTPLENG.create_layers(
4636: i_org_id,
4637: i_txn_id,
4638: l_to_layer,
4639: i_item_id,