APPS.IGS_HE_SUBMSN_RETURN_PKG dependencies on IGS_HE_USR_RTN_CLAS

Line 106: ELSIF NOT igs_he_usr_rtn_clas_pkg.get_pk_for_validation (

102:
103: IF (((old_references.user_return_subclass = new_references.user_return_subclass)) OR
104: ((new_references.user_return_subclass IS NULL))) THEN
105: NULL;
106: ELSIF NOT igs_he_usr_rtn_clas_pkg.get_pk_for_validation (
107: new_references.user_return_subclass
108: ) THEN
109: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
110: igs_ge_msg_stack.add;

Line 159: FROM IGS_HE_SUBMSN_RETURN hsr, IGS_HE_USR_RTN_CLAS hurc

155: --cursor to check for the existence of the submission return record for 'DLHE' system return class
156: CURSOR cur_check_record_exist (cp_submission_name igs_he_submsn_return.submission_name%type)
157: IS
158: SELECT hsr.rowid
159: FROM IGS_HE_SUBMSN_RETURN hsr, IGS_HE_USR_RTN_CLAS hurc
160: WHERE hsr.submission_name = cp_submission_name AND
161: hsr.user_return_subclass = hurc.user_return_subclass AND
162: hurc.system_return_class_type = 'DLHE' ;
163: --variable to find if the submission record exists

Line 170: FROM IGS_HE_USR_RTN_CLAS hsr

166: --cursor to obtain the system return class type based on the user return type
167: CURSOR cur_system_return_class (cp_user_return_class igs_he_submsn_return.user_return_subclass%type)
168: IS
169: SELECT hsr.system_return_class_type
170: FROM IGS_HE_USR_RTN_CLAS hsr
171: WHERE hsr.user_return_subclass = cp_user_return_class;
172: --variable to find if the submission record exists
173: l_sys_return_subclass igs_he_usr_rtn_clas.system_return_class_type%TYPE;
174:

Line 173: l_sys_return_subclass igs_he_usr_rtn_clas.system_return_class_type%TYPE;

169: SELECT hsr.system_return_class_type
170: FROM IGS_HE_USR_RTN_CLAS hsr
171: WHERE hsr.user_return_subclass = cp_user_return_class;
172: --variable to find if the submission record exists
173: l_sys_return_subclass igs_he_usr_rtn_clas.system_return_class_type%TYPE;
174:
175: BEGIN
176: OPEN cur_system_return_class(new_references.user_return_subclass);
177: FETCH cur_system_return_class INTO l_sys_return_subclass;

Line 271: PROCEDURE get_fk_igs_he_usr_rtn_clas (

267:
268: END get_fk_igs_he_submsn_header;
269:
270:
271: PROCEDURE get_fk_igs_he_usr_rtn_clas (
272: x_user_return_subclass IN VARCHAR2
273: ) AS
274: /*
275: || Created By : rgopalan

Line 303: END get_fk_igs_he_usr_rtn_clas;

299: RETURN;
300: END IF;
301: CLOSE cur_rowid;
302:
303: END get_fk_igs_he_usr_rtn_clas;
304:
305:
306: PROCEDURE before_dml (
307: p_action IN VARCHAR2,