eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_APP_REQ_PKG dependencies on IGS_AD_APP_REQ

Line 1: PACKAGE BODY igs_ad_app_req_pkg AS

1: PACKAGE BODY igs_ad_app_req_pkg AS
2: /* $Header: IGSAIA2B.pls 120.7 2005/10/07 09:37:07 appldev ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references igs_ad_app_req%ROWTYPE;

2: /* $Header: IGSAIA2B.pls 120.7 2005/10/07 09:37:07 appldev ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references igs_ad_app_req%ROWTYPE;
7: new_references igs_ad_app_req%ROWTYPE;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references igs_ad_app_req%ROWTYPE;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references igs_ad_app_req%ROWTYPE;
7: new_references igs_ad_app_req%ROWTYPE;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2,

Line 59: FROM IGS_AD_APP_REQ

55: ***************************************************************/
56:
57: CURSOR cur_old_ref_values IS
58: SELECT *
59: FROM IGS_AD_APP_REQ
60: WHERE rowid = x_rowid;
61:
62: BEGIN
63:

Line 137: CURSOR c_appl_status (cp_person_id igs_ad_app_req.person_id%TYPE,

133: (reverse chronological order - newest change first)
134: ***************************************************************/
135:
136: -- Cursor to get the application processing status for an application
137: CURSOR c_appl_status (cp_person_id igs_ad_app_req.person_id%TYPE,
138: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
139: SELECT s_adm_appl_status
140: FROM igs_ad_appl_stat
141: WHERE adm_appl_status = ( SELECT adm_appl_status

Line 138: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS

134: ***************************************************************/
135:
136: -- Cursor to get the application processing status for an application
137: CURSOR c_appl_status (cp_person_id igs_ad_app_req.person_id%TYPE,
138: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
139: SELECT s_adm_appl_status
140: FROM igs_ad_appl_stat
141: WHERE adm_appl_status = ( SELECT adm_appl_status
142: FROM igs_ad_appl

Line 149: CURSOR cur_enr_dpt(cp_applicant_fee_type igs_ad_app_req.applicant_fee_type%TYPE) IS

145:
146: l_appl_status igs_ad_appl.adm_appl_status%TYPE;
147:
148: -- Cursor to get the fee type
149: CURSOR cur_enr_dpt(cp_applicant_fee_type igs_ad_app_req.applicant_fee_type%TYPE) IS
150: SELECT system_status
151: FROM igs_ad_code_classes
152: WHERE code_id = cp_applicant_fee_type;
153:

Line 155: CURSOR cur_ent_dpt_upd(cp_applicant_fee_status igs_ad_app_req.applicant_fee_status%TYPE) IS

151: FROM igs_ad_code_classes
152: WHERE code_id = cp_applicant_fee_type;
153:
154: -- Cursor to get the fee status
155: CURSOR cur_ent_dpt_upd(cp_applicant_fee_status igs_ad_app_req.applicant_fee_status%TYPE) IS
156: SELECT system_status
157: FROM igs_ad_code_classes
158: WHERE code_id = cp_applicant_fee_status;
159:

Line 164: CURSOR c_appl_dt(cp_person_id igs_ad_app_req.person_id%TYPE,

160: l_fee_status igs_ad_code_classes.system_status%TYPE;
161: l_fee_type igs_ad_code_classes.system_status%TYPE;
162:
163: -- Cursor to get the application date of the application
164: CURSOR c_appl_dt(cp_person_id igs_ad_app_req.person_id%TYPE,
165: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
166: SELECT appl_dt
167: FROM igs_ad_appl
168: where person_id = cp_person_id

Line 165: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS

161: l_fee_type igs_ad_code_classes.system_status%TYPE;
162:
163: -- Cursor to get the application date of the application
164: CURSOR c_appl_dt(cp_person_id igs_ad_app_req.person_id%TYPE,
165: cp_admission_appl_number igs_ad_app_req.admission_appl_number%TYPE) IS
166: SELECT appl_dt
167: FROM igs_ad_appl
168: where person_id = cp_person_id
169: and admission_appl_number = cp_admission_appl_number;

Line 429: FROM igs_ad_app_req

425: ***************************************************************/
426:
427: CURSOR cur_rowid IS
428: SELECT rowid
429: FROM igs_ad_app_req
430: WHERE app_req_id = x_app_req_id
431: FOR UPDATE NOWAIT;
432:
433: lv_rowid cur_rowid%RowType;

Line 467: FROM igs_ad_app_req

463: ***************************************************************/
464:
465: CURSOR cur_rowid IS
466: SELECT rowid
467: FROM igs_ad_app_req
468: WHERE person_id = x_person_id
469: AND admission_appl_number = x_admission_appl_number ;
470:
471: lv_rowid cur_rowid%RowType;

Line 505: FROM igs_ad_app_req

501: ***************************************************************/
502:
503: CURSOR cur_rowid IS
504: SELECT rowid
505: FROM igs_ad_app_req
506: WHERE applicant_fee_status = x_code_id ;
507:
508: lv_rowid cur_rowid%RowType;
509:

Line 512: FROM igs_ad_app_req

508: lv_rowid cur_rowid%RowType;
509:
510: CURSOR cur_rowid2 IS
511: SELECT rowid
512: FROM igs_ad_app_req
513: WHERE applicant_fee_type = x_code_id ;
514:
515: lv_rowid2 cur_rowid2%RowType;
516:

Line 519: FROM igs_ad_app_req

515: lv_rowid2 cur_rowid2%RowType;
516:
517: CURSOR cur_rowid3 IS
518: SELECT rowid
519: FROM igs_ad_app_req
520: WHERE fee_payment_method = x_code_id ;
521:
522: lv_rowid3 cur_rowid3%RowType;
523:

Line 645: igs_ad_app_req_pkg.g_pkg_cst_completed_chk := 'N'; -- this variable is called from the procedure igs_ad_gen_002.check_adm_appl_inst_stat (rghosh)

641: x_credit_card_payee_cd ,
642: x_credit_card_status_code
643: );
644:
645: igs_ad_app_req_pkg.g_pkg_cst_completed_chk := 'N'; -- this variable is called from the procedure igs_ad_gen_002.check_adm_appl_inst_stat (rghosh)
646:
647: igs_ad_gen_002.check_adm_appl_inst_stat(
648: x_person_id,
649: x_admission_appl_number

Line 651: igs_ad_app_req_pkg.g_pkg_cst_completed_chk := 'Y';

647: igs_ad_gen_002.check_adm_appl_inst_stat(
648: x_person_id,
649: x_admission_appl_number
650: );
651: igs_ad_app_req_pkg.g_pkg_cst_completed_chk := 'Y';
652:
653: IF (p_action = 'INSERT') THEN
654: -- Call all the procedures related to Before Insert.
655: Null;

Line 787: CURSOR C IS SELECT rowid FROM igs_ad_app_req

783: in GL Interface CS Document
784: (reverse chronological order - newest change first)
785: ***************************************************************/
786:
787: CURSOR C IS SELECT rowid FROM igs_ad_app_req
788: WHERE APP_REQ_ID= X_APP_REQ_ID
789: ;
790: X_LAST_UPDATE_DATE DATE ;
791: X_LAST_UPDATED_BY NUMBER ;

Line 858: INSERT INTO IGS_AD_APP_REQ (

854: );
855: IF (x_mode = 'S') THEN
856: igs_sc_gen_001.set_ctx('R');
857: END IF;
858: INSERT INTO IGS_AD_APP_REQ (
859: APP_REQ_ID
860: ,PERSON_ID
861: ,ADMISSION_APPL_NUMBER
862: ,APPLICANT_FEE_TYPE

Line 888: IGS_AD_APP_REQ_S.NEXTVAL

884: credit_card_tangible_cd ,
885: credit_card_payee_cd ,
886: credit_card_status_code
887: ) VALUES (
888: IGS_AD_APP_REQ_S.NEXTVAL
889: ,NEW_REFERENCES.PERSON_ID
890: ,NEW_REFERENCES.ADMISSION_APPL_NUMBER
891: ,NEW_REFERENCES.APPLICANT_FEE_TYPE
892: ,NEW_REFERENCES.APPLICANT_FEE_STATUS

Line 1018: FROM IGS_AD_APP_REQ

1014: credit_card_tangible_cd ,
1015: credit_card_payee_cd ,
1016: credit_card_status_code
1017:
1018: FROM IGS_AD_APP_REQ
1019: WHERE rowid = x_rowid
1020: FOR UPDATE NOWAIT;
1021: tlinfo c1%ROWTYPE;
1022: begin

Line 1167: UPDATE igs_ad_app_req SET

1163: );
1164: IF (x_mode = 'S') THEN
1165: igs_sc_gen_001.set_ctx('R');
1166: END IF;
1167: UPDATE igs_ad_app_req SET
1168: PERSON_ID = NEW_REFERENCES.PERSON_ID,
1169: ADMISSION_APPL_NUMBER = NEW_REFERENCES.ADMISSION_APPL_NUMBER,
1170: APPLICANT_FEE_TYPE = NEW_REFERENCES.APPLICANT_FEE_TYPE,
1171: APPLICANT_FEE_STATUS = NEW_REFERENCES.APPLICANT_FEE_STATUS,

Line 1275: FROM igs_ad_app_req

1271: ***************************************************************/
1272:
1273: CURSOR c1 IS
1274: SELECT rowid
1275: FROM igs_ad_app_req
1276: WHERE app_req_id= x_app_req_id
1277: ;
1278: BEGIN
1279: OPEN c1;

Line 1366: DELETE FROM IGS_AD_APP_REQ

1362: );
1363: IF (x_mode = 'S') THEN
1364: igs_sc_gen_001.set_ctx('R');
1365: END IF;
1366: DELETE FROM IGS_AD_APP_REQ
1367: WHERE rowid = x_rowid;
1368: IF (SQL%NOTFOUND) THEN
1369: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1370: igs_ge_msg_stack.add;

Line 1404: END igs_ad_app_req_pkg;

1400: RAISE;
1401: END IF;
1402: END delete_row;
1403:
1404: END igs_ad_app_req_pkg;