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 not exists
48: (select null

Line 49: from pay_batch_lines pbl

45: where bal.assignment_id = l_asg_id
46: and bal.batch_id = l_batch_id
47: and not exists
48: (select null
49: from pay_batch_lines pbl
50: where pbl.batch_id = l_batch_id
51: and pbl.assignment_id = l_asg_id
52: and pbl.batch_line_status in ('T','E'))
53: order by bal.batch_sequence,bal.batch_line_id

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

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

Line 641: -- update pay_batch_lines bal

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

Line 663: -- update pay_batch_lines bal

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

Line 696: update pay_batch_lines

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

Line 718: update pay_batch_lines

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

Line 747: update pay_batch_lines

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

Line 766: update pay_batch_lines

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

Line 794: update pay_batch_lines

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

Line 820: update pay_batch_lines

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

Line 851: update pay_batch_lines

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

Line 917: update pay_batch_lines

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

Line 960: update pay_batch_lines

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

Line 1016: from pay_batch_lines pbl

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

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

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

Line 1243: update pay_batch_lines bal

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

Line 1272: update pay_batch_lines bal

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

Line 1536: delete from pay_batch_lines

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

Line 1632: , pay_batch_lines bal

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

Line 1741: update pay_batch_lines bal

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

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

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

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

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

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

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

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

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

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

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

Line 2903: from pay_batch_lines pbl

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

Line 3016: g_line_record2 pay_batch_lines%ROWTYPE;

3012: -- Oracle 8. Declare temporary line_record variable in order to
3013: -- preserve original, since we will call api with a new 'in out'
3014: -- parameter mode on line_record.
3015: g_line_record1 csr_asg_lines%ROWTYPE;
3016: g_line_record2 pay_batch_lines%ROWTYPE;
3017: --
3018: l_bee_iv_upgrade varchar2(1);
3019: --
3020: begin

Line 3202: UPDATE pay_batch_lines

3198: -- used when legislative hook has changed line
3199: <>
3200: g_line_record.effective_date := TRUNC (g_line_record.effective_date);
3201: --
3202: UPDATE pay_batch_lines
3203: SET effective_date = g_line_record.effective_date
3204: WHERE CURRENT OF csr_asg_lines;
3205: --
3206: -- If element is a benefit and effective_date for this line is

Line 3269: update pay_batch_lines

3265: -- Included the assumption legislation code can be null.
3266: --
3267: g_line_record.element_type_id := l_element_type_id;
3268: --
3269: update pay_batch_lines
3270: set element_type_id = g_line_record.element_type_id
3271: where current of csr_asg_lines;
3272: --
3273: exception

Line 3960: from pay_batch_lines bal

3956: -- the line
3957: --
3958: select *
3959: into g_line_record2
3960: from pay_batch_lines bal
3961: where bal.batch_id = p_batch_id
3962: and bal.batch_line_id = g_line_record.batch_line_id;
3963:
3964: g_line_record := g_line_record2;

Line 4810: from pay_batch_lines

4806: and (control_status <> 'T' or p_mode='Y');
4807: --
4808: cursor pbl (p_batch_id number) is
4809: select batch_line_id
4810: from pay_batch_lines
4811: where batch_id = p_batch_id
4812: and (batch_line_status <> 'T' or p_mode='Y');
4813: --
4814: begin

Line 4839: from pay_batch_lines pbl

4835: where source_type = 'H'
4836: and source_id = p_batch_id
4837: and (not exists
4838: (select null
4839: from pay_batch_lines pbl
4840: where pbl.batch_id = p_batch_id
4841: and pbl.batch_line_status = 'T')
4842: or p_mode='Y');
4843: --