[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,
565: /* Changes for VMI. Adding planning transfer transaction */
566: if (i_txn_action_id NOT IN (2,5,3,12,21,28,55)) then
567: l_stmt_num := 80;
568:
569: l_new_cost := CSTPLENG.compute_layer_actual_cost(
570: i_org_id,
571: i_cost_method,
572: i_txn_id,
573: i_layer_id,
682: end if;
683:
684: if (i_org_id = i_txn_org_id or i_txn_action_id <> 3 or l_to_std_exp <> 1) then
685: l_stmt_num := 104;
686: CSTPLENG.calc_layer_average_cost (i_org_id,
687: i_txn_id,
688: l_layer_id,
689: i_cost_type,
690: i_item_id,
1307: Intransit shipment, FOB shipment from non-std to LIFO
1308: Intransit receipt, FOB receipt from non-std to LIFO
1309: */
1310: if ((l_to_method IN (5,6)) and (l_from_method <> 1 or i_txn_action_id = 3)) then
1311: CSTPLENG.create_layers(
1312: i_org_id,
1313: i_txn_id,
1314: l_to_layer,
1315: i_item_id,
1347: FND_FILE.PUT_LINE(FND_FILE.LOG,'Interorg transfer send org: (consume layers) ...');
1348: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_org_id) || ':' || to_char(l_from_method));
1349: FND_FILE.PUT_LINE(FND_FILE.LOG,to_char(i_txn_id) || ':' || to_char(l_from_layer));
1350: if (l_from_method IN (5,6)) then
1351: CSTPLENG.consume_layers(
1352: i_org_id,
1353: i_txn_id,
1354: l_from_layer,
1355: i_item_id,
1880: if(o_interorg_rec=1 and i_txn_action_id <> 3) then
1881: FND_FILE.PUT_LINE(FND_FILE.LOG,'Creating layers when sending org is std costing org');
1882:
1883: -- Fix for bug 1872444
1884: -- Populate l_to_layer before calling CSTPLENG.create_layers
1885: -- for direct interorg transactions
1886: -- Also, the second argument was changed from i_txn_id to
1887: -- l_txn_update_id
1888:
1896: 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 );
1897: end if;
1898:
1899:
1900: CSTPLENG.create_layers(
1901: i_org_id,
1902: l_txn_update_id,
1903: l_to_layer,
1904: i_item_id,
3371: INTO l_src_id
3372: FROM mtl_material_transactions
3373: WHERE transaction_id = i_txn_id;
3374: l_stmt_num :=88;
3375: l_src_number := CSTPLENG.GET_SOURCE_NUMBER(i_txn_id,i_txn_src_type,l_src_id);
3376: l_stmt_num :=89;
3377: INSERT
3378: INTO cst_inv_layers (
3379: layer_id,
3470: end if;
3471: end if; --l_exp_item
3472: l_stmt_num := 90;
3473:
3474: l_new_cost := CSTPLENG.compute_layer_actual_cost(
3475: i_org_id,
3476: i_cost_method,
3477: i_txn_id,
3478: l_from_layer, --i_layer_id,
3555: l_no_update_qty := 0;
3556: end if;
3557:
3558: l_stmt_num := 95;
3559: CSTPLENG.calc_layer_average_cost(
3560: i_org_id,
3561: i_txn_id,
3562: l_from_layer,
3563: i_cost_type,
3740: -- create inventory layer
3741:
3742: l_stmt_num := 120;
3743:
3744: CSTPLENG.create_layers(
3745: i_org_id,
3746: i_txn_id,
3747: l_to_layer,
3748: i_item_id,
3776: end if;
3777:
3778: l_stmt_num := 125;
3779:
3780: CSTPLENG.calc_layer_average_cost(
3781: i_org_id,
3782: i_txn_id,
3783: l_to_layer,
3784: i_cost_type,
3901: -- create inventory layer
3902:
3903: l_stmt_num := 140;
3904:
3905: CSTPLENG.create_layers(
3906: i_org_id,
3907: i_txn_id,
3908: l_to_layer,
3909: i_item_id,
3937: end if;
3938:
3939: l_stmt_num := 150;
3940:
3941: CSTPLENG.calc_layer_average_cost(
3942: i_org_id,
3943: i_txn_id,
3944: l_to_layer,
3945: i_cost_type,
4580: OR (i_txn_action_id = 21 and i_org_id = i_txn_org_id and i_fob_point = 1)) then
4581:
4582: if (l_from_method IN (5,6)) then
4583: l_stmt_num := 50;
4584: CSTPLENG.consume_layers(
4585: i_org_id,
4586: i_txn_id,
4587: l_from_layer,
4588: i_item_id,
4698: --
4699: -- Bug 5391121: we need to create layers
4700: -- if (l_to_method IN (5,6) or (i_txn_action_id = 3))
4701: -- then
4702: CSTPLENG.create_layers(
4703: i_org_id,
4704: i_txn_id,
4705: l_to_layer,
4706: i_item_id,