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.IGF_AP_EFC_CALC dependencies on IGF_AP_EFC_SUBF

Line 896: igf_ap_efc_subf.a_p_inc(l_p_inc);

892: BEGIN
893: p_sc_asset := null ;
894:
895: -- Get the Parents' Income in last year
896: igf_ap_efc_subf.a_p_inc(l_p_inc);
897:
898: -- Get Allowances against Parents' Income
899: igf_ap_efc_subf.a_allow_ag_p_inc ( l_p_inc, l_allow_ag_p_inc ) ;
900:

Line 899: igf_ap_efc_subf.a_allow_ag_p_inc ( l_p_inc, l_allow_ag_p_inc ) ;

895: -- Get the Parents' Income in last year
896: igf_ap_efc_subf.a_p_inc(l_p_inc);
897:
898: -- Get Allowances against Parents' Income
899: igf_ap_efc_subf.a_allow_ag_p_inc ( l_p_inc, l_allow_ag_p_inc ) ;
900:
901: -- Get the Parents' Available Income
902: igf_ap_efc_subf.a_available_inc( l_p_inc, l_allow_ag_p_inc,l_available_income );
903:

Line 902: igf_ap_efc_subf.a_available_inc( l_p_inc, l_allow_ag_p_inc,l_available_income );

898: -- Get Allowances against Parents' Income
899: igf_ap_efc_subf.a_allow_ag_p_inc ( l_p_inc, l_allow_ag_p_inc ) ;
900:
901: -- Get the Parents' Available Income
902: igf_ap_efc_subf.a_available_inc( l_p_inc, l_allow_ag_p_inc,l_available_income );
903:
904: -- Get Parents' contribution from Assets
905: igf_ap_efc_subf.a_p_cont_assets( l_p_cont_assets );
906:

Line 905: igf_ap_efc_subf.a_p_cont_assets( l_p_cont_assets );

901: -- Get the Parents' Available Income
902: igf_ap_efc_subf.a_available_inc( l_p_inc, l_allow_ag_p_inc,l_available_income );
903:
904: -- Get Parents' contribution from Assets
905: igf_ap_efc_subf.a_p_cont_assets( l_p_cont_assets );
906:
907: -- Get Parents' Contribution
908: igf_ap_efc_subf.a_p_cont( l_available_income, l_p_cont_assets, l_p_aai, l_p_cont );
909:

Line 908: igf_ap_efc_subf.a_p_cont( l_available_income, l_p_cont_assets, l_p_aai, l_p_cont );

904: -- Get Parents' contribution from Assets
905: igf_ap_efc_subf.a_p_cont_assets( l_p_cont_assets );
906:
907: -- Get Parents' Contribution
908: igf_ap_efc_subf.a_p_cont( l_available_income, l_p_cont_assets, l_p_aai, l_p_cont );
909:
910: -- Get student's income in 2000
911: igf_ap_efc_subf.a_s_inc(l_s_inc);
912:

Line 911: igf_ap_efc_subf.a_s_inc(l_s_inc);

907: -- Get Parents' Contribution
908: igf_ap_efc_subf.a_p_cont( l_available_income, l_p_cont_assets, l_p_aai, l_p_cont );
909:
910: -- Get student's income in 2000
911: igf_ap_efc_subf.a_s_inc(l_s_inc);
912:
913: -- Get Allowances against Student's income
914: igf_ap_efc_subf.a_allow_ag_s_inc( l_s_inc, l_p_aai, l_allow_ag_s_inc );
915:

Line 914: igf_ap_efc_subf.a_allow_ag_s_inc( l_s_inc, l_p_aai, l_allow_ag_s_inc );

910: -- Get student's income in 2000
911: igf_ap_efc_subf.a_s_inc(l_s_inc);
912:
913: -- Get Allowances against Student's income
914: igf_ap_efc_subf.a_allow_ag_s_inc( l_s_inc, l_p_aai, l_allow_ag_s_inc );
915:
916: -- Get Student's contribution from income
917: igf_ap_efc_subf.a_s_cont( l_s_inc, l_allow_ag_s_inc, l_s_cont );
918:

Line 917: igf_ap_efc_subf.a_s_cont( l_s_inc, l_allow_ag_s_inc, l_s_cont );

913: -- Get Allowances against Student's income
914: igf_ap_efc_subf.a_allow_ag_s_inc( l_s_inc, l_p_aai, l_allow_ag_s_inc );
915:
916: -- Get Student's contribution from income
917: igf_ap_efc_subf.a_s_cont( l_s_inc, l_allow_ag_s_inc, l_s_cont );
918:
919: -- Get Student's contribution from Assets
920: igf_ap_efc_subf.a_s_cont_assets ( l_s_cont_assets );
921:

Line 920: igf_ap_efc_subf.a_s_cont_assets ( l_s_cont_assets );

916: -- Get Student's contribution from income
917: igf_ap_efc_subf.a_s_cont( l_s_inc, l_allow_ag_s_inc, l_s_cont );
918:
919: -- Get Student's contribution from Assets
920: igf_ap_efc_subf.a_s_cont_assets ( l_s_cont_assets );
921:
922: p_sc_asset := l_s_cont_assets ;
923:
924: -- Get the first 9 Months EFC

Line 926: igf_ap_efc_subf.a_p_cont_less_9( l_p_cont, p_no_of_months, l_p_cont_less_9 );

922: p_sc_asset := l_s_cont_assets ;
923:
924: -- Get the first 9 Months EFC
925: -- Get Parents' contribution for < 9 months
926: igf_ap_efc_subf.a_p_cont_less_9( l_p_cont, p_no_of_months, l_p_cont_less_9 );
927:
928: -- Get Student's contribution from Available Income for < 9 months
929: igf_ap_efc_subf.a_s_cont_less_9 ( l_s_cont, p_no_of_months, l_s_cont_less_9 );
930:

Line 929: igf_ap_efc_subf.a_s_cont_less_9 ( l_s_cont, p_no_of_months, l_s_cont_less_9 );

925: -- Get Parents' contribution for < 9 months
926: igf_ap_efc_subf.a_p_cont_less_9( l_p_cont, p_no_of_months, l_p_cont_less_9 );
927:
928: -- Get Student's contribution from Available Income for < 9 months
929: igf_ap_efc_subf.a_s_cont_less_9 ( l_s_cont, p_no_of_months, l_s_cont_less_9 );
930:
931: -- Get Student's EFC for < 9 months
932: igf_ap_efc_subf.a_efc_not_9(l_p_cont_less_9, l_s_cont_less_9, l_s_cont_assets, p_efc );
933:

Line 932: igf_ap_efc_subf.a_efc_not_9(l_p_cont_less_9, l_s_cont_less_9, l_s_cont_assets, p_efc );

928: -- Get Student's contribution from Available Income for < 9 months
929: igf_ap_efc_subf.a_s_cont_less_9 ( l_s_cont, p_no_of_months, l_s_cont_less_9 );
930:
931: -- Get Student's EFC for < 9 months
932: igf_ap_efc_subf.a_efc_not_9(l_p_cont_less_9, l_s_cont_less_9, l_s_cont_assets, p_efc );
933:
934: -- Due to a differential that is coming in the formula which requires
935: -- Independent calculation for 9th ,10th , 11th and 12th Month .
936: -- The following structure is added.

Line 939: igf_ap_efc_subf.a_efc( l_p_cont, l_s_cont, l_s_cont_assets, g_efc_a_9 );

935: -- Independent calculation for 9th ,10th , 11th and 12th Month .
936: -- The following structure is added.
937: IF p_no_of_months > 8 THEN
938: -- Get Parents contribution for 9th month
939: igf_ap_efc_subf.a_efc( l_p_cont, l_s_cont, l_s_cont_assets, g_efc_a_9 );
940: END IF ;
941:
942: IF p_no_of_months > 9 THEN
943: -- Get Parents contribution for 10th month

Line 944: igf_ap_efc_subf.a_p_cont_more_9(l_p_aai, l_p_cont, 10, l_p_cont_more_9 );

940: END IF ;
941:
942: IF p_no_of_months > 9 THEN
943: -- Get Parents contribution for 10th month
944: igf_ap_efc_subf.a_p_cont_more_9(l_p_aai, l_p_cont, 10, l_p_cont_more_9 );
945: -- Get Students EFC for > 9 months
946: igf_ap_efc_subf.a_efc_not_9(l_p_cont_more_9,l_s_cont, l_s_cont_assets, g_efc_a_10 );
947: END IF ;
948:

Line 946: igf_ap_efc_subf.a_efc_not_9(l_p_cont_more_9,l_s_cont, l_s_cont_assets, g_efc_a_10 );

942: IF p_no_of_months > 9 THEN
943: -- Get Parents contribution for 10th month
944: igf_ap_efc_subf.a_p_cont_more_9(l_p_aai, l_p_cont, 10, l_p_cont_more_9 );
945: -- Get Students EFC for > 9 months
946: igf_ap_efc_subf.a_efc_not_9(l_p_cont_more_9,l_s_cont, l_s_cont_assets, g_efc_a_10 );
947: END IF ;
948:
949: IF p_no_of_months > 10 THEN
950: -- Get Parents contribution for 11th month

Line 951: igf_ap_efc_subf.a_p_cont_more_9(l_p_aai, l_p_cont, 11, l_p_cont_more_9 );

947: END IF ;
948:
949: IF p_no_of_months > 10 THEN
950: -- Get Parents contribution for 11th month
951: igf_ap_efc_subf.a_p_cont_more_9(l_p_aai, l_p_cont, 11, l_p_cont_more_9 );
952: -- Get Students EFC for 11th month
953: igf_ap_efc_subf.a_efc_not_9(l_p_cont_more_9,l_s_cont, l_s_cont_assets, g_efc_a_11 );
954: END IF ;
955:

Line 953: igf_ap_efc_subf.a_efc_not_9(l_p_cont_more_9,l_s_cont, l_s_cont_assets, g_efc_a_11 );

949: IF p_no_of_months > 10 THEN
950: -- Get Parents contribution for 11th month
951: igf_ap_efc_subf.a_p_cont_more_9(l_p_aai, l_p_cont, 11, l_p_cont_more_9 );
952: -- Get Students EFC for 11th month
953: igf_ap_efc_subf.a_efc_not_9(l_p_cont_more_9,l_s_cont, l_s_cont_assets, g_efc_a_11 );
954: END IF ;
955:
956:
957: IF p_no_of_months > 11 THEN

Line 959: igf_ap_efc_subf.a_p_cont_more_9(l_p_aai, l_p_cont, 12, l_p_cont_more_9 );

955:
956:
957: IF p_no_of_months > 11 THEN
958: -- Get Parents contribution for 11th month
959: igf_ap_efc_subf.a_p_cont_more_9(l_p_aai, l_p_cont, 12, l_p_cont_more_9 );
960: -- Get Students EFC for 12th month
961: igf_ap_efc_subf.a_efc_not_9(l_p_cont_more_9,l_s_cont, l_s_cont_assets, g_efc_a_12 );
962: END IF;
963:

Line 961: igf_ap_efc_subf.a_efc_not_9(l_p_cont_more_9,l_s_cont, l_s_cont_assets, g_efc_a_12 );

957: IF p_no_of_months > 11 THEN
958: -- Get Parents contribution for 11th month
959: igf_ap_efc_subf.a_p_cont_more_9(l_p_aai, l_p_cont, 12, l_p_cont_more_9 );
960: -- Get Students EFC for 12th month
961: igf_ap_efc_subf.a_efc_not_9(l_p_cont_more_9,l_s_cont, l_s_cont_assets, g_efc_a_12 );
962: END IF;
963:
964: EXCEPTION
965: WHEN EXCEPTION_IN_SETUP THEN

Line 998: igf_ap_efc_subf.b_s_inc( l_s_inc );

994:
995: BEGIN
996:
997: -- Get Student/Spouse income in 2000
998: igf_ap_efc_subf.b_s_inc( l_s_inc );
999:
1000: -- Get Allowance against Student/Spouse income
1001: igf_ap_efc_subf.b_allow_ag_s_inc( l_s_inc, l_allow_ag_s_inc );
1002:

Line 1001: igf_ap_efc_subf.b_allow_ag_s_inc( l_s_inc, l_allow_ag_s_inc );

997: -- Get Student/Spouse income in 2000
998: igf_ap_efc_subf.b_s_inc( l_s_inc );
999:
1000: -- Get Allowance against Student/Spouse income
1001: igf_ap_efc_subf.b_allow_ag_s_inc( l_s_inc, l_allow_ag_s_inc );
1002:
1003: -- Get contribution from Available Income
1004: igf_ap_efc_subf.b_s_cont( l_s_inc, l_allow_ag_s_inc, l_s_cont );
1005:

Line 1004: igf_ap_efc_subf.b_s_cont( l_s_inc, l_allow_ag_s_inc, l_s_cont );

1000: -- Get Allowance against Student/Spouse income
1001: igf_ap_efc_subf.b_allow_ag_s_inc( l_s_inc, l_allow_ag_s_inc );
1002:
1003: -- Get contribution from Available Income
1004: igf_ap_efc_subf.b_s_cont( l_s_inc, l_allow_ag_s_inc, l_s_cont );
1005:
1006: -- Get Student/Spouse contribution from Assets
1007: igf_ap_efc_subf.b_s_cont_assets ( l_s_cont_assets );
1008:

Line 1007: igf_ap_efc_subf.b_s_cont_assets ( l_s_cont_assets );

1003: -- Get contribution from Available Income
1004: igf_ap_efc_subf.b_s_cont( l_s_inc, l_allow_ag_s_inc, l_s_cont );
1005:
1006: -- Get Student/Spouse contribution from Assets
1007: igf_ap_efc_subf.b_s_cont_assets ( l_s_cont_assets );
1008:
1009: l_sec_efc_s_cont_assets := l_s_cont_assets;
1010:
1011: IF ( p_frml_code <> '2' ) THEN

Line 1016: igf_ap_efc_subf.b_efc ( l_s_cont, l_s_cont_assets, p_efc );

1012: l_s_cont_assets := 0;
1013: END IF;
1014:
1015: -- Get Expected Family Contribution for 9 months
1016: igf_ap_efc_subf.b_efc ( l_s_cont, l_s_cont_assets, p_efc );
1017:
1018: IF ( p_sec_efc_type = '2') THEN
1019: -- Get Expected Family Contribution for 9 months for secondary efc type 2.
1020: igf_ap_efc_subf.b_efc ( l_s_cont, l_sec_efc_s_cont_assets, p_sec_efc );

Line 1020: igf_ap_efc_subf.b_efc ( l_s_cont, l_sec_efc_s_cont_assets, p_sec_efc );

1016: igf_ap_efc_subf.b_efc ( l_s_cont, l_s_cont_assets, p_efc );
1017:
1018: IF ( p_sec_efc_type = '2') THEN
1019: -- Get Expected Family Contribution for 9 months for secondary efc type 2.
1020: igf_ap_efc_subf.b_efc ( l_s_cont, l_sec_efc_s_cont_assets, p_sec_efc );
1021: END IF;
1022:
1023: IF ( p_no_of_months >= 9 ) THEN
1024: NULL; -- In this case EFC for > 9 months is = 9 month EFC

Line 1027: igf_ap_efc_subf.b_efc_less_9( p_no_of_months, p_efc );

1023: IF ( p_no_of_months >= 9 ) THEN
1024: NULL; -- In this case EFC for > 9 months is = 9 month EFC
1025: ELSE
1026: -- Get Expected Family Contribution for less than 9 months
1027: igf_ap_efc_subf.b_efc_less_9( p_no_of_months, p_efc );
1028:
1029: IF ( p_sec_efc_type = '2') THEN
1030: igf_ap_efc_subf.b_efc_less_9( p_no_of_months, p_sec_efc );
1031: END IF;

Line 1030: igf_ap_efc_subf.b_efc_less_9( p_no_of_months, p_sec_efc );

1026: -- Get Expected Family Contribution for less than 9 months
1027: igf_ap_efc_subf.b_efc_less_9( p_no_of_months, p_efc );
1028:
1029: IF ( p_sec_efc_type = '2') THEN
1030: igf_ap_efc_subf.b_efc_less_9( p_no_of_months, p_sec_efc );
1031: END IF;
1032: END IF;
1033:
1034: EXCEPTION

Line 1069: igf_ap_efc_subf.c_s_inc ( l_s_inc );

1065: l_s_cont NUMBER(12,3) ; -- Contribution from Available Income
1066:
1067: BEGIN
1068: -- Get Student/Spouse Income in 2000.
1069: igf_ap_efc_subf.c_s_inc ( l_s_inc );
1070:
1071: -- Get Allowances against Student/Spouse Income
1072: igf_ap_efc_subf.c_allow_ag_s_inc ( l_s_inc, l_allow_ag_s_inc );
1073:

Line 1072: igf_ap_efc_subf.c_allow_ag_s_inc ( l_s_inc, l_allow_ag_s_inc );

1068: -- Get Student/Spouse Income in 2000.
1069: igf_ap_efc_subf.c_s_inc ( l_s_inc );
1070:
1071: -- Get Allowances against Student/Spouse Income
1072: igf_ap_efc_subf.c_allow_ag_s_inc ( l_s_inc, l_allow_ag_s_inc );
1073:
1074: -- Get Available Income
1075: igf_ap_efc_subf.c_available_inc( l_s_inc, l_allow_ag_s_inc, l_available_income );
1076:

Line 1075: igf_ap_efc_subf.c_available_inc( l_s_inc, l_allow_ag_s_inc, l_available_income );

1071: -- Get Allowances against Student/Spouse Income
1072: igf_ap_efc_subf.c_allow_ag_s_inc ( l_s_inc, l_allow_ag_s_inc );
1073:
1074: -- Get Available Income
1075: igf_ap_efc_subf.c_available_inc( l_s_inc, l_allow_ag_s_inc, l_available_income );
1076:
1077:
1078: -- Get Available Income
1079: -- igf_ap_efc_subf.c_available_inc( l_s_inc, l_allow_ag_s_inc, l_s_cont );

Line 1079: -- igf_ap_efc_subf.c_available_inc( l_s_inc, l_allow_ag_s_inc, l_s_cont );

1075: igf_ap_efc_subf.c_available_inc( l_s_inc, l_allow_ag_s_inc, l_available_income );
1076:
1077:
1078: -- Get Available Income
1079: -- igf_ap_efc_subf.c_available_inc( l_s_inc, l_allow_ag_s_inc, l_s_cont );
1080:
1081: -- Get Student/Spouse contribution from Assets
1082: igf_ap_efc_subf.c_s_cont_assets ( l_s_cont_assets );
1083:

Line 1082: igf_ap_efc_subf.c_s_cont_assets ( l_s_cont_assets );

1078: -- Get Available Income
1079: -- igf_ap_efc_subf.c_available_inc( l_s_inc, l_allow_ag_s_inc, l_s_cont );
1080:
1081: -- Get Student/Spouse contribution from Assets
1082: igf_ap_efc_subf.c_s_cont_assets ( l_s_cont_assets );
1083:
1084:
1085: IF ( p_frml_code = '6') then
1086: igf_ap_efc_subf.c_efc ( l_available_income, 0, p_efc , 'P' );

Line 1086: igf_ap_efc_subf.c_efc ( l_available_income, 0, p_efc , 'P' );

1082: igf_ap_efc_subf.c_s_cont_assets ( l_s_cont_assets );
1083:
1084:
1085: IF ( p_frml_code = '6') then
1086: igf_ap_efc_subf.c_efc ( l_available_income, 0, p_efc , 'P' );
1087: igf_ap_efc_subf.c_efc ( l_available_income, l_s_cont_assets, p_sec_efc, 'S' );
1088: ELSE
1089: igf_ap_efc_subf.c_efc ( l_available_income, l_s_cont_assets, p_efc, 'P' );
1090: END IF;

Line 1087: igf_ap_efc_subf.c_efc ( l_available_income, l_s_cont_assets, p_sec_efc, 'S' );

1083:
1084:
1085: IF ( p_frml_code = '6') then
1086: igf_ap_efc_subf.c_efc ( l_available_income, 0, p_efc , 'P' );
1087: igf_ap_efc_subf.c_efc ( l_available_income, l_s_cont_assets, p_sec_efc, 'S' );
1088: ELSE
1089: igf_ap_efc_subf.c_efc ( l_available_income, l_s_cont_assets, p_efc, 'P' );
1090: END IF;
1091:

Line 1089: igf_ap_efc_subf.c_efc ( l_available_income, l_s_cont_assets, p_efc, 'P' );

1085: IF ( p_frml_code = '6') then
1086: igf_ap_efc_subf.c_efc ( l_available_income, 0, p_efc , 'P' );
1087: igf_ap_efc_subf.c_efc ( l_available_income, l_s_cont_assets, p_sec_efc, 'S' );
1088: ELSE
1089: igf_ap_efc_subf.c_efc ( l_available_income, l_s_cont_assets, p_efc, 'P' );
1090: END IF;
1091:
1092: IF ( p_no_of_months >= 9 ) THEN
1093:

Line 1098: igf_ap_efc_subf.c_efc_less_9( p_no_of_months, p_efc );

1094: NULL; -- In this case EFC for > 9 months is = 9 month EFC
1095: ELSE
1096:
1097: -- Get Expected Family Contribution for less than 9 months
1098: igf_ap_efc_subf.c_efc_less_9( p_no_of_months, p_efc );
1099:
1100: IF ( p_sec_efc_type = '3') THEN
1101: igf_ap_efc_subf.c_efc_less_9( p_no_of_months, p_sec_efc );
1102: END IF;

Line 1101: igf_ap_efc_subf.c_efc_less_9( p_no_of_months, p_sec_efc );

1097: -- Get Expected Family Contribution for less than 9 months
1098: igf_ap_efc_subf.c_efc_less_9( p_no_of_months, p_efc );
1099:
1100: IF ( p_sec_efc_type = '3') THEN
1101: igf_ap_efc_subf.c_efc_less_9( p_no_of_months, p_sec_efc );
1102: END IF;
1103:
1104: END IF;
1105:

Line 1185: igf_ap_efc_subf.auto_zero_efc(p_isir_rec.primary_efc_type);

1181: l_ftype := 'S'; -- Simplified
1182: END IF;
1183:
1184: IF ( p_formula = '5' and p_isir_rec.sec_efc_type = '2' ) THEN
1185: igf_ap_efc_subf.auto_zero_efc(p_isir_rec.primary_efc_type);
1186: -- AUTO ZERO
1187: p_sec_efc := 0;
1188: g_s_efc_a_9 := null ;
1189: g_s_efc_a_10 := null ;

Line 1196: igf_ap_efc_subf.auto_zero_efc(p_isir_rec.primary_efc_type);

1192:
1193: END IF;
1194:
1195: IF ( p_formula = '0' ) THEN
1196: igf_ap_efc_subf.auto_zero_efc(p_isir_rec.primary_efc_type);
1197: -- AUTO ZERO
1198: p_efc := 0;
1199: g_efc_a_9 := null ;
1200: g_efc_a_10 := null ;