DBA Data[Home] [Help]

APPS.EGO_ICC_BULKLOAD_PVT dependencies on EGO_MAPPINGS_B

Line 2641: FROM ego_mappings_b b

2637:
2638: CURSOR c
2639: IS
2640: SELECT 1
2641: FROM ego_mappings_b b
2642: WHERE b.mapped_obj_pk1_val = to_char(p_action_id)
2643: AND b.function_id = p_function_id
2644: AND b.func_param_id = p_func_param_id;
2645:

Line 7245: l_mapped_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'A';

7241:
7242: l_msg_count NUMBER := 0;
7243: l_error_code NUMBER := 0;
7244: l_msg_data VARCHAR2(4000);
7245: l_mapped_obj_type EGO_MAPPINGS_B.MAPPED_OBJ_TYPE%TYPE := 'A';
7246:
7247: e_skip_record EXCEPTION;
7248: e_unexpected_error EXCEPTION;
7249:

Line 8482: FROM EGO_MAPPINGS_B

8478:
8479: CURSOR cur_curr_param_count ( p_function_id number, p_icc_id number)
8480: IS
8481: SELECT COUNT(1) AS count_map
8482: FROM EGO_MAPPINGS_B
8483: where function_id = p_function_id
8484: and mapped_obj_type = 'A'
8485: and mapped_obj_pk1_val = ( select action_id
8486: from ego_actions_b