[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
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);
1622: l_input_sql_where varchar2(4000) := 'WHERE 1=1 ';
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);
1989: l_output_sql_where varchar2(4000) := 'WHERE 1=1 ';
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);
2232: l_perf_sql_where varchar2(4000) := 'WHERE 1=1 ';
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);
2678: l_output_sql_select_clob clob;
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);
3519: l_table_object_id cn_objects.object_id%type;
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);
3684: l_input_sql_where varchar2(4000) := 'WHERE 1=1';
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);
3829: l_input_sql_select_clob clob;
4815: spec_code cn_utils.code_type;
4816: body_code cn_utils.code_type;
4817: dummy NUMBER(7);
4818: l_module_id number(15);
4819: l_repository_id cn_repositories.repository_id%TYPE;
4820: BEGIN
4821: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
4822: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
4823: 'cn.plsql.cn_formula_gen_pkg.create_formula.begin',
4827: cn_utils.set_org_id(g_org_id);
4828:
4829: SELECT repository_id
4830: INTO l_repository_id
4831: FROM cn_repositories_all
4832: WHERE org_id = g_org_id;
4833: package_name := 'cn_formula_' || abs(p_formula_id) || '_' || abs(g_org_id) || '_pkg';
4834:
4835: check_create_object(package_name, 'PKS', package_spec_id, l_repository_id);