73: ln_complete := 0;
74: ln_error := 0;
75: ln_unprocessed := 0;
76:
77: hr_utility.trace('Before ROE Assignment Information');
78: hr_utility.trace('Document Id '||document_id);
79:
80: ln_request_id := substr(document_id,1,instr(document_id,':') -1 );
81: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
74: ln_error := 0;
75: ln_unprocessed := 0;
76:
77: hr_utility.trace('Before ROE Assignment Information');
78: hr_utility.trace('Document Id '||document_id);
79:
80: ln_request_id := substr(document_id,1,instr(document_id,':') -1 );
81: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
82: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );
81: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
82: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );
83: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
84:
85: hr_utility.trace('ln_request_id = '||ln_request_id);
86: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
87: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
88:
89: FOR asg_roe_info_rec IN asg_roe_info_cur (ln_request_id)
82: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );
83: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
84:
85: hr_utility.trace('ln_request_id = '||ln_request_id);
86: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
87: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
88:
89: FOR asg_roe_info_rec IN asg_roe_info_cur (ln_request_id)
90: LOOP
83: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
84:
85: hr_utility.trace('ln_request_id = '||ln_request_id);
86: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
87: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
88:
89: FOR asg_roe_info_rec IN asg_roe_info_cur (ln_request_id)
90: LOOP
91:
106: document := '
'||X_segment1||'
'||X_segment2||'
'||X_segment3||'
112:
113: document_type := 'text/html';
114:
115: exception when others then
116: hr_utility.trace('Exception Others');
117:
118: end get_roe_assignment_info;
119:
120:
163: ln_complete := 0;
164: ln_error := 0;
165: ln_unprocessed := 0;
166:
167: hr_utility.trace('Before ROE MAG Assignment Information');
168: hr_utility.trace('Document Id '||document_id);
169:
170: ln_request_id := substr(document_id,1,instr(document_id,':') -1 );
171: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
164: ln_error := 0;
165: ln_unprocessed := 0;
166:
167: hr_utility.trace('Before ROE MAG Assignment Information');
168: hr_utility.trace('Document Id '||document_id);
169:
170: ln_request_id := substr(document_id,1,instr(document_id,':') -1 );
171: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
172: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );
171: ln_business_group_id := substr(document_id,instr(document_id,':',1,1)+1 ,
172: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );
173: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
174:
175: hr_utility.trace('ln_request_id = '||ln_request_id);
176: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
177: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
178:
179: FOR asg_roe_mag_info_rec IN asg_roe_mag_info_cur (ln_request_id)
172: instr(document_id,':',1,2) -instr(document_id,':',1,1)-1 );
173: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
174:
175: hr_utility.trace('ln_request_id = '||ln_request_id);
176: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
177: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
178:
179: FOR asg_roe_mag_info_rec IN asg_roe_mag_info_cur (ln_request_id)
180: LOOP
173: ld_payroll_date_paid := substr(document_id,instr(document_id,':',1,2)+1 );
174:
175: hr_utility.trace('ln_request_id = '||ln_request_id);
176: hr_utility.trace('ln_business_group_id = '||ln_business_group_id);
177: hr_utility.trace('ld_payroll_date_paid = '||ld_payroll_date_paid);
178:
179: FOR asg_roe_mag_info_rec IN asg_roe_mag_info_cur (ln_request_id)
180: LOOP
181:
196: document := '
'||X_segment1||'
'||X_segment2||'
'||X_segment3||'
201:
202: document_type := 'text/html';
203:
204: exception when others then
205: hr_utility.trace('Exception Others');
206:
207: end get_roe_mag_assignment_info;
208:
209: end pay_ca_workflow_api_pkg;