APPS.IGS_DA_TRNS_IMP dependencies on IGS_AV_ADV_STANDING_PKG

Line 542: igs_av_adv_standing_pkg.delete_row (l_adv_stnd.ROWID);

538:
539: FOR l_adv_stnd IN c_adv_stnd
540: LOOP
541: BEGIN
542: igs_av_adv_standing_pkg.delete_row (l_adv_stnd.ROWID);
543: EXCEPTION
544: WHEN OTHERS
545: THEN
546: NULL;

Line 2209: -- Foreign Key with Table IGS_AV_ADV_STANDING_PKG

2205: +===========================================================================*/
2206: x_return_status BOOLEAN := TRUE;
2207: l_c_tmp_msg VARCHAR2 (30);
2208: BEGIN
2209: -- Foreign Key with Table IGS_AV_ADV_STANDING_PKG
2210: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_STD_UNT_DB_CONS');
2211: write_message ( 'p_person_id='
2212: || p_person_id
2213: || ' p_program_cd='

Line 2221: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation (x_person_id => p_person_id,

2217: || ' p_prev_institution_code='
2218: || p_prev_institution_code
2219: );
2220:
2221: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation (x_person_id => p_person_id,
2222: x_course_cd => p_program_cd,
2223: x_version_number => p_as_version_number,
2224: x_exemption_institution_cd => p_prev_institution_code
2225: )

Line 2230: write_message ('validate_std_unt_db_cons IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION '

2226: THEN
2227: fnd_message.set_name ('IGS', 'IGS_AV_NO_ADV_STND_DET_EXIST');
2228: fnd_msg_pub.ADD;
2229: x_return_status := FALSE;
2230: write_message ('validate_std_unt_db_cons IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION '
2231: );
2232: notify_error (p_batch_id,
2233: p_person_id,
2234: p_program_cd,

Line 2584: igs_av_adv_standing_pkg.update_row (x_rowid => l_adv_stnd.ROWID,

2580: total_exmptn_approved, total_exmptn_granted and total_exmptn_perc_grntd
2581: */
2582: OPEN c_adv_stnd;
2583: FETCH c_adv_stnd INTO l_adv_stnd;
2584: igs_av_adv_standing_pkg.update_row (x_rowid => l_adv_stnd.ROWID,
2585: x_person_id => p_person_id,
2586: x_course_cd => p_program_cd,
2587: x_version_number => p_course_version,
2588: x_total_exmptn_approved => l_total_exmptn_approved,

Line 2896: write_message ('Before IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION'

2892: p_version_number => l_version_number,
2893: p_prev_institution_code => l_prev_institution_code
2894: )
2895: THEN
2896: write_message ('Before IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION'
2897: );
2898:
2899: -- Validate that the current record is already present in the tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_ALL
2900: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation (x_person_id => l_person_id,

Line 2900: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation (x_person_id => l_person_id,

2896: write_message ('Before IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION'
2897: );
2898:
2899: -- Validate that the current record is already present in the tables IGS_AV_ADV_STANDING_ALL and IGS_AV_STND_UNIT_ALL
2900: IF NOT igs_av_adv_standing_pkg.get_pk_for_validation (x_person_id => l_person_id,
2901: x_course_cd => p_program_cd,
2902: x_version_number => l_as_version_number,
2903: x_exemption_institution_cd => l_prev_institution_code
2904: )

Line 2909: igs_av_adv_standing_pkg.insert_row (x_rowid => v_rowid,

2905: THEN
2906: write_message ('***** INSERT INTO IGS_AV_ADV_STANDING_ALL *****'
2907: );
2908:
2909: igs_av_adv_standing_pkg.insert_row (x_rowid => v_rowid,
2910: x_person_id => l_person_id,
2911: x_course_cd => UPPER (p_program_cd
2912: ),
2913: x_version_number => l_as_version_number,

Line 2921: END IF; --IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION

2917: x_exemption_institution_cd => l_prev_institution_code,
2918: x_org_id => igs_ge_gen_003.get_org_id ()
2919: );
2920:
2921: END IF; --IGS_AV_ADV_STANDING_PKG.GET_PK_FOR_VALIDATION
2922:
2923: write_message ('Before IGS_AV_STND_UNIT_PKG.GET_UK_FOR_VALIDATION'
2924: );
2925: