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.IGS_PS_GEN_008 dependencies on IGS_CA_INST

Line 2509: v_exam_cal_type igs_ca_inst.cal_type%TYPE;

2505: v_tro_recs_skipped BOOLEAN ;
2506: v_uai_continue BOOLEAN ;
2507: v_ret_val BOOLEAN ;
2508: v_successful_pattern_mbr BOOLEAN ;
2509: v_exam_cal_type igs_ca_inst.cal_type%TYPE;
2510: v_exam_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2511: v_latest_gs_version igs_as_grd_schema.version_number%TYPE;
2512: v_unit_contact igs_ps_unit_ofr_opt.unit_contact%TYPE;
2513: v_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE;

Line 2510: v_exam_ci_sequence_number igs_ca_inst.sequence_number%TYPE;

2506: v_uai_continue BOOLEAN ;
2507: v_ret_val BOOLEAN ;
2508: v_successful_pattern_mbr BOOLEAN ;
2509: v_exam_cal_type igs_ca_inst.cal_type%TYPE;
2510: v_exam_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
2511: v_latest_gs_version igs_as_grd_schema.version_number%TYPE;
2512: v_unit_contact igs_ps_unit_ofr_opt.unit_contact%TYPE;
2513: v_assessment_type igs_as_assessmnt_typ.assessment_type%TYPE;
2514: v_reference igs_as_unitass_item.reference%TYPE;

Line 2598: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS

2594: CURSOR c_uai_seq_num IS
2595: SELECT IGS_AS_UNITASS_ITEM_SEQ_NUM_S.NEXTVAL
2596: FROM DUAL;
2597:
2598: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2599: SELECT start_dt,end_dt
2600: FROM igs_ca_inst_all
2601: WHERE cal_type = cp_cal_type
2602: AND sequence_number = cp_seq_num;

Line 2600: FROM igs_ca_inst_all

2596: FROM DUAL;
2597:
2598: CURSOR c_teach_date(cp_cal_type igs_ca_inst_all.cal_type%TYPE ,cp_seq_num igs_ca_inst_all.sequence_number%TYPE) IS
2599: SELECT start_dt,end_dt
2600: FROM igs_ca_inst_all
2601: WHERE cal_type = cp_cal_type
2602: AND sequence_number = cp_seq_num;
2603: l_d_src_teach_cal_start_dt DATE;
2604: l_d_src_teach_cal_end_dt DATE;

Line 2659: PROCEDURE crspl_upd_usec_relation (p_src_cal_type igs_ca_inst.cal_type%TYPE,

2655:
2656: END handle_excp;
2657:
2658:
2659: PROCEDURE crspl_upd_usec_relation (p_src_cal_type igs_ca_inst.cal_type%TYPE,
2660: p_src_sequence_num igs_ca_inst.sequence_number%TYPE,
2661: p_dst_cal_type igs_ca_inst.cal_type%TYPE,
2662: p_dst_sequence_num igs_ca_inst.sequence_number%TYPE
2663: ) AS

Line 2660: p_src_sequence_num igs_ca_inst.sequence_number%TYPE,

2656: END handle_excp;
2657:
2658:
2659: PROCEDURE crspl_upd_usec_relation (p_src_cal_type igs_ca_inst.cal_type%TYPE,
2660: p_src_sequence_num igs_ca_inst.sequence_number%TYPE,
2661: p_dst_cal_type igs_ca_inst.cal_type%TYPE,
2662: p_dst_sequence_num igs_ca_inst.sequence_number%TYPE
2663: ) AS
2664: /*************************************************************

Line 2661: p_dst_cal_type igs_ca_inst.cal_type%TYPE,

2657:
2658:
2659: PROCEDURE crspl_upd_usec_relation (p_src_cal_type igs_ca_inst.cal_type%TYPE,
2660: p_src_sequence_num igs_ca_inst.sequence_number%TYPE,
2661: p_dst_cal_type igs_ca_inst.cal_type%TYPE,
2662: p_dst_sequence_num igs_ca_inst.sequence_number%TYPE
2663: ) AS
2664: /*************************************************************
2665: Created By : sarakshi

Line 2662: p_dst_sequence_num igs_ca_inst.sequence_number%TYPE

2658:
2659: PROCEDURE crspl_upd_usec_relation (p_src_cal_type igs_ca_inst.cal_type%TYPE,
2660: p_src_sequence_num igs_ca_inst.sequence_number%TYPE,
2661: p_dst_cal_type igs_ca_inst.cal_type%TYPE,
2662: p_dst_sequence_num igs_ca_inst.sequence_number%TYPE
2663: ) AS
2664: /*************************************************************
2665: Created By : sarakshi
2666: Date Created By :23-Sep-2003

Line 2816: cal_type igs_ca_inst_all.cal_type%TYPE,

2812: l_b_var1 BOOLEAN := FALSE;
2813:
2814: --- added as a part of performance activity ---
2815: TYPE teach_cal_rec IS RECORD(
2816: cal_type igs_ca_inst_all.cal_type%TYPE,
2817: sequence_number igs_ca_inst_all.sequence_number%TYPE
2818: );
2819: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
2820: teachCalendar_tbl teachCalendar;

Line 2817: sequence_number igs_ca_inst_all.sequence_number%TYPE

2813:
2814: --- added as a part of performance activity ---
2815: TYPE teach_cal_rec IS RECORD(
2816: cal_type igs_ca_inst_all.cal_type%TYPE,
2817: sequence_number igs_ca_inst_all.sequence_number%TYPE
2818: );
2819: TYPE teachCalendar IS TABLE OF teach_cal_rec INDEX BY BINARY_INTEGER;
2820: teachCalendar_tbl teachCalendar;
2821: l_n_counter NUMBER(10);

Line 2853: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,

2849: END LOOP;
2850:
2851: END createCalendar;
2852:
2853: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2854: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS
2855: BEGIN
2856: IF teachCalendar_tbl.EXISTS(1) THEN
2857: FOR i IN 1..teachCalendar_tbl.last LOOP

Line 2854: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS

2850:
2851: END createCalendar;
2852:
2853: FUNCTION testCalendar(cp_cal_type igs_ca_inst_all.cal_type%TYPE,
2854: cp_sequence_number igs_ca_inst_all.sequence_number%TYPE) RETURN BOOLEAN AS
2855: BEGIN
2856: IF teachCalendar_tbl.EXISTS(1) THEN
2857: FOR i IN 1..teachCalendar_tbl.last LOOP
2858: IF cp_cal_type=teachCalendar_tbl(i).cal_type AND

Line 2947: p_old_exam_cal_type igs_ca_inst.cal_type%TYPE,

2943: END crspl_upd_usec_relation;
2944:
2945:
2946: PROCEDURE crspl_get_new_exam_cal (
2947: p_old_exam_cal_type igs_ca_inst.cal_type%TYPE,
2948: p_old_exam_seq_num igs_ca_inst.sequence_number%TYPE,
2949: p_new_exam_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
2950: p_new_exam_seq_num OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
2951: p_uoo_id NUMBER) AS

Line 2948: p_old_exam_seq_num igs_ca_inst.sequence_number%TYPE,

2944:
2945:
2946: PROCEDURE crspl_get_new_exam_cal (
2947: p_old_exam_cal_type igs_ca_inst.cal_type%TYPE,
2948: p_old_exam_seq_num igs_ca_inst.sequence_number%TYPE,
2949: p_new_exam_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
2950: p_new_exam_seq_num OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
2951: p_uoo_id NUMBER) AS
2952: -------------------------------------------------------------------------------------------

Line 2949: p_new_exam_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

2945:
2946: PROCEDURE crspl_get_new_exam_cal (
2947: p_old_exam_cal_type igs_ca_inst.cal_type%TYPE,
2948: p_old_exam_seq_num igs_ca_inst.sequence_number%TYPE,
2949: p_new_exam_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
2950: p_new_exam_seq_num OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
2951: p_uoo_id NUMBER) AS
2952: -------------------------------------------------------------------------------------------
2953: --Change History:

Line 2950: p_new_exam_seq_num OUT NOCOPY igs_ca_inst.sequence_number%TYPE,

2946: PROCEDURE crspl_get_new_exam_cal (
2947: p_old_exam_cal_type igs_ca_inst.cal_type%TYPE,
2948: p_old_exam_seq_num igs_ca_inst.sequence_number%TYPE,
2949: p_new_exam_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
2950: p_new_exam_seq_num OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
2951: p_uoo_id NUMBER) AS
2952: -------------------------------------------------------------------------------------------
2953: --Change History:
2954: --Who When What

Line 2963: cp_exam_cal_type igs_ca_inst.cal_type%TYPE,

2959: v_old_total_occurrence NUMBER(4) ;
2960: v_new_total_occurrence NUMBER(4) ;
2961:
2962: CURSOR c_exam_cal_type (
2963: cp_exam_cal_type igs_ca_inst.cal_type%TYPE,
2964: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
2965: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
2966: SELECT ci.cal_type,
2967: ci.sequence_number

Line 2964: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,

2960: v_new_total_occurrence NUMBER(4) ;
2961:
2962: CURSOR c_exam_cal_type (
2963: cp_exam_cal_type igs_ca_inst.cal_type%TYPE,
2964: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
2965: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
2966: SELECT ci.cal_type,
2967: ci.sequence_number
2968: FROM igs_ca_type ct,

Line 2965: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS

2961:
2962: CURSOR c_exam_cal_type (
2963: cp_exam_cal_type igs_ca_inst.cal_type%TYPE,
2964: cp_teach_cal_type igs_ca_inst.cal_type%TYPE,
2965: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
2966: SELECT ci.cal_type,
2967: ci.sequence_number
2968: FROM igs_ca_type ct,
2969: igs_ca_inst ci,

Line 2969: igs_ca_inst ci,

2965: cp_teach_seq_num igs_ca_inst.sequence_number%TYPE) IS
2966: SELECT ci.cal_type,
2967: ci.sequence_number
2968: FROM igs_ca_type ct,
2969: igs_ca_inst ci,
2970: igs_ca_inst_rel cir
2971: WHERE cir.sup_ci_sequence_number = ci.sequence_number
2972: AND cir.sup_cal_type = ci.cal_type
2973: AND ct.cal_type = ci.cal_type

Line 2970: igs_ca_inst_rel cir

2966: SELECT ci.cal_type,
2967: ci.sequence_number
2968: FROM igs_ca_type ct,
2969: igs_ca_inst ci,
2970: igs_ca_inst_rel cir
2971: WHERE cir.sup_ci_sequence_number = ci.sequence_number
2972: AND cir.sup_cal_type = ci.cal_type
2973: AND ct.cal_type = ci.cal_type
2974: AND ct.s_cal_cat = cst_exam

Line 2982: cp_exam_cal_type IGS_CA_INST.cal_type%TYPE,

2978: ORDER BY ci.start_dt;
2979: v_exam_cal_rec c_exam_cal_type%ROWTYPE;
2980:
2981: CURSOR c_exam_cal_count (
2982: cp_exam_cal_type IGS_CA_INST.cal_type%TYPE,
2983: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
2984: cp_teach_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2985: SELECT COUNT(ci.cal_type)
2986: FROM IGS_CA_TYPE ct,

Line 2983: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,

2979: v_exam_cal_rec c_exam_cal_type%ROWTYPE;
2980:
2981: CURSOR c_exam_cal_count (
2982: cp_exam_cal_type IGS_CA_INST.cal_type%TYPE,
2983: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
2984: cp_teach_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2985: SELECT COUNT(ci.cal_type)
2986: FROM IGS_CA_TYPE ct,
2987: IGS_CA_INST ci,

Line 2984: cp_teach_seq_num IGS_CA_INST.sequence_number%TYPE) IS

2980:
2981: CURSOR c_exam_cal_count (
2982: cp_exam_cal_type IGS_CA_INST.cal_type%TYPE,
2983: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
2984: cp_teach_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2985: SELECT COUNT(ci.cal_type)
2986: FROM IGS_CA_TYPE ct,
2987: IGS_CA_INST ci,
2988: IGS_CA_INST_REL cir

Line 2987: IGS_CA_INST ci,

2983: cp_teach_cal_type IGS_CA_INST.cal_type%TYPE,
2984: cp_teach_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2985: SELECT COUNT(ci.cal_type)
2986: FROM IGS_CA_TYPE ct,
2987: IGS_CA_INST ci,
2988: IGS_CA_INST_REL cir
2989: WHERE cir.sup_ci_sequence_number = ci.sequence_number
2990: AND cir.sup_cal_type = ci.cal_type
2991: AND ct.cal_type = ci.cal_type

Line 2988: IGS_CA_INST_REL cir

2984: cp_teach_seq_num IGS_CA_INST.sequence_number%TYPE) IS
2985: SELECT COUNT(ci.cal_type)
2986: FROM IGS_CA_TYPE ct,
2987: IGS_CA_INST ci,
2988: IGS_CA_INST_REL cir
2989: WHERE cir.sup_ci_sequence_number = ci.sequence_number
2990: AND cir.sup_cal_type = ci.cal_type
2991: AND ct.cal_type = ci.cal_type
2992: AND ct.s_cal_cat = cst_exam