APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_APLINS_ADMREQ

Line 53: l_aplins_admreq_id igs_ad_aplins_admreq.aplins_admreq_id%TYPE;

49: p_org_id IN NUMBER
50: ) AS
51:
52: l_tracking_id igs_tr_item.tracking_id%TYPE;
53: l_aplins_admreq_id igs_ad_aplins_admreq.aplins_admreq_id%TYPE;
54: l_message_name VARCHAR2(30);
55: l_found BOOLEAN;
56: l_acad_cal_type igs_ca_inst.cal_type%TYPE;
57: l_acad_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 457: igs_ad_aplins_admreq ar,

453: CURSOR check_existence_cur IS
454: SELECT
455: ar.rowid, ar.tracking_id, itt.tracking_type
456: FROM
457: igs_ad_aplins_admreq ar,
458: igs_tr_item itt,
459: igs_tr_type tt
460: WHERE
461: ar.person_id = p_person_id AND

Line 520: FROM igs_ad_aplins_admreq ar

516: process_apc_rec process_apc_cur%ROWTYPE;
517:
518: CURSOR check_duplicate_cur (cp_tracking_type igs_tr_type.tracking_type%TYPE) IS
519: SELECT ar.tracking_id
520: FROM igs_ad_aplins_admreq ar
521: WHERE ar.person_id = p_person_id
522: AND ar.admission_appl_number = p_admission_appl_number
523: AND ar.course_cd = p_program_code
524: AND ar.sequence_number = p_sequence_number

Line 554: l_tracking_id igs_ad_aplins_admreq.tracking_id%TYPE;

550: p_completion_due_dt IN DATE
551: ) AS
552:
553: l_message_name VARCHAR2(30);
554: l_tracking_id igs_ad_aplins_admreq.tracking_id%TYPE;
555: l_aplins_admreq_id igs_ad_aplins_admreq.aplins_admreq_id%TYPE;
556: l_rowid VARCHAR2(25);
557: l_override_offset_clc_ind VARCHAR2(2);
558: BEGIN

Line 555: l_aplins_admreq_id igs_ad_aplins_admreq.aplins_admreq_id%TYPE;

551: ) AS
552:
553: l_message_name VARCHAR2(30);
554: l_tracking_id igs_ad_aplins_admreq.tracking_id%TYPE;
555: l_aplins_admreq_id igs_ad_aplins_admreq.aplins_admreq_id%TYPE;
556: l_rowid VARCHAR2(25);
557: l_override_offset_clc_ind VARCHAR2(2);
558: BEGIN
559: /*

Line 585: igs_ad_aplins_admreq_pkg.insert_row(

581: p_message_name => l_message_name
582: );
583: IF l_tracking_id IS NOT NULL THEN
584: BEGIN
585: igs_ad_aplins_admreq_pkg.insert_row(
586: x_rowid => l_rowid,
587: x_aplins_admreq_id => l_aplins_admreq_id,
588: x_person_id => p_person_id,
589: x_admission_appl_number => p_admission_appl_number,

Line 691: igs_ad_aplins_admreq_pkg.delete_row ( check_existence_rec.rowid);

687: Check if records already exist in the linking table for the application instance
688: and the tracking items
689: */
690: FOR check_existence_rec IN check_existence_cur LOOP
691: igs_ad_aplins_admreq_pkg.delete_row ( check_existence_rec.rowid);
692: IF igs_tr_gen_002.trkp_del_tri ( check_existence_rec.tracking_id, l_message_name) THEN
693: log_detail(FND_MESSAGE.GET_STRING( 'IGS', 'IGS_AD_TRAC_NOT_REQ_DELETED'));
694: log_detail('Tracking ID :: ' || IGS_GE_NUMBER.TO_CANN( check_existence_rec.tracking_id) ||
695: ' of tracking type :: ' || check_existence_rec.tracking_type);