APPS.EGO_ICC_BULKLOAD_PVT dependencies on EGO_FUNC_PARAMS_B

Line 1629: from ego_func_params_b efpb

1625: write_debug (l_proc_name, '26');
1626:
1627: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1628: set efpmi.parameter_id = ( select efpb.func_param_id
1629: from ego_func_params_b efpb
1630: where efpb.internal_name = efpmi.parameter_name
1631: and efpb.function_id = efpmi.function_id
1632: )
1633: WHERE efpmi.parameter_id IS NULL

Line 1648: from ego_func_params_b efpb

1644: write_debug (l_proc_name, '27');
1645:
1646: UPDATE EGO_FUNC_PARAMS_MAP_INTERFACE efpmi
1647: set efpmi.parameter_name = ( select efpb.internal_name
1648: from ego_func_params_b efpb
1649: where efpb.func_param_id = efpmi.parameter_id
1650: and efpb.function_id = efpmi.function_id
1651: )
1652: WHERE efpmi.parameter_name IS NULL

Line 2705: l_function_id ego_func_params_b.function_id%TYPE;

2701: --
2702: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_FN_PARAM_MAP;
2703: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2704:
2705: l_function_id ego_func_params_b.function_id%TYPE;
2706: l_func_param_id ego_func_params_b.func_param_id%TYPE;
2707: l_func_params_tbl ego_func_param_map_tbl_type;
2708: l_object_id fnd_objects.object_id%TYPE := null;
2709: l_action_id ego_actions_b.action_id%TYPE := null;

Line 2706: l_func_param_id ego_func_params_b.func_param_id%TYPE;

2702: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_FN_PARAM_MAP;
2703: l_token_table ERROR_HANDLER.Token_Tbl_Type;
2704:
2705: l_function_id ego_func_params_b.function_id%TYPE;
2706: l_func_param_id ego_func_params_b.func_param_id%TYPE;
2707: l_func_params_tbl ego_func_param_map_tbl_type;
2708: l_object_id fnd_objects.object_id%TYPE := null;
2709: l_action_id ego_actions_b.action_id%TYPE := null;
2710: l_mapping_found BOOLEAN := FALSE;

Line 2719: from ego_func_params_b efpb

2715: ,p_function_id NUMBER
2716: )
2717: IS
2718: select FUNC_PARAM_ID, internal_name
2719: from ego_func_params_b efpb
2720: where efpb.function_id = p_function_id
2721: and efpb.internal_name = nvl(p_param_name, efpb.internal_name)
2722: and efpb.func_param_id = nvl(p_param_id ,efpb.func_param_id)
2723: ;

Line 2958: FROM EGO_FUNC_PARAMS_B

2954:
2955: CURSOR cur_func_check ( p_cur_func_id NUMBER)
2956: IS
2957: SELECT 1
2958: FROM EGO_FUNC_PARAMS_B
2959: WHERE function_id = p_cur_func_id
2960: AND param_type = 'R'
2961: AND data_type IN ('O', 'N', 'V', 'I', 'L', 'S')
2962: ;

Line 7255: from ego_func_params_b

7251:
7252: CURSOR cur_func_param_count ( p_function_id number)
7253: IS
7254: SELECT COUNT(1) count
7255: from ego_func_params_b
7256: where function_id = p_function_id;
7257:
7258:
7259:

Line 8475: FROM EGO_FUNC_PARAMS_B

8471:
8472: CURSOR cur_prod_param_count ( p_function_id number)
8473: IS
8474: SELECT COUNT(1) AS count_prod
8475: FROM EGO_FUNC_PARAMS_B
8476: where function_id = p_function_id
8477: ;
8478:
8479: CURSOR cur_curr_param_count ( p_function_id number, p_icc_id number)