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.PAY_MAGTAPE_GENERIC dependencies on PAY_MAGNETIC_RECORDS

Line 27: formula_next_block pay_magnetic_records.next_block_id%TYPE;

23: int_prm_names pay_mag_tape.host_array;
24: int_prm_values pay_mag_tape.host_array;
25: --
26: -- Formula level details
27: formula_next_block pay_magnetic_records.next_block_id%TYPE;
28: formula_id pay_magnetic_records.formula_id%TYPE;
29: formula_frequency pay_magnetic_records.frequency%TYPE;
30: formula_overflow pay_magnetic_records.overflow_mode%TYPE;
31: formula_inter_repeat pay_magnetic_records.last_run_executed_mode%TYPE;

Line 28: formula_id pay_magnetic_records.formula_id%TYPE;

24: int_prm_values pay_mag_tape.host_array;
25: --
26: -- Formula level details
27: formula_next_block pay_magnetic_records.next_block_id%TYPE;
28: formula_id pay_magnetic_records.formula_id%TYPE;
29: formula_frequency pay_magnetic_records.frequency%TYPE;
30: formula_overflow pay_magnetic_records.overflow_mode%TYPE;
31: formula_inter_repeat pay_magnetic_records.last_run_executed_mode%TYPE;
32: formula_action_level pay_magnetic_records.action_level%TYPE;

Line 29: formula_frequency pay_magnetic_records.frequency%TYPE;

25: --
26: -- Formula level details
27: formula_next_block pay_magnetic_records.next_block_id%TYPE;
28: formula_id pay_magnetic_records.formula_id%TYPE;
29: formula_frequency pay_magnetic_records.frequency%TYPE;
30: formula_overflow pay_magnetic_records.overflow_mode%TYPE;
31: formula_inter_repeat pay_magnetic_records.last_run_executed_mode%TYPE;
32: formula_action_level pay_magnetic_records.action_level%TYPE;
33: formula_block_label pay_magnetic_records.block_label%TYPE;

Line 30: formula_overflow pay_magnetic_records.overflow_mode%TYPE;

26: -- Formula level details
27: formula_next_block pay_magnetic_records.next_block_id%TYPE;
28: formula_id pay_magnetic_records.formula_id%TYPE;
29: formula_frequency pay_magnetic_records.frequency%TYPE;
30: formula_overflow pay_magnetic_records.overflow_mode%TYPE;
31: formula_inter_repeat pay_magnetic_records.last_run_executed_mode%TYPE;
32: formula_action_level pay_magnetic_records.action_level%TYPE;
33: formula_block_label pay_magnetic_records.block_label%TYPE;
34: formula_block_row_label pay_magnetic_records.block_row_label%TYPE;

Line 31: formula_inter_repeat pay_magnetic_records.last_run_executed_mode%TYPE;

27: formula_next_block pay_magnetic_records.next_block_id%TYPE;
28: formula_id pay_magnetic_records.formula_id%TYPE;
29: formula_frequency pay_magnetic_records.frequency%TYPE;
30: formula_overflow pay_magnetic_records.overflow_mode%TYPE;
31: formula_inter_repeat pay_magnetic_records.last_run_executed_mode%TYPE;
32: formula_action_level pay_magnetic_records.action_level%TYPE;
33: formula_block_label pay_magnetic_records.block_label%TYPE;
34: formula_block_row_label pay_magnetic_records.block_row_label%TYPE;
35: xml_proc_name pay_magnetic_records.xml_proc_name%TYPE;

Line 32: formula_action_level pay_magnetic_records.action_level%TYPE;

28: formula_id pay_magnetic_records.formula_id%TYPE;
29: formula_frequency pay_magnetic_records.frequency%TYPE;
30: formula_overflow pay_magnetic_records.overflow_mode%TYPE;
31: formula_inter_repeat pay_magnetic_records.last_run_executed_mode%TYPE;
32: formula_action_level pay_magnetic_records.action_level%TYPE;
33: formula_block_label pay_magnetic_records.block_label%TYPE;
34: formula_block_row_label pay_magnetic_records.block_row_label%TYPE;
35: xml_proc_name pay_magnetic_records.xml_proc_name%TYPE;
36: rec_sequence pay_magnetic_records.sequence%TYPE;

Line 33: formula_block_label pay_magnetic_records.block_label%TYPE;

29: formula_frequency pay_magnetic_records.frequency%TYPE;
30: formula_overflow pay_magnetic_records.overflow_mode%TYPE;
31: formula_inter_repeat pay_magnetic_records.last_run_executed_mode%TYPE;
32: formula_action_level pay_magnetic_records.action_level%TYPE;
33: formula_block_label pay_magnetic_records.block_label%TYPE;
34: formula_block_row_label pay_magnetic_records.block_row_label%TYPE;
35: xml_proc_name pay_magnetic_records.xml_proc_name%TYPE;
36: rec_sequence pay_magnetic_records.sequence%TYPE;
37: return_arr_offset number;

Line 34: formula_block_row_label pay_magnetic_records.block_row_label%TYPE;

30: formula_overflow pay_magnetic_records.overflow_mode%TYPE;
31: formula_inter_repeat pay_magnetic_records.last_run_executed_mode%TYPE;
32: formula_action_level pay_magnetic_records.action_level%TYPE;
33: formula_block_label pay_magnetic_records.block_label%TYPE;
34: formula_block_row_label pay_magnetic_records.block_row_label%TYPE;
35: xml_proc_name pay_magnetic_records.xml_proc_name%TYPE;
36: rec_sequence pay_magnetic_records.sequence%TYPE;
37: return_arr_offset number;
38: --

Line 35: xml_proc_name pay_magnetic_records.xml_proc_name%TYPE;

31: formula_inter_repeat pay_magnetic_records.last_run_executed_mode%TYPE;
32: formula_action_level pay_magnetic_records.action_level%TYPE;
33: formula_block_label pay_magnetic_records.block_label%TYPE;
34: formula_block_row_label pay_magnetic_records.block_row_label%TYPE;
35: xml_proc_name pay_magnetic_records.xml_proc_name%TYPE;
36: rec_sequence pay_magnetic_records.sequence%TYPE;
37: return_arr_offset number;
38: --
39: --

Line 36: rec_sequence pay_magnetic_records.sequence%TYPE;

32: formula_action_level pay_magnetic_records.action_level%TYPE;
33: formula_block_label pay_magnetic_records.block_label%TYPE;
34: formula_block_row_label pay_magnetic_records.block_row_label%TYPE;
35: xml_proc_name pay_magnetic_records.xml_proc_name%TYPE;
36: rec_sequence pay_magnetic_records.sequence%TYPE;
37: return_arr_offset number;
38: --
39: --
40:

Line 223: temp_formula_block_label pay_magnetic_records.block_label%TYPE;

219: IS
220: found boolean;
221: cnt number;
222: no_rows number;
223: temp_formula_block_label pay_magnetic_records.block_label%TYPE;
224: temp_formula_block_row_label pay_magnetic_records.block_row_label%TYPE;
225: i number;
226: prm_cnt number;
227:

Line 224: temp_formula_block_row_label pay_magnetic_records.block_row_label%TYPE;

220: found boolean;
221: cnt number;
222: no_rows number;
223: temp_formula_block_label pay_magnetic_records.block_label%TYPE;
224: temp_formula_block_row_label pay_magnetic_records.block_row_label%TYPE;
225: i number;
226: prm_cnt number;
227:
228: /* Function tab_is_open

Line 404: from pay_magnetic_records pmr

400: hr_utility.trace('Entering pay_magtape_generic.is_intermediate_required');
401: end if;
402: select 'M'
403: into dummy
404: from pay_magnetic_records pmr
405: where pmr.magnetic_block_id = block_id(level_no)
406: and pmr.last_run_executed_mode in ('A', 'R', 'F');
407: --
408: return TRUE;

Line 443: ' from pay_magnetic_records '||

439: statem := 'select formula_id, next_block_id,'||
440: ' frequency, overflow_mode, '||
441: 'last_run_executed_mode, action_level ,'||
442: 'block_label,block_row_label,xml_proc_name,sequence '||
443: ' from pay_magnetic_records '||
444: 'where magnetic_block_id = '||block||
445: ' order by sequence';
446: dbms_sql.parse(sql_cur,
447: statem,

Line 516: 'from pay_magnetic_records '||

512: statem := 'select formula_id,next_block_id,'||
513: 'frequency,overflow_mode,'||
514: 'last_run_executed_mode,action_level,'||
515: 'block_label,block_row_label,xml_proc_name,sequence '||
516: 'from pay_magnetic_records '||
517: 'where magnetic_block_id='||block||
518: ' and last_run_executed_mode in (''R'',''A'',''F'')'||
519: ' order by sequence';
520: dbms_sql.parse(sql_cur,