APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_PS_UNITASS_ITEM

Line 2383: FROM igs_ps_unitass_item

2379:
2380: PROCEDURE create_item( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS
2381: CURSOR c_unitass_item(cp_n_uoo_id NUMBER ,cp_assessment_id NUMBER,cp_sequence_number NUMBER) IS
2382: SELECT *
2383: FROM igs_ps_unitass_item
2384: WHERE uoo_id = cp_n_uoo_id
2385: AND ass_id = cp_assessment_id
2386: AND sequence_number=cp_sequence_number;
2387:

Line 2397: l_n_us_ass_item_group_id igs_ps_unitass_item.us_ass_item_group_id%type;

2393:
2394: l_c_exam_cal_type igs_ca_inst_all.cal_type%TYPE;
2395: l_n_exam_seq_num igs_ca_inst_all.sequence_number%TYPE;
2396:
2397: l_n_us_ass_item_group_id igs_ps_unitass_item.us_ass_item_group_id%type;
2398:
2399: -- validate parameters passed.
2400: PROCEDURE validate_parameters_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS
2401: BEGIN

Line 2424: FROM igs_ps_unitass_item

2420: -- Check for Update
2421: FUNCTION check_insert_update_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) RETURN VARCHAR2 IS
2422: CURSOR c_unitass_item(cp_n_uoo_id NUMBER ,cp_assessment_id NUMBER,cp_sequence_number NUMBER) IS
2423: SELECT 'X'
2424: FROM igs_ps_unitass_item
2425: WHERE uoo_id = cp_n_uoo_id
2426: AND ass_id = cp_assessment_id
2427: AND sequence_number=cp_sequence_number;
2428:

Line 2479: FROM igs_ps_unitass_item

2475:
2476: PROCEDURE Assign_default( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS
2477: CURSOR c_unitass_item(cp_n_uoo_id NUMBER ,cp_assessment_id NUMBER,cp_sequence_number NUMBER) IS
2478: SELECT *
2479: FROM igs_ps_unitass_item
2480: WHERE uoo_id = cp_n_uoo_id
2481: AND ass_id = cp_assessment_id
2482: AND sequence_number=cp_sequence_number;
2483:

Line 2709: IF igs_ps_unitass_item_pkg.get_uk_for_validation (x_ass_id =>p_unitass_item_rec.assessment_id,

2705: c_assessment_id_rec c_assessment_id%ROWTYPE;
2706: BEGIN
2707: IF (p_insert_update = 'I') THEN
2708: -- Unique Key Validation
2709: IF igs_ps_unitass_item_pkg.get_uk_for_validation (x_ass_id =>p_unitass_item_rec.assessment_id,
2710: x_sequence_number=>p_unitass_item_rec.sequence_number,
2711: x_uoo_id =>l_n_uoo_id) THEN
2712: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'USEC_ASSMNT', 'LEGACY_TOKENS', FALSE);
2713: p_unitass_item_rec.status := 'W';

Line 2872: INSERT INTO igs_ps_unitass_item

2868:
2869: IF p_unitass_item_rec.status = 'S' THEN
2870: IF l_insert_update = 'I' THEN
2871: /* Insert Record */
2872: INSERT INTO igs_ps_unitass_item
2873: (unit_section_ass_item_id,
2874: uoo_id,
2875: ass_id,
2876: sequence_number,

Line 2902: (igs_ps_unitass_item_s.NEXTVAL,

2898: final_mandatory_type_code,
2899: final_weight_qty
2900: )
2901: VALUES
2902: (igs_ps_unitass_item_s.NEXTVAL,
2903: l_n_uoo_id,
2904: p_unitass_item_rec.assessment_id,
2905: igs_ps_unitass_item_seq_num_s.NEXTVAL,
2906: l_d_start_dt,

Line 2905: igs_ps_unitass_item_seq_num_s.NEXTVAL,

2901: VALUES
2902: (igs_ps_unitass_item_s.NEXTVAL,
2903: l_n_uoo_id,
2904: p_unitass_item_rec.assessment_id,
2905: igs_ps_unitass_item_seq_num_s.NEXTVAL,
2906: l_d_start_dt,
2907: l_d_end_dt,
2908: p_unitass_item_rec.due_dt,
2909: p_unitass_item_rec.reference,

Line 2939: UPDATE igs_ps_unitass_item

2935: p_unitass_item_rec.unit_class||' '||'Assesment_id:'||p_unitass_item_rec.assessment_id);
2936: END IF;
2937:
2938: ELSE --update
2939: UPDATE igs_ps_unitass_item
2940: SET due_dt = p_unitass_item_rec.due_dt,
2941: reference = p_unitass_item_rec.reference,
2942: dflt_item_ind = p_unitass_item_rec.dflt_item_ind,
2943: logical_delete_dt = p_unitass_item_rec.logical_delete_dt,