DBA Data[Home] [Help]

APPS.RRS_SITE_UDA_BULKLOAD_INTF dependencies on EGO_USER_ATTRS_BULK_PVT

Line 289: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITES' );

285: l_debug_level := 3; --continue writing to the Debug Log opened.
286: ELSE
287: l_debug_level := 0; --Since Debug log is not opened, donot open Debug log for User-Attrs also.
288: END IF;
289: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITES' );
290: l_user_attrs_return_status := FND_API.G_RET_STS_SUCCESS;
291:
292: Open c_rrs_site_ua_intf;
293: fetch c_rrs_site_ua_intf into l_cnt;

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

442: ELSE
443: l_privilege_predicate_api_name := NULL;
444: END IF;
445:
446: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITE' );
447: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
448: p_api_version => G_API_VERSION --IN NUMBER
449: ,p_application_id => 718 --IN NUMBER
450: ,p_attr_group_type => 'RRS_SITEMGMT_GROUP' --IN VARCHAR2

Line 447: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

443: l_privilege_predicate_api_name := NULL;
444: END IF;
445:
446: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_SITE' );
447: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
448: p_api_version => G_API_VERSION --IN NUMBER
449: ,p_application_id => 718 --IN NUMBER
450: ,p_attr_group_type => 'RRS_SITEMGMT_GROUP' --IN VARCHAR2
451: ,p_object_name => 'RRS_SITE' --IN VARCHAR2

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

547: ' WHERE HL.LOCATION_ID = UAI2.LOCATION_ID)'||
548: ' UNION ALL ' ||
549: ' (SELECT UAI2.COUNTRY FROM DUAL)' ;
550:
551: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_LOCATION' );
552:
553: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
554: p_api_version => G_API_VERSION --IN NUMBER
555: ,p_application_id => 718 --IN NUMBER

Line 553: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

549: ' (SELECT UAI2.COUNTRY FROM DUAL)' ;
550:
551: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_LOCATION' );
552:
553: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
554: p_api_version => G_API_VERSION --IN NUMBER
555: ,p_application_id => 718 --IN NUMBER
556: ,p_attr_group_type => 'RRS_LOCATION_GROUP' --IN VARCHAR2
557: ,p_object_name => 'RRS_LOCATION' --IN VARCHAR2

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

642: ' WHERE RTA.TRADE_AREA_ID = UAI2.TRADE_AREA_ID)'||
643: ' UNION ALL ' ||
644: ' (SELECT UAI2.GROUP_ID FROM DUAL)' ;
645:
646: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_TRADE_AREA' );
647:
648: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
649: p_api_version => G_API_VERSION --IN NUMBER
650: ,p_application_id => 718 --IN NUMBER

Line 648: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

644: ' (SELECT UAI2.GROUP_ID FROM DUAL)' ;
645:
646: Write_Conclog('Executing EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data -'||'RRS_TRADE_AREA' );
647:
648: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
649: p_api_version => G_API_VERSION --IN NUMBER
650: ,p_application_id => 718 --IN NUMBER
651: ,p_attr_group_type => 'RRS_TRADE_AREA_GROUP' --IN VARCHAR2
652: ,p_object_name => 'RRS_TRADE_AREA' --IN VARCHAR2