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_PROCESSING_ERRORS_TAB

Line 37: local_processing_errors rrs_processing_errors_tab;

33:
34:
35:
36:
37: local_processing_errors rrs_processing_errors_tab;
38:
39:
40: Procedure main(
41: ERRBUF OUT NOCOPY VARCHAR2

Line 287: local_processing_errors rrs_processing_errors_tab;

283: );
284: Type rrs_site_counts_tab is Table of rrs_site_counts_rec;
285: l_site_counts rrs_site_counts_tab;
286:
287: local_processing_errors rrs_processing_errors_tab;
288: p_processing_errors rrs_processing_errors_tab;
289: l_msg VARCHAR2(1000);
290:
291: begin

Line 288: p_processing_errors rrs_processing_errors_tab;

284: Type rrs_site_counts_tab is Table of rrs_site_counts_rec;
285: l_site_counts rrs_site_counts_tab;
286:
287: local_processing_errors rrs_processing_errors_tab;
288: p_processing_errors rrs_processing_errors_tab;
289: l_msg VARCHAR2(1000);
290:
291: begin
292:

Line 293: p_processing_errors := rrs_processing_errors_tab();

289: l_msg VARCHAR2(1000);
290:
291: begin
292:
293: p_processing_errors := rrs_processing_errors_tab();
294: local_processing_errors := rrs_processing_errors_tab();
295:
296:
297: SELECT SITE_IDENTIFICATION_NUMBER , count(*)

Line 294: local_processing_errors := rrs_processing_errors_tab();

290:
291: begin
292:
293: p_processing_errors := rrs_processing_errors_tab();
294: local_processing_errors := rrs_processing_errors_tab();
295:
296:
297: SELECT SITE_IDENTIFICATION_NUMBER , count(*)
298: BULK COLLECT

Line 460: local_processing_errors rrs_processing_errors_tab;

456: and BATCH_ID = l_batch_id
457: and Process_status = G_PS_IN_PROCESS;
458:
459:
460: local_processing_errors rrs_processing_errors_tab;
461: p_processing_errors rrs_processing_errors_tab;
462:
463: p_init_msg_list varchar2(1) := 'T';
464: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

Line 461: p_processing_errors rrs_processing_errors_tab;

457: and Process_status = G_PS_IN_PROCESS;
458:
459:
460: local_processing_errors rrs_processing_errors_tab;
461: p_processing_errors rrs_processing_errors_tab;
462:
463: p_init_msg_list varchar2(1) := 'T';
464: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
465: p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

Line 617: p_processing_errors := rrs_processing_errors_tab();

613:
614:
615: FOR site_data IN c_new_interface_row(l_batch_id) LOOP
616:
617: p_processing_errors := rrs_processing_errors_tab();
618: local_processing_errors := rrs_processing_errors_tab();
619:
620: l_row_status := 'S';
621: l_create_party := 'N';

Line 618: local_processing_errors := rrs_processing_errors_tab();

614:
615: FOR site_data IN c_new_interface_row(l_batch_id) LOOP
616:
617: p_processing_errors := rrs_processing_errors_tab();
618: local_processing_errors := rrs_processing_errors_tab();
619:
620: l_row_status := 'S';
621: l_create_party := 'N';
622: l_create_location := 'N';

Line 2104: p_processing_errors IN RRS_PROCESSING_ERRORS_TAB

2100:
2101:
2102:
2103: Procedure Write_interface_errors(
2104: p_processing_errors IN RRS_PROCESSING_ERRORS_TAB
2105: )is
2106: conc_status Boolean;
2107: begin
2108:

Line 2156: ,p_processing_errors IN OUT NOCOPY RRS_PROCESSING_ERRORS_TAB

2152: ,p_destination_table_name IN varchar2
2153: ,p_process_status IN varchar2
2154: ,p_transaction_type IN varchar2
2155: ,p_batch_id IN number
2156: ,p_processing_errors IN OUT NOCOPY RRS_PROCESSING_ERRORS_TAB
2157: )is
2158: begin
2159:
2160:

Line 2544: local_processing_errors rrs_processing_errors_tab;

2540: and h.location_id = b.location_id
2541: and a.site_identification_number = b.site_identification_number;
2542:
2543:
2544: local_processing_errors rrs_processing_errors_tab;
2545: p_processing_errors rrs_processing_errors_tab;
2546:
2547: p_init_msg_list varchar2(1) := 'T';
2548: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

Line 2545: p_processing_errors rrs_processing_errors_tab;

2541: and a.site_identification_number = b.site_identification_number;
2542:
2543:
2544: local_processing_errors rrs_processing_errors_tab;
2545: p_processing_errors rrs_processing_errors_tab;
2546:
2547: p_init_msg_list varchar2(1) := 'T';
2548: l_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;
2549: p_location_rec HZ_LOCATION_V2PUB.LOCATION_REC_TYPE;

Line 2624: p_processing_errors := rrs_processing_errors_tab();

2620:
2621: FOR site_data IN c_update_interface_row(l_batch_id) LOOP
2622:
2623:
2624: p_processing_errors := rrs_processing_errors_tab();
2625: local_processing_errors := rrs_processing_errors_tab();
2626:
2627: l_row_status := 'S';
2628: l_create_party := 'N';

Line 2625: local_processing_errors := rrs_processing_errors_tab();

2621: FOR site_data IN c_update_interface_row(l_batch_id) LOOP
2622:
2623:
2624: p_processing_errors := rrs_processing_errors_tab();
2625: local_processing_errors := rrs_processing_errors_tab();
2626:
2627: l_row_status := 'S';
2628: l_create_party := 'N';
2629: l_update_location := 'N';