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.

APPS.RRS_IMPORT_INTERFACE_PKG dependencies on RRS_SITES_B

Line 325: ,p_destination_table_name => 'RRS_SITES_B'

321: ,p_message_name => 'MESSAGE NAME'
322: -- ,p_message_text => 'This Batch has multiple rows with same Site Identification Number : '||l_site_counts(1).site_identification_number|| ' , Modify the batch.'
323: ,p_message_text => l_msg
324: ,p_source_table_name => 'RRS_SITES_INTERFACE'
325: ,p_destination_table_name => 'RRS_SITES_B'
326: ,p_process_status => '3'
327: ,p_transaction_type => G_TX_TYPE_CREATE
328: ,p_batch_id => p_batch_id
329: ,p_processing_errors => local_processing_errors

Line 498: Type rrs_site_id_rec is RECORD (site_id RRS_SITES_B.SITE_ID%TYPE);

494: l_geo_source varchar2(30);
495: l_db_geo_source varchar2(30);
496: l_upd_geo_data varchar2(1);
497:
498: Type rrs_site_id_rec is RECORD (site_id RRS_SITES_B.SITE_ID%TYPE);
499: Type rrs_site_id_tab is TABLE OF NUMBER;
500: s_site_ids rrs_site_id_tab;
501:
502: x_num_rows number;

Line 649: ,p_destination_table_name => 'RRS_SITES_B'

645: ,p_message_name => 'MESSAGE NAME'
646: -- ,p_message_text => 'This Site Identification Number already exists, Enter a new number.'
647: ,p_message_text => l_msg
648: ,p_source_table_name => 'RRS_SITES_INTERFACE'
649: ,p_destination_table_name => 'RRS_SITES_B'
650: ,p_process_status => '3'
651: ,p_transaction_type => site_data.transaction_type
652: ,p_batch_id => site_data.batch_id
653: ,p_processing_errors => local_processing_errors

Line 704: ,p_destination_table_name => 'RRS_SITES_B'

700: ,p_message_name => 'MESSAGE NAME'
701: -- ,p_message_text => 'Site Status code is not valid for site_id : '||site_data.site_identification_number
702: ,p_message_text => l_msg
703: ,p_source_table_name => 'RRS_SITES_INTERFACE'
704: ,p_destination_table_name => 'RRS_SITES_B'
705: ,p_process_status => '3'
706: ,p_transaction_type => site_data.transaction_type
707: ,p_batch_id => site_data.batch_id
708: ,p_processing_errors => local_processing_errors

Line 727: ,p_destination_table_name => 'RRS_SITES_B'

723: ,p_message_name => 'MESSAGE NAME'
724: -- ,p_message_text => 'Site Status code cannot be null for site_id : '||site_data.site_identification_number
725: ,p_message_text => l_msg
726: ,p_source_table_name => 'RRS_SITES_INTERFACE'
727: ,p_destination_table_name => 'RRS_SITES_B'
728: ,p_process_status => '3'
729: ,p_transaction_type => site_data.transaction_type
730: ,p_batch_id => site_data.batch_id
731: ,p_processing_errors => local_processing_errors

Line 762: ,p_destination_table_name => 'RRS_SITES_B'

758: ,p_message_name => 'MESSAGE NAME'
759: -- ,p_message_text => 'Brandname Code validation fails for : '||site_data.site_identification_number
760: ,p_message_text => l_msg
761: ,p_source_table_name => 'RRS_SITES_INTERFACE'
762: ,p_destination_table_name => 'RRS_SITES_B'
763: ,p_process_status => '3'
764: ,p_transaction_type => site_data.transaction_type
765: ,p_batch_id => site_data.batch_id
766: ,p_processing_errors => local_processing_errors

Line 796: ,p_destination_table_name => 'RRS_SITES_B'

792: ,p_message_name => 'MESSAGE NAME'
793: -- ,p_message_text => 'Calendar Code validation fails for : '||site_data.site_identification_number
794: ,p_message_text => l_msg
795: ,p_source_table_name => 'RRS_SITES_INTERFACE'
796: ,p_destination_table_name => 'RRS_SITES_B'
797: ,p_process_status => '3'
798: ,p_transaction_type => site_data.transaction_type
799: ,p_batch_id => site_data.batch_id
800: ,p_processing_errors => local_processing_errors

Line 1254: ,p_destination_table_name => 'RRS_SITES_B'

1250: ,p_message_name => 'MESSAGE NAME'
1251: -- ,p_message_text => 'Site type code cannot be null for site_id : '||site_data.site_identification_number
1252: ,p_message_text => l_msg
1253: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1254: ,p_destination_table_name => 'RRS_SITES_B'
1255: ,p_process_status => '3'
1256: ,p_transaction_type => site_data.transaction_type
1257: ,p_batch_id => site_data.batch_id
1258: ,p_processing_errors => local_processing_errors

Line 1285: ,p_destination_table_name => 'RRS_SITES_B'

1281: ,p_message_name => 'MESSAGE NAME'
1282: -- ,p_message_text => 'Site type code validation fails for : '||site_data.site_identification_number
1283: ,p_message_text => l_msg
1284: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1285: ,p_destination_table_name => 'RRS_SITES_B'
1286: ,p_process_status => '3'
1287: ,p_transaction_type => site_data.transaction_type
1288: ,p_batch_id => site_data.batch_id
1289: ,p_processing_errors => local_processing_errors

Line 1305: ,p_destination_table_name => 'RRS_SITES_B'

1301: ,p_column_name => 'SITE_PARTY_ID'
1302: ,p_message_name => 'MESSAGE NAME'
1303: ,p_message_text => 'Site type code and External party validation fails for : '||site_data.site_identification_number
1304: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1305: ,p_destination_table_name => 'RRS_SITES_B'
1306: ,p_process_status => '3'
1307: ,p_transaction_type => site_data.transaction_type
1308: ,p_batch_id => site_data.batch_id
1309: ,p_processing_errors => local_processing_errors

Line 1331: ,p_destination_table_name => 'RRS_SITES_B'

1327: ,p_column_name => 'SITE_PARTY_ID'
1328: ,p_message_name => 'MESSAGE NAME'
1329: ,p_message_text => 'Site type code and External party validation fails for : '||site_data.site_identification_number
1330: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1331: ,p_destination_table_name => 'RRS_SITES_B'
1332: ,p_process_status => '3'
1333: ,p_transaction_type => site_data.transaction_type
1334: ,p_batch_id => site_data.batch_id
1335: ,p_processing_errors => local_processing_errors

Line 1348: ,p_destination_table_name => 'RRS_SITES_B'

1344: ,p_column_name => 'SITE_PARTY_ID'
1345: ,p_message_name => 'MESSAGE NAME'
1346: ,p_message_text => 'Site type code and External party validation fails for : '||site_data.site_identification_number
1347: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1348: ,p_destination_table_name => 'RRS_SITES_B'
1349: ,p_process_status => '3'
1350: ,p_transaction_type => site_data.transaction_type
1351: ,p_batch_id => site_data.batch_id
1352: ,p_processing_errors => local_processing_errors

Line 1378: ,p_destination_table_name => 'RRS_SITES_B'

1374: ,p_column_name => 'LE_PARTY_ID'
1375: ,p_message_name => 'MESSAGE NAME'
1376: ,p_message_text => 'Site type code and LE party validation fails for : '||site_data.site_identification_number
1377: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1378: ,p_destination_table_name => 'RRS_SITES_B'
1379: ,p_process_status => '3'
1380: ,p_transaction_type => site_data.transaction_type
1381: ,p_batch_id => site_data.batch_id
1382: ,p_processing_errors => local_processing_errors

Line 1395: ,p_destination_table_name => 'RRS_SITES_B'

1391: ,p_column_name => 'LE_PARTY_ID'
1392: ,p_message_name => 'MESSAGE NAME'
1393: ,p_message_text => 'Site type code and LE party validation fails for : '||site_data.site_identification_number
1394: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1395: ,p_destination_table_name => 'RRS_SITES_B'
1396: ,p_process_status => '3'
1397: ,p_transaction_type => site_data.transaction_type
1398: ,p_batch_id => site_data.batch_id
1399: ,p_processing_errors => local_processing_errors

Line 1497: ,p_destination_table_name => 'RRS_SITES_B'

1493: ,p_column_name => 'SITE_PARTY_ID'
1494: ,p_message_name => 'MESSAGE NAME'
1495: ,p_message_text => 'Error Creating the Party for : '||site_data.site_identification_number
1496: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1497: ,p_destination_table_name => 'RRS_SITES_B'
1498: ,p_process_status => '3'
1499: ,p_transaction_type => site_data.transaction_type
1500: ,p_batch_id => site_data.batch_id
1501: ,p_processing_errors => local_processing_errors

Line 1548: ,p_destination_table_name => 'RRS_SITES_B'

1544: ,p_column_name => 'PARTY_SITE_ID'
1545: ,p_message_name => 'MESSAGE NAME'
1546: ,p_message_text => 'Error Creating the Party Site for : '||site_data.site_identification_number
1547: ,p_source_table_name => 'RRS_SITES_INTERFACE'
1548: ,p_destination_table_name => 'RRS_SITES_B'
1549: ,p_process_status => '3'
1550: ,p_transaction_type => site_data.transaction_type
1551: ,p_batch_id => site_data.batch_id
1552: ,p_processing_errors => local_processing_errors

Line 1713: from rrs_sites_b

1709:
1710: Begin
1711: select 'E'
1712: into x_return_flag
1713: from rrs_sites_b
1714: where site_identification_number = p_site_id_num;
1715: exception
1716: when no_data_found then
1717: x_return_flag := 'S';

Line 1725: from rrs_sites_b

1721:
1722: Begin
1723: select 'S'
1724: into x_return_flag
1725: from rrs_sites_b
1726: where site_identification_number = p_site_id_num;
1727: exception
1728: when no_data_found then
1729: x_return_flag := 'E';

Line 1737: from rrs_sites_b

1733:
1734: Begin
1735: select 'S'
1736: into x_return_flag
1737: from rrs_sites_b
1738: where site_id = p_site_id;
1739: exception
1740: when no_data_found then
1741: null;

Line 2199: from RRS_SITES_B RSB , RRS_SITES_INTERFACE RSI

2195: )is
2196:
2197: cursor c_new_sites (p_batch_id number ) is
2198: Select RSB.Site_identification_number,RSB.site_id
2199: from RRS_SITES_B RSB , RRS_SITES_INTERFACE RSI
2200: where RSB.site_identification_number = RSI.site_identification_number
2201: and RSI.batch_id = p_batch_id
2202: and RSI.process_status = G_PS_IN_PROCESS
2203: and RSI.transaction_type = G_TX_TYPE_CREATE;

Line 2226: insert into rrs_sites_b

2222: * ************************************************/
2223:
2224: Begin
2225:
2226: insert into rrs_sites_b
2227: (
2228: SITE_ID
2229: ,SITE_IDENTIFICATION_NUMBER
2230: ,SITE_TYPE_CODE

Line 2303: From RRS_SITES_INTERFACE A ,RRS_SITES_B B, FND_LANGUAGES L

2299: ,a.LAST_UPDATED_BY
2300: ,SYSDATE
2301: ,a.LAST_UPDATE_LOGIN
2302: ,NULL
2303: From RRS_SITES_INTERFACE A ,RRS_SITES_B B, FND_LANGUAGES L
2304: where batch_id = p_batch_id
2305: and transaction_type = G_TX_TYPE_CREATE
2306: and process_status = G_PS_IN_PROCESS
2307: and A.site_identification_number = b.site_identification_number

Line 2360: From RRS_SITES_INTERFACE A ,RRS_SITES_B B

2356: ,SYSDATE
2357: ,G_USER_ID
2358: ,SYSDATE
2359: ,G_LOGIN_ID
2360: From RRS_SITES_INTERFACE A ,RRS_SITES_B B
2361: where batch_id = p_batch_id
2362: and transaction_type = G_TX_TYPE_CREATE
2363: and process_status = G_PS_IN_PROCESS
2364: and A.SITE_USE_TYPE_CODE is NOT NULL

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 2578: Type rrs_site_id_rec is RECORD (site_id RRS_SITES_B.SITE_ID%TYPE);

2574:
2575: l_update_location varchar2(1);
2576: l_create_party varchar2(1);
2577:
2578: Type rrs_site_id_rec is RECORD (site_id RRS_SITES_B.SITE_ID%TYPE);
2579: Type rrs_site_id_tab is TABLE OF NUMBER;
2580: s_site_ids rrs_site_id_tab;
2581:
2582: x_num_rows number;

Line 2651: ,p_destination_table_name => 'RRS_SITES_B'

2647: ,p_column_name => 'SITE_IDENTIFICATION_NUMBER'
2648: ,p_message_name => 'MESSAGE NAME'
2649: ,p_message_text => 'Site Identification Number '||site_data.site_id_num_intf||' does not exist, Enter an existing number.'
2650: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2651: ,p_destination_table_name => 'RRS_SITES_B'
2652: ,p_process_status => '3'
2653: ,p_transaction_type => site_data.transaction_type_intf
2654: ,p_batch_id => site_data.batch_id
2655: ,p_processing_errors => local_processing_errors

Line 2694: ,p_destination_table_name => 'RRS_SITES_B'

2690: ,p_column_name => 'SITE_STATUS_CODE'
2691: ,p_message_name => 'MESSAGE NAME'
2692: ,p_message_text => 'Site Status code is not valid for site_id : '||site_data.site_identification_number
2693: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2694: ,p_destination_table_name => 'RRS_SITES_B'
2695: ,p_process_status => '3'
2696: ,p_transaction_type => site_data.transaction_type_intf
2697: ,p_batch_id => site_data.batch_id
2698: ,p_processing_errors => local_processing_errors

Line 2711: ,p_destination_table_name => 'RRS_SITES_B'

2707: ,p_column_name => 'SITE_STATUS_CODE'
2708: ,p_message_name => 'MESSAGE NAME'
2709: ,p_message_text => 'Site Status code cannot be null for site_id : '||site_data.site_id_num_intf
2710: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2711: ,p_destination_table_name => 'RRS_SITES_B'
2712: ,p_process_status => '3'
2713: ,p_transaction_type => site_data.transaction_type_intf
2714: ,p_batch_id => site_data.batch_id
2715: ,p_processing_errors => local_processing_errors

Line 2738: ,p_destination_table_name => 'RRS_SITES_B'

2734: ,p_column_name => 'BRANDNAME_CODE'
2735: ,p_message_name => 'MESSAGE NAME'
2736: ,p_message_text => 'Brandname Code validation fails for : '||site_data.site_id_num_intf
2737: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2738: ,p_destination_table_name => 'RRS_SITES_B'
2739: ,p_process_status => '3'
2740: ,p_transaction_type => site_data.transaction_type_intf
2741: ,p_batch_id => site_data.batch_id
2742: ,p_processing_errors => local_processing_errors

Line 2766: ,p_destination_table_name => 'RRS_SITES_B'

2762: ,p_column_name => 'CALENDAR_CODE'
2763: ,p_message_name => 'MESSAGE NAME'
2764: ,p_message_text => 'Calendar Code validation fails for : '||site_data.site_id_num_intf
2765: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2766: ,p_destination_table_name => 'RRS_SITES_B'
2767: ,p_process_status => '3'
2768: ,p_transaction_type => site_data.transaction_type_intf
2769: ,p_batch_id => site_data.batch_id
2770: ,p_processing_errors => local_processing_errors

Line 2988: ,p_destination_table_name => 'RRS_SITES_B'

2984: ,p_column_name => 'SITE_TYPE_CODE'
2985: ,p_message_name => 'MESSAGE NAME'
2986: ,p_message_text => 'Site type code cannot be null for site_id : '||site_data.site_id_num_intf
2987: ,p_source_table_name => 'RRS_SITES_INTERFACE'
2988: ,p_destination_table_name => 'RRS_SITES_B'
2989: ,p_process_status => '3'
2990: ,p_transaction_type => site_data.transaction_type_intf
2991: ,p_batch_id => site_data.batch_id
2992: ,p_processing_errors => local_processing_errors

Line 3004: ,p_destination_table_name => 'RRS_SITES_B'

3000: ,p_column_name => 'SITE_TYPE_CODE'
3001: ,p_message_name => 'MESSAGE NAME'
3002: ,p_message_text => 'Site type code cannot be changed for site_id : '||site_data.site_id_num_intf
3003: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3004: ,p_destination_table_name => 'RRS_SITES_B'
3005: ,p_process_status => '3'
3006: ,p_transaction_type => site_data.transaction_type_intf
3007: ,p_batch_id => site_data.batch_id
3008: ,p_processing_errors => local_processing_errors

Line 3021: ,p_destination_table_name => 'RRS_SITES_B'

3017: ,p_column_name => 'SITE_TYPE_CODE'
3018: ,p_message_name => 'MESSAGE NAME'
3019: ,p_message_text => 'Site type code cannot be changed for site_id : '||site_data.site_id_num_intf
3020: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3021: ,p_destination_table_name => 'RRS_SITES_B'
3022: ,p_process_status => '3'
3023: ,p_transaction_type => site_data.transaction_type_intf
3024: ,p_batch_id => site_data.batch_id
3025: ,p_processing_errors => local_processing_errors

Line 3038: ,p_destination_table_name => 'RRS_SITES_B'

3034: ,p_column_name => 'SITE_PARTY_ID'
3035: ,p_message_name => 'MESSAGE NAME'
3036: ,p_message_text => 'Site Party ID cannot be changed for : '||site_data.site_id_num_intf
3037: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3038: ,p_destination_table_name => 'RRS_SITES_B'
3039: ,p_process_status => '3'
3040: ,p_transaction_type => site_data.transaction_type_intf
3041: ,p_batch_id => site_data.batch_id
3042: ,p_processing_errors => local_processing_errors

Line 3064: ,p_destination_table_name => 'RRS_SITES_B'

3060: ,p_column_name => 'SITE_PARTY_ID'
3061: ,p_message_name => 'MESSAGE NAME'
3062: ,p_message_text => 'Site type code and External party validation fails for : '||site_data.site_id_num_intf
3063: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3064: ,p_destination_table_name => 'RRS_SITES_B'
3065: ,p_process_status => '3'
3066: ,p_transaction_type => site_data.transaction_type_intf
3067: ,p_batch_id => site_data.batch_id
3068: ,p_processing_errors => local_processing_errors

Line 3081: ,p_destination_table_name => 'RRS_SITES_B'

3077: ,p_column_name => 'LE_PARTY_ID'
3078: ,p_message_name => 'MESSAGE NAME'
3079: ,p_message_text => 'LE Party ID cannot be changed for : '||site_data.site_id_num_intf
3080: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3081: ,p_destination_table_name => 'RRS_SITES_B'
3082: ,p_process_status => '3'
3083: ,p_transaction_type => site_data.transaction_type_intf
3084: ,p_batch_id => site_data.batch_id
3085: ,p_processing_errors => local_processing_errors

Line 3107: ,p_destination_table_name => 'RRS_SITES_B'

3103: ,p_column_name => 'LE_PARTY_ID'
3104: ,p_message_name => 'MESSAGE NAME'
3105: ,p_message_text => 'Site type code and LE party validation fails for : '||site_data.site_id_num_intf
3106: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3107: ,p_destination_table_name => 'RRS_SITES_B'
3108: ,p_process_status => '3'
3109: ,p_transaction_type => site_data.transaction_type_intf
3110: ,p_batch_id => site_data.batch_id
3111: ,p_processing_errors => local_processing_errors

Line 3130: ,p_destination_table_name => 'RRS_SITES_B'

3126: ,p_column_name => 'LE_PARTY_ID'
3127: ,p_message_name => 'MESSAGE NAME'
3128: ,p_message_text => 'Site type code and Party validation fails for : '||site_data.site_id_num_intf
3129: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3130: ,p_destination_table_name => 'RRS_SITES_B'
3131: ,p_process_status => '3'
3132: ,p_transaction_type => site_data.transaction_type_intf
3133: ,p_batch_id => site_data.batch_id
3134: ,p_processing_errors => local_processing_errors

Line 3155: ,p_destination_table_name => 'RRS_SITES_B'

3151: ,p_column_name => 'SITE_TYPE_CODE'
3152: ,p_message_name => 'MESSAGE NAME'
3153: ,p_message_text => 'Site type code validation fails for : '||site_data.site_id_num_intf
3154: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3155: ,p_destination_table_name => 'RRS_SITES_B'
3156: ,p_process_status => '3'
3157: ,p_transaction_type => site_data.transaction_type_intf
3158: ,p_batch_id => site_data.batch_id
3159: ,p_processing_errors => local_processing_errors

Line 3181: ,p_destination_table_name => 'RRS_SITES_B'

3177: ,p_column_name => 'SITE_ID'
3178: ,p_message_name => 'MESSAGE NAME'
3179: ,p_message_text => 'User does not have View Privileges on Site : '||site_data.site_id_num_intf
3180: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3181: ,p_destination_table_name => 'RRS_SITES_B'
3182: ,p_process_status => '3'
3183: ,p_transaction_type => site_data.transaction_type_intf
3184: ,p_batch_id => site_data.batch_id
3185: ,p_processing_errors => local_processing_errors

Line 3205: ,p_destination_table_name => 'RRS_SITES_B'

3201: ,p_column_name => 'SITE_ID'
3202: ,p_message_name => 'MESSAGE NAME'
3203: ,p_message_text => 'User does not have Edit Privileges on Site : '||site_data.site_id_num_intf
3204: ,p_source_table_name => 'RRS_SITES_INTERFACE'
3205: ,p_destination_table_name => 'RRS_SITES_B'
3206: ,p_process_status => '3'
3207: ,p_transaction_type => site_data.transaction_type_intf
3208: ,p_batch_id => site_data.batch_id
3209: ,p_processing_errors => local_processing_errors

Line 3443: Update RRS_SITES_B A

3439: * Interface tables into base tables.
3440: * ************************************************/
3441:
3442:
3443: Update RRS_SITES_B A
3444: Set (
3445: A.SITE_TYPE_CODE, A.SITE_STATUS_CODE , A.BRANDNAME_CODE , A.CALENDAR_CODE , A.SITE_PARTY_ID , A.PARTY_SITE_ID ,
3446: A.LE_PARTY_ID , A.OBJECT_VERSION_NUMBER , A.LAST_UPDATED_BY , A.LAST_UPDATE_DATE
3447: ) =

Line 3468: Set Name = (select site_name from RRS_SITES_INTERFACE B, RRS_SITES_B RSB

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
3472: and B.PROCESS_STATUS = G_PS_IN_PROCESS

Line 3476: from RRS_SITES_INTERFACE C, RRS_SITES_B RSB1

3472: and B.PROCESS_STATUS = G_PS_IN_PROCESS
3473: and B.Transaction_type = G_TX_TYPE_UPDATE ),
3474: SOURCE_LANG = userenv('LANG')
3475: Where A.site_id in (select RSB1.site_id
3476: from RRS_SITES_INTERFACE C, RRS_SITES_B RSB1
3477: Where C.Batch_id = p_batch_id
3478: and RSB1.site_identification_number = C.site_identification_number
3479: and C.Process_status = G_PS_IN_PROCESS
3480: and C.Transaction_type = G_TX_TYPE_UPDATE )

Line 3510: From RRS_SITES_INTERFACE A ,RRS_SITES_B B

3506: ,SYSDATE
3507: ,A.LAST_UPDATED_BY
3508: ,SYSDATE
3509: ,A.LAST_UPDATE_LOGIN
3510: From RRS_SITES_INTERFACE A ,RRS_SITES_B B
3511: where batch_id = p_batch_id
3512: and transaction_type = G_TX_TYPE_UPDATE
3513: and process_status = G_PS_IN_PROCESS
3514: and A.SITE_USE_TYPE_CODE is NOT NULL