APPS.EGO_ICC_BULKLOAD_PVT dependencies on FND_OBJECTS

Line 16: FROM fnd_objects

12:
13: CURSOR cur_get_obj_id
14: IS
15: SELECT object_id
16: FROM fnd_objects
17: WHERE obj_name = G_ITEM_OBJ_NAME;
18:
19: TYPE number_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER; --- added bug 9701271
20:

Line 2512: l_ret fnd_objects.object_id%TYPE;

2508: --
2509:
2510: FUNCTION get_object_id RETURN NUMBER IS
2511:
2512: l_ret fnd_objects.object_id%TYPE;
2513:
2514: BEGIN
2515:
2516: OPEN cur_get_obj_id;

Line 2708: l_object_id fnd_objects.object_id%TYPE := null;

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;
2711:
2712:

Line 4425: and object_id = ( select object_id from fnd_objects where obj_name = G_ITEM_OBJ_NAME)

4421: select association_id
4422: from ego_obj_ag_assocs_b
4423: where attr_group_id = p_attr_group_id
4424: and classification_code = to_char(p_icc_id)
4425: and object_id = ( select object_id from fnd_objects where obj_name = G_ITEM_OBJ_NAME)
4426: and rownum = 1
4427: ;
4428: */
4429:

Line 5721: l_object_id fnd_objects.object_id%TYPE;

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:
5724: l_msg_count NUMBER := 0;
5725: l_error_code NUMBER := 0;

Line 5937: l_object_id FND_OBJECTS.object_id%TYPE := null;

5933: IS
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

Line 7081: l_object_id fnd_objects.object_id%TYPE;

7077: )
7078: IS
7079: l_proc_name VARCHAR2(30) := 'CALL_AG_ASSOC_API';
7080: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_AG_ASSOC;
7081: l_object_id fnd_objects.object_id%TYPE;
7082: l_association_id ego_obj_ag_assocs_b.association_id%TYPE;
7083:
7084: l_msg_count NUMBER := 0;
7085: l_error_code NUMBER := 0;

Line 7239: l_object_id fnd_objects.object_id%TYPE := null;

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;
7243: l_error_code NUMBER := 0;