DBA Data[Home] [Help]

APPS.CSTPLENG dependencies on CST_INV_LAYERS_S

Line 1315: -- create inventory layers using the sequence cst_inv_layers_s --

1311: -- * If layer created has positive quantity, then replenish all --
1312: -- negative inventory layers --
1313: -- --
1314: -- PURPOSE: --
1315: -- create inventory layers using the sequence cst_inv_layers_s --
1316: -- --
1317: -- PARAMETERS: --
1318: -- i_txn_qty : primary quantity --
1319: -- i_interorg_rec : interorg shimpment (= 0), --

Line 1931: SELECT cst_inv_layers_s.nextval

1927: WHERE inv_layer_id = l_inv_layer_id;
1928: ELSE
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

Line 5139: select cst_inv_layers_s.nextval

5135:
5136: if (l_inv_layer_id = 0) then
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 (