DBA Data[Home] [Help]

APPS.IGS_EN_SU_ATTEMPT_PKG dependencies on IGS_PE_STD_TODO

Line 427: v_return_val IGS_PE_STD_TODO.sequence_number%TYPE;

423: v_message_token VARCHAR2(2000);
424: v_rule_waived_person_id IGS_EN_SU_ATTEMPT_ALL.rule_waived_person_id%TYPE;
425: v_effective_dt DATE;
426: v_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE;
427: v_return_val IGS_PE_STD_TODO.sequence_number%TYPE;
428: v_old_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.unit_attempt_status%TYPE;
429: v_old_location_cd IGS_EN_SU_ATTEMPT_ALL.location_cd%TYPE;
430: v_old_unit_class IGS_EN_SU_ATTEMPT_ALL.unit_class%TYPE;
431: cst_duplicate CONSTANT VARCHAR2(10) := 'DUPLICATE';

Line 1345: -- Log an entry in the IGS_PE_STD_TODO table, indicating that a fee re-assessment

1341: NVL(old_references.uoo_id, new_references.uoo_id));
1342: END IF;
1343: -- END, anilk, Audit special fee build
1344:
1345: -- Log an entry in the IGS_PE_STD_TODO table, indicating that a fee re-assessment
1346: -- is required.
1347: IF p_inserting OR p_updating THEN
1348: v_sequence_number := IGS_GE_GEN_003.GENP_INS_STDNT_TODO(
1349: new_references.person_id,