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_SE_ARCHIVE_CWCA dependencies on PAY_BALANCE_PKG

Line 668: pay_balance_pkg.set_context('ASSIGNMENT_ID',g_assignment_id);

664:
665:
666: /* Setting Context */
667: BEGIN
668: pay_balance_pkg.set_context('ASSIGNMENT_ID',g_assignment_id);
669: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
670: END;
671:
672:

Line 669: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);

665:
666: /* Setting Context */
667: BEGIN
668: pay_balance_pkg.set_context('ASSIGNMENT_ID',g_assignment_id);
669: pay_balance_pkg.set_context('TAX_UNIT_ID',l_legal_employer_id);
670: END;
671:
672:
673: --- Check for Artistic Work

Line 732: l_addl_time_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

728:
729:
730: IF csr_balance%FOUND THEN
731:
732: l_addl_time_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
733: l_tot_addl_time_hours := l_tot_addl_time_hours + nvl(l_addl_time_hours,0);
734: END IF;
735: END LOOP ;
736:

Line 751: l_addl_time_hw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

747: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
748: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
749: CLOSE csr_bg_Get_Defined_Balance_Id;
750: IF csr_balance%FOUND THEN
751: l_addl_time_hw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
752: l_tot_addl_time_hw := l_tot_addl_time_hw + nvl(l_addl_time_hw,0);
753: END IF;
754: END LOOP ;
755:

Line 769: l_relief_duty_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

765: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
766: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
767: CLOSE csr_bg_Get_Defined_Balance_Id;
768: IF csr_balance%FOUND THEN
769: l_relief_duty_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
770: l_tot_relief_duty_hours := l_tot_relief_duty_hours + nvl(l_relief_duty_hours,0);
771: END IF;
772: END LOOP ;
773:

Line 790: l_relief_duty_hw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

786: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
787: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
788: CLOSE csr_bg_Get_Defined_Balance_Id;
789: IF csr_balance%FOUND THEN
790: l_relief_duty_hw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
791: l_tot_relief_duty_hw := l_tot_relief_duty_hw + nvl(l_relief_duty_hw,0);
792: END IF;
793: END LOOP ;
794:

Line 810: l_relief_duty_mw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

806: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
807: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
808: CLOSE csr_bg_Get_Defined_Balance_Id;
809: IF csr_balance%FOUND THEN
810: l_relief_duty_mw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
811: l_tot_relief_duty_mw := l_tot_relief_duty_mw + nvl(l_relief_duty_mw,0);
812: END IF;
813: END LOOP ;
814:

Line 829: l_overtime_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

825: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
826: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
827: CLOSE csr_bg_Get_Defined_Balance_Id;
828: IF csr_balance%FOUND THEN
829: l_overtime_hours :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
830: l_tot_overtime_hours := l_tot_overtime_hours + nvl(l_overtime_hours,0);
831: END IF;
832: END LOOP ;
833:

Line 847: l_overtime_hw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

843: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension,g_business_group_id);
844: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
845: CLOSE csr_bg_Get_Defined_Balance_Id;
846: IF csr_balance%FOUND THEN
847: l_overtime_hw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
848: l_tot_overtime_hw := l_tot_overtime_hw + nvl(l_overtime_hw,0);
849: END IF;
850: END LOOP ;
851:

Line 940: l_oth_comp :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

936:
937: IF csr_balance%FOUND THEN
938:
939: l_oth_comp :=0;
940: l_oth_comp :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
941: --fnd_file.put_line (fnd_file.LOG, 'l_oth_comp' ||l_oth_comp);
942:
943: IF l_oth_comp > 0 THEN
944:

Line 1082: l_overtime_mw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

1078: CLOSE csr_bg_Get_Defined_Balance_Id;
1079:
1080: IF csr_balance%FOUND THEN
1081: l_overtime_mw := 0;
1082: l_overtime_mw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
1083: --fnd_file.put_line (fnd_file.LOG, 'l_overtime_mw' ||l_overtime_mw);
1084: IF l_overtime_mw > 0 THEN
1085:
1086: pay_action_information_api.create_action_information

Line 1159: l_addl_time_mw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;

1155:
1156: IF csr_balance%FOUND THEN
1157:
1158: l_addl_time_mw :=0;
1159: l_addl_time_mw :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ID =>g_assignment_id, P_VIRTUAL_DATE =>l_reporting_date ) ;
1160: --fnd_file.put_line (fnd_file.LOG, 'l_addl_time_mw' ||l_addl_time_mw);
1161: IF l_addl_time_mw > 0 THEN
1162:
1163: pay_action_information_api.create_action_information

Line 1352: l_value := nvl(pay_balance_pkg.get_value(l_context1,p_assignment_id,p_virtual_date), 0);

1348: OPEN get_dbal_id(p_balance_name, p_balance_dim);
1349: FETCH get_dbal_id INTO l_context1;
1350: CLOSE get_dbal_id;
1351:
1352: l_value := nvl(pay_balance_pkg.get_value(l_context1,p_assignment_id,p_virtual_date), 0);
1353:
1354: RETURN l_value;
1355:
1356: END GET_DEFINED_BALANCE_VALUE ;