APPS.IGS_AD_APLINS_ADMREQ_PKG dependencies on IGS_TR_ITEM

Line 141: ELSIF NOT igs_tr_item_pkg.get_pk_for_validation (

137:
138: IF (((old_references.tracking_id = new_references.tracking_id)) OR
139: ((new_references.tracking_id IS NULL))) THEN
140: NULL;
141: ELSIF NOT igs_tr_item_pkg.get_pk_for_validation (
142: new_references.tracking_id
143: ) THEN
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;

Line 274: PROCEDURE get_fk_igs_tr_item_all (

270:
271: END get_fk_igs_ad_ps_appl_inst_all;
272:
273:
274: PROCEDURE get_fk_igs_tr_item_all (
275: x_tracking_id IN NUMBER
276: ) AS
277: /*
278: || Created By : [email protected]

Line 306: END get_fk_igs_tr_item_all;

302: RETURN;
303: END IF;
304: CLOSE cur_rowid;
305:
306: END get_fk_igs_tr_item_all;
307:
308: PROCEDURE check_appl_compl_stat (
309: x_tracking_id IN NUMBER,
310: x_person_id IN NUMBER,

Line 339: CURSOR c_not_post_adm (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

335: AND nominated_course_cd = p_nominated_course_cd
336: AND sequence_number = p_sequence_number
337: AND IGS_AD_GEN_007.ADMP_GET_SADS (adm_doc_status) = 'SATISFIED';
338:
339: CURSOR c_not_post_adm (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
340: SELECT 'X'
341: FROM igs_tr_item a,
342: igs_tr_type b
343: WHERE a.tracking_id = cp_tracking_id

Line 341: FROM igs_tr_item a,

337: AND IGS_AD_GEN_007.ADMP_GET_SADS (adm_doc_status) = 'SATISFIED';
338:
339: CURSOR c_not_post_adm (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
340: SELECT 'X'
341: FROM igs_tr_item a,
342: igs_tr_type b
343: WHERE a.tracking_id = cp_tracking_id
344: AND b.tracking_type = a.tracking_type
345: AND b.S_TRACKING_TYPE <> 'POST_ADMISSION' ;

Line 402: CURSOR c_track_type (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS

398: */
399:
400: --begin apadegal adtd001 igs.m
401: -- cursor to find the System Tracking type of the given Tracking item
402: CURSOR c_track_type (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
403: SELECT ttype.S_TRACKING_TYPE
404: FROM igs_tr_item titem, igs_tr_type ttype
405: WHERE titem.tracking_id = cp_tracking_id AND
406: titem.tracking_type = ttype.tracking_type;

Line 404: FROM igs_tr_item titem, igs_tr_type ttype

400: --begin apadegal adtd001 igs.m
401: -- cursor to find the System Tracking type of the given Tracking item
402: CURSOR c_track_type (cp_tracking_id igs_tr_item.tracking_id%TYPE) IS
403: SELECT ttype.S_TRACKING_TYPE
404: FROM igs_tr_item titem, igs_tr_type ttype
405: WHERE titem.tracking_id = cp_tracking_id AND
406: titem.tracking_type = ttype.tracking_type;
407:
408: lv_tracking_type IGS_TR_TYPE.S_TRACKING_TYPE%TYPE;