APPS.RRS_IMPORT_INTERFACE_PKG dependencies on RRS_SITE_USES

Line 828: ,p_destination_table_name => 'RRS_SITE_USES'

824: ,p_message_name => 'MESSAGE NAME'
825: -- ,p_message_text => 'Site Use Type Code validation fails for : '||site_data.site_identification_number
826: ,p_message_text => l_msg
827: ,p_source_table_name => 'RRS_SITES_INTERFACE'
828: ,p_destination_table_name => 'RRS_SITE_USES'
829: ,p_process_status => '3'
830: ,p_transaction_type => site_data.transaction_type
831: ,p_batch_id => site_data.batch_id
832: ,p_processing_errors => local_processing_errors

Line 2334: insert into RRS_SITE_USES(

2330:
2331:
2332: Begin
2333:
2334: insert into RRS_SITE_USES(
2335: SITE_USE_ID
2336: ,SITE_ID
2337: ,SITE_USE_TYPE_CODE
2338: ,STATUS_CODE

Line 2349: rrs_site_uses_s.nextval

2345: ,LAST_UPDATE_LOGIN
2346: )
2347: (
2348: Select
2349: rrs_site_uses_s.nextval
2350: ,B.SITE_ID
2351: ,A.SITE_USE_TYPE_CODE
2352: ,'A'
2353: ,'Y'

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 2788: ,p_destination_table_name => 'RRS_SITE_USES'

2784: ,p_column_name => 'SITE_USE_TYPE_CODE'
2785: ,p_message_name => 'MESSAGE NAME'
2786: ,p_message_text => 'Site Use Type Code ( Purpose ) Code cannot be changed for : '||site_data.site_id_num_intf
2787: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2788: ,p_destination_table_name => 'RRS_SITE_USES'
2789: ,p_process_status => '3'
2790: ,p_transaction_type => site_data.transaction_type_intf
2791: ,p_batch_id => site_data.batch_id
2792: ,p_processing_errors => local_processing_errors

Line 3484: insert into RRS_SITE_USES(

3480: and C.Transaction_type = G_TX_TYPE_UPDATE )
3481: AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);
3482:
3483:
3484: insert into RRS_SITE_USES(
3485: SITE_USE_ID
3486: ,SITE_ID
3487: ,SITE_USE_TYPE_CODE
3488: ,STATUS_CODE

Line 3499: rrs_site_uses_s.nextval

3495: ,LAST_UPDATE_LOGIN
3496: )
3497: (
3498: Select
3499: rrs_site_uses_s.nextval
3500: ,B.SITE_ID
3501: ,SITE_USE_TYPE_CODE
3502: ,'A'
3503: ,'Y'

Line 3517: from RRS_SITE_USES C

3513: and process_status = G_PS_IN_PROCESS
3514: and A.SITE_USE_TYPE_CODE is NOT NULL
3515: and A.site_identification_number = B.site_identification_number
3516: and NOT EXISTS ( select C.site_id
3517: from RRS_SITE_USES C
3518: where B.Site_id = C.Site_id )
3519: );
3520:
3521: