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_APPL_LTR_PKG dependencies on IGS_AD_APPL

Line 1: package body IGS_AD_APPL_LTR_PKG as

1: package body IGS_AD_APPL_LTR_PKG as
2: /* $Header: IGSAI06B.pls 115.4 2002/11/28 21:54:11 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_APPL_LTR%RowType;
5: new_references IGS_AD_APPL_LTR%RowType;

Line 4: old_references IGS_AD_APPL_LTR%RowType;

1: package body IGS_AD_APPL_LTR_PKG as
2: /* $Header: IGSAI06B.pls 115.4 2002/11/28 21:54:11 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_APPL_LTR%RowType;
5: new_references IGS_AD_APPL_LTR%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_APPL_LTR%RowType;

1: package body IGS_AD_APPL_LTR_PKG as
2: /* $Header: IGSAI06B.pls 115.4 2002/11/28 21:54:11 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_APPL_LTR%RowType;
5: new_references IGS_AD_APPL_LTR%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_AD_APPL_LTR

22: ) as
23:
24: CURSOR cur_old_ref_values IS
25: SELECT *
26: FROM IGS_AD_APPL_LTR
27: WHERE rowid = x_rowid;
28:
29: BEGIN
30:

Line 70: -- ON IGS_AD_APPL_LTR

66:
67: -- Trigger description :-
68: -- "OSS_TST".trg_aal_br_iu
69: -- BEFORE INSERT OR UPDATE
70: -- ON IGS_AD_APPL_LTR
71: -- FOR EACH ROW
72:
73: PROCEDURE BeforeRowInsertUpdate1(
74: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 78: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;

74: p_inserting IN BOOLEAN DEFAULT FALSE,
75: p_updating IN BOOLEAN DEFAULT FALSE,
76: p_deleting IN BOOLEAN DEFAULT FALSE
77: ) as
78: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
79: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
80: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
81: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
82: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

Line 79: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;

75: p_updating IN BOOLEAN DEFAULT FALSE,
76: p_deleting IN BOOLEAN DEFAULT FALSE
77: ) as
78: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
79: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
80: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
81: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
82: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
83: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

Line 80: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;

76: p_deleting IN BOOLEAN DEFAULT FALSE
77: ) as
78: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
79: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
80: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
81: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
82: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
83: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
84: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;

Line 81: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

77: ) as
78: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
79: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
80: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
81: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
82: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
83: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
84: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
85: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

Line 82: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;

78: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
79: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
80: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
81: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
82: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
83: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
84: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
85: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
86: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;

Line 83: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;

79: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
80: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
81: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
82: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
83: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
84: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
85: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
86: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
87: v_message_name VARCHAR2(30);

Line 84: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;

80: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
81: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
82: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
83: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
84: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
85: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
86: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
87: v_message_name VARCHAR2(30);
88: v_issue_dt DATE;

Line 85: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;

81: v_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;
82: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
83: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
84: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
85: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
86: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
87: v_message_name VARCHAR2(30);
88: v_issue_dt DATE;
89: BEGIN

Line 86: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;

82: v_adm_cal_type IGS_AD_APPL.adm_cal_type%TYPE;
83: v_adm_ci_sequence_number IGS_AD_APPL.adm_ci_sequence_number%TYPE;
84: v_appl_dt IGS_AD_APPL.appl_dt%TYPE;
85: v_adm_appl_status IGS_AD_APPL.adm_appl_status%TYPE;
86: v_adm_fee_status IGS_AD_APPL.adm_fee_status%TYPE;
87: v_message_name VARCHAR2(30);
88: v_issue_dt DATE;
89: BEGIN
90: -- Validate correspondence type

Line 149: IF NOT IGS_AD_APPL_PKG.Get_PK_For_Validation (

145: ((new_references.person_id IS NULL) OR
146: (new_references.admission_appl_number IS NULL))) THEN
147: NULL;
148: ELSE
149: IF NOT IGS_AD_APPL_PKG.Get_PK_For_Validation (
150: new_references.person_id,
151: new_references.admission_appl_number
152: )THEN
153: FND_MESSAGE.SET_NAME('FND','FORM_RECORD_DELETED');

Line 199: IGS_AD_APPL_LTR_PHR_PKG.GET_FK_IGS_AD_APPL_LTR (

195:
196: PROCEDURE Check_Child_Existance as
197: BEGIN
198:
199: IGS_AD_APPL_LTR_PHR_PKG.GET_FK_IGS_AD_APPL_LTR (
200: old_references.person_id,
201: old_references.admission_appl_number,
202: old_references.correspondence_type,
203: old_references.sequence_number

Line 218: FROM IGS_AD_APPL_LTR

214: RETURN BOOLEAN as
215:
216: CURSOR cur_rowid IS
217: SELECT rowid
218: FROM IGS_AD_APPL_LTR
219: WHERE person_id = x_person_id
220: AND admission_appl_number = x_admission_appl_number
221: AND correspondence_type = x_correspondence_type
222: AND sequence_number = x_sequence_number

Line 241: PROCEDURE GET_FK_IGS_AD_APPL (

237: END IF;
238:
239: END Get_PK_For_Validation;
240:
241: PROCEDURE GET_FK_IGS_AD_APPL (
242: x_person_id IN NUMBER,
243: x_admission_appl_number IN NUMBER
244: ) as
245:

Line 248: FROM IGS_AD_APPL_LTR

244: ) as
245:
246: CURSOR cur_rowid IS
247: SELECT rowid
248: FROM IGS_AD_APPL_LTR
249: WHERE person_id = x_person_id
250: AND admission_appl_number = x_admission_appl_number ;
251:
252: lv_rowid cur_rowid%RowType;

Line 267: END GET_FK_IGS_AD_APPL;

263: Return;
264: END IF;
265: Close cur_rowid;
266:
267: END GET_FK_IGS_AD_APPL;
268:
269: PROCEDURE GET_FK_IGS_CO_TYPE (
270: x_correspondence_type IN VARCHAR2
271: ) as

Line 275: FROM IGS_AD_APPL_LTR

271: ) as
272:
273: CURSOR cur_rowid IS
274: SELECT rowid
275: FROM IGS_AD_APPL_LTR
276: WHERE correspondence_type = x_correspondence_type ;
277:
278: lv_rowid cur_rowid%RowType;
279:

Line 304: FROM IGS_AD_APPL_LTR

300: ) as
301:
302: CURSOR cur_rowid IS
303: SELECT rowid
304: FROM IGS_AD_APPL_LTR
305: WHERE person_id = x_person_id
306: AND correspondence_type = x_correspondence_type
307: AND letter_reference_number = x_letter_reference_number
308: AND spl_sequence_number = x_sequence_number ;

Line 479: cursor C is select ROWID from IGS_AD_APPL_LTR

475: X_LETTER_REFERENCE_NUMBER in NUMBER,
476: X_SPL_SEQUENCE_NUMBER in NUMBER,
477: X_MODE in VARCHAR2 default 'R'
478: ) as
479: cursor C is select ROWID from IGS_AD_APPL_LTR
480: where PERSON_ID = X_PERSON_ID
481: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
482: and CORRESPONDENCE_TYPE = X_CORRESPONDENCE_TYPE
483: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER;

Line 539: insert into IGS_AD_APPL_LTR (

535: x_last_updated_by =>X_LAST_UPDATED_BY,
536: x_last_update_login=> X_LAST_UPDATE_LOGIN
537: );
538:
539: insert into IGS_AD_APPL_LTR (
540: PERSON_ID,
541: ADMISSION_APPL_NUMBER,
542: CORRESPONDENCE_TYPE,
543: SEQUENCE_NUMBER,

Line 603: from IGS_AD_APPL_LTR

599: cursor c1 is select
600: COMPOSED_IND,
601: LETTER_REFERENCE_NUMBER,
602: SPL_SEQUENCE_NUMBER
603: from IGS_AD_APPL_LTR
604: where ROWID = X_ROWID
605: for update nowait;
606: tlinfo c1%rowtype;
607:

Line 706: update IGS_AD_APPL_LTR set

702: else
703: X_PROGRAM_UPDATE_DATE := SYSDATE;
704: end if;
705: end if;
706: update IGS_AD_APPL_LTR set
707: COMPOSED_IND = NEW_REFERENCES.COMPOSED_IND,
708: LETTER_REFERENCE_NUMBER = NEW_REFERENCES.LETTER_REFERENCE_NUMBER,
709: SPL_SEQUENCE_NUMBER = NEW_REFERENCES.SPL_SEQUENCE_NUMBER,
710: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 740: cursor c1 is select rowid from IGS_AD_APPL_LTR

736: X_LETTER_REFERENCE_NUMBER in NUMBER,
737: X_SPL_SEQUENCE_NUMBER in NUMBER,
738: X_MODE in VARCHAR2 default 'R'
739: ) as
740: cursor c1 is select rowid from IGS_AD_APPL_LTR
741: where PERSON_ID = X_PERSON_ID
742: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
743: and CORRESPONDENCE_TYPE = X_CORRESPONDENCE_TYPE
744: and SEQUENCE_NUMBER = X_SEQUENCE_NUMBER

Line 785: delete from IGS_AD_APPL_LTR

781: p_action => 'DELETE',
782: x_rowid => X_ROWID
783: );
784:
785: delete from IGS_AD_APPL_LTR
786: where ROWID = X_ROWID;
787: if (sql%notfound) then
788: raise no_data_found;
789: end if;

Line 797: end IGS_AD_APPL_LTR_PKG;

793: );
794:
795: end DELETE_ROW;
796:
797: end IGS_AD_APPL_LTR_PKG;