APPS.EGO_ICC_BULKLOAD_PVT dependencies on EGO_OBJ_AG_ASSOCS_B

Line 4416: l_association_id ego_obj_ag_assocs_b.association_id%TYPE := null;

4412:
4413: IS
4414: l_proc_name VARCHAR2(30) := 'Get_AG_Association';
4415:
4416: l_association_id ego_obj_ag_assocs_b.association_id%TYPE := null;
4417:
4418: /*
4419: cursor cur_ag_assoc
4420: is

Line 4422: from ego_obj_ag_assocs_b

4418: /*
4419: cursor cur_ag_assoc
4420: is
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

Line 4645: l_association_id ego_obj_ag_assocs_b.association_id%TYPE := null;

4641: l_Mesg_Token_tbl Error_Handler.Mesg_Token_Tbl_Type;
4642: l_dummy boolean;
4643: l_data_level_id ego_data_level_b.data_level_id%TYPE := NULL;
4644: l_icc_name mtl_item_catalog_groups_b_kfv.padded_concatenated_segments%TYPE := null;
4645: l_association_id ego_obj_ag_assocs_b.association_id%TYPE := null;
4646: l_return_status VARCHAR2(1);
4647: l_return_status2 VARCHAR2(1);
4648: l_locking_party_id NUMBER;
4649: l_lock_flag ego_object_lock.lock_flag%TYPE;

Line 5722: l_association_id ego_obj_ag_assocs_b.association_id%TYPE;

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;
5726:

Line 7082: l_association_id ego_obj_ag_assocs_b.association_id%TYPE;

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;
7086: