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_NL_IZA_UPLOAD dependencies on PAY_BATCH_LINES

Line 37: | and pay_batch_lines table. |

33: |Description: This Procedure initiates the IZA upload process. It |
34: | takes in the parameters passed from the information in |
35: | concurrent program definition and calls various |
36: | procedures for inserting data into pay_batch_headers |
37: | and pay_batch_lines table. |
38: ----------------------------------------------------------------------*/
39:
40:
41:

Line 843: ,p_batch_id pay_batch_lines.batch_id%TYPE

839:
840:
841:
842: PROCEDURE create_batch_line (p_session_date DATE
843: ,p_batch_id pay_batch_lines.batch_id%TYPE
844: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
845: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
846: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
847: ,p_effective_date pay_batch_lines.effective_date%TYPE

Line 844: ,p_assignment_id pay_batch_lines.assignment_id%TYPE

840:
841:
842: PROCEDURE create_batch_line (p_session_date DATE
843: ,p_batch_id pay_batch_lines.batch_id%TYPE
844: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
845: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
846: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
847: ,p_effective_date pay_batch_lines.effective_date%TYPE
848: ,p_date_earned pay_batch_lines.date_earned%TYPE

Line 845: ,p_assignment_number pay_batch_lines.assignment_number%TYPE

841:
842: PROCEDURE create_batch_line (p_session_date DATE
843: ,p_batch_id pay_batch_lines.batch_id%TYPE
844: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
845: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
846: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
847: ,p_effective_date pay_batch_lines.effective_date%TYPE
848: ,p_date_earned pay_batch_lines.date_earned%TYPE
849: ,p_element_name pay_batch_lines.element_name%TYPE

Line 846: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE

842: PROCEDURE create_batch_line (p_session_date DATE
843: ,p_batch_id pay_batch_lines.batch_id%TYPE
844: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
845: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
846: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
847: ,p_effective_date pay_batch_lines.effective_date%TYPE
848: ,p_date_earned pay_batch_lines.date_earned%TYPE
849: ,p_element_name pay_batch_lines.element_name%TYPE
850: ,p_element_type_id pay_batch_lines.element_type_id%TYPE

Line 847: ,p_effective_date pay_batch_lines.effective_date%TYPE

843: ,p_batch_id pay_batch_lines.batch_id%TYPE
844: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
845: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
846: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
847: ,p_effective_date pay_batch_lines.effective_date%TYPE
848: ,p_date_earned pay_batch_lines.date_earned%TYPE
849: ,p_element_name pay_batch_lines.element_name%TYPE
850: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
851: ,p_value_1 pay_batch_lines.value_1%TYPE

Line 848: ,p_date_earned pay_batch_lines.date_earned%TYPE

844: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
845: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
846: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
847: ,p_effective_date pay_batch_lines.effective_date%TYPE
848: ,p_date_earned pay_batch_lines.date_earned%TYPE
849: ,p_element_name pay_batch_lines.element_name%TYPE
850: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
851: ,p_value_1 pay_batch_lines.value_1%TYPE
852: ,p_bline_id OUT NOCOPY NUMBER

Line 849: ,p_element_name pay_batch_lines.element_name%TYPE

845: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
846: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
847: ,p_effective_date pay_batch_lines.effective_date%TYPE
848: ,p_date_earned pay_batch_lines.date_earned%TYPE
849: ,p_element_name pay_batch_lines.element_name%TYPE
850: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
851: ,p_value_1 pay_batch_lines.value_1%TYPE
852: ,p_bline_id OUT NOCOPY NUMBER
853: ,p_obj_vn OUT NOCOPY NUMBER

Line 850: ,p_element_type_id pay_batch_lines.element_type_id%TYPE

846: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
847: ,p_effective_date pay_batch_lines.effective_date%TYPE
848: ,p_date_earned pay_batch_lines.date_earned%TYPE
849: ,p_element_name pay_batch_lines.element_name%TYPE
850: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
851: ,p_value_1 pay_batch_lines.value_1%TYPE
852: ,p_bline_id OUT NOCOPY NUMBER
853: ,p_obj_vn OUT NOCOPY NUMBER
854: ) IS

Line 851: ,p_value_1 pay_batch_lines.value_1%TYPE

847: ,p_effective_date pay_batch_lines.effective_date%TYPE
848: ,p_date_earned pay_batch_lines.date_earned%TYPE
849: ,p_element_name pay_batch_lines.element_name%TYPE
850: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
851: ,p_value_1 pay_batch_lines.value_1%TYPE
852: ,p_bline_id OUT NOCOPY NUMBER
853: ,p_obj_vn OUT NOCOPY NUMBER
854: ) IS
855:

Line 898: | create_batch_line to create a record in pay_batch_lines|

894: |Description: This procedure will take in the Data Record, validates |
895: | it and decides if it needs to be processed or rejected |
896: | by calling the function iza_validation. |
897: | After validation it calls the wrapper procedure |
898: | create_batch_line to create a record in pay_batch_lines|
899: | It also creates the record in the table |
900: | PAY_NL_IZA_UPLD_STATUS table for Rejected and Processed|
901: | records. |
902: ----------------------------------------------------------------------*/

Line 1075: -- the record in pay_batch_lines

1071:
1072:
1073: -- Check if the Contribution amount IZA is not zero, then validate the record
1074: -- if the record gets validated then call create_batch_line procedure to create
1075: -- the record in pay_batch_lines
1076:
1077:
1078: IF l_contribution1 <> 0 OR l_contribution2 <> 0 THEN
1079: iza_validation(p_bg_id,l_record_eff_start_date,l_record_eff_end_date,l_exchange_number,l_client_num,l_sub_emplr_num,p_org_id,p_org_struct_version_id,l_person_id,l_assignment_id,l_assignment_num,l_reject_reason_code1);