APPS.CN_RT_QUOTA_ASGN_PVT dependencies on CN_CALC_FORMULAS

Line 23: cn_calc_formulas fml

19: rs.NAME,
20: fml.NAME calc_formula_name
21: FROM cn_rt_formula_asgns rf,
22: cn_rate_schedules_all rs,
23: cn_calc_formulas fml
24: WHERE fml.calc_formula_id = p_calc_formula_id AND rf.rate_schedule_id = rs.rate_schedule_id AND fml.calc_formula_id = rf.calc_formula_id;
25:
26: l_rec rt_quota_asgn_rec_type;
27: rt_date rate_formula_date_curs%ROWTYPE;

Line 1020: FROM cn_calc_formulas

1016: FROM cn_formula_inputs
1017: WHERE calc_formula_id = l_parent_id
1018: UNION
1019: SELECT output_exp_id
1020: FROM cn_calc_formulas
1021: WHERE calc_formula_id = l_parent_id);
1022:
1023: TYPE stack_type IS TABLE OF cn_calc_formulas.calc_formula_id%TYPE;
1024:

Line 1023: TYPE stack_type IS TABLE OF cn_calc_formulas.calc_formula_id%TYPE;

1019: SELECT output_exp_id
1020: FROM cn_calc_formulas
1021: WHERE calc_formula_id = l_parent_id);
1022:
1023: TYPE stack_type IS TABLE OF cn_calc_formulas.calc_formula_id%TYPE;
1024:
1025: l_stack stack_type := stack_type() ;
1026: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
1027: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

Line 1026: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

1022:
1023: TYPE stack_type IS TABLE OF cn_calc_formulas.calc_formula_id%TYPE;
1024:
1025: l_stack stack_type := stack_type() ;
1026: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
1027: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
1028:
1029: CURSOR rt_quota_asgn_curs (
1030: l_calc_formula_id NUMBER,

Line 1027: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;

1023: TYPE stack_type IS TABLE OF cn_calc_formulas.calc_formula_id%TYPE;
1024:
1025: l_stack stack_type := stack_type() ;
1026: l_parent_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
1027: l_child_calc_formula_id cn_calc_formulas.calc_formula_id%TYPE;
1028:
1029: CURSOR rt_quota_asgn_curs (
1030: l_calc_formula_id NUMBER,
1031: l_quota_id NUMBER

Line 1072: FROM cn_calc_formulas

1068: SELECT NAME,
1069: calc_formula_id
1070: INTO l_calc_rec.NAME,
1071: l_calc_rec.calc_formula_id
1072: FROM cn_calc_formulas
1073: WHERE calc_formula_id = l_parent_calc_formula_id;
1074:
1075: l_calc_formulas (l_calc_rec.calc_formula_id) := l_calc_rec;
1076:

Line 1185: l_formula_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;

1181: l_counter NUMBER;
1182: l_name VARCHAR2 (1000);
1183: l_loading_status VARCHAR2 (240);
1184: l_formula_type CN_QUOTAS.QUOTA_TYPE_CODE%TYPE ;
1185: l_formula_dim CN_CALC_FORMULAS.NUMBER_DIM%TYPE;
1186: l_rate_dim CN_RATE_SCHEDULES.NUMBER_DIM%TYPE;
1187: BEGIN
1188: -- Standard Start of API savepoint
1189: SAVEPOINT check_rt_quota_asgn;

Line 1287: FROM cn_calc_formulas fml

1283: ELSE
1284: BEGIN
1285: SELECT NAME
1286: INTO l_name
1287: FROM cn_calc_formulas fml
1288: WHERE fml.calc_formula_id = p_rt_quota_asgn.calc_formula_id;
1289: EXCEPTION
1290: WHEN NO_DATA_FOUND
1291: THEN

Line 1365: SELECT NUMBER_DIM INTO l_formula_dim FROM CN_CALC_FORMULAS

1361: END IF;
1362:
1363: -- CHECK THAT NUMBER OF FORMULA DIMS = NUMBER OF RATE DIMS
1364: IF l_formula_type = 'FORMULA' THEN
1365: SELECT NUMBER_DIM INTO l_formula_dim FROM CN_CALC_FORMULAS
1366: WHERE calc_formula_id = p_rt_quota_asgn.calc_formula_id;
1367: SELECT NUMBER_DIM INTO l_rate_dim FROM CN_RATE_SCHEDULES
1368: WHERE rate_schedule_id = p_rt_quota_asgn.rate_schedule_id;
1369: IF l_formula_dim <> l_rate_dim THEN