[Home] [Help]
809: -- Get the object_id in cn_objects for formula, if not exist, create it.
810: PROCEDURE check_create_object(x_name cn_objects.name%TYPE,
811: x_object_type cn_objects.object_type%TYPE,
812: x_object_id IN OUT NOCOPY cn_objects.object_id%TYPE,
813: x_repository_id cn_repositories.repository_id%TYPE)
814: IS
815: dummy NUMBER;
816: x_rowid ROWID;
817: BEGIN
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);
1629: l_input_sql_where varchar2(4000) := 'WHERE 1=1 ';
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);
2002: l_output_sql_where varchar2(4000) := 'WHERE 1=1 ';
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);
2245: l_perf_sql_where varchar2(4000) := 'WHERE 1=1 ';
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);
2691: l_output_sql_select_clob clob;
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);
3532: l_table_object_id cn_objects.object_id%type;
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);
3697: l_input_sql_where varchar2(4000) := 'WHERE 1=1';
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);
3842: l_input_sql_select_clob clob;
4828: spec_code cn_utils.code_type;
4829: body_code cn_utils.code_type;
4830: dummy NUMBER(7);
4831: l_module_id number(15);
4832: l_repository_id cn_repositories.repository_id%TYPE;
4833: BEGIN
4834:
4835: -- ADDED for bug 14230033
4836: IF ( ad_zd.get_edition('PATCH') IS NOT NULL ) THEN
4851: cn_utils.set_org_id(g_org_id);
4852:
4853: SELECT repository_id
4854: INTO l_repository_id
4855: FROM cn_repositories_all
4856: WHERE org_id = g_org_id;
4857: package_name := 'cn_formula_' || abs(p_formula_id) || '_' || abs(g_org_id) || '_pkg';
4858:
4859: check_create_object(package_name, 'PKS', package_spec_id, l_repository_id);