DBA Data[Home] [Help]

APPS.OKL_EXECUTE_FORMULA_PVT dependencies on OKL_FNCTN_PRMTRS_V

Line 155: TYPE fnctn_prmtrs_val_rec_type IS RECORD(pmr_id okl_fnctn_prmtrs_v.pmr_id%TYPE

151:
152:
153: ) IS
154: -- Type Declarations
155: TYPE fnctn_prmtrs_val_rec_type IS RECORD(pmr_id okl_fnctn_prmtrs_v.pmr_id%TYPE
156: ,value okl_fnctn_prmtrs_v.value%TYPE
157: ,fpr_type okl_fnctn_prmtrs_v.fpr_type%TYPE
158: );
159: TYPE fnctn_prmtrs_val_tbl_type IS TABLE OF fnctn_prmtrs_val_rec_type

Line 156: ,value okl_fnctn_prmtrs_v.value%TYPE

152:
153: ) IS
154: -- Type Declarations
155: TYPE fnctn_prmtrs_val_rec_type IS RECORD(pmr_id okl_fnctn_prmtrs_v.pmr_id%TYPE
156: ,value okl_fnctn_prmtrs_v.value%TYPE
157: ,fpr_type okl_fnctn_prmtrs_v.fpr_type%TYPE
158: );
159: TYPE fnctn_prmtrs_val_tbl_type IS TABLE OF fnctn_prmtrs_val_rec_type
160: INDEX BY BINARY_INTEGER;

Line 157: ,fpr_type okl_fnctn_prmtrs_v.fpr_type%TYPE

153: ) IS
154: -- Type Declarations
155: TYPE fnctn_prmtrs_val_rec_type IS RECORD(pmr_id okl_fnctn_prmtrs_v.pmr_id%TYPE
156: ,value okl_fnctn_prmtrs_v.value%TYPE
157: ,fpr_type okl_fnctn_prmtrs_v.fpr_type%TYPE
158: );
159: TYPE fnctn_prmtrs_val_tbl_type IS TABLE OF fnctn_prmtrs_val_rec_type
160: INDEX BY BINARY_INTEGER;
161:

Line 209: CURSOR fnctn_prmtrs_csr(cp_dsf_id IN okl_fnctn_prmtrs_v.dsf_id%TYPE) IS

205: ,source
206: FROM okl_data_src_fnctns_v
207: WHERE id = cp_dsf_id;
208:
209: CURSOR fnctn_prmtrs_csr(cp_dsf_id IN okl_fnctn_prmtrs_v.dsf_id%TYPE) IS
210: SELECT dsf_id
211: ,pmr_id
212: ,sequence_number
213: ,value

Line 215: FROM okl_fnctn_prmtrs_v

211: ,pmr_id
212: ,sequence_number
213: ,value
214: ,fpr_type
215: FROM okl_fnctn_prmtrs_v
216: WHERE dsf_id = cp_dsf_id
217: ORDER BY sequence_number;
218:
219: BEGIN