DBA Data[Home] [Help]

APPS.RRS_BULKLOAD_ENTITIES dependencies on EGO_USER_ATTRS_BULK_PVT

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_USER_ATTRS_BULK_PVT';

3: AS
4: ----------------------------------------------------------------------------
5: -- Global constants
6: ----------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'EGO_USER_ATTRS_BULK_PVT';
8: G_REQUEST_ID NUMBER := FND_GLOBAL.CONC_REQUEST_ID;
9: G_PROGAM_APPLICATION_ID NUMBER := FND_GLOBAL.PROG_APPL_ID;
10: G_PROGAM_ID NUMBER := FND_GLOBAL.CONC_PROGRAM_ID;
11: G_USER_NAME FND_USER.USER_NAME%TYPE := FND_GLOBAL.USER_NAME;

Line 822: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITE' );

818: ----------------------------------------------------------
819: -- Code added for RBAC project - complete.
820: ----------------------------------------------------------
821:
822: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITE' );
823:
824: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
825: p_api_version => G_API_VERSION --IN NUMBER
826: ,p_application_id => 718 --IN NUMBER

Line 824: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

820: ----------------------------------------------------------
821:
822: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITE' );
823:
824: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
825: p_api_version => G_API_VERSION --IN NUMBER
826: ,p_application_id => 718 --IN NUMBER
827: ,p_attr_group_type => 'RRS_SITEMGMT_GROUP' --IN VARCHAR2
828: ,p_object_name => 'RRS_SITE' --IN VARCHAR2

Line 909: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_LOCATION' );

905: WHERE DATA_SET_ID = p_data_set_id
906: AND (PROCESS_STATUS IS NULL OR
907: PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
908: l_rel_sql := 'SELECT CODE FROM RRS_LOCATIONS_OCV' ;
909: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_LOCATION' );
910: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
911: p_api_version => G_API_VERSION --IN NUMBER
912: ,p_application_id => 718 --IN NUMBER
913: ,p_attr_group_type => 'RRS_LOCATION_GROUP' --IN VARCHAR2

Line 910: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

906: AND (PROCESS_STATUS IS NULL OR
907: PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
908: l_rel_sql := 'SELECT CODE FROM RRS_LOCATIONS_OCV' ;
909: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_LOCATION' );
910: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
911: p_api_version => G_API_VERSION --IN NUMBER
912: ,p_application_id => 718 --IN NUMBER
913: ,p_attr_group_type => 'RRS_LOCATION_GROUP' --IN VARCHAR2
914: ,p_object_name => 'RRS_LOCATION' --IN VARCHAR2

Line 985: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_TRADE_AREA' );

981: AND (PROCESS_STATUS IS NULL OR
982: PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
983: l_rel_sql := 'SELECT CODE FROM RRS_TRADE_AREAS_OCV' ;
984:
985: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_TRADE_AREA' );
986:
987: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
988: p_api_version => G_API_VERSION --IN NUMBER
989: ,p_application_id => 718 --IN NUMBER

Line 987: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

983: l_rel_sql := 'SELECT CODE FROM RRS_TRADE_AREAS_OCV' ;
984:
985: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_TRADE_AREA' );
986:
987: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
988: p_api_version => G_API_VERSION --IN NUMBER
989: ,p_application_id => 718 --IN NUMBER
990: ,p_attr_group_type => 'RRS_TRADE_AREA_GROUP' --IN VARCHAR2
991: ,p_object_name => 'RRS_TRADE_AREA' --IN VARCHAR2