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.

APPS.CN_FORMULA_GEN_PKG dependencies on CN_OBJ_PACKAGES_V

Line 1624: package_spec_id cn_obj_packages_v.package_id%TYPE;

1620: IS
1621: procedure_name cn_obj_procedures_v.name%TYPE;
1622: procedure_desc cn_obj_procedures_v.description%TYPE;
1623: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
1624: package_spec_id cn_obj_packages_v.package_id%TYPE;
1625: x_repository_id cn_repositories.repository_id%TYPE;
1626:
1627: l_input_sql_select varchar2(8000);
1628: l_input_sql_from varchar2(4000);

Line 1997: package_spec_id cn_obj_packages_v.package_id%TYPE;

1993: IS
1994: procedure_name cn_obj_procedures_v.name%TYPE;
1995: procedure_desc cn_obj_procedures_v.description%TYPE;
1996: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
1997: package_spec_id cn_obj_packages_v.package_id%TYPE;
1998: x_repository_id cn_repositories.repository_id%TYPE;
1999:
2000: l_output_sql_select varchar2(8000);
2001: l_output_sql_from varchar2(4000);

Line 2240: package_spec_id cn_obj_packages_v.package_id%TYPE;

2236: IS
2237: procedure_name cn_obj_procedures_v.name%TYPE;
2238: procedure_desc cn_obj_procedures_v.description%TYPE;
2239: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
2240: package_spec_id cn_obj_packages_v.package_id%TYPE;
2241: x_repository_id cn_repositories.repository_id%TYPE;
2242:
2243: l_perf_sql_select varchar2(8000);
2244: l_perf_sql_from varchar2(4000);

Line 2686: package_spec_id cn_obj_packages_v.package_id%TYPE;

2682: IS
2683: procedure_name cn_obj_procedures_v.name%TYPE;
2684: procedure_desc cn_obj_procedures_v.description%TYPE;
2685: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
2686: package_spec_id cn_obj_packages_v.package_id%TYPE;
2687: x_repository_id cn_repositories.repository_id%TYPE;
2688:
2689: l_rate_dim_sequence NUMBER;
2690: l_output_sql_select varchar2(8000);

Line 3527: package_spec_id cn_obj_packages_v.package_id%TYPE;

3523: IS
3524: procedure_name cn_obj_procedures_v.name%TYPE;
3525: procedure_desc cn_obj_procedures_v.description%TYPE;
3526: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
3527: package_spec_id cn_obj_packages_v.package_id%TYPE;
3528: x_repository_id cn_repositories.repository_id%TYPE;
3529:
3530: l_counter NUMBER(15);
3531: l_variable_declaration VARCHAR2(400);

Line 3692: package_spec_id cn_obj_packages_v.package_id%TYPE;

3688: IS
3689: procedure_name cn_obj_procedures_v.name%TYPE;
3690: procedure_desc cn_obj_procedures_v.description%TYPE;
3691: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
3692: package_spec_id cn_obj_packages_v.package_id%TYPE;
3693: x_repository_id cn_repositories.repository_id%TYPE;
3694:
3695: l_input_sql_select varchar2(8000);
3696: l_input_sql_from varchar2(4000);

Line 3837: package_spec_id cn_obj_packages_v.package_id%TYPE;

3833: IS
3834: procedure_name cn_obj_procedures_v.name%TYPE;
3835: procedure_desc cn_obj_procedures_v.description%TYPE;
3836: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
3837: package_spec_id cn_obj_packages_v.package_id%TYPE;
3838: x_repository_id cn_repositories.repository_id%TYPE;
3839:
3840: l_input_sql_select VARCHAR2(8000);
3841: l_input_sql_from varchar2(4000);

Line 4822: package_name cn_obj_packages_v.name%TYPE;

4818: END get_estimated_payout;
4819:
4820: -- invoke all formula component constructors to create formula
4821: FUNCTION create_formula (p_formula_id number) RETURN BOOLEAN IS
4822: package_name cn_obj_packages_v.name%TYPE;
4823: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4824: package_spec_id cn_obj_packages_v.package_id%TYPE;
4825: package_body_id cn_obj_packages_v.package_id%TYPE;
4826: package_spec_desc cn_obj_packages_v.description%TYPE;

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

4819:
4820: -- invoke all formula component constructors to create formula
4821: FUNCTION create_formula (p_formula_id number) RETURN BOOLEAN IS
4822: package_name cn_obj_packages_v.name%TYPE;
4823: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4824: package_spec_id cn_obj_packages_v.package_id%TYPE;
4825: package_body_id cn_obj_packages_v.package_id%TYPE;
4826: package_spec_desc cn_obj_packages_v.description%TYPE;
4827: package_body_desc cn_obj_packages_v.description%TYPE;

Line 4824: package_spec_id cn_obj_packages_v.package_id%TYPE;

4820: -- invoke all formula component constructors to create formula
4821: FUNCTION create_formula (p_formula_id number) RETURN BOOLEAN IS
4822: package_name cn_obj_packages_v.name%TYPE;
4823: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4824: package_spec_id cn_obj_packages_v.package_id%TYPE;
4825: package_body_id cn_obj_packages_v.package_id%TYPE;
4826: package_spec_desc cn_obj_packages_v.description%TYPE;
4827: package_body_desc cn_obj_packages_v.description%TYPE;
4828: spec_code cn_utils.code_type;

Line 4825: package_body_id cn_obj_packages_v.package_id%TYPE;

4821: FUNCTION create_formula (p_formula_id number) RETURN BOOLEAN IS
4822: package_name cn_obj_packages_v.name%TYPE;
4823: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4824: package_spec_id cn_obj_packages_v.package_id%TYPE;
4825: package_body_id cn_obj_packages_v.package_id%TYPE;
4826: package_spec_desc cn_obj_packages_v.description%TYPE;
4827: package_body_desc cn_obj_packages_v.description%TYPE;
4828: spec_code cn_utils.code_type;
4829: body_code cn_utils.code_type;

Line 4826: package_spec_desc cn_obj_packages_v.description%TYPE;

4822: package_name cn_obj_packages_v.name%TYPE;
4823: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4824: package_spec_id cn_obj_packages_v.package_id%TYPE;
4825: package_body_id cn_obj_packages_v.package_id%TYPE;
4826: package_spec_desc cn_obj_packages_v.description%TYPE;
4827: package_body_desc cn_obj_packages_v.description%TYPE;
4828: spec_code cn_utils.code_type;
4829: body_code cn_utils.code_type;
4830: dummy NUMBER(7);

Line 4827: package_body_desc cn_obj_packages_v.description%TYPE;

4823: package_type cn_obj_packages_v.package_type%TYPE := 'FML';
4824: package_spec_id cn_obj_packages_v.package_id%TYPE;
4825: package_body_id cn_obj_packages_v.package_id%TYPE;
4826: package_spec_desc cn_obj_packages_v.description%TYPE;
4827: package_body_desc cn_obj_packages_v.description%TYPE;
4828: spec_code cn_utils.code_type;
4829: body_code cn_utils.code_type;
4830: dummy NUMBER(7);
4831: l_module_id number(15);