APPS.RRS_IMPORT_INTERFACE_PKG dependencies on RRS_SITES_TL

Line 672: ,p_destination_table_name => 'RRS_SITES_TL'

668: ,p_message_name => 'MESSAGE NAME'
669: -- ,p_message_text => 'Site Name cannot be Null for : '||site_data.site_identification_number
670: ,p_message_text => l_msg
671: ,p_source_table_name => 'RRS_SITES_INTERFACE'
672: ,p_destination_table_name => 'RRS_SITES_TL'
673: ,p_process_status => '3'
674: ,p_transaction_type => site_data.transaction_type
675: ,p_batch_id => site_data.batch_id
676: ,p_processing_errors => local_processing_errors

Line 2280: insert into RRS_SITES_TL(

2276: end if;
2277:
2278: Begin
2279:
2280: insert into RRS_SITES_TL(
2281: SITE_ID
2282: ,NAME
2283: ,LANGUAGE
2284: ,SOURCE_LANG

Line 2311: from RRS_SITES_TL T

2307: and A.site_identification_number = b.site_identification_number
2308: and L.INSTALLED_FLAG in ('I', 'B')
2309: and not exists
2310: (select NULL
2311: from RRS_SITES_TL T
2312: where T.SITE_ID = B.site_id
2313: and T.LANGUAGE = L.LANGUAGE_CODE)
2314: );
2315:

Line 2531: FROM RRS_SITES_INTERFACE a, RRS_SITES_B B , RRS_SITES_TL C, RRS_SITE_USES D,

2527: ,h.COUNTY county
2528: ,h.COUNTRY country
2529: ,h.GEOMETRY_SOURCE geometry_source
2530: ,h.object_version_number
2531: FROM RRS_SITES_INTERFACE a, RRS_SITES_B B , RRS_SITES_TL C, RRS_SITE_USES D,
2532: HZ_LOCATIONS H
2533: WHERE TRANSACTION_TYPE = G_TX_TYPE_UPDATE
2534: and BATCH_ID = l_batch_id
2535: and Process_status = G_PS_IN_PROCESS

Line 2667: ,p_destination_table_name => 'RRS_SITES_TL'

2663: ,p_column_name => 'SITE_NAME'
2664: ,p_message_name => 'MESSAGE NAME'
2665: ,p_message_text => 'Site Name cannot be Null for : '||site_data.site_identification_number
2666: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2667: ,p_destination_table_name => 'RRS_SITES_TL'
2668: ,p_process_status => '3'
2669: ,p_transaction_type => site_data.transaction_type_intf
2670: ,p_batch_id => site_data.batch_id
2671: ,p_processing_errors => local_processing_errors

Line 3467: Update RRS_SITES_TL A

3463: FND_FILE.put_line(FND_FILE.LOG, 'Total No. of Sites Updated : '||to_char(sql%rowcount));
3464: end if;
3465:
3466:
3467: Update RRS_SITES_TL A
3468: Set Name = (select site_name from RRS_SITES_INTERFACE B, RRS_SITES_B RSB
3469: where RSB.site_identification_number = B.site_identification_number
3470: and RSB.Site_id = A.Site_id
3471: and B.Batch_id = p_batch_id