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 2486: from dual;

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

Line 2659: FROM dual;

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

Line 5141: from dual;

5137: /* No inv layers exist: Hence create one with 0 qty,cost */
5138:
5139: select cst_inv_layers_s.nextval
5140: into l_inv_layer_id
5141: from dual;
5142:
5143: insert into cst_inv_layers (
5144: create_transaction_id,
5145: layer_id,

Line 5183: from dual;

5179: i_req_id,
5180: i_prg_appl_id,
5181: i_prg_id,
5182: sysdate
5183: from dual;
5184:
5185: insert into cst_inv_layer_cost_details (
5186: layer_id,
5187: inv_layer_id,

Line 5215: from dual;

5211: i_req_id,
5212: i_prg_appl_id,
5213: i_prg_id,
5214: sysdate
5215: from dual;
5216:
5217:
5218: end if; /* if no layer exists */
5219:

Line 5976: from dual;

5972: 3, l_inv_res_acct,
5973: 4, l_inv_osp_acct,
5974: 5, l_inv_ovhd_acct)
5975: into l_acct
5976: from dual;
5977: end if;
5978:
5979: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, l_qty_adj * l_cost,
5980: sign(l_qty_adj * l_cost) * abs(l_qty_adj)/*modified for bug #4005770*/ /*l_qty_adj*/, l_acct, l_sob_id, 1,

Line 6017: from dual;

6013: 3, decode(l_res_acct,-1, l_mat_acct, l_res_acct),
6014: 4, decode(l_osp_acct,-1, l_mat_acct, l_osp_acct),
6015: 5, decode(l_ovhd_acct,-1, l_mat_acct, l_ovhd_acct))
6016: into l_acct
6017: from dual;
6018: end if;
6019:
6020: CSTPACDP.insert_account(i_org_id, i_txn_id, l_item_id, (l_qty_adj * l_cost) - l_var - l_onhand_var,
6021: l_qty_adj, l_acct, l_sob_id, 2,