APPS.RRS_SITE_UDA_BULKLOAD_INTF dependencies on EGO_USER_ATTRS_DATA_PVT

Line 320: ,TRANSACTION_TYPE = UPPER(NVL(TRANSACTION_TYPE,EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE))

316: ,REQUEST_ID = G_REQUEST_ID
317: ,PROGRAM_APPLICATION_ID = G_PROGAM_APPLICATION_ID
318: ,PROGRAM_ID = G_PROGAM_ID
319: ,PROGRAM_UPDATE_DATE = SYSDATE
320: ,TRANSACTION_TYPE = UPPER(NVL(TRANSACTION_TYPE,EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE))
321: WHERE DATA_SET_ID = p_data_set_id
322: AND (PROCESS_STATUS IS NULL OR
323: PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
324:

Line 539: ,TRANSACTION_TYPE = UPPER(NVL(TRANSACTION_TYPE,EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE))

535: ,CREATION_DATE = DECODE(CREATION_DATE, NULL, SYSDATE, CREATION_DATE)
536: ,LAST_UPDATED_BY = G_USER_ID
537: ,LAST_UPDATE_DATE = SYSDATE
538: ,LAST_UPDATE_LOGIN = G_LOGIN_ID
539: ,TRANSACTION_TYPE = UPPER(NVL(TRANSACTION_TYPE,EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE))
540: WHERE DATA_SET_ID = p_data_set_id
541: AND (PROCESS_STATUS IS NULL OR
542: PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
543: -- l_rel_sql := 'SELECT CODE FROM RRS_LOCATIONS_OCV' ;

Line 633: ,TRANSACTION_TYPE = UPPER(NVL(TRANSACTION_TYPE,EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE))

629: ,CREATION_DATE = DECODE(CREATION_DATE, NULL, SYSDATE, CREATION_DATE)
630: ,LAST_UPDATED_BY = G_USER_ID
631: ,LAST_UPDATE_DATE = SYSDATE
632: ,LAST_UPDATE_LOGIN = G_LOGIN_ID
633: ,TRANSACTION_TYPE = UPPER(NVL(TRANSACTION_TYPE,EGO_USER_ATTRS_DATA_PVT.G_SYNC_MODE))
634: WHERE DATA_SET_ID = p_data_set_id
635: AND (PROCESS_STATUS IS NULL OR
636: PROCESS_STATUS = G_PS_TO_BE_PROCESSED);
637: -- l_rel_sql := 'SELECT CODE FROM RRS_TRADE_AREAS_OCV' ;