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.

[Home] [Help]

APPS.IGS_AS_CALC_AWARD_MARK dependencies on IGS_PR_UL_MARK_DTL

Line 246: p_core_ind_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE,

242: END get_earned_cp;
243:
244: FUNCTION get_avail_cp (p_person_id igs_as_su_stmptout.person_id%TYPE,
245: p_course_cd igs_as_su_stmptout.course_cd%TYPE,
246: p_core_ind_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE,
247: p_unit_level igs_pr_ul_mark_cnfg.unit_level%TYPE)
248: RETURN NUMBER
249: IS
250: -- cursor to get the sum of available cp

Line 253: cp_core_ind_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE,

249: IS
250: -- cursor to get the sum of available cp
251: CURSOR c_avail_cp (cp_person_id igs_as_su_stmptout.person_id%TYPE,
252: cp_course_cd igs_as_su_stmptout.course_cd%TYPE,
253: cp_core_ind_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE,
254: cp_unit_level igs_pr_ul_mark_cnfg.unit_level%TYPE) IS
255: SELECT SUM(
256: get_earned_cp
257: (

Line 418: cp_mark_config_id igs_pr_ul_mark_dtl.mark_config_id%TYPE

414: ) = cp_include;
415:
416: -- CURSOR to get cnfg details
417: CURSOR c_ul_mark_dtl (
418: cp_mark_config_id igs_pr_ul_mark_dtl.mark_config_id%TYPE
419: )
420: IS
421: SELECT core_indicator_code, total_credits, required_flag,
422: priority_num, unit_selection_code

Line 423: FROM igs_pr_ul_mark_dtl

419: )
420: IS
421: SELECT core_indicator_code, total_credits, required_flag,
422: priority_num, unit_selection_code
423: FROM igs_pr_ul_mark_dtl
424: WHERE mark_config_id = cp_mark_config_id
425: ORDER BY priority_num ASC;
426:
427: rec_ul_mark_dtl c_ul_mark_dtl%ROWTYPE;

Line 429: p1_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;

425: ORDER BY priority_num ASC;
426:
427: rec_ul_mark_dtl c_ul_mark_dtl%ROWTYPE;
428: -- define the local variables to store the above values
429: p1_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
430: p1_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
431: p1_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
432: p1_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
433: p1_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;

Line 430: p1_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;

426:
427: rec_ul_mark_dtl c_ul_mark_dtl%ROWTYPE;
428: -- define the local variables to store the above values
429: p1_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
430: p1_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
431: p1_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
432: p1_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
433: p1_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
434: p2_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;

Line 431: p1_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;

427: rec_ul_mark_dtl c_ul_mark_dtl%ROWTYPE;
428: -- define the local variables to store the above values
429: p1_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
430: p1_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
431: p1_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
432: p1_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
433: p1_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
434: p2_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
435: p2_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;

Line 432: p1_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;

428: -- define the local variables to store the above values
429: p1_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
430: p1_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
431: p1_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
432: p1_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
433: p1_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
434: p2_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
435: p2_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
436: p2_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;

Line 433: p1_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;

429: p1_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
430: p1_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
431: p1_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
432: p1_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
433: p1_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
434: p2_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
435: p2_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
436: p2_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
437: p2_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;

Line 434: p2_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;

430: p1_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
431: p1_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
432: p1_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
433: p1_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
434: p2_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
435: p2_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
436: p2_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
437: p2_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
438: p2_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;

Line 435: p2_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;

431: p1_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
432: p1_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
433: p1_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
434: p2_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
435: p2_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
436: p2_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
437: p2_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
438: p2_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
439: p3_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;

Line 436: p2_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;

432: p1_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
433: p1_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
434: p2_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
435: p2_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
436: p2_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
437: p2_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
438: p2_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
439: p3_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
440: p3_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;

Line 437: p2_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;

433: p1_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
434: p2_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
435: p2_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
436: p2_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
437: p2_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
438: p2_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
439: p3_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
440: p3_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
441: p3_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;

Line 438: p2_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;

434: p2_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
435: p2_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
436: p2_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
437: p2_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
438: p2_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
439: p3_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
440: p3_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
441: p3_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
442: p3_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;

Line 439: p3_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;

435: p2_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
436: p2_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
437: p2_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
438: p2_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
439: p3_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
440: p3_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
441: p3_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
442: p3_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
443: p3_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;

Line 440: p3_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;

436: p2_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
437: p2_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
438: p2_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
439: p3_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
440: p3_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
441: p3_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
442: p3_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
443: p3_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
444: -- following local variable to manipulate the derived cp at each unit level

Line 441: p3_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;

437: p2_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
438: p2_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
439: p3_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
440: p3_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
441: p3_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
442: p3_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
443: p3_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
444: -- following local variable to manipulate the derived cp at each unit level
445: p1_avail_cp NUMBER := 0;

Line 442: p3_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;

438: p2_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
439: p3_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
440: p3_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
441: p3_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
442: p3_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
443: p3_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
444: -- following local variable to manipulate the derived cp at each unit level
445: p1_avail_cp NUMBER := 0;
446: p1_config_cp NUMBER := 0;

Line 443: p3_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;

439: p3_core_indicator_code igs_pr_ul_mark_dtl.core_indicator_code%TYPE;
440: p3_total_credits igs_pr_ul_mark_dtl.total_credits%TYPE;
441: p3_required_flag igs_pr_ul_mark_dtl.required_flag%TYPE;
442: p3_priority_num igs_pr_ul_mark_dtl.priority_num%TYPE;
443: p3_unit_selection_code igs_pr_ul_mark_dtl.unit_selection_code%TYPE;
444: -- following local variable to manipulate the derived cp at each unit level
445: p1_avail_cp NUMBER := 0;
446: p1_config_cp NUMBER := 0;
447: p1_required_cp NUMBER := 0;

Line 463: cp_mark_config_id igs_pr_ul_mark_dtl.mark_config_id%TYPE

459: p3_final_derived_cp NUMBER := 0;
460:
461: -- cursor to get the config details based on mark_config_id
462: CURSOR c_cnfg_dtls (
463: cp_mark_config_id igs_pr_ul_mark_dtl.mark_config_id%TYPE
464: )
465: IS
466: SELECT core_indicator_code, total_credits, required_flag,
467: priority_num, unit_selection_code

Line 468: FROM igs_pr_ul_mark_dtl

464: )
465: IS
466: SELECT core_indicator_code, total_credits, required_flag,
467: priority_num, unit_selection_code
468: FROM igs_pr_ul_mark_dtl
469: WHERE mark_config_id = cp_mark_config_id
470: ORDER BY priority_num ASC;
471:
472: /* jhanda */