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 719: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITE' );

715: AND (PROCESS_STATUS IS NULL OR
716: PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
717: l_rel_sql := 'SELECT CODE FROM RRS_SITES_OCV';
718:
719: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITE' );
720:
721: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
722: p_api_version => G_API_VERSION --IN NUMBER
723: ,p_application_id => 718 --IN NUMBER

Line 721: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

717: l_rel_sql := 'SELECT CODE FROM RRS_SITES_OCV';
718:
719: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITE' );
720:
721: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
722: p_api_version => G_API_VERSION --IN NUMBER
723: ,p_application_id => 718 --IN NUMBER
724: ,p_attr_group_type => 'RRS_SITEMGMT_GROUP' --IN VARCHAR2
725: ,p_object_name => 'RRS_SITE' --IN VARCHAR2

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

802: WHERE DATA_SET_ID = p_data_set_id
803: AND (PROCESS_STATUS IS NULL OR
804: PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
805: l_rel_sql := 'SELECT CODE FROM RRS_LOCATIONS_OCV' ;
806: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_LOCATION' );
807: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
808: p_api_version => G_API_VERSION --IN NUMBER
809: ,p_application_id => 718 --IN NUMBER
810: ,p_attr_group_type => 'RRS_LOCATION_GROUP' --IN VARCHAR2

Line 807: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

803: AND (PROCESS_STATUS IS NULL OR
804: PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
805: l_rel_sql := 'SELECT CODE FROM RRS_LOCATIONS_OCV' ;
806: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_LOCATION' );
807: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
808: p_api_version => G_API_VERSION --IN NUMBER
809: ,p_application_id => 718 --IN NUMBER
810: ,p_attr_group_type => 'RRS_LOCATION_GROUP' --IN VARCHAR2
811: ,p_object_name => 'RRS_LOCATION' --IN VARCHAR2

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

878: AND (PROCESS_STATUS IS NULL OR
879: PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
880: l_rel_sql := 'SELECT CODE FROM RRS_TRADE_AREAS_OCV' ;
881:
882: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_TRADE_AREA' );
883:
884: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
885: p_api_version => G_API_VERSION --IN NUMBER
886: ,p_application_id => 718 --IN NUMBER

Line 884: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

880: l_rel_sql := 'SELECT CODE FROM RRS_TRADE_AREAS_OCV' ;
881:
882: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_TRADE_AREA' );
883:
884: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
885: p_api_version => G_API_VERSION --IN NUMBER
886: ,p_application_id => 718 --IN NUMBER
887: ,p_attr_group_type => 'RRS_TRADE_AREA_GROUP' --IN VARCHAR2
888: ,p_object_name => 'RRS_TRADE_AREA' --IN VARCHAR2