[Home] [Help]
1: package body pay_hk_soe_pkg as
2: /* $Header: pyhksoe.pkb 120.9.12010000.2 2008/08/06 07:22:54 ubhat ship $ */
3:
4: g_debug boolean;
5: g_package constant varchar2(100) := 'pay_hk_soe_pkg.';
1: package body pay_hk_soe_pkg as
2: /* $Header: pyhksoe.pkb 120.9.12010000.2 2008/08/06 07:22:54 ubhat ship $ */
3:
4: g_debug boolean;
5: g_package constant varchar2(100) := 'pay_hk_soe_pkg.';
6: g_sql long;
7:
8: ------------------------------------------------------------------------
9: -- Define global variable to store defined_balance_id's and the
434: AND paa.assignment_action_id = p_assignment_action_id;
435:
436: BEGIN
437:
438: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_balances');
439:
440: OPEN csr_locked_action_id;
441: FETCH csr_locked_action_id INTO l_assignment_action_id;
442: CLOSE csr_locked_action_id;
503: , ''NET'',5
504: , ''DIRECT_PAYMENTS'',6
505: , ''TOTAL_PAYMENTS'',7)';
506:
507: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_balances');
508:
509: RETURN g_sql;
510:
511: END get_balances;
525: RETURN LONG
526: IS
527: BEGIN
528:
529: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_payment_methods');
530:
531: g_sql := 'SELECT /*+
532: INDEX(opm PAY_ORG_PAYMENT_METHODS_F_PK) */
533: org_payment_method_name COL01
558: AND opm.effective_end_date
559: AND opm.payment_type_id = pt.payment_type_id
560: AND pt.language = USERENV(''LANG'')';
561:
562: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_payment_methods');
563:
564: RETURN g_sql;
565:
566: END get_payment_methods;
600: AND paa.assignment_action_id = p_assignment_action_id;
601:
602: BEGIN
603:
604: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_element_information');
605:
606: OPEN csr_prepayment;
607: FETCH csr_prepayment INTO l_assignment_action_id;
608: CLOSE csr_prepayment;
655: AND prr.element_type_id = org.org_information2
656: AND prv.input_value_id = org.org_information3
657: AND prv.result_value IS NOT NULL';
658:
659: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_element_information');
660:
661: RETURN g_sql;
662:
663: END get_other_element_information;
699:
700: BEGIN
701:
702:
703: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_balance_information');
704:
705: OPEN csr_locked_action_id;
706: FETCH csr_locked_action_id INTO l_assignment_action_id;
707: CLOSE csr_locked_action_id;
743: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
744: , NULL
745: , NULL) <> 0';
746:
747: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_balance_information');
748:
749: RETURN g_sql;
750:
751: END get_other_balance_information;
834:
835: BEGIN
836:
837:
838: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_annual_leave_information');
839:
840: OPEN csr_prepayment;
841: FETCH csr_prepayment INTO l_assignment_action_id;
842: CLOSE csr_prepayment;
884: , TO_CHAR(' || l_annual_leave_balance|| ',fnd_currency.get_format_mask(:G_CURRENCY_CODE,40)) COL16
885: , ''' || l_uom || ''' COL03
886: FROM DUAL';
887:
888: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_annual_leave_information');
889:
890: ELSE
891: CLOSE csr_get_annual_leave_details;
892: END IF;
922:
923: BEGIN
924:
925:
926: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_leave_taken');
927:
928: OPEN csr_prepayment;
929: FETCH csr_prepayment INTO l_assignment_action_id;
930: CLOSE csr_prepayment;
971: AND ppa.effective_date BETWEEN piv.effective_start_date
972: AND piv.effective_end_date';
973:
974:
975: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_leave_taken');
976:
977: RETURN g_sql;
978:
979: END get_leave_taken;
982: g_def_bal_id_populated_payment := FALSE; /* Bug 4210525 */
983: g_def_bal_id_populated_ytd := FALSE; /* Bug 4210525 */
984: g_debug := hr_utility.debug_enabled;
985:
986: end pay_hk_soe_pkg;