APPS.CSTPLENG dependencies on DUAL

Line 870: from dual;

866: i_req_id,
867: i_prg_appl_id,
868: i_prg_id,
869: sysdate
870: from dual;
871: -- case 6 REPLENISH CILCD CILCD
872: elsif(i_mode = 'REPLENISH' and i_actual_cost_table = 'CILCD' and i_layer_cost_table = 'CILCD') then
873:
874: insert into mtl_cst_layer_act_cost_details (

Line 1563: FROM dual;

1559: 0,
1560: 'Y',
1561: 0,
1562: 'N'
1563: FROM dual;
1564: END IF; /* l_count > 0 */
1565: END IF; /* l_count > 0 */
1566: RETURN;
1567: END IF; /* i_exp_flag = 1 */

Line 1933: FROM dual;

1929: /* Generate Inv Layer ID */
1930: l_stmt_num := 95;
1931: SELECT cst_inv_layers_s.nextval
1932: INTO l_inv_layer_id
1933: FROM dual;
1934:
1935: IF (l_debug = 'Y') THEN
1936: FND_FILE.PUT_LINE(FND_FILE.LOG,'Creating inventory layers ...');
1937: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inventory Layer Number : ' || to_char(l_inv_layer_id));

Line 2487: from dual;

2483: 0,
2484: 'Y',
2485: 0,
2486: 'N'
2487: from dual;
2488: end if;
2489: return;
2490: end if;
2491:

Line 2660: FROM dual;

2656: 0,
2657: 'Y',
2658: 0,
2659: 'N'
2660: FROM dual;
2661: end if; /* l_count > 0 */
2662: return;
2663: else
2664: get_layers_consumed(

Line 5245: from dual;

5241: /* No inv layers exist: Hence create one with 0 qty,cost */
5242:
5243: select cst_inv_layers_s.nextval
5244: into l_inv_layer_id
5245: from dual;
5246:
5247: insert into cst_inv_layers (
5248: create_transaction_id,
5249: layer_id,

Line 5287: from dual;

5283: i_req_id,
5284: i_prg_appl_id,
5285: i_prg_id,
5286: sysdate
5287: from dual;
5288:
5289: insert into cst_inv_layer_cost_details (
5290: layer_id,
5291: inv_layer_id,

Line 5319: from dual;

5315: i_req_id,
5316: i_prg_appl_id,
5317: i_prg_id,
5318: sysdate
5319: from dual;
5320:
5321:
5322: end if; /* if no layer exists */
5323:

Line 6080: from dual;

6076: 3, l_inv_res_acct,
6077: 4, l_inv_osp_acct,
6078: 5, l_inv_ovhd_acct)
6079: into l_acct
6080: from dual;
6081: end if;
6082:
6083: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, l_qty_adj * l_cost,
6084: sign(l_qty_adj * l_cost) * abs(l_qty_adj)/*modified for bug #4005770*/ /*l_qty_adj*/, l_acct, l_sob_id, 1,

Line 6122: from dual;

6118: 3, decode(l_res_acct,-1, l_mat_acct, l_res_acct),
6119: 4, decode(l_osp_acct,-1, l_mat_acct, l_osp_acct),
6120: 5, decode(l_ovhd_acct,-1, l_mat_acct, l_ovhd_acct))
6121: into l_acct
6122: from dual;
6123: end if;
6124:
6125: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, (l_qty_adj * l_cost) - l_var - l_onhand_var,
6126: l_qty_adj, l_acct, l_sob_id, 2,