[Home] [Help]
56: p_system_stat IN VARCHAR2,
57: p_cumulative_ind IN VARCHAR2,
58: p_stat_type IN OUT NOCOPY igs_pr_stat_type.stat_type%TYPE,
59: p_org_unit_cd OUT NOCOPY igs_pr_org_stat.org_unit_cd%TYPE,
60: p_include_std_ind OUT NOCOPY igs_pr_org_stat.include_standard_ind%TYPE,
61: p_include_local_ind OUT NOCOPY igs_pr_org_stat.include_local_ind%TYPE,
62: p_include_other_ind OUT NOCOPY igs_pr_org_stat.include_other_ind%TYPE,
63: p_derivation OUT NOCOPY igs_pr_stat_type.derivation%TYPE,
64: p_init_msg_list IN VARCHAR2,
352: END IF;
353:
354: -- Initialize API return status to success.
355: p_return_status := fnd_api.g_ret_sts_success;
356: -- Standard call to get message count and if count is 1, get message info
357: fnd_msg_pub.count_and_get (
358: p_encoded=> fnd_api.g_false,
359: p_count=> p_msg_count,
360: p_data=> p_msg_data
403: p_system_stat IN VARCHAR2,
404: p_cumulative_ind IN VARCHAR2,
405: p_stat_type IN OUT NOCOPY igs_pr_stat_type.stat_type%TYPE,
406: p_org_unit_cd OUT NOCOPY igs_pr_org_stat.org_unit_cd%TYPE,
407: p_include_std_ind OUT NOCOPY igs_pr_org_stat.include_standard_ind%TYPE,
408: p_include_local_ind OUT NOCOPY igs_pr_org_stat.include_local_ind%TYPE,
409: p_include_other_ind OUT NOCOPY igs_pr_org_stat.include_other_ind%TYPE,
410: p_derivation OUT NOCOPY igs_pr_stat_type.derivation%TYPE,
411: p_init_msg_list IN VARCHAR2,
433: CURSOR c_org_stat IS
434: SELECT orst.org_unit_cd,
435: st.stat_type,
436: st.derivation,
437: orst.include_standard_ind,
438: orst.include_local_ind,
439: orst.include_other_ind
440: FROM igs_en_stdnt_ps_att spa,
441: igs_ps_ver crv,
448: AND st.stat_type = orst.stat_type
449: AND orst.org_unit_cd = crv.responsible_org_unit_cd
450: AND (orst.stat_type = p_stat_type
451: OR p_stat_type IS NULL
452: AND ((p_system_stat IS NULL AND orst.standard_ind = 'Y')
453: OR (p_system_stat = 'STANDARD' AND orst.standard_ind = 'Y'))
454: AND ((p_cumulative_ind = 'Y'
455: AND (orst.timeframe = 'CUMULATIVE'
456: OR orst.timeframe = 'BOTH'))
449: AND orst.org_unit_cd = crv.responsible_org_unit_cd
450: AND (orst.stat_type = p_stat_type
451: OR p_stat_type IS NULL
452: AND ((p_system_stat IS NULL AND orst.standard_ind = 'Y')
453: OR (p_system_stat = 'STANDARD' AND orst.standard_ind = 'Y'))
454: AND ((p_cumulative_ind = 'Y'
455: AND (orst.timeframe = 'CUMULATIVE'
456: OR orst.timeframe = 'BOTH'))
457: OR (p_cumulative_ind = 'N' AND orst.timeframe = 'PERIOD'
462: --
463: CURSOR c_inst_stat IS
464: SELECT st.stat_type,
465: st.derivation,
466: inst.include_standard_ind,
467: inst.include_local_ind,
468: inst.include_other_ind
469: FROM igs_pr_stat_type st, igs_pr_inst_stat inst
470: WHERE st.stat_type = inst.stat_type
469: FROM igs_pr_stat_type st, igs_pr_inst_stat inst
470: WHERE st.stat_type = inst.stat_type
471: AND (inst.stat_type = p_stat_type
472: OR p_stat_type IS NULL
473: AND ((p_system_stat IS NULL AND inst.standard_ind = 'Y')
474: OR (p_system_stat = 'STANDARD' AND inst.standard_ind =
475: 'Y'))
476: AND ((p_cumulative_ind = 'Y'
477: AND (inst.timeframe = 'CUMULATIVE'
470: WHERE st.stat_type = inst.stat_type
471: AND (inst.stat_type = p_stat_type
472: OR p_stat_type IS NULL
473: AND ((p_system_stat IS NULL AND inst.standard_ind = 'Y')
474: OR (p_system_stat = 'STANDARD' AND inst.standard_ind =
475: 'Y'))
476: AND ((p_cumulative_ind = 'Y'
477: AND (inst.timeframe = 'CUMULATIVE'
478: OR inst.timeframe = 'BOTH'))
503: END IF;
504:
505: --
506: -- Check whether the system stat is not within the given values
507: -- i.e standard,fin_aid or progession
508: -- If not raise an error
509: --
510: IF (p_system_stat IS NOT NULL
511: AND p_system_stat NOT IN ('STANDARD', 'FIN_AID', 'PROGRESSION')) THEN
507: -- i.e standard,fin_aid or progession
508: -- If not raise an error
509: --
510: IF (p_system_stat IS NOT NULL
511: AND p_system_stat NOT IN ('STANDARD', 'FIN_AID', 'PROGRESSION')) THEN
512: l_message := 'IGS_PR_SYSTEM_STAT_INCORRECT';
513: fnd_message.set_name('IGS', l_message);
514: fnd_msg_pub.ADD;
515: RAISE fnd_api.g_exc_error;
526: ELSE
527: p_stat_type := lc_org_stat.stat_type;
528: p_derivation := lc_org_stat.derivation;
529: p_org_unit_cd := lc_org_stat.org_unit_cd;
530: p_include_std_ind := lc_org_stat.include_standard_ind;
531: p_include_local_ind := lc_org_stat.include_local_ind;
532: p_include_other_ind := lc_org_stat.include_other_ind;
533: END IF;
534:
556: ELSE
557: p_stat_type := lc_inst_stat.stat_type;
558: p_derivation := lc_inst_stat.derivation;
559: p_org_unit_cd := NULL;
560: p_include_std_ind := lc_inst_stat.include_standard_ind;
561: p_include_local_ind := lc_inst_stat.include_local_ind;
562: p_include_other_ind := lc_inst_stat.include_other_ind;
563: END IF;
564:
567:
568: CLOSE c_org_stat;
569: -- Initialize API return status to success.
570: p_return_status := fnd_api.g_ret_sts_success;
571: -- Standard call to get message count and if count is 1, get message info
572: fnd_msg_pub.count_and_get(
573: p_encoded => fnd_api.g_false,
574: p_count => p_msg_count,
575: p_data => p_msg_data);
784: END IF;
785:
786: -- Initialize API return status to success.
787: p_return_status := fnd_api.g_ret_sts_success;
788: -- Standard call to get message count and if count is 1, get message info
789: fnd_msg_pub.count_and_get(
790: p_encoded => fnd_api.g_false,
791: p_count => p_msg_count,
792: p_data => p_msg_data);
1025: p_attempted_cp := l_attempted_cp_total;
1026: p_earned_cp := l_earned_cp_total;
1027: -- Initialize API return status to success.
1028: p_return_status := fnd_api.g_ret_sts_success;
1029: -- Standard call to get message count and if count is 1, get message info.
1030: fnd_msg_pub.count_and_get(
1031: p_encoded => fnd_api.g_false,
1032: p_count => p_msg_count,
1033: p_data => p_msg_data);
1267: END IF;
1268:
1269: -- Initialize API return status to success.
1270: p_return_status := fnd_api.g_ret_sts_success;
1271: -- Standard call to get message count and if count is 1, get message info.
1272: fnd_msg_pub.count_and_get(
1273: p_encoded => fnd_api.g_false,
1274: p_count => p_msg_count,
1275: p_data => p_msg_data);
1338: --------------------------------------------------------------------------
1339:
1340: l_stat_type igs_pr_stat_type.stat_type%TYPE;
1341: l_org_unit_cd igs_pr_org_stat.org_unit_cd%TYPE;
1342: l_include_std_ind igs_pr_org_stat.include_standard_ind%TYPE;
1343: l_include_local_ind igs_pr_org_stat.include_local_ind%TYPE;
1344: l_include_other_ind igs_pr_org_stat.include_other_ind%TYPE;
1345: l_derivation igs_pr_stat_type.derivation%TYPE;
1346: l_earned_cp NUMBER;
1427: p_msg_data := l_msg_data;
1428: RETURN;
1429: END IF;
1430:
1431: -- Check for the Standard Indicator Flag then loop thru Student Unit Attempts
1432: IF l_include_std_ind = 'Y' THEN
1433: -- Check if the Unit Reference Code is included/excluded for this Stat Type
1434: IF chk_unit_ref_cd(
1435: p_unit_cd,
1531: p_earned_cp := l_earned_cp;
1532: p_attempted_cp := l_attempted_cp;
1533: -- Initialize API return status to success.
1534: p_return_status := fnd_api.g_ret_sts_success;
1535: -- Standard call to get message count and if count is 1, get message info.
1536: fnd_msg_pub.count_and_get(
1537: p_encoded => fnd_api.g_false,
1538: p_count => p_msg_count,
1539: p_data => p_msg_data);
1672: p_earned_cp := l_earned_cp;
1673: p_attempted_cp := l_attempted_cp;
1674: -- Initialize API return status to success.
1675: p_return_status := fnd_api.g_ret_sts_success;
1676: -- Standard call to get message count and if count is 1, get message info.
1677: fnd_msg_pub.count_and_get(
1678: p_encoded => fnd_api.g_false,
1679: p_count => p_msg_count,
1680: p_data => p_msg_data);
1807: p_gpa_cp := l_gpa_cp;
1808: p_gpa_quality_points := l_gpa_quality_points;
1809: -- Initialize API return status to success.
1810: p_return_status := fnd_api.g_ret_sts_success;
1811: -- Standard call to get message count and if count is 1, get message info.
1812: fnd_msg_pub.count_and_get(
1813: p_encoded => fnd_api.g_false,
1814: p_count => p_msg_count,
1815: p_data => p_msg_data);
2000: l_gpa_qp_total NUMBER := 0;
2001: l_gpa_value NUMBER := 0;
2002: l_stat_type igs_pr_stat_type.stat_type%TYPE;
2003: l_org_unit_cd igs_pr_org_stat.org_unit_cd%TYPE;
2004: l_include_std_ind igs_pr_org_stat.include_standard_ind%TYPE;
2005: l_include_local_ind igs_pr_org_stat.include_local_ind%TYPE;
2006: l_include_other_ind igs_pr_org_stat.include_other_ind%TYPE;
2007: l_derivation igs_pr_stat_type.derivation%TYPE;
2008: l_init_msg_list VARCHAR2(20);
2101: p_gpa_cp := lc_sas.gpa_credit_points;
2102: p_gpa_quality_points := lc_sas.gpa_quality_points;
2103: -- Initialize API return status to success.
2104: p_return_status := fnd_api.g_ret_sts_success;
2105: -- Standard call to get message count and if count is 1, get message info
2106: fnd_msg_pub.count_and_get(
2107: p_encoded => fnd_api.g_false,
2108: p_count => p_msg_count,
2109: p_data => p_msg_data);
2118: p_gpa_quality_points :=NULL;
2119:
2120: -- Initialize API return status to success.
2121: p_return_status := fnd_api.g_ret_sts_success;
2122: -- Standard call to get message count and if count is 1, get message info
2123: fnd_msg_pub.count_and_get(
2124: p_encoded => fnd_api.g_false,
2125: p_count => p_msg_count,
2126: p_data => p_msg_data);
2145: p_gpa_cp := lc_sas.gpa_credit_points;
2146: p_gpa_quality_points := lc_sas.gpa_quality_points;
2147: -- Initialize API return status to success.
2148: p_return_status := fnd_api.g_ret_sts_success;
2149: -- Standard call to get message count and if count is 1, get message info
2150: fnd_msg_pub.count_and_get(
2151: p_encoded => fnd_api.g_false,
2152: p_count => p_msg_count,
2153: p_data => p_msg_data);
2157: CLOSE c_sas;
2158: END IF;
2159:
2160:
2161: -- Check for the Standard Indicator Flag then loop through Student Unit
2162: -- Attempts
2163: IF l_include_std_ind = 'Y' THEN
2164: -- Loop through all of the Student Unit Attempts records (SUA)
2165: FOR lc_sua_uv IN c_sua_uv LOOP
2306: p_earned_cp := l_earned_cp_total;
2307: p_enrolled_cp :=l_enrolled_cp_total;
2308: -- Initialize API return status to success.
2309: p_return_status := fnd_api.g_ret_sts_success;
2310: -- Standard call to get message count and if count is 1, get message
2311: -- info.
2312: fnd_msg_pub.count_and_get(
2313: p_encoded => fnd_api.g_false,
2314: p_count => p_msg_count,
2426: p_earned_cp := l_earned_cp;
2427: p_attempted_cp := l_attempted_cp;
2428: -- Initialize API return status to success.
2429: p_return_status := fnd_api.g_ret_sts_success;
2430: -- Standard call to get message count and if count is 1, get message info.
2431: fnd_msg_pub.count_and_get(
2432: p_encoded => fnd_api.g_false,
2433: p_count => p_msg_count,
2434: p_data => p_msg_data);
2545: p_gpa_cp := l_gpa_cp;
2546: p_gpa_quality_points := l_gpa_quality_points;
2547: -- Initialize API return status to success.
2548: p_return_status := fnd_api.g_ret_sts_success;
2549: -- Standard call to get message count and if count is 1, get message info.
2550: fnd_msg_pub.count_and_get(
2551: p_encoded => fnd_api.g_false,
2552: p_count => p_msg_count,
2553: p_data => p_msg_data);
2765: END IF;
2766:
2767: -- Initialize API return status to success.
2768: p_return_status := fnd_api.g_ret_sts_success;
2769: -- Standard call to get message count and if count is 1, get message info
2770: fnd_msg_pub.count_and_get(
2771: p_encoded => fnd_api.g_false,
2772: p_count => p_msg_count,
2773: p_data => p_msg_data);