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.EGO_ICC_BULKLOAD_PVT dependencies on EGO_ACTIONS_B

Line 2559: FROM ego_actions_b act

2555: p_action_id IN NUMBER ) RETURN NUMBER IS
2556:
2557: CURSOR c IS
2558: SELECT act.function_id
2559: FROM ego_actions_b act
2560: WHERE act.object_id = p_object_id
2561: AND act.classification_code = p_classification_code
2562: AND act.action_id = p_action_id;
2563:

Line 2564: l_ret ego_actions_b.function_id%TYPE;

2560: WHERE act.object_id = p_object_id
2561: AND act.classification_code = p_classification_code
2562: AND act.action_id = p_action_id;
2563:
2564: l_ret ego_actions_b.function_id%TYPE;
2565: l_proc_name CONSTANT VARCHAR2(30) := 'GET_ACTION_FUNCTION_ID';
2566:
2567: BEGIN
2568: write_debug(l_proc_name,'Entering method with params icc id = ' || p_classification_code ||

Line 2709: l_action_id ego_actions_b.action_id%TYPE := null;

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;
2711:
2712:
2713: cursor cur_func_param ( p_param_name VARCHAR2 default null

Line 5719: l_action_name EGO_ACTIONS_B.action_name%TYPE := 'ItemRequestProcessAction';

5715: )
5716: IS
5717: l_proc_name VARCHAR2(30) := 'Process_Function_Actions';
5718: l_sequence NUMBER := 100;
5719: l_action_name EGO_ACTIONS_B.action_name%TYPE := 'ItemRequestProcessAction';
5720: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_AG_ASSOC;
5721: l_object_id fnd_objects.object_id%TYPE;
5722: l_association_id ego_obj_ag_assocs_b.association_id%TYPE;
5723:

Line 5938: l_action_id ego_actions_b.action_id%TYPE := null;

5934:
5935: l_proc_name VARCHAR2(30) := 'Create_Action_for_Func';
5936: l_entity_code VARCHAR2(50) := G_ENTITY_ICC_HEADER;
5937: l_object_id FND_OBJECTS.object_id%TYPE := null;
5938: l_action_id ego_actions_b.action_id%TYPE := null;
5939: l_old_num_func_id ego_actions_b.function_id%TYPE := NULL;
5940: l_old_desc_func_id ego_actions_b.function_id%TYPE := NULL;
5941: l_old_key_attrs_num ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675
5942: l_old_key_attrs_desc ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675

Line 5939: l_old_num_func_id ego_actions_b.function_id%TYPE := NULL;

5935: l_proc_name VARCHAR2(30) := 'Create_Action_for_Func';
5936: l_entity_code VARCHAR2(50) := G_ENTITY_ICC_HEADER;
5937: l_object_id FND_OBJECTS.object_id%TYPE := null;
5938: l_action_id ego_actions_b.action_id%TYPE := null;
5939: l_old_num_func_id ego_actions_b.function_id%TYPE := NULL;
5940: l_old_desc_func_id ego_actions_b.function_id%TYPE := NULL;
5941: l_old_key_attrs_num ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675
5942: l_old_key_attrs_desc ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675
5943:

Line 5940: l_old_desc_func_id ego_actions_b.function_id%TYPE := NULL;

5936: l_entity_code VARCHAR2(50) := G_ENTITY_ICC_HEADER;
5937: l_object_id FND_OBJECTS.object_id%TYPE := null;
5938: l_action_id ego_actions_b.action_id%TYPE := null;
5939: l_old_num_func_id ego_actions_b.function_id%TYPE := NULL;
5940: l_old_desc_func_id ego_actions_b.function_id%TYPE := NULL;
5941: l_old_key_attrs_num ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675
5942: l_old_key_attrs_desc ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675
5943:
5944: e_unexpected_error EXCEPTION;

Line 5941: l_old_key_attrs_num ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675

5937: l_object_id FND_OBJECTS.object_id%TYPE := null;
5938: l_action_id ego_actions_b.action_id%TYPE := null;
5939: l_old_num_func_id ego_actions_b.function_id%TYPE := NULL;
5940: l_old_desc_func_id ego_actions_b.function_id%TYPE := NULL;
5941: l_old_key_attrs_num ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675
5942: l_old_key_attrs_desc ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675
5943:
5944: e_unexpected_error EXCEPTION;
5945: l_seq_name VARCHAR2(30) := NULL;

Line 5942: l_old_key_attrs_desc ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675

5938: l_action_id ego_actions_b.action_id%TYPE := null;
5939: l_old_num_func_id ego_actions_b.function_id%TYPE := NULL;
5940: l_old_desc_func_id ego_actions_b.function_id%TYPE := NULL;
5941: l_old_key_attrs_num ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675
5942: l_old_key_attrs_desc ego_actions_b.enable_key_attributes%TYPE; -- Bug 12394675
5943:
5944: e_unexpected_error EXCEPTION;
5945: l_seq_name VARCHAR2(30) := NULL;
5946:

Line 5953: FROM ego_actions_b

5949: ,p_object_id number
5950: )
5951: IS
5952: SELECT action_id
5953: FROM ego_actions_b
5954: WHERE function_id = p_function_id
5955: and classification_code = to_char(p_icc_id)
5956: and object_id = p_object_id
5957: ;

Line 5965: FROM ego_actions_b

5961: ,p_object_id number
5962: )
5963: IS
5964: SELECT function_id, enable_key_attributes
5965: FROM ego_actions_b
5966: WHERE action_id = p_action_id
5967: and classification_code = to_char(p_icc_id)
5968: and object_id = p_object_id
5969: ;

Line 7238: l_action_id ego_actions_b.action_id%TYPE := null;

7234: IS
7235: l_proc_name VARCHAR2(30) := 'Call_func_param_assoc_api';
7236: l_application_id NUMBER := NULL;
7237: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_FN_PARAM_MAP;
7238: l_action_id ego_actions_b.action_id%TYPE := null;
7239: l_object_id fnd_objects.object_id%TYPE := null;
7240:
7241:
7242: l_msg_count NUMBER := 0;

Line 8486: from ego_actions_b

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
8487: where function_id = p_function_id
8488: and classification_code = to_char(p_icc_id)
8489: )
8490: ;

Line 8802: FROM ego_actions_b

8798: ---
8799:
8800: SELECT action_id
8801: into l_action_id
8802: FROM ego_actions_b
8803: WHERE function_id = rec_icc_func.function_id
8804: AND classification_code = to_char(rec_icc_func.item_catalog_group_id)
8805: ;
8806: