eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.CN_FORMULA_GEN_PKG dependencies on CN_OBJ_PACKAGES_V

Line 1617: package_spec_id cn_obj_packages_v.package_id%TYPE;

1613: IS
1614: procedure_name cn_obj_procedures_v.name%TYPE;
1615: procedure_desc cn_obj_procedures_v.description%TYPE;
1616: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
1617: package_spec_id cn_obj_packages_v.package_id%TYPE;
1618: x_repository_id cn_repositories.repository_id%TYPE;
1619:
1620: l_input_sql_select varchar2(8000);
1621: l_input_sql_from varchar2(4000);

Line 1984: package_spec_id cn_obj_packages_v.package_id%TYPE;

1980: IS
1981: procedure_name cn_obj_procedures_v.name%TYPE;
1982: procedure_desc cn_obj_procedures_v.description%TYPE;
1983: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
1984: package_spec_id cn_obj_packages_v.package_id%TYPE;
1985: x_repository_id cn_repositories.repository_id%TYPE;
1986:
1987: l_output_sql_select varchar2(8000);
1988: l_output_sql_from varchar2(4000);

Line 2227: package_spec_id cn_obj_packages_v.package_id%TYPE;

2223: IS
2224: procedure_name cn_obj_procedures_v.name%TYPE;
2225: procedure_desc cn_obj_procedures_v.description%TYPE;
2226: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
2227: package_spec_id cn_obj_packages_v.package_id%TYPE;
2228: x_repository_id cn_repositories.repository_id%TYPE;
2229:
2230: l_perf_sql_select varchar2(8000);
2231: l_perf_sql_from varchar2(4000);

Line 2673: package_spec_id cn_obj_packages_v.package_id%TYPE;

2669: IS
2670: procedure_name cn_obj_procedures_v.name%TYPE;
2671: procedure_desc cn_obj_procedures_v.description%TYPE;
2672: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
2673: package_spec_id cn_obj_packages_v.package_id%TYPE;
2674: x_repository_id cn_repositories.repository_id%TYPE;
2675:
2676: l_rate_dim_sequence NUMBER;
2677: l_output_sql_select varchar2(8000);

Line 3514: package_spec_id cn_obj_packages_v.package_id%TYPE;

3510: IS
3511: procedure_name cn_obj_procedures_v.name%TYPE;
3512: procedure_desc cn_obj_procedures_v.description%TYPE;
3513: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
3514: package_spec_id cn_obj_packages_v.package_id%TYPE;
3515: x_repository_id cn_repositories.repository_id%TYPE;
3516:
3517: l_counter NUMBER(15);
3518: l_variable_declaration VARCHAR2(400);

Line 3679: package_spec_id cn_obj_packages_v.package_id%TYPE;

3675: IS
3676: procedure_name cn_obj_procedures_v.name%TYPE;
3677: procedure_desc cn_obj_procedures_v.description%TYPE;
3678: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
3679: package_spec_id cn_obj_packages_v.package_id%TYPE;
3680: x_repository_id cn_repositories.repository_id%TYPE;
3681:
3682: l_input_sql_select varchar2(8000);
3683: l_input_sql_from varchar2(4000);

Line 3824: package_spec_id cn_obj_packages_v.package_id%TYPE;

3820: IS
3821: procedure_name cn_obj_procedures_v.name%TYPE;
3822: procedure_desc cn_obj_procedures_v.description%TYPE;
3823: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
3824: package_spec_id cn_obj_packages_v.package_id%TYPE;
3825: x_repository_id cn_repositories.repository_id%TYPE;
3826:
3827: l_input_sql_select VARCHAR2(8000);
3828: l_input_sql_from varchar2(4000);

Line 4809: package_name cn_obj_packages_v.name%TYPE;

4805: END get_estimated_payout;
4806:
4807: -- invoke all formula component constructors to create formula
4808: FUNCTION create_formula (p_formula_id number) RETURN BOOLEAN IS
4809: package_name cn_obj_packages_v.name%TYPE;
4810: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4811: package_spec_id cn_obj_packages_v.package_id%TYPE;
4812: package_body_id cn_obj_packages_v.package_id%TYPE;
4813: package_spec_desc cn_obj_packages_v.description%TYPE;

Line 4810: package_type cn_obj_packages_v.package_type%TYPE := 'FML';

4806:
4807: -- invoke all formula component constructors to create formula
4808: FUNCTION create_formula (p_formula_id number) RETURN BOOLEAN IS
4809: package_name cn_obj_packages_v.name%TYPE;
4810: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4811: package_spec_id cn_obj_packages_v.package_id%TYPE;
4812: package_body_id cn_obj_packages_v.package_id%TYPE;
4813: package_spec_desc cn_obj_packages_v.description%TYPE;
4814: package_body_desc cn_obj_packages_v.description%TYPE;

Line 4811: package_spec_id cn_obj_packages_v.package_id%TYPE;

4807: -- invoke all formula component constructors to create formula
4808: FUNCTION create_formula (p_formula_id number) RETURN BOOLEAN IS
4809: package_name cn_obj_packages_v.name%TYPE;
4810: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4811: package_spec_id cn_obj_packages_v.package_id%TYPE;
4812: package_body_id cn_obj_packages_v.package_id%TYPE;
4813: package_spec_desc cn_obj_packages_v.description%TYPE;
4814: package_body_desc cn_obj_packages_v.description%TYPE;
4815: spec_code cn_utils.code_type;

Line 4812: package_body_id cn_obj_packages_v.package_id%TYPE;

4808: FUNCTION create_formula (p_formula_id number) RETURN BOOLEAN IS
4809: package_name cn_obj_packages_v.name%TYPE;
4810: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4811: package_spec_id cn_obj_packages_v.package_id%TYPE;
4812: package_body_id cn_obj_packages_v.package_id%TYPE;
4813: package_spec_desc cn_obj_packages_v.description%TYPE;
4814: package_body_desc cn_obj_packages_v.description%TYPE;
4815: spec_code cn_utils.code_type;
4816: body_code cn_utils.code_type;

Line 4813: package_spec_desc cn_obj_packages_v.description%TYPE;

4809: package_name cn_obj_packages_v.name%TYPE;
4810: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4811: package_spec_id cn_obj_packages_v.package_id%TYPE;
4812: package_body_id cn_obj_packages_v.package_id%TYPE;
4813: package_spec_desc cn_obj_packages_v.description%TYPE;
4814: package_body_desc cn_obj_packages_v.description%TYPE;
4815: spec_code cn_utils.code_type;
4816: body_code cn_utils.code_type;
4817: dummy NUMBER(7);

Line 4814: package_body_desc cn_obj_packages_v.description%TYPE;

4810: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4811: package_spec_id cn_obj_packages_v.package_id%TYPE;
4812: package_body_id cn_obj_packages_v.package_id%TYPE;
4813: package_spec_desc cn_obj_packages_v.description%TYPE;
4814: package_body_desc cn_obj_packages_v.description%TYPE;
4815: spec_code cn_utils.code_type;
4816: body_code cn_utils.code_type;
4817: dummy NUMBER(7);
4818: l_module_id number(15);