[Home] [Help]
181: -- Return cursor that selects no rows
182: sqlstr := 'select 1 '||
183: '/* ERROR - Employer Details Fetch failed with: '||
184: sqlerrm(sqlcode)||' */ '||
185: 'from dual where to_char(:payroll_action_id) = dummy';
186: hr_utility.set_location(' Leaving: range code',110);
187: END archive_range_code;
188: --------------------------------------------------------------------------------
189: -- get_defined_balance_id pay_nl_wage_report_pkg.get_defined_balance_id
1377: l_tu_sit_payroll_corr_ptd VARCHAR2(30);
1378: --
1379: CURSOR csr_chk_corr_ele_exists(c_pay_act_id NUMBER) IS
1380: SELECT 'Y'
1381: FROM DUAL
1382: WHERE EXISTS (SELECT /*+ ORDERED */ 1
1383: FROM pay_assignment_actions paa
1384: ,pay_action_information pai
1385: WHERE paa.payroll_action_id = c_pay_act_id
3451: WHERE ffc.context_name = p_context_name;
3452: --
3453: CURSOR csr_chk_corr_ele_exists(c_ass_act_id NUMBER) IS
3454: SELECT 'Y'
3455: FROM DUAL
3456: WHERE EXISTS (SELECT /*+ ORDERED */ 1
3457: FROM pay_assignment_actions bal_assact
3458: -- ,pay_payroll_actions bact
3459: ,pay_assignment_actions assact
6578: , p_tax_unit_id => l_tax_unit_id
6579: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6580: , p_action_information4 => '0001 - '||fnd_message.get
6581: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6582: , p_action_information6 => '0001 - '||'Tag TotLnLbPh, (Total wage for taxes). The total amount of wages should be the same as the sum of the individual amounts of wage for taxes.'
6583: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6584: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6585: END IF;
6586: --
6605: , p_tax_unit_id => l_tax_unit_id
6606: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6607: , p_action_information4 => '0002 - '||fnd_message.get
6608: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6609: , p_action_information6 => '0002 - '||'Tag TotLnSV, (Total SI wage). The total amount of SI wages should be the same as the sum of the individual amounts of SI wages.'
6610: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6611: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6612: END IF;
6613: --
6631: , p_tax_unit_id => l_tax_unit_id
6632: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6633: , p_action_information4 => '0003 - '||fnd_message.get
6634: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6635: , p_action_information6 => '0003 - '||'Tag IngLbPh, (Deducted Tax). The total amount of deducted tax should be the same as the sum of the individual amounts of deducted Tax.'
6636: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6637: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6638: END IF;
6639: --
6657: , p_tax_unit_id => l_tax_unit_id
6658: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6659: , p_action_information4 => '0006 - '||fnd_message.get
6660: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6661: , p_action_information6 => '0006 - '||'Tag PrAWF, (Total Contribution WeWe (EE+ER)). The total amount of contribution should be the same as the sum of the individual amounts of WeWe contribution employer + employee.'
6662: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6663: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6664: END IF;
6665: --
6683: , p_tax_unit_id => l_tax_unit_id
6684: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6685: , p_action_information4 => '0008 - '||fnd_message.get
6686: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6687: , p_action_information6 => '0008 - '||'Tag PrUFO, (Contribution UFO). The total amount of contribution should be the same as the sum of the individual amounts of contribution UFO.'
6688: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6689: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6690: END IF;
6691: --
6716: , p_tax_unit_id => l_tax_unit_id
6717: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6718: , p_action_information4 => '0009 - '||fnd_message.get
6719: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6720: , p_action_information6 => '0009 - '||'Tag TotVergZvw/TotWghZvw, (Total amount Zvw allowance). The total amount of Zvw allowance should be the same as the sum of the individual amounts of Zvw allowance.'
6721: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6722: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6723: END IF;
6724: --
6742: , p_tax_unit_id => l_tax_unit_id
6743: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6744: , p_action_information4 => '0010 - '||fnd_message.get
6745: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6746: , p_action_information6 => '0010 - '||'Tag TotTeBet, (Total amount to be paid payroll period). The total amount should be the correct sum of the individual total amounts.'
6747: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6748: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6749: END IF;
6750: --
6800: , p_tax_unit_id => l_tax_unit_id
6801: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6802: , p_action_information4 => '0012 - '||fnd_message.get
6803: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6804: , p_action_information6 => '0012 - '||'Tag IngBijdrZvw, (Total of deducted contribution Zvw). The total amount of contribution Zvw should be the same as the sum of the individual amounts of contribution Zvw.'
6805: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6806: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6807: END IF;
6808: --
6826: , p_tax_unit_id => l_tax_unit_id
6827: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6828: , p_action_information4 => '0016 - '||fnd_message.get
6829: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6830: , p_action_information6 => '0016 - '||'Tag PrWAOAof, (Total contribution WAO/WGA/IVA). The total amount of contributions should be the same as the sum of the individual amounts of contribution WAO/WGA/IVA.'
6831: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6832: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6833: END IF;
6834: --
6860: , p_tax_unit_id => l_tax_unit_id
6861: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6862: , p_action_information4 => '0021 - '||fnd_message.get
6863: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6864: , p_action_information6 => '0021 - '||'Tag PrWAOAok, (Total contribution general WAO/WGA Differentiated). The total amount of contributions should be the same as the sum of the individual amounts of WAO/WGA Differentiated.'
6865: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6866: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6867: END IF;
6868: --
6886: , p_tax_unit_id => l_tax_unit_id
6887: , p_action_information_category => 'NL_WR_EXCEPTION_REPORT'
6888: , p_action_information4 => '0018 - '||fnd_message.get
6889: , p_action_information5 => fnd_date.date_to_canonical(l_end_date)
6890: , p_action_information6 => '0018 - '||'Tag PrWgf, (Total contribution waiting money fund). The total amount of contribution should be the same as the sum of the individual amounts of contribution waiting money fund.'
6891: , p_action_information7 => substr(l_tax_details.tax_rep_name,1,200)
6892: , p_action_information8 => substr(l_tax_details.tax_reg_num,1,12));
6893: END IF;
6894: --
7520: l_chk_person_id := csr_persons_rec.person_id;
7521: --
7522: SELECT pay_assignment_actions_s.NEXTVAL
7523: INTO l_actid
7524: FROM dual;
7525: -- CREATE THE ARCHIVE ASSIGNMENT ACTION
7526: hr_nonrun_asact.insact(lockingactid => l_actid
7527: ,assignid => csr_persons_rec.assignment_id
7528: ,pactid => p_actid
7539: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
7540: l_chk_assignment_id := csr_rec.assignment_id;
7541: SELECT pay_assignment_actions_s.NEXTVAL
7542: INTO l_actid
7543: FROM dual;
7544: --Fnd_file.put_line(FND_FILE.LOG,'#######~~csr_rec.assignment_action_id :'||l_actid||','||csr_rec.assignment_action_id);
7545: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
7546: hr_nonrun_asact.insact(lockingactid => l_actid
7547: ,assignid => csr_rec.assignment_id
7566:
7567: IF csr_rec.assignment_action_id IS NOT NULL THEN --10100628
7568: SELECT pay_assignment_actions_s.NEXTVAL
7569: INTO l_actid
7570: FROM dual;
7571: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
7572: hr_nonrun_asact.insact(lockingactid => l_actid
7573: ,assignid => csr_rec.assignment_id
7574: ,pactid => p_actid
7590: IF csr_rec.assignment_id <> l_chk_assignment_id THEN
7591: l_chk_assignment_id := csr_rec.assignment_id;
7592: SELECT pay_assignment_actions_s.NEXTVAL
7593: INTO l_actid
7594: FROM dual;
7595: -- CREATE THE ARCHIVE ASSIGNMENT ACTION FOR THE MASTER ASSIGNMENT ACTION
7596: hr_nonrun_asact.insact(lockingactid => l_actid
7597: ,assignid => csr_rec.assignment_id
7598: ,pactid => p_actid
7642: FOR csr_rec IN csr_assignment_actions(l_arc_pactid) LOOP
7643: --
7644: SELECT pay_assignment_actions_s.NEXTVAL
7645: INTO l_actid
7646: FROM dual;
7647: --
7648: hr_nonrun_asact.insact(lockingactid => l_actid
7649: ,assignid => csr_rec.assignment_id
7650: ,pactid => p_actid
9656: AND pca.cag_information_category= 'NL';
9657: --
9658: CURSOR csr_chk_emp_reported(c_assignment_id NUMBER) IS
9659: SELECT 'Y'
9660: FROM DUAL
9661: WHERE EXISTS(SELECT /*+ ORDERED */ 1
9662: FROM pay_assignment_actions paa
9663: ,pay_payroll_actions ppa
9664: ,pay_action_interlocks pai
14826: AND action_information_category = 'NL_WR_EMPLOYER_INFO';
14827: --
14828: CURSOR csr_chk_exception (c_payroll_action_id NUMBER) IS
14829: SELECT 'EXCEPTION'
14830: FROM DUAL
14831: WHERE EXISTS (SELECT 1
14832: FROM pay_action_information pai
14833: WHERE action_context_id = c_payroll_action_id
14834: AND action_information_category = 'NL_WR_EXCEPTION_REPORT')