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_LTR

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 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 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 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;