[Home] [Help]
1: package body pay_hk_soe_pkg as
2: /* $Header: pyhksoe.pkb 120.12 2011/05/05 10:34:02 jmarupil noship $ */
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.12 2011/05/05 10:34:02 jmarupil noship $ */
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
435: AND paa.assignment_action_id = p_assignment_action_id;
436:
437: BEGIN
438:
439: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_balances');
440:
441: OPEN csr_locked_action_id;
442: FETCH csr_locked_action_id INTO l_assignment_action_id;
443: CLOSE csr_locked_action_id;
504: , ''NET'',5
505: , ''DIRECT_PAYMENTS'',6
506: , ''TOTAL_PAYMENTS'',7)';
507:
508: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_balances');
509:
510: RETURN g_sql;
511:
512: END get_balances;
526: RETURN LONG
527: IS
528: BEGIN
529:
530: hr_utility.trace('Entering: '|| 'pay_hk_soe_pkg.get_payment_methods');
531:
532: g_sql := 'SELECT /*+
533: INDEX(opm PAY_ORG_PAYMENT_METHODS_F_PK) */
534: org_payment_method_name COL01
559: AND opm.effective_end_date
560: AND opm.payment_type_id = pt.payment_type_id
561: AND pt.language = USERENV(''LANG'')';
562:
563: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_payment_methods');
564:
565: RETURN g_sql;
566:
567: END get_payment_methods;
601: AND paa.assignment_action_id = p_assignment_action_id;
602:
603: BEGIN
604:
605: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_element_information');
606:
607: OPEN csr_prepayment;
608: FETCH csr_prepayment INTO l_assignment_action_id;
609: CLOSE csr_prepayment;
656: AND prr.element_type_id = org.org_information2
657: AND prv.input_value_id = org.org_information3
658: AND prv.result_value IS NOT NULL';
659:
660: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_element_information');
661:
662: RETURN g_sql;
663:
664: END get_other_element_information;
700:
701: BEGIN
702:
703:
704: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_other_balance_information');
705:
706: OPEN csr_locked_action_id;
707: FETCH csr_locked_action_id INTO l_assignment_action_id;
708: CLOSE csr_locked_action_id;
744: , fnd_date.canonical_to_date(''' || fnd_date.date_to_canonical(l_date_earned) || ''')
745: , NULL
746: , NULL) <> 0';
747:
748: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_other_balance_information');
749:
750: RETURN g_sql;
751:
752: END get_other_balance_information;
835:
836: BEGIN
837:
838:
839: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_annual_leave_information');
840:
841: OPEN csr_prepayment;
842: FETCH csr_prepayment INTO l_assignment_action_id;
843: CLOSE csr_prepayment;
889: , ''' || l_uom || ''' COL03
890: FROM DUAL';
891: END IF;
892:
893: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_annual_leave_information');
894:
895: RETURN g_sql;
896:
897: END get_annual_leave_info;
921:
922: BEGIN
923:
924:
925: hr_utility.trace('Entering: ' || 'pay_hk_soe_pkg.get_leave_taken');
926:
927: OPEN csr_prepayment;
928: FETCH csr_prepayment INTO l_assignment_action_id;
929: CLOSE csr_prepayment;
970: AND ppa.effective_date BETWEEN piv.effective_start_date
971: AND piv.effective_end_date';
972:
973:
974: hr_utility.trace('Leaving: ' || 'pay_hk_soe_pkg.get_leave_taken');
975:
976: RETURN g_sql;
977:
978: END get_leave_taken;
981: g_def_bal_id_populated_payment := FALSE; /* Bug 4210525 */
982: g_def_bal_id_populated_ytd := FALSE; /* Bug 4210525 */
983: g_debug := hr_utility.debug_enabled;
984:
985: end pay_hk_soe_pkg;