eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.RRS_SITE_UDA_BULKLOAD_INTF dependencies on RRS_SITE_UA_INTF

Line 67: from rrs_site_ua_intf

63: BEGIN
64: BEGIN
65: select distinct process_status
66: into l_status
67: from rrs_site_ua_intf
68: where data_set_id = 10000;
69: EXCEPTION
70: WHEN NO_DATA_FOUND THEN NULL;
71: WHEN TOO_MANY_ROWS THEN NULL;

Line 257: site_id rrs_site_ua_intf.site_id%TYPE,

253: l_privilege_predicate_api_name VARCHAR2(250);
254: l_security_for_validate VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N');
255:
256: TYPE local_site_id_list_rec is RECORD (
257: site_id rrs_site_ua_intf.site_id%TYPE,
258: site_number rrs_site_ua_intf.site_number%TYPE,
259: transaction_type rrs_site_ua_intf.transaction_type%TYPE
260: );
261:

Line 258: site_number rrs_site_ua_intf.site_number%TYPE,

254: l_security_for_validate VARCHAR2(30) := NVL(FND_PROFILE.VALUE('RRS_ROLE_BASED_SECURITY_ENABLED'),'N');
255:
256: TYPE local_site_id_list_rec is RECORD (
257: site_id rrs_site_ua_intf.site_id%TYPE,
258: site_number rrs_site_ua_intf.site_number%TYPE,
259: transaction_type rrs_site_ua_intf.transaction_type%TYPE
260: );
261:
262: TYPE local_site_id_list_tab IS TABLE OF local_site_id_list_rec;

Line 259: transaction_type rrs_site_ua_intf.transaction_type%TYPE

255:
256: TYPE local_site_id_list_rec is RECORD (
257: site_id rrs_site_ua_intf.site_id%TYPE,
258: site_number rrs_site_ua_intf.site_number%TYPE,
259: transaction_type rrs_site_ua_intf.transaction_type%TYPE
260: );
261:
262: TYPE local_site_id_list_tab IS TABLE OF local_site_id_list_rec;
263: l_site_id_list local_site_id_list_tab;

Line 269: CURSOR c_rrs_site_ua_intf is

265: local_processing_errors rrs_processing_errors_tab;
266: p_processing_errors rrs_processing_errors_tab;
267: l_row_status varchar2(1);
268:
269: CURSOR c_rrs_site_ua_intf is
270: select count(*) from RRS_SITE_UA_INTF
271: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
272: AND data_set_id = p_data_set_id;
273: CURSOR c_rrs_loc_ua_intf is

Line 270: select count(*) from RRS_SITE_UA_INTF

266: p_processing_errors rrs_processing_errors_tab;
267: l_row_status varchar2(1);
268:
269: CURSOR c_rrs_site_ua_intf is
270: select count(*) from RRS_SITE_UA_INTF
271: WHERE PROCESS_STATUS = G_PS_TO_BE_PROCESSED
272: AND data_set_id = p_data_set_id;
273: CURSOR c_rrs_loc_ua_intf is
274: select count(*) from RRS_LOCATION_UA_INTF

Line 292: Open c_rrs_site_ua_intf;

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;
294: Close c_rrs_site_ua_intf;
295:
296: IF l_cnt > 0 THEN

Line 293: fetch c_rrs_site_ua_intf into l_cnt;

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;
294: Close c_rrs_site_ua_intf;
295:
296: IF l_cnt > 0 THEN
297:

Line 294: Close c_rrs_site_ua_intf;

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;
294: Close c_rrs_site_ua_intf;
295:
296: IF l_cnt > 0 THEN
297:
298:

Line 314: UPDATE RRS_SITE_UA_INTF

310: END IF;
311: END IF;
312:
313:
314: UPDATE RRS_SITE_UA_INTF
315: SET PROCESS_STATUS = G_PS_IN_PROCESS
316: ,REQUEST_ID = G_REQUEST_ID
317: ,PROGRAM_APPLICATION_ID = G_PROGAM_APPLICATION_ID
318: ,PROGRAM_ID = G_PROGAM_ID

Line 343: from rrs_site_ua_intf

339:
340: select distinct site_id , site_number, transaction_type
341: Bulk Collect
342: into l_site_id_list
343: from rrs_site_ua_intf
344: where data_set_id = p_data_set_id;
345:
346: if l_site_id_list.count > 0 then
347:

Line 368: ,p_source_table_name => 'RRS_SITE_UA_INTF'

364: ,p_site_id_num => l_site_id_list(i).site_number
365: ,p_column_name => 'SITE_ID'
366: ,p_message_name => 'MESSAGE NAME'
367: ,p_message_text => 'User does not have View Privileges on Site : '||l_site_id_list(i).site_number
368: ,p_source_table_name => 'RRS_SITE_UA_INTF'
369: ,p_destination_table_name => 'RRS_SITES_EXT_B'
370: ,p_process_status => '3'
371: ,p_transaction_type => l_site_id_list(i).transaction_type
372: ,p_batch_id => p_batch_id

Line 393: ,p_source_table_name => 'RRS_SITE_UA_INTF'

389: ,p_site_id_num => l_site_id_list(i).site_number
390: ,p_column_name => 'SITE_ID'
391: ,p_message_name => 'MESSAGE NAME'
392: ,p_message_text => 'User does not have Edit Privileges on Site : '||l_site_id_list(i).site_number
393: ,p_source_table_name => 'RRS_SITE_UA_INTF'
394: ,p_destination_table_name => 'RRS_SITES_EXT_B'
395: ,p_process_status => '3'
396: ,p_transaction_type => l_site_id_list(i).transaction_type
397: ,p_batch_id => p_batch_id

Line 406: Update RRS_SITE_UA_INTF

402: end if;
403:
404: if l_row_status = 'E' then
405:
406: Update RRS_SITE_UA_INTF
407: Set Process_status = '3'
408: Where data_set_id = p_data_set_id
409: and process_status = G_PS_IN_PROCESS
410: and site_id = l_site_id_list(i).site_id

Line 453: ,p_interface_table_name => 'RRS_SITE_UA_INTF' --IN VARCHAR2

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
452: ,p_hz_party_id => G_HZ_PARTY_ID
453: ,p_interface_table_name => 'RRS_SITE_UA_INTF' --IN VARCHAR2
454: ,p_data_set_id => p_data_set_id --IN NUMBER
455: ,p_entity_id => G_ENTITY_ID --IN NUMBER
456: ,p_entity_index => l_entity_index_counter --IN NUMBER
457: ,p_entity_code => G_ENTITY_CODE --IN VARCHAR2

Line 505: DELETE FROM RRS_SITE_UA_INTF

501: -----------------------------------------------
502: -- Delete all successful rows from the table --
503: -- (they're the only rows still in process) --
504: -----------------------------------------------
505: DELETE FROM RRS_SITE_UA_INTF
506: WHERE BATCH_ID = p_batch_id
507: AND PROCESS_STATUS = G_PS_IN_PROCESS;
508: ELSE
509: ----------------------------------------------

Line 513: UPDATE RRS_SITE_UA_INTF

509: ----------------------------------------------
510: -- Mark all rows we've processed as success --
511: -- if they weren't marked as failure above --
512: ----------------------------------------------
513: UPDATE RRS_SITE_UA_INTF
514: SET PROCESS_STATUS = G_PS_SUCCESS
515: WHERE batch_id = p_batch_id
516: AND PROCESS_STATUS = G_PS_IN_PROCESS;
517: END IF;

Line 765: ,'RRS_SITE_UA_INTF'

761: ,COLUMN_NAME
762: ,MESSAGE_NAME
763: ,MESSAGE_TYPE
764: ,ERROR_MESSAGE
765: ,'RRS_SITE_UA_INTF'
766: ,'RRS_INTERFACE_ERRORS'
767: ,CREATED_BY
768: ,CREATION_DATE
769: ,LAST_UPDATED_BY