APPS.EGO_EXT_FWK_PUB dependencies on EGO_ATTRS_V

Line 2660: v_source_ag_app_id IN EGO_ATTRS_V.APPLICATION_ID%TYPE

2656: l_msg_data VARCHAR2(1000);
2657:
2658: CURSOR ego_attribute_csr
2659: (
2660: v_source_ag_app_id IN EGO_ATTRS_V.APPLICATION_ID%TYPE
2661: ,v_source_ag_type IN EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE
2662: ,v_source_ag_name IN EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE
2663: ) IS
2664: SELECT APPLICATION_ID,

Line 2661: ,v_source_ag_type IN EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE

2657:
2658: CURSOR ego_attribute_csr
2659: (
2660: v_source_ag_app_id IN EGO_ATTRS_V.APPLICATION_ID%TYPE
2661: ,v_source_ag_type IN EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE
2662: ,v_source_ag_name IN EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE
2663: ) IS
2664: SELECT APPLICATION_ID,
2665: ATTR_GROUP_TYPE,

Line 2662: ,v_source_ag_name IN EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE

2658: CURSOR ego_attribute_csr
2659: (
2660: v_source_ag_app_id IN EGO_ATTRS_V.APPLICATION_ID%TYPE
2661: ,v_source_ag_type IN EGO_ATTRS_V.ATTR_GROUP_TYPE%TYPE
2662: ,v_source_ag_name IN EGO_ATTRS_V.ATTR_GROUP_NAME%TYPE
2663: ) IS
2664: SELECT APPLICATION_ID,
2665: ATTR_GROUP_TYPE,
2666: ATTR_GROUP_NAME,

Line 2683: FROM EGO_ATTRS_V

2679: DISPLAY_CODE,
2680: DATABASE_COLUMN,
2681: UOM_CLASS,
2682: DECODE(DISPLAY_CODE,'D',1,0) DISP_CODE --bugFix:5589398
2683: FROM EGO_ATTRS_V
2684: WHERE APPLICATION_ID = v_source_ag_app_id
2685: AND ATTR_GROUP_TYPE = v_source_ag_type
2686: AND ATTR_GROUP_NAME = v_source_ag_name
2687: ORDER BY DISP_CODE, SEQUENCE;

Line 2689: l_sequence ego_attrs_v.sequence%TYPE;

2685: AND ATTR_GROUP_TYPE = v_source_ag_type
2686: AND ATTR_GROUP_NAME = v_source_ag_name
2687: ORDER BY DISP_CODE, SEQUENCE;
2688:
2689: l_sequence ego_attrs_v.sequence%TYPE;
2690: ego_attribute_rec ego_attribute_csr%ROWTYPE;
2691: l_sequence_numbers VARCHAR2(10000);
2692:
2693: BEGIN

Line 8375: FROM EGO_ATTR_GROUPS_V AGV, EGO_ATTRS_V AV

8371: FROM EGO_ATTR_GROUPS_V WHERE ATTR_GROUP_ID = p_attr_group_id;
8372:
8373: SELECT Count(1)
8374: INTO l_attr_count
8375: FROM EGO_ATTR_GROUPS_V AGV, EGO_ATTRS_V AV
8376: WHERE AGV.APPLICATION_ID = AV.APPLICATION_ID
8377: AND AGV.ATTR_GROUP_TYPE = AV.ATTR_GROUP_TYPE
8378: AND AGV.ATTR_GROUP_NAME = AV.ATTR_GROUP_NAME
8379: AND AGV.ATTR_GROUP_ID = p_attr_group_id;