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

Line 789: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab

785: -- Rev# Date Userid Description --
786: --------------------------------------------------------------------------
787: -- 115.0 09-SEP-2005 aaagarwa Initial Version --
788: --------------------------------------------------------------------------
789: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab
790: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab
791: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
792: )
793: IS

Line 790: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab

786: --------------------------------------------------------------------------
787: -- 115.0 09-SEP-2005 aaagarwa Initial Version --
788: --------------------------------------------------------------------------
789: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab
790: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab
791: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
792: )
793: IS
794: l_message VARCHAR2(255);

Line 791: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

787: -- 115.0 09-SEP-2005 aaagarwa Initial Version --
788: --------------------------------------------------------------------------
789: PROCEDURE balance_difference(g_result_table1 IN pay_balance_pkg.t_detailed_bal_out_tab
790: ,g_result_table2 IN pay_balance_pkg.t_detailed_bal_out_tab
791: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
792: )
793: IS
794: l_message VARCHAR2(255);
795: l_procedure VARCHAR2(100);

Line 843: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab

839: ,p_balance_dimension IN VARCHAR2
840: ,p_balance_dimension1 IN VARCHAR2 DEFAULT NULL
841: ,p_balance_dimension2 IN VARCHAR2 DEFAULT NULL
842: ,p_balance_dimension3 IN VARCHAR2 DEFAULT NULL
843: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
844: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
845: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
846: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
847: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

Line 844: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

840: ,p_balance_dimension1 IN VARCHAR2 DEFAULT NULL
841: ,p_balance_dimension2 IN VARCHAR2 DEFAULT NULL
842: ,p_balance_dimension3 IN VARCHAR2 DEFAULT NULL
843: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
844: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
845: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
846: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
847: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
848: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab

Line 845: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

841: ,p_balance_dimension2 IN VARCHAR2 DEFAULT NULL
842: ,p_balance_dimension3 IN VARCHAR2 DEFAULT NULL
843: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
844: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
845: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
846: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
847: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
848: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
849: )

Line 846: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

842: ,p_balance_dimension3 IN VARCHAR2 DEFAULT NULL
843: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
844: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
845: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
846: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
847: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
848: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
849: )
850: IS

Line 847: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab

843: ,g_context_table IN OUT NOCOPY pay_balance_pkg.t_context_tab
844: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
845: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
846: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
847: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
848: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
849: )
850: IS
851:

Line 848: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab

844: ,g_result_table IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
845: ,g_result_table1 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
846: ,g_result_table2 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
847: ,g_result_table3 IN OUT NOCOPY pay_balance_pkg.t_detailed_bal_out_tab
848: ,g_balance_value_tab IN OUT NOCOPY pay_balance_pkg.t_balance_value_tab
849: )
850: IS
851:
852: l_action_info_id NUMBER;

Line 854: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

850: IS
851:
852: l_action_info_id NUMBER;
853: l_ovn NUMBER;
854: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
855: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
856: l_message VARCHAR2(255);
857: l_procedure VARCHAR2(100);
858: l_result_table4 pay_balance_pkg.t_detailed_bal_out_tab;

Line 855: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

851:
852: l_action_info_id NUMBER;
853: l_ovn NUMBER;
854: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
855: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
856: l_message VARCHAR2(255);
857: l_procedure VARCHAR2(100);
858: l_result_table4 pay_balance_pkg.t_detailed_bal_out_tab;
859:

Line 858: l_result_table4 pay_balance_pkg.t_detailed_bal_out_tab;

854: l_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
855: l_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
856: l_message VARCHAR2(255);
857: l_procedure VARCHAR2(100);
858: l_result_table4 pay_balance_pkg.t_detailed_bal_out_tab;
859:
860:
861: BEGIN
862:

Line 891: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

887:
888: g_balance_value_tab(1).defined_balance_id :=
889: pay_in_tax_utils.get_defined_balance('Adjusted Advance for Allowances','_ASG_COMP_YTD');
890:
891: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
892: ,p_defined_balance_lst => g_balance_value_tab
893: ,p_context_lst => g_context_table
894: ,p_output_table => l_result_table1
895: );

Line 901: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id

897:
898: IF pre_gre_asg_act_id IS NOT NULL
899: THEN
900: pay_in_utils.set_location(g_debug,l_procedure, 30);
901: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id
902: ,p_defined_balance_lst => g_balance_value_tab
903: ,p_context_lst => g_context_table
904: ,p_output_table => l_result_table2
905: );

Line 923: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

919:
920: g_balance_value_tab(1).defined_balance_id :=
921: pay_in_tax_utils.get_defined_balance(p_balance_name,p_balance_dimension);
922:
923: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
924: ,p_defined_balance_lst => g_balance_value_tab
925: ,p_context_lst => g_context_table
926: ,p_output_table => l_result_table1--g_result_table
927: );

Line 934: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id

930:
931: IF pre_gre_asg_act_id IS NOT NULL
932: THEN
933: pay_in_utils.set_location(g_debug,l_procedure, 30);
934: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id
935: ,p_defined_balance_lst => g_balance_value_tab
936: ,p_context_lst => g_context_table
937: ,p_output_table => l_result_table2
938: );

Line 952: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

948: pay_in_utils.set_location(g_debug,l_procedure, 50);
949: g_balance_value_tab(1).defined_balance_id :=
950: pay_in_tax_utils.get_defined_balance(p_balance_name1,p_balance_dimension1);
951:
952: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
953: ,p_defined_balance_lst => g_balance_value_tab
954: ,p_context_lst => g_context_table
955: ,p_output_table => l_result_table1--g_result_table1
956: );

Line 960: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id

956: );
957: IF pre_gre_asg_act_id IS NOT NULL AND p_action_inf_category = 'IN_EOY_PERQ'
958: THEN
959: pay_in_utils.set_location(g_debug,l_procedure, 60);
960: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id
961: ,p_defined_balance_lst => g_balance_value_tab
962: ,p_context_lst => g_context_table
963: ,p_output_table => l_result_table2
964: );

Line 979: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

975: pay_in_utils.set_location(g_debug,l_procedure, 90);
976: g_balance_value_tab(1).defined_balance_id :=
977: pay_in_tax_utils.get_defined_balance(p_balance_name2,p_balance_dimension2);
978:
979: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
980: ,p_defined_balance_lst => g_balance_value_tab
981: ,p_context_lst => g_context_table
982: ,p_output_table => l_result_table1--g_result_table2
983: );

Line 987: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id

983: );
984: IF pre_gre_asg_act_id IS NOT NULL
985: THEN
986: pay_in_utils.set_location(g_debug,l_procedure, 100);
987: pay_balance_pkg.get_value(p_assignment_action_id => pre_gre_asg_act_id
988: ,p_defined_balance_lst => g_balance_value_tab
989: ,p_context_lst => g_context_table
990: ,p_output_table => l_result_table2
991: );

Line 1005: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1001: pay_in_utils.set_location(g_debug,l_procedure, 120);
1002: g_balance_value_tab(1).defined_balance_id :=
1003: pay_in_tax_utils.get_defined_balance(p_balance_name3,p_balance_dimension3);
1004:
1005: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1006: ,p_defined_balance_lst => g_balance_value_tab
1007: ,p_context_lst => g_context_table
1008: ,p_output_table => g_result_table3
1009: );

Line 1179: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1175: AND pbd.balance_dimension_id = pdb.balance_dimension_id
1176: ORDER BY pbt.balance_name;
1177:
1178: g_bal_name_tab t_bal_name_tab;
1179: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1180: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1181: g_context_table pay_balance_pkg.t_context_tab;
1182: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1183: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1180: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

1176: ORDER BY pbt.balance_name;
1177:
1178: g_bal_name_tab t_bal_name_tab;
1179: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1180: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1181: g_context_table pay_balance_pkg.t_context_tab;
1182: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1183: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1184: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1181: g_context_table pay_balance_pkg.t_context_tab;

1177:
1178: g_bal_name_tab t_bal_name_tab;
1179: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1180: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1181: g_context_table pay_balance_pkg.t_context_tab;
1182: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1183: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1184: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1185: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1182: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1178: g_bal_name_tab t_bal_name_tab;
1179: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1180: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1181: g_context_table pay_balance_pkg.t_context_tab;
1182: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1183: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1184: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1185: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1186:

Line 1183: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

1179: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1180: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1181: g_context_table pay_balance_pkg.t_context_tab;
1182: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1183: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1184: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1185: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1186:
1187: i NUMBER;

Line 1184: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

1180: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1181: g_context_table pay_balance_pkg.t_context_tab;
1182: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1183: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1184: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1185: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1186:
1187: i NUMBER;
1188: l_defined_balance_id NUMBER;

Line 1185: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;

1181: g_context_table pay_balance_pkg.t_context_tab;
1182: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1183: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1184: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1185: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1186:
1187: i NUMBER;
1188: l_defined_balance_id NUMBER;
1189: l_action_info_id NUMBER;

Line 1230: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1226: pay_in_utils.set_location(g_debug,l_procedure, 20);
1227:
1228: g_context_table(1).tax_unit_id := p_gre_id;
1229:
1230: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1231: ,p_defined_balance_lst => g_balance_value_tab
1232: ,p_context_lst => g_context_table
1233: ,p_output_table => g_result_table
1234: );

Line 1278: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1274: END LOOP;
1275:
1276:
1277:
1278: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1279: ,p_defined_balance_lst => g_balance_value_tab
1280: ,p_context_lst => g_context_table
1281: ,p_output_table => g_result_table
1282: );

Line 1305: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1301:
1302: g_balance_value_tab1(1).defined_balance_id :=
1303: pay_in_tax_utils.get_defined_balance('Gross Chapter VIA Deductions','_ASG_LE_COMP_PTD');
1304:
1305: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1306: ,p_defined_balance_lst => g_balance_value_tab1
1307: ,p_context_lst => g_context_table
1308: ,p_output_table => g_result_table1
1309: );

Line 1415: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1411: g_balance_value_tab(1).defined_balance_id :=
1412: pay_in_tax_utils.get_defined_balance('Deductions under Section 80CCE','_ASG_LE_COMP_PTD');
1413:
1414: -- Qualifying Amounts for Life Insurance and Deferred Annuity obtained
1415: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1416: ,p_defined_balance_lst => g_balance_value_tab
1417: ,p_context_lst => g_context_table
1418: ,p_output_table => g_result_table
1419: );

Line 1435: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1431: g_context_table(1).tax_unit_id := p_gre_id;
1432: g_balance_value_tab1(1).defined_balance_id :=
1433: pay_in_tax_utils.get_defined_balance('Gross Chapter VIA Deductions','_ASG_LE_COMP_PTD');
1434:
1435: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1436: ,p_defined_balance_lst => g_balance_value_tab1
1437: ,p_context_lst => g_context_table
1438: ,p_output_table => g_result_table1
1439: );

Line 1465: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1461: g_balance_value_tab1(3).defined_balance_id :=
1462: pay_in_tax_utils.get_defined_balance('Senior Citizens Savings Scheme','_ASG_LE_PTD');
1463:
1464:
1465: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1466: ,p_defined_balance_lst => g_balance_value_tab1
1467: ,p_context_lst => g_context_table
1468: ,p_output_table => g_result_table1
1469: );

Line 1493: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

1489: pay_in_tax_utils.get_defined_balance('F16 ER Pension Contribution','_ASG_LE_PTD');
1490: g_balance_value_tab1(2).defined_balance_id :=
1491: pay_in_tax_utils.get_defined_balance('F16 Section 80CCD','_ASG_LE_PTD');
1492:
1493: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
1494: ,p_defined_balance_lst => g_balance_value_tab1
1495: ,p_context_lst => g_context_table
1496: ,p_output_table => g_result_table1
1497: );

Line 1659: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1655: AND (pur.legislation_code = 'IN' OR pur.business_group_id = g_bg_id)
1656: AND g_start_date BETWEEN pur.effective_start_date AND pur.effective_end_date
1657: ORDER by name ASC;
1658:
1659: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1660: g_context_table pay_balance_pkg.t_context_tab;
1661: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1662: l_action_info_id NUMBER;
1663: l_ovn NUMBER;

Line 1660: g_context_table pay_balance_pkg.t_context_tab;

1656: AND g_start_date BETWEEN pur.effective_start_date AND pur.effective_end_date
1657: ORDER by name ASC;
1658:
1659: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1660: g_context_table pay_balance_pkg.t_context_tab;
1661: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1662: l_action_info_id NUMBER;
1663: l_ovn NUMBER;
1664: l_defined_balance_id NUMBER;

Line 1661: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1657: ORDER by name ASC;
1658:
1659: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1660: g_context_table pay_balance_pkg.t_context_tab;
1661: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1662: l_action_info_id NUMBER;
1663: l_ovn NUMBER;
1664: l_defined_balance_id NUMBER;
1665: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1665: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

1661: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1662: l_action_info_id NUMBER;
1663: l_ovn NUMBER;
1664: l_defined_balance_id NUMBER;
1665: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1666: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1667: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1668: l_value NUMBER;
1669: i NUMBER := 0;

Line 1666: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

1662: l_action_info_id NUMBER;
1663: l_ovn NUMBER;
1664: l_defined_balance_id NUMBER;
1665: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1666: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1667: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1668: l_value NUMBER;
1669: i NUMBER := 0;
1670: l_message VARCHAR2(255);

Line 1667: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;

1663: l_ovn NUMBER;
1664: l_defined_balance_id NUMBER;
1665: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1666: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1667: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1668: l_value NUMBER;
1669: i NUMBER := 0;
1670: l_message VARCHAR2(255);
1671: l_procedure VARCHAR2(100);

Line 1727: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1723: THEN
1724: IF p_flag -- Neither the first nor the last record. Hence diff of THRA _ASG_YTD at 2 diff act ids.
1725: THEN
1726: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance','_ASG_YTD');
1727: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1728: ,p_assignment_action_id => p_run_asg_action_id
1729: );
1730: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1731: ,p_assignment_action_id => pre_gre_asg_act_id

Line 1730: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1726: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance','_ASG_YTD');
1727: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1728: ,p_assignment_action_id => p_run_asg_action_id
1729: );
1730: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1731: ,p_assignment_action_id => pre_gre_asg_act_id
1732: );
1733: ELSE -- Last Record. Hence diff of Projected and YTD value.
1734: l_defined_balance_id :=

Line 1737: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1733: ELSE -- Last Record. Hence diff of Projected and YTD value.
1734: l_defined_balance_id :=
1735: pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance for Projection','_ASG_LE_PTD');
1736:
1737: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1738: ,p_assignment_action_id => p_run_asg_action_id
1739: );
1740: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance','_ASG_YTD');
1741: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

Line 1741: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1737: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1738: ,p_assignment_action_id => p_run_asg_action_id
1739: );
1740: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance','_ASG_YTD');
1741: l_value := l_value - pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1742: ,p_assignment_action_id => pre_gre_asg_act_id
1743: );
1744: END IF;
1745: ELSIF p_flag -- First Record in a multi tan scenario, hence take the THRA_ASG_YTD

Line 1749: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1745: ELSIF p_flag -- First Record in a multi tan scenario, hence take the THRA_ASG_YTD
1746: THEN
1747: pay_in_utils.set_location(g_debug,l_procedure, 40);
1748: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance','_ASG_YTD');
1749: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1750: ,p_assignment_action_id => p_run_asg_action_id
1751: );
1752: ELSE -- Only a single record exists, hence take the Projetced value
1753: pay_in_utils.set_location(g_debug,l_procedure, 50);

Line 1755: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id

1751: );
1752: ELSE -- Only a single record exists, hence take the Projetced value
1753: pay_in_utils.set_location(g_debug,l_procedure, 50);
1754: l_defined_balance_id := pay_in_tax_utils.get_defined_balance('Taxable House Rent Allowance for Projection','_ASG_PTD');
1755: l_value := pay_balance_pkg.get_value(p_defined_balance_id => l_defined_balance_id
1756: ,p_assignment_action_id => p_run_asg_action_id
1757: );
1758: END IF;
1759:

Line 1801: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1797: ,p_gre_id IN NUMBER
1798: ,pre_gre_asg_act_id IN NUMBER DEFAULT NULL
1799: )
1800: IS
1801: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1802: g_context_table pay_balance_pkg.t_context_tab;
1803: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1804: l_action_info_id NUMBER;
1805: l_ovn NUMBER;

Line 1802: g_context_table pay_balance_pkg.t_context_tab;

1798: ,pre_gre_asg_act_id IN NUMBER DEFAULT NULL
1799: )
1800: IS
1801: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1802: g_context_table pay_balance_pkg.t_context_tab;
1803: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1804: l_action_info_id NUMBER;
1805: l_ovn NUMBER;
1806: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1803: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1799: )
1800: IS
1801: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1802: g_context_table pay_balance_pkg.t_context_tab;
1803: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1804: l_action_info_id NUMBER;
1805: l_ovn NUMBER;
1806: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1807: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

Line 1806: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;

1802: g_context_table pay_balance_pkg.t_context_tab;
1803: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1804: l_action_info_id NUMBER;
1805: l_ovn NUMBER;
1806: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1807: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1808: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1809: l_message VARCHAR2(255);
1810: l_procedure VARCHAR2(100);

Line 1807: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;

1803: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1804: l_action_info_id NUMBER;
1805: l_ovn NUMBER;
1806: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1807: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1808: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1809: l_message VARCHAR2(255);
1810: l_procedure VARCHAR2(100);
1811:

Line 1808: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;

1804: l_action_info_id NUMBER;
1805: l_ovn NUMBER;
1806: g_result_table1 pay_balance_pkg.t_detailed_bal_out_tab;
1807: g_result_table2 pay_balance_pkg.t_detailed_bal_out_tab;
1808: g_result_table3 pay_balance_pkg.t_detailed_bal_out_tab;
1809: l_message VARCHAR2(255);
1810: l_procedure VARCHAR2(100);
1811:
1812: BEGIN

Line 1977: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

1973: AND pbd.legislation_code = 'IN'
1974: AND pbt.balance_type_id = pdb.balance_type_id
1975: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1976:
1977: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1978: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1979: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1980:
1981: i NUMBER;

Line 1978: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

1974: AND pbt.balance_type_id = pdb.balance_type_id
1975: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1976:
1977: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1978: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1979: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1980:
1981: i NUMBER;
1982: j NUMBER;

Line 1979: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

1975: AND pbd.balance_dimension_id = pdb.balance_dimension_id;
1976:
1977: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
1978: g_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
1979: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
1980:
1981: i NUMBER;
1982: j NUMBER;
1983: g_bal_name_tab t_bal_name_tab;

Line 1985: g_context_table pay_balance_pkg.t_context_tab;

1981: i NUMBER;
1982: j NUMBER;
1983: g_bal_name_tab t_bal_name_tab;
1984: g_bal_name_tab1 t_bal_name_tab;
1985: g_context_table pay_balance_pkg.t_context_tab;
1986: l_action_info_id NUMBER;
1987: l_ovn NUMBER;
1988: l_in_tax_ded NUMBER;
1989: l_message VARCHAR2(255);

Line 2021: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab);

2017: g_bal_name_tab(i).balance_name := c_rec.balance_name;
2018: i := i + 1;
2019: END LOOP;
2020:
2021: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab);
2022:
2023: pay_in_utils.set_location(g_debug,l_procedure, 20);
2024:
2025:

Line 2062: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab1);

2058: g_bal_name_tab1(i).balance_name := c_rec.balance_name;
2059: i := i + 1;
2060: END LOOP;
2061:
2062: pay_balance_pkg.get_value(p_run_asg_action_id,g_balance_value_tab1);
2063:
2064: pay_in_utils.set_location(g_debug,l_procedure, 30);
2065:
2066: FOR i IN 1..g_balance_value_tab1.COUNT

Line 2111: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id

2107: END LOOP;
2108:
2109: pay_in_utils.set_location(g_debug,l_procedure, 50);
2110:
2111: pay_balance_pkg.get_value(p_assignment_action_id => p_run_asg_action_id
2112: ,p_defined_balance_lst => g_balance_value_tab1
2113: ,p_context_lst => g_context_table
2114: ,p_output_table => g_result_table
2115: );

Line 2249: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;

2245:
2246:
2247:
2248:
2249: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
2250: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
2251: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
2252: g_context_table pay_balance_pkg.t_context_tab;
2253: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

Line 2250: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;

2246:
2247:
2248:
2249: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
2250: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
2251: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
2252: g_context_table pay_balance_pkg.t_context_tab;
2253: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
2254: g_bal_name_tab t_bal_name_tab;

Line 2251: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;

2247:
2248:
2249: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
2250: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
2251: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
2252: g_context_table pay_balance_pkg.t_context_tab;
2253: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
2254: g_bal_name_tab t_bal_name_tab;
2255: i NUMBER;

Line 2252: g_context_table pay_balance_pkg.t_context_tab;

2248:
2249: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
2250: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
2251: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
2252: g_context_table pay_balance_pkg.t_context_tab;
2253: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
2254: g_bal_name_tab t_bal_name_tab;
2255: i NUMBER;
2256: l_context VARCHAR2(50);

Line 2253: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

2249: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
2250: l_balance_value_tab1 pay_balance_pkg.t_balance_value_tab;
2251: l_balance_value_tab2 pay_balance_pkg.t_balance_value_tab;
2252: g_context_table pay_balance_pkg.t_context_tab;
2253: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
2254: g_bal_name_tab t_bal_name_tab;
2255: i NUMBER;
2256: l_context VARCHAR2(50);
2257: l_defined_balance_id NUMBER;

Line 2300: pay_balance_pkg.get_value(p_run_asg_action_id,l_balance_value_tab1);

2296:
2297: l_balance_value_tab1 := g_balance_value_tab;
2298: l_balance_value_tab2 := g_balance_value_tab;
2299:
2300: pay_balance_pkg.get_value(p_run_asg_action_id,l_balance_value_tab1);
2301:
2302: IF pre_gre_asg_act_id IS NOT NULL
2303: THEN
2304: pay_balance_pkg.get_value(pre_gre_asg_act_id,l_balance_value_tab2);

Line 2304: pay_balance_pkg.get_value(pre_gre_asg_act_id,l_balance_value_tab2);

2300: pay_balance_pkg.get_value(p_run_asg_action_id,l_balance_value_tab1);
2301:
2302: IF pre_gre_asg_act_id IS NOT NULL
2303: THEN
2304: pay_balance_pkg.get_value(pre_gre_asg_act_id,l_balance_value_tab2);
2305: END IF;
2306:
2307: pay_in_utils.set_location(g_debug,l_procedure, 30);
2308: FOR i IN 1..g_balance_value_tab.COUNT