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.PSP_ARCHIVE_RETRIEVE dependencies on PSP_DISTRIBUTION_INT_ARCH

Line 1957: INTO psp_distribution_int_arch (distribution_interface_id

1953: -- Transferring data to archive table
1954:
1955: FORALL k IN 1 .. r_batch_rec.t_distribution_interface_id.COUNT
1956: INSERT
1957: INTO psp_distribution_int_arch (distribution_interface_id
1958: , person_id
1959: , assignment_id
1960: , element_type_id
1961: , distribution_date

Line 2173: SELECT/+INDEX (pdia PSP_DISTRIBUTION_INT_ARCH_N1)/ pdia.ROWID

2169:
2170: -- Cursor selects the archived records from the interface table for the batches which were picked based on the arch request id.
2171:
2172: CURSOR batch_cur(p_batch_name VARCHAR2) IS
2173: SELECT/*+INDEX (pdia PSP_DISTRIBUTION_INT_ARCH_N1)*/ pdia.ROWID
2174: ,distribution_interface_id
2175: ,person_id
2176: ,assignment_id
2177: ,element_type_id

Line 2222: FROM psp_distribution_int_arch pdia,psp_arch_ret_requests parr

2218: ,suspense_org_account_id
2219: ,currency_code
2220: ,suspense_auto_glccid
2221: ,suspense_auto_exp_type
2222: FROM psp_distribution_int_arch pdia,psp_arch_ret_requests parr
2223: WHERE parr.request_id = p_arch_request_id
2224: AND parr.batch_name = p_batch_name
2225: AND pdia.request_id = parr.request_id
2226: AND pdia.batch_name = parr.batch_name;

Line 2238: TYPE batch_tab_type IS TABLE OF psp_distribution_int_arch%ROWTYPE INDEX BY PLS_INTEGER;

2234:
2235: l_valid_batch_exists BOOLEAN := false;
2236:
2237:
2238: TYPE batch_tab_type IS TABLE OF psp_distribution_int_arch%ROWTYPE INDEX BY PLS_INTEGER;
2239:
2240:
2241: TYPE t_num_15_type IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
2242: TYPE t_varchar_50_type IS TABLE OF VARCHAR2(50) INDEX BY BINARY_INTEGER;

Line 2249: TYPE t_batch_name_type IS TABLE OF psp_distribution_int_arch.batch_name%TYPE INDEX BY PLS_INTEGER;

2245: TYPE t_date_type IS TABLE OF DATE INDEX BY BINARY_INTEGER;
2246: TYPE t_num_15d2_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
2247:
2248:
2249: TYPE t_batch_name_type IS TABLE OF psp_distribution_int_arch.batch_name%TYPE INDEX BY PLS_INTEGER;
2250:
2251: -- Record type to store batch information
2252: TYPE batch_name_rec_type IS RECORD (batch_name T_BATCH_NAME_TYPE,batch_size T_NUM_15_TYPE,min_dist_date T_DATE_TYPE,max_dist_date T_DATE_TYPE);
2253:

Line 2570: DELETE FROM psp_distribution_int_arch

2566:
2567: -- Deletes the records from the archive table once the records get created in main table.
2568:
2569: FORALL k IN 1..r_batch_rec.t_distribution_interface_id.COUNT
2570: DELETE FROM psp_distribution_int_arch
2571: WHERE ROWID = r_batch_rec.T_row_id(k);
2572:
2573: g_bulk_row_count :=0;
2574: FOR bulk_idx IN 1..r_batch_rec.t_distribution_interface_id.COUNT