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_ZA_EOY_VAL dependencies on PAY_ZA_EOY_VAL

Line 1: Package body PAY_ZA_EOY_VAL as

1: Package body PAY_ZA_EOY_VAL as
2: /* $Header: pyzatyev.pkb 120.9.12010000.9 2008/09/11 08:35:29 rbabla ship $ */
3: -- Pacakge Body
4: Function modulus_10_test
5: (p_tax_number in number) return number

Line 80: raise_application_error(-20101,'PAY_ZA_EOY_VAL.MODULUS_10_TEST exception');

76: when value_error then
77: return 0;
78:
79: when others then
80: raise_application_error(-20101,'PAY_ZA_EOY_VAL.MODULUS_10_TEST exception');
81:
82:
83:
84: end modulus_10_test;

Line 162: raise_application_error(-20101,'PAY_ZA_EOY_VAL.MODULUS_10_TEST exception');

158: when value_error then
159: return 0;
160:
161: when others then
162: raise_application_error(-20101,'PAY_ZA_EOY_VAL.MODULUS_10_TEST exception');
163:
164:
165:
166: end modulus_10_test;

Line 197: raise_application_error(-20102,'PAY_ZA_EOY_VAL.CHECK_ID_DOB exception');

193:
194: exception
195:
196: when others then
197: raise_application_error(-20102,'PAY_ZA_EOY_VAL.CHECK_ID_DOB exception');
198:
199:
200: end check_id_dob;
201:

Line 238: raise_application_error(-20103,'PAY_ZA_EOY_VAL.CHECK_IRP5_NO exception');

234:
235: exception
236:
237: when others then
238: raise_application_error(-20103,'PAY_ZA_EOY_VAL.CHECK_IRP5_NO exception');
239:
240:
241: end check_IRP5_no;
242:

Line 260: raise_application_error(-20104,'PAY_ZA_EOY_VAL.GET_TAX_START_END_DATE exception');

256:
257: exception
258:
259: when others then
260: raise_application_error(-20104,'PAY_ZA_EOY_VAL.GET_TAX_START_END_DATE exception');
261:
262:
263: end get_tax_start_end_dates;
264:

Line 350: raise_application_error(-20105,'PAY_ZA_EOY_VAL.POPULATE_MESSAGES exception');

346:
347: exception
348:
349: when others then
350: raise_application_error(-20105,'PAY_ZA_EOY_VAL.POPULATE_MESSAGES exception');
351:
352:
353: end populate_messages;
354:

Line 383: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value

379: g_application_id CONSTANT NUMBER := 801 ;
380:
381: CURSOR negative_amt_check_cur(p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
382: select irp5.code,
383: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
384: FROM pay_za_irp5_bal_codes irp5,
385: ff_archive_items arc,
386: ff_database_items dbi
387: WHERE dbi.user_entity_id = arc.user_entity_id

Line 431: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) < 0 ;

427: or
428: (irp5.code = 4493)
429: )
430: group by irp5.code
431: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) < 0 ;
432:
433: /* Cursor to fetch all LumpSum Balance Sars Codes ( For Main Certificate) which have neagtive amounts*/
434: CURSOR fetch_lmpsm_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) is
435: select irp5.code,

Line 436: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value

432:
433: /* Cursor to fetch all LumpSum Balance Sars Codes ( For Main Certificate) which have neagtive amounts*/
434: CURSOR fetch_lmpsm_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) is
435: select irp5.code,
436: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
437: FROM pay_za_irp5_bal_codes irp5,
438: ff_archive_items arc,
439: ff_database_items dbi,
440: ff_archive_item_contexts faic2,

Line 452: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))))<0 ;

448: AND ffc2.context_id = faic2.context_id
449: AND ffc2.context_name = 'SOURCE_TEXT'
450: AND faic2.CONTEXT = 'To Be Advised'
451: group by irp5.code
452: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))))<0 ;
453:
454: /* Cursor to fetch The -ve Lump Sum balances with Directive Number other than Default
455: That is checking the Lump Sum Certificate balances */
456: CURSOR get_lmpsm_crt_bal (p_asg_act_id pay_assignment_actions.assignment_action_id%TYPE) is

Line 457: select sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(arc.value)))) value

453:
454: /* Cursor to fetch The -ve Lump Sum balances with Directive Number other than Default
455: That is checking the Lump Sum Certificate balances */
456: CURSOR get_lmpsm_crt_bal (p_asg_act_id pay_assignment_actions.assignment_action_id%TYPE) is
457: select sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(arc.value)))) value
458: , faic2.CONTEXT Tax_Directive_Number
459: , irp5.code code
460: from pay_za_irp5_bal_codes irp5,
461: ff_archive_items arc,

Line 490: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(arc.value)))) < 0;

486: AND ffc2.context_id = faic2.context_id
487: AND ffc2.context_name = 'SOURCE_TEXT'
488: group BY faic2.CONTEXT
489: , irp5.code
490: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(arc.value)))) < 0;
491:
492:
493: /*Cursor to fetch all Deduction Balances which have either negative amounts or missing clearance numbers*/
494: CURSOR fetch_deduction_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%type) IS

Line 497: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value

493: /*Cursor to fetch all Deduction Balances which have either negative amounts or missing clearance numbers*/
494: CURSOR fetch_deduction_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%type) IS
495: select irp5.code ,
496: faic2.CONTEXT clearance_num,
497: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
498: FROM pay_za_irp5_bal_codes irp5,
499: ff_archive_items arc,
500: ff_database_items dbi,
501: ff_archive_item_contexts faic2,

Line 513: HAVING (sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))))<0)

509: AND ffc2.context_id = faic2.context_id
510: AND ffc2.context_name = 'SOURCE_NUMBER'
511: group by irp5.code,
512: faic2.CONTEXT
513: HAVING (sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))))<0)
514: OR (faic2.CONTEXT = g_default_clrno
515: and sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) <> 0);
516: --added above condition for Bug 7214056
517:

Line 515: and sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) <> 0);

511: group by irp5.code,
512: faic2.CONTEXT
513: HAVING (sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))))<0)
514: OR (faic2.CONTEXT = g_default_clrno
515: and sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) <> 0);
516: --added above condition for Bug 7214056
517:
518: /*Cursor to fetch Medical Aid Code Values for Cross Validation*/
519: CURSOR fetch_med_code_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS

Line 521: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value

517:
518: /*Cursor to fetch Medical Aid Code Values for Cross Validation*/
519: CURSOR fetch_med_code_bal_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
520: select irp5.code,
521: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
522: FROM pay_za_irp5_bal_codes irp5,
523: ff_archive_items arc,
524: ff_database_items dbi
525: WHERE irp5.code IN (3810, 3813, 4005, 4024, 4025, 4485, 4486)

Line 585: trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))) value

581: CURSOR fetch_pkg_balances( p_asgn_action_id pay_assignment_actions.assignment_action_id%type) IS
582: select irp5.code,
583: irp5.full_balance_name bal_name,
584: irp5.balance_type_id bal_type_id,
585: trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)))) value
586: FROM pay_za_irp5_bal_codes irp5,
587: ff_archive_items arc,
588: ff_database_items dbi,
589: per_assignment_extra_info paei,

Line 652: AND pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)) <> '0';

648: AND arc.context1 = p_asgn_action_id
649: AND arc.context1 = paa.assignment_action_id
650: AND paei.AEI_INFORMATION8 <> '1' -- 'Pension Basis: Fixed Percentage of Specific Income
651: AND paei.information_type = 'ZA_SPECIFIC_INFO'
652: AND pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0)) <> '0';
653:
654: /*Fetch elements feeding to PKG classification */
655: CURSOR fetch_pkg_ele( p_asgn_action_id pay_assignment_actions.assignment_action_id%type, p_bal_typ_id pay_balance_types.balance_type_id%type) IS
656: SELECT ELEM.element_name element_name,

Line 657: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))

653:
654: /*Fetch elements feeding to PKG classification */
655: CURSOR fetch_pkg_ele( p_asgn_action_id pay_assignment_actions.assignment_action_id%type, p_bal_typ_id pay_balance_types.balance_type_id%type) IS
656: SELECT ELEM.element_name element_name,
657: sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0)))))
658: from pay_balance_feeds_f FEED
659: , pay_run_result_values TARGET
660: , pay_run_results RR
661: , per_time_periods PPTP

Line 689: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0))))) <> 0;

685: and ASSACT.action_sequence <= BAL_ASSACT.action_sequence
686: and ASSACT.assignment_id = BAL_ASSACT.assignment_id
687: AND feed.BALANCE_TYPE_ID = p_bal_typ_id
688: GROUP BY ELEM.element_name
689: HAVING sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(TARGET.RESULT_VALUE,0))))) <> 0;
690:
691:
692: TYPE med_code_tab IS TABLE OF NUMBER Index BY PLS_INTEGER;
693: med_code_t med_code_tab ;

Line 734: SELECT irp5.code, sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value

730: --End changes for Bug No 6749775
731:
732: /* Cursor to check sanity of 3915 and 4115 codes */
733: CURSOR chk_rtrmnt_fnd_cur ( p_asgn_action_id pay_assignment_actions.assignment_action_id%TYPE) IS
734: SELECT irp5.code, sum(trunc(to_number(pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))))) value
735: FROM ff_archive_items arc,
736: ff_database_items dbi,
737: pay_za_irp5_bal_codes irp5
738: WHERE arc.user_entity_id = dbi.user_entity_id

Line 770: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))

766:
767: -- Rule 1) If an employee has paid any Tax during the current tax year,
768: -- they must have a value in the SITE and/or PAYE balance (SITE_ASG_TAX_YTD or PAYE_ASG_TAX_YTD)
769: -- FND_FILE.PUT_LINE(FND_FILE.LOG, 'Rule 1) If Employee has paid tax during current tax year, he should have SITE/PAYE split');
770: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
771: into l_tax_ytd
772: from ff_archive_items arc,
773: ff_database_items dbi
774: where dbi.user_name = 'A_TAX_ASG_TAX_YTD'

Line 779: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))

775: and arc.user_entity_id = dbi.user_entity_id
776: and arc.context1 = asgn.assignment_action_id;
777:
778: IF l_tax_ytd > 0 THEN
779: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
780: into l_site
781: from ff_archive_items arc,
782: ff_database_items dbi
783: where dbi.user_name = 'A_SITE_ASG_TAX_YTD'

Line 787: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))

783: where dbi.user_name = 'A_SITE_ASG_TAX_YTD'
784: and arc.user_entity_id = dbi.user_entity_id
785: and arc.context1 = asgn.assignment_action_id;
786:
787: select pay_za_eoy_val.decimal_character_conversion(nvl(arc.value,0))
788: into l_paye
789: from ff_archive_items arc,
790: ff_database_items dbi
791: where dbi.user_name = 'A_PAYE_ASG_TAX_YTD'

Line 1040: end PAY_ZA_EOY_VAL;

1036: errbuf := substr(SQLERRM,1,255);
1037: retcode := sqlcode;
1038: end VALIDATE_TYE_DATA;
1039:
1040: end PAY_ZA_EOY_VAL;