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_PROCEDURES_V

Line 605: procedure_name cn_obj_procedures_v.name%TYPE,

601: END split_long_sql;
602:
603: -- initialize the procedure boilerplate
604: PROCEDURE proc_init_boilerplate (code IN OUT NOCOPY cn_utils.code_type,
605: procedure_name cn_obj_procedures_v.name%TYPE,
606: description cn_obj_procedures_v.description%TYPE)
607: IS
608: X_userid VARCHAR2(20);
609: BEGIN

Line 606: description cn_obj_procedures_v.description%TYPE)

602:
603: -- initialize the procedure boilerplate
604: PROCEDURE proc_init_boilerplate (code IN OUT NOCOPY cn_utils.code_type,
605: procedure_name cn_obj_procedures_v.name%TYPE,
606: description cn_obj_procedures_v.description%TYPE)
607: IS
608: X_userid VARCHAR2(20);
609: BEGIN
610: SELECT user INTO X_userid FROM sys.dual;

Line 623: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,

619: cn_utils.appendcr(code, '--');
620: END proc_init_boilerplate;
621:
622: -- initialize the procedure
623: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
624: description cn_obj_procedures_v.description%TYPE,
625: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
626: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
627: return_type cn_obj_procedures_v.return_type%TYPE,

Line 624: description cn_obj_procedures_v.description%TYPE,

620: END proc_init_boilerplate;
621:
622: -- initialize the procedure
623: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
624: description cn_obj_procedures_v.description%TYPE,
625: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
626: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
627: return_type cn_obj_procedures_v.return_type%TYPE,
628: package_id cn_obj_procedures_v.package_id%TYPE,

Line 625: parameter_list cn_obj_procedures_v.parameter_list%TYPE,

621:
622: -- initialize the procedure
623: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
624: description cn_obj_procedures_v.description%TYPE,
625: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
626: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
627: return_type cn_obj_procedures_v.return_type%TYPE,
628: package_id cn_obj_procedures_v.package_id%TYPE,
629: repository_id cn_obj_procedures_v.repository_id%TYPE,

Line 626: procedure_type cn_obj_procedures_v.procedure_type%TYPE,

622: -- initialize the procedure
623: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
624: description cn_obj_procedures_v.description%TYPE,
625: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
626: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
627: return_type cn_obj_procedures_v.return_type%TYPE,
628: package_id cn_obj_procedures_v.package_id%TYPE,
629: repository_id cn_obj_procedures_v.repository_id%TYPE,
630: spec_code IN OUT NOCOPY cn_utils.code_type,

Line 627: return_type cn_obj_procedures_v.return_type%TYPE,

623: PROCEDURE proc_init(procedure_name cn_obj_procedures_v.name%TYPE,
624: description cn_obj_procedures_v.description%TYPE,
625: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
626: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
627: return_type cn_obj_procedures_v.return_type%TYPE,
628: package_id cn_obj_procedures_v.package_id%TYPE,
629: repository_id cn_obj_procedures_v.repository_id%TYPE,
630: spec_code IN OUT NOCOPY cn_utils.code_type,
631: body_code IN OUT NOCOPY cn_utils.code_type) IS

Line 628: package_id cn_obj_procedures_v.package_id%TYPE,

624: description cn_obj_procedures_v.description%TYPE,
625: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
626: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
627: return_type cn_obj_procedures_v.return_type%TYPE,
628: package_id cn_obj_procedures_v.package_id%TYPE,
629: repository_id cn_obj_procedures_v.repository_id%TYPE,
630: spec_code IN OUT NOCOPY cn_utils.code_type,
631: body_code IN OUT NOCOPY cn_utils.code_type) IS
632: BEGIN

Line 629: repository_id cn_obj_procedures_v.repository_id%TYPE,

625: parameter_list cn_obj_procedures_v.parameter_list%TYPE,
626: procedure_type cn_obj_procedures_v.procedure_type%TYPE,
627: return_type cn_obj_procedures_v.return_type%TYPE,
628: package_id cn_obj_procedures_v.package_id%TYPE,
629: repository_id cn_obj_procedures_v.repository_id%TYPE,
630: spec_code IN OUT NOCOPY cn_utils.code_type,
631: body_code IN OUT NOCOPY cn_utils.code_type) IS
632: BEGIN
633: -- Generate boilerplate comments

Line 1621: procedure_name cn_obj_procedures_v.name%TYPE;

1617: -- construct the get_input procedure for the formula package.
1618: PROCEDURE get_input ( spec_code IN OUT NOCOPY cn_utils.code_type,
1619: body_code IN OUT NOCOPY cn_utils.code_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;

Line 1622: procedure_desc cn_obj_procedures_v.description%TYPE;

1618: PROCEDURE get_input ( spec_code IN OUT NOCOPY cn_utils.code_type,
1619: body_code IN OUT NOCOPY cn_utils.code_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:

Line 1623: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

1619: body_code IN OUT NOCOPY cn_utils.code_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);

Line 1994: procedure_name cn_obj_procedures_v.name%TYPE;

1990: -- construct the get_commission procedure for the formula package.
1991: PROCEDURE get_commission (spec_code IN OUT NOCOPY cn_utils.code_type,
1992: body_code IN OUT NOCOPY cn_utils.code_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;

Line 1995: procedure_desc cn_obj_procedures_v.description%TYPE;

1991: PROCEDURE get_commission (spec_code IN OUT NOCOPY cn_utils.code_type,
1992: body_code IN OUT NOCOPY cn_utils.code_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:

Line 1996: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

1992: body_code IN OUT NOCOPY cn_utils.code_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);

Line 2237: procedure_name cn_obj_procedures_v.name%TYPE;

2233: --construct the get_perf procedure for the formula package.
2234: PROCEDURE get_perf (spec_code IN OUT NOCOPY cn_utils.code_type,
2235: body_code IN OUT NOCOPY cn_utils.code_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;

Line 2238: procedure_desc cn_obj_procedures_v.description%TYPE;

2234: PROCEDURE get_perf (spec_code IN OUT NOCOPY cn_utils.code_type,
2235: body_code IN OUT NOCOPY cn_utils.code_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:

Line 2239: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

2235: body_code IN OUT NOCOPY cn_utils.code_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);

Line 2683: procedure_name cn_obj_procedures_v.name%TYPE;

2679: -- construct the calculate_quota procdure which will be invoked from the dispatcher in calc engine
2680: PROCEDURE calculate_quota (spec_code IN OUT NOCOPY cn_utils.code_type,
2681: body_code IN OUT NOCOPY cn_utils.code_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;

Line 2684: procedure_desc cn_obj_procedures_v.description%TYPE;

2680: PROCEDURE calculate_quota (spec_code IN OUT NOCOPY cn_utils.code_type,
2681: body_code IN OUT NOCOPY cn_utils.code_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:

Line 2685: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

2681: body_code IN OUT NOCOPY cn_utils.code_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;

Line 3524: procedure_name cn_obj_procedures_v.name%TYPE;

3520: -- construct the get_result procedure which will be invoked if this formula is used as an embeded formula
3521: PROCEDURE get_result (spec_code IN OUT NOCOPY cn_utils.code_type,
3522: body_code IN OUT NOCOPY cn_utils.code_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;

Line 3525: procedure_desc cn_obj_procedures_v.description%TYPE;

3521: PROCEDURE get_result (spec_code IN OUT NOCOPY cn_utils.code_type,
3522: body_code IN OUT NOCOPY cn_utils.code_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:

Line 3526: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

3522: body_code IN OUT NOCOPY cn_utils.code_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);

Line 3689: procedure_name cn_obj_procedures_v.name%TYPE;

3685: -- construct the update_revclass_perf procedure for the formula package.
3686: PROCEDURE update_revclass_perf (spec_code IN OUT NOCOPY cn_utils.code_type,
3687: body_code IN OUT NOCOPY cn_utils.code_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;

Line 3690: procedure_desc cn_obj_procedures_v.description%TYPE;

3686: PROCEDURE update_revclass_perf (spec_code IN OUT NOCOPY cn_utils.code_type,
3687: body_code IN OUT NOCOPY cn_utils.code_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:

Line 3691: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

3687: body_code IN OUT NOCOPY cn_utils.code_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);

Line 3834: procedure_name cn_obj_procedures_v.name%TYPE;

3830: -- construct the calculate_quota procdure which will be invoked from the dispatcher in calc engine
3831: PROCEDURE calculate_bonus_quota (spec_code IN OUT NOCOPY cn_utils.code_type,
3832: body_code IN OUT NOCOPY cn_utils.code_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;

Line 3835: procedure_desc cn_obj_procedures_v.description%TYPE;

3831: PROCEDURE calculate_bonus_quota (spec_code IN OUT NOCOPY cn_utils.code_type,
3832: body_code IN OUT NOCOPY cn_utils.code_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:

Line 3836: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

3832: body_code IN OUT NOCOPY cn_utils.code_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);

Line 4297: procedure_name cn_obj_procedures_v.name%TYPE;

4293: -- construct the get_forecast_commission procdure which will be invoked by Income Planner
4294: PROCEDURE get_forecast_commission(spec_code IN OUT NOCOPY cn_utils.code_type,
4295: body_code IN OUT NOCOPY cn_utils.code_type )
4296: IS
4297: procedure_name cn_obj_procedures_v.name%TYPE;
4298: procedure_desc cn_obj_procedures_v.description%TYPE;
4299: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
4300:
4301: l_rate_dim_sequence NUMBER;

Line 4298: procedure_desc cn_obj_procedures_v.description%TYPE;

4294: PROCEDURE get_forecast_commission(spec_code IN OUT NOCOPY cn_utils.code_type,
4295: body_code IN OUT NOCOPY cn_utils.code_type )
4296: IS
4297: procedure_name cn_obj_procedures_v.name%TYPE;
4298: procedure_desc cn_obj_procedures_v.description%TYPE;
4299: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
4300:
4301: l_rate_dim_sequence NUMBER;
4302: l_sql_select VARCHAR2(8000);

Line 4299: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

4295: body_code IN OUT NOCOPY cn_utils.code_type )
4296: IS
4297: procedure_name cn_obj_procedures_v.name%TYPE;
4298: procedure_desc cn_obj_procedures_v.description%TYPE;
4299: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
4300:
4301: l_rate_dim_sequence NUMBER;
4302: l_sql_select VARCHAR2(8000);
4303: l_sql_from VARCHAR2(4000);

Line 4690: procedure_name cn_obj_procedures_v.name%TYPE;

4686: -- construct the get_estimated_payout procdure which will be invoked by SFP quota modeling
4687: PROCEDURE get_estimated_payout(spec_code IN OUT NOCOPY cn_utils.code_type,
4688: body_code IN OUT NOCOPY cn_utils.code_type )
4689: IS
4690: procedure_name cn_obj_procedures_v.name%TYPE;
4691: procedure_desc cn_obj_procedures_v.description%TYPE;
4692: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
4693:
4694: l_sql_select VARCHAR2(8000);

Line 4691: procedure_desc cn_obj_procedures_v.description%TYPE;

4687: PROCEDURE get_estimated_payout(spec_code IN OUT NOCOPY cn_utils.code_type,
4688: body_code IN OUT NOCOPY cn_utils.code_type )
4689: IS
4690: procedure_name cn_obj_procedures_v.name%TYPE;
4691: procedure_desc cn_obj_procedures_v.description%TYPE;
4692: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
4693:
4694: l_sql_select VARCHAR2(8000);
4695: l_piped_sql_select VARCHAR2(8000);

Line 4692: parameter_list cn_obj_procedures_v.parameter_list%TYPE;

4688: body_code IN OUT NOCOPY cn_utils.code_type )
4689: IS
4690: procedure_name cn_obj_procedures_v.name%TYPE;
4691: procedure_desc cn_obj_procedures_v.description%TYPE;
4692: parameter_list cn_obj_procedures_v.parameter_list%TYPE;
4693:
4694: l_sql_select VARCHAR2(8000);
4695: l_piped_sql_select VARCHAR2(8000);
4696: l_sql_from VARCHAR2(4000);