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.PAYPLNK dependencies on PAY_BATCH_LINES

Line 37: from pay_batch_lines bal

33: error_occurred exception;
34: --
35: cursor csr_all_lines (l_batch_id in number) is
36: select *
37: from pay_batch_lines bal
38: where bal.batch_id = l_batch_id
39: order by bal.batch_line_id
40: for update;
41: --

Line 44: from pay_batch_lines bal

40: for update;
41: --
42: cursor csr_asg_lines (l_batch_id in number, l_asg_id in number) is
43: select *
44: from pay_batch_lines bal
45: where bal.assignment_id = l_asg_id
46: and bal.batch_id = l_batch_id
47: and bal.batch_line_status not in ('T','E') /* Bug 13814081 */
48: order by bal.batch_sequence,bal.batch_line_id

Line 420: l_assignment_id pay_batch_lines.assignment_id%TYPE := null;

416: l_line_check number;
417: l_leg_line_check boolean := false;
418: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;
419: --
420: l_assignment_id pay_batch_lines.assignment_id%TYPE := null;
421: l_error_text pay_message_lines.line_text%TYPE := null;
422: l_assignment_exists varchar2(1) := null;
423: not_upper boolean := false;
424: --

Line 643: -- update pay_batch_lines bal

639: -- begin
640: -- for l_error_count in 1..g_count loop
641: -- if (g_line_record.batch_line_id = l_line_id_tbl(l_error_count)) then
642: -- --
643: -- update pay_batch_lines bal
644: -- set bal.batch_line_status =
645: -- decode(l_status_tbl(l_error_count),'F','E','V')
646: -- where current of csr_all_lines;
647: -- --

Line 665: -- update pay_batch_lines bal

661: -- hr_utility.set_location('payplnk.validate',30);
662: -- --
663: -- if l_line_match = false then
664: -- --
665: -- update pay_batch_lines bal
666: -- set bal.batch_line_status = 'V'
667: -- where current of csr_all_lines;
668: -- else
669: -- l_line_match := false;

Line 698: update pay_batch_lines

694: g_line_record.batch_line_id,
695: 'L',
696: l_error_text);
697: --
698: update pay_batch_lines
699: set batch_line_status = 'E'
700: where current of csr_all_lines;
701: else
702: --

Line 720: update pay_batch_lines

716: --
717: g_line_record.assignment_id := l_assignment_id;
718: not_upper := false;
719: --
720: update pay_batch_lines
721: set assignment_id = l_assignment_id
722: where current of csr_all_lines;
723: --
724: exception

Line 749: update pay_batch_lines

745: g_line_record.batch_line_id,
746: 'L',
747: l_error_text);
748: --
749: update pay_batch_lines
750: set batch_line_status = 'E'
751: where current of csr_all_lines;
752: --
753: end;

Line 768: update pay_batch_lines

764: asg.effective_start_date
765: and asg.effective_end_date
766: and asg.business_group_id = p_business_group_id;
767: --
768: update pay_batch_lines
769: set assignment_id = l_assignment_id
770: where current of csr_all_lines;
771: --
772: end if;

Line 796: update pay_batch_lines

792: g_line_record.batch_line_id,
793: 'L',
794: l_error_text);
795: --
796: update pay_batch_lines
797: set batch_line_status = 'E'
798: where current of csr_all_lines;
799: --
800: --

Line 822: update pay_batch_lines

818: g_line_record.batch_line_id,
819: 'L',
820: l_error_text);
821: --
822: update pay_batch_lines
823: set batch_line_status = 'E'
824: where current of csr_all_lines;
825: --
826: end;

Line 853: update pay_batch_lines

849: g_line_record.batch_line_id,
850: 'L',
851: l_error_text);
852: --
853: update pay_batch_lines
854: set batch_line_status = 'E'
855: where current of csr_all_lines;
856: --
857: --

Line 919: update pay_batch_lines

915: g_line_record.batch_line_id,
916: 'L',
917: l_error_text);
918: --
919: update pay_batch_lines
920: set batch_line_status = 'E'
921: where current of csr_all_lines;
922: --
923: end;

Line 962: update pay_batch_lines

958: g_line_record.batch_line_id,
959: 'L',
960: l_error_text);
961: --
962: update pay_batch_lines
963: set batch_line_status = 'E'
964: where current of csr_all_lines;
965: --
966: end;

Line 1018: from pay_batch_lines pbl

1014: l_purge_after_transfer pay_batch_headers.purge_after_transfer%TYPE := null;
1015: --
1016: cursor csr_error_lines is
1017: select 'Y'
1018: from pay_batch_lines pbl
1019: where pbl.batch_line_status = 'E'
1020: and pbl.batch_id = p_batch_id;
1021: --
1022: cursor csr_error_totals is

Line 1181: l_batch_line_status pay_batch_lines.batch_line_status%TYPE := null;

1177: p_batch_id in number,
1178: p_asg_id in number
1179: ) is
1180: --
1181: l_batch_line_status pay_batch_lines.batch_line_status%TYPE := null;
1182: l_error_count binary_integer :=0;
1183: l_line_match boolean := false;
1184: --
1185: --

Line 1245: update pay_batch_lines bal

1241: begin
1242: for l_error_count in 1..g_count loop
1243: if (g_line_record.batch_line_id = g_line_id_tbl(l_error_count)) then
1244: --
1245: update pay_batch_lines bal
1246: set bal.batch_line_status =
1247: decode(l_batch_line_status,
1248: 'T',decode(g_status_tbl(l_error_count),'F','E','T'),
1249: decode(g_status_tbl(l_error_count),'F','E','V'))

Line 1274: update pay_batch_lines bal

1270: hr_utility.set_location('payplnk.set_line_status',30);
1271: --
1272: if l_line_match = false then
1273: --
1274: update pay_batch_lines bal
1275: set bal.batch_line_status = l_batch_line_status
1276: where current of csr_asg_lines;
1277: else
1278: l_line_match := false;

Line 1538: delete from pay_batch_lines

1534: where batch_id = p_batch_id;
1535: --
1536: hr_utility.set_location('payplnk.purge',15);
1537: --
1538: delete from pay_batch_lines
1539: where batch_id = p_batch_id;
1540: --
1541: hr_utility.set_location('payplnk.purge',20);
1542: --

Line 1634: , pay_batch_lines bal

1630: from sys.dual
1631: where exists
1632: (select null
1633: from pay_batch_headers bah
1634: , pay_batch_lines bal
1635: , pay_batch_control_totals bac
1636: where bah.batch_id = bal.batch_id(+)
1637: and bah.batch_id = bac.batch_id(+)
1638: and bah.batch_id = p_batch_id

Line 1743: update pay_batch_lines bal

1739: and bac.control_status <> 'T';
1740: --
1741: hr_utility.set_location('payplnk.validate_header',30);
1742: --
1743: update pay_batch_lines bal
1744: set bal.batch_line_status = 'U'
1745: where bal.batch_id = p_batch_id
1746: and bal.batch_line_status <> 'T';
1747: --

Line 2809: l_element_type_id pay_batch_lines.element_type_id%TYPE :=null;

2805: l_effective_end_date1 date := null;
2806: -- l_business_group_id number := null;
2807: not_upper boolean := false;
2808: --
2809: l_element_type_id pay_batch_lines.element_type_id%TYPE :=null;
2810: l_assignment_id pay_batch_lines.assignment_id%TYPE :=null;
2811: l_element_name pay_batch_lines.element_name%TYPE :=null;
2812: l_assignment_number pay_batch_lines.assignment_number%TYPE :=null;
2813: l_error_text pay_message_lines.line_text%TYPE :=null;

Line 2810: l_assignment_id pay_batch_lines.assignment_id%TYPE :=null;

2806: -- l_business_group_id number := null;
2807: not_upper boolean := false;
2808: --
2809: l_element_type_id pay_batch_lines.element_type_id%TYPE :=null;
2810: l_assignment_id pay_batch_lines.assignment_id%TYPE :=null;
2811: l_element_name pay_batch_lines.element_name%TYPE :=null;
2812: l_assignment_number pay_batch_lines.assignment_number%TYPE :=null;
2813: l_error_text pay_message_lines.line_text%TYPE :=null;
2814: l_input_value_id pay_input_values_f.input_value_id%TYPE :=null;

Line 2811: l_element_name pay_batch_lines.element_name%TYPE :=null;

2807: not_upper boolean := false;
2808: --
2809: l_element_type_id pay_batch_lines.element_type_id%TYPE :=null;
2810: l_assignment_id pay_batch_lines.assignment_id%TYPE :=null;
2811: l_element_name pay_batch_lines.element_name%TYPE :=null;
2812: l_assignment_number pay_batch_lines.assignment_number%TYPE :=null;
2813: l_error_text pay_message_lines.line_text%TYPE :=null;
2814: l_input_value_id pay_input_values_f.input_value_id%TYPE :=null;
2815: l_uom pay_input_values_f.uom%TYPE :=null;

Line 2812: l_assignment_number pay_batch_lines.assignment_number%TYPE :=null;

2808: --
2809: l_element_type_id pay_batch_lines.element_type_id%TYPE :=null;
2810: l_assignment_id pay_batch_lines.assignment_id%TYPE :=null;
2811: l_element_name pay_batch_lines.element_name%TYPE :=null;
2812: l_assignment_number pay_batch_lines.assignment_number%TYPE :=null;
2813: l_error_text pay_message_lines.line_text%TYPE :=null;
2814: l_input_value_id pay_input_values_f.input_value_id%TYPE :=null;
2815: l_uom pay_input_values_f.uom%TYPE :=null;
2816: l_input_curr_code pay_element_types_f.input_currency_code%TYPE := null;

Line 2832: l_user_status pay_batch_lines.batch_line_status%TYPE :=null;

2828: l_cost_allocation_structure
2829: per_business_groups_perf.cost_allocation_structure%TYPE :=null;
2830: l_legislation_code per_business_groups_perf.legislation_code%TYPE := null;
2831: l_link_id pay_element_links_f.element_link_id%TYPE :=null;
2832: l_user_status pay_batch_lines.batch_line_status%TYPE :=null;
2833: l_user_message pay_message_lines.line_text%TYPE :=null;
2834: --
2835: absence_entry_already_created boolean := false;
2836: l_absence_attendance_type_id number;

Line 2907: from pay_batch_lines pbl

2903: --
2904: --
2905: cursor csr_chk_asg_lines (l_batch_id in number, l_asg_id in number) is
2906: select 'Y'
2907: from pay_batch_lines pbl
2908: where pbl.batch_id = l_batch_id
2909: and pbl.assignment_id = l_asg_id
2910: and pbl.batch_line_status in ('T','E');
2911: --

Line 3024: g_line_record2 pay_batch_lines%ROWTYPE;

3020: -- Oracle 8. Declare temporary line_record variable in order to
3021: -- preserve original, since we will call api with a new 'in out'
3022: -- parameter mode on line_record.
3023: g_line_record1 csr_asg_lines%ROWTYPE;
3024: g_line_record2 pay_batch_lines%ROWTYPE;
3025: --
3026: l_bee_iv_upgrade varchar2(1);
3027: --
3028: begin

Line 3211: UPDATE pay_batch_lines

3207: -- used when legislative hook has changed line
3208: <>
3209: g_line_record.effective_date := TRUNC (g_line_record.effective_date);
3210: --
3211: UPDATE pay_batch_lines
3212: SET effective_date = g_line_record.effective_date
3213: WHERE CURRENT OF csr_asg_lines;
3214: --
3215: -- If element is a benefit and effective_date for this line is

Line 3278: update pay_batch_lines

3274: -- Included the assumption legislation code can be null.
3275: --
3276: g_line_record.element_type_id := l_element_type_id;
3277: --
3278: update pay_batch_lines
3279: set element_type_id = g_line_record.element_type_id
3280: where current of csr_asg_lines;
3281: --
3282: exception

Line 3978: from pay_batch_lines bal

3974: -- the line
3975: --
3976: select *
3977: into g_line_record2
3978: from pay_batch_lines bal
3979: where bal.batch_id = p_batch_id
3980: and bal.batch_line_id = g_line_record.batch_line_id;
3981:
3982: g_line_record := g_line_record2;

Line 4842: from pay_batch_lines

4838: and (control_status <> 'T' or p_mode='Y');
4839: --
4840: cursor pbl (p_batch_id number) is
4841: select batch_line_id
4842: from pay_batch_lines
4843: where batch_id = p_batch_id
4844: and (batch_line_status <> 'T' or p_mode='Y');
4845: --
4846: begin

Line 4871: from pay_batch_lines pbl

4867: where source_type = 'H'
4868: and source_id = p_batch_id
4869: and (not exists
4870: (select null
4871: from pay_batch_lines pbl
4872: where pbl.batch_id = p_batch_id
4873: and pbl.batch_line_status = 'T')
4874: or p_mode='Y');
4875: --