12: |Description: This Procedure initiates the IZA upload process. It |
13: | takes in the parameters passed from the information in |
14: | concurrent program definition and calls various |
15: | procedures for inserting data into pay_batch_headers |
16: | and pay_batch_lines table. |
17: ----------------------------------------------------------------------*/
18:
19:
20: PROCEDURE iza_upload( errbuf OUT NOCOPY VARCHAR2,
62: |Description: This procedure will take in the Data Record, validates |
63: | it and decides if it needs to be processed or rejected |
64: | by calling the function iza_validation. |
65: | After validation it calls the wrapper procedure |
66: | create_batch_line to create a record in pay_batch_lines|
67: | It also creates the record in the table |
68: | PAY_NL_IZA_UPLD_STATUS table for Rejected and Processed|
69: | records. |
70: ----------------------------------------------------------------------*/
111: ----------------------------------------------------------------------*/
112:
113:
114: PROCEDURE create_batch_line (p_session_date DATE
115: ,p_batch_id pay_batch_lines.batch_id%TYPE
116: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
117: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
118: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
119: ,p_effective_date pay_batch_lines.effective_date%TYPE
112:
113:
114: PROCEDURE create_batch_line (p_session_date DATE
115: ,p_batch_id pay_batch_lines.batch_id%TYPE
116: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
117: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
118: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
119: ,p_effective_date pay_batch_lines.effective_date%TYPE
120: ,p_date_earned pay_batch_lines.date_earned%TYPE
113:
114: PROCEDURE create_batch_line (p_session_date DATE
115: ,p_batch_id pay_batch_lines.batch_id%TYPE
116: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
117: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
118: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
119: ,p_effective_date pay_batch_lines.effective_date%TYPE
120: ,p_date_earned pay_batch_lines.date_earned%TYPE
121: ,p_element_name pay_batch_lines.element_name%TYPE
114: PROCEDURE create_batch_line (p_session_date DATE
115: ,p_batch_id pay_batch_lines.batch_id%TYPE
116: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
117: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
118: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
119: ,p_effective_date pay_batch_lines.effective_date%TYPE
120: ,p_date_earned pay_batch_lines.date_earned%TYPE
121: ,p_element_name pay_batch_lines.element_name%TYPE
122: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
115: ,p_batch_id pay_batch_lines.batch_id%TYPE
116: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
117: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
118: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
119: ,p_effective_date pay_batch_lines.effective_date%TYPE
120: ,p_date_earned pay_batch_lines.date_earned%TYPE
121: ,p_element_name pay_batch_lines.element_name%TYPE
122: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
123: ,p_value_1 pay_batch_lines.value_1%TYPE
116: ,p_assignment_id pay_batch_lines.assignment_id%TYPE
117: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
118: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
119: ,p_effective_date pay_batch_lines.effective_date%TYPE
120: ,p_date_earned pay_batch_lines.date_earned%TYPE
121: ,p_element_name pay_batch_lines.element_name%TYPE
122: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
123: ,p_value_1 pay_batch_lines.value_1%TYPE
124: ,p_bline_id OUT NOCOPY NUMBER
117: ,p_assignment_number pay_batch_lines.assignment_number%TYPE
118: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
119: ,p_effective_date pay_batch_lines.effective_date%TYPE
120: ,p_date_earned pay_batch_lines.date_earned%TYPE
121: ,p_element_name pay_batch_lines.element_name%TYPE
122: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
123: ,p_value_1 pay_batch_lines.value_1%TYPE
124: ,p_bline_id OUT NOCOPY NUMBER
125: ,p_obj_vn OUT NOCOPY NUMBER
118: ,p_batch_sequence pay_batch_lines.batch_sequence%TYPE
119: ,p_effective_date pay_batch_lines.effective_date%TYPE
120: ,p_date_earned pay_batch_lines.date_earned%TYPE
121: ,p_element_name pay_batch_lines.element_name%TYPE
122: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
123: ,p_value_1 pay_batch_lines.value_1%TYPE
124: ,p_bline_id OUT NOCOPY NUMBER
125: ,p_obj_vn OUT NOCOPY NUMBER
126: );
119: ,p_effective_date pay_batch_lines.effective_date%TYPE
120: ,p_date_earned pay_batch_lines.date_earned%TYPE
121: ,p_element_name pay_batch_lines.element_name%TYPE
122: ,p_element_type_id pay_batch_lines.element_type_id%TYPE
123: ,p_value_1 pay_batch_lines.value_1%TYPE
124: ,p_bline_id OUT NOCOPY NUMBER
125: ,p_obj_vn OUT NOCOPY NUMBER
126: );
127: