APPS.IGS_AD_APPL_LTR_PHR_PKG dependencies on IGS_AD_APPL_LTR_PHR

Line 1: package body IGS_AD_APPL_LTR_PHR_PKG as

1: package body IGS_AD_APPL_LTR_PHR_PKG as
2: /* $Header: IGSAI11B.pls 115.5 2002/11/28 21:55:37 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_APPL_LTR_PHR%RowType;
5: new_references IGS_AD_APPL_LTR_PHR%RowType;

Line 4: old_references IGS_AD_APPL_LTR_PHR%RowType;

1: package body IGS_AD_APPL_LTR_PHR_PKG as
2: /* $Header: IGSAI11B.pls 115.5 2002/11/28 21:55:37 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_APPL_LTR_PHR%RowType;
5: new_references IGS_AD_APPL_LTR_PHR%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_APPL_LTR_PHR%RowType;

1: package body IGS_AD_APPL_LTR_PHR_PKG as
2: /* $Header: IGSAI11B.pls 115.5 2002/11/28 21:55:37 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_APPL_LTR_PHR%RowType;
5: new_references IGS_AD_APPL_LTR_PHR%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_AD_APPL_LTR_PHR

24: ) AS
25:
26: CURSOR cur_old_ref_values IS
27: SELECT *
28: FROM IGS_AD_APPL_LTR_PHR
29: WHERE rowid = x_rowid;
30:
31: BEGIN
32:

Line 74: -- ON IGS_AD_APPL_LTR_PHR

70:
71: -- Trigger description :-
72: -- "OSS_TST".trg_aalp_br_iu
73: -- BEFORE INSERT OR UPDATE
74: -- ON IGS_AD_APPL_LTR_PHR
75: -- FOR EACH ROW
76:
77: PROCEDURE BeforeRowInsertUpdate1(
78: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 200: FROM IGS_AD_APPL_LTR_PHR

196: RETURN BOOLEAN AS
197:
198: CURSOR cur_rowid IS
199: SELECT rowid
200: FROM IGS_AD_APPL_LTR_PHR
201: WHERE person_id = x_person_id
202: AND admission_appl_number = x_admission_appl_number
203: AND correspondence_type = x_correspondence_type
204: AND aal_sequence_number = x_aal_sequence_number

Line 233: FROM IGS_AD_APPL_LTR_PHR

229: ) AS
230:
231: CURSOR cur_rowid IS
232: SELECT rowid
233: FROM IGS_AD_APPL_LTR_PHR
234: WHERE person_id = x_person_id
235: AND admission_appl_number = x_admission_appl_number
236: AND correspondence_type = x_correspondence_type
237: AND aal_sequence_number = x_sequence_number ;

Line 262: FROM IGS_AD_APPL_LTR_PHR

258: ) AS
259:
260: CURSOR cur_rowid IS
261: SELECT rowid
262: FROM IGS_AD_APPL_LTR_PHR
263: WHERE letter_parameter_type = x_letter_parameter_type ;
264:
265: lv_rowid cur_rowid%RowType;
266:

Line 288: FROM IGS_AD_APPL_LTR_PHR

284: ) AS
285:
286: CURSOR cur_rowid IS
287: SELECT rowid
288: FROM IGS_AD_APPL_LTR_PHR
289: WHERE phrase_cd = x_phrase_cd ;
290:
291: lv_rowid cur_rowid%RowType;
292:

Line 473: cursor C is select ROWID from IGS_AD_APPL_LTR_PHR

469: X_PHRASE_TEXT in VARCHAR2,
470: X_MODE in VARCHAR2 default 'R'
471: ) as
472:
473: cursor C is select ROWID from IGS_AD_APPL_LTR_PHR
474: where PERSON_ID = X_PERSON_ID
475: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
476: and CORRESPONDENCE_TYPE = X_CORRESPONDENCE_TYPE
477: and AAL_SEQUENCE_NUMBER = X_AAL_SEQUENCE_NUMBER

Line 522: insert into IGS_AD_APPL_LTR_PHR (

518: x_last_updated_by =>X_LAST_UPDATED_BY,
519: x_last_update_login=> X_LAST_UPDATE_LOGIN
520: );
521:
522: insert into IGS_AD_APPL_LTR_PHR (
523: PERSON_ID,
524: ADMISSION_APPL_NUMBER,
525: CORRESPONDENCE_TYPE,
526: AAL_SEQUENCE_NUMBER,

Line 585: from IGS_AD_APPL_LTR_PHR

581: PHRASE_CD,
582: PHRASE_ORDER_NUMBER,
583: LETTER_PARAMETER_TYPE,
584: PHRASE_TEXT
585: from IGS_AD_APPL_LTR_PHR
586: where ROWID = X_ROWID
587: for update nowait;
588: tlinfo c1%rowtype;
589:

Line 677: update IGS_AD_APPL_LTR_PHR set

673: x_last_update_login=> X_LAST_UPDATE_LOGIN
674: );
675:
676:
677: update IGS_AD_APPL_LTR_PHR set
678: PHRASE_CD = NEW_REFERENCES.PHRASE_CD,
679: PHRASE_ORDER_NUMBER = NEW_REFERENCES.PHRASE_ORDER_NUMBER,
680: LETTER_PARAMETER_TYPE = NEW_REFERENCES.LETTER_PARAMETER_TYPE,
681: PHRASE_TEXT = NEW_REFERENCES.PHRASE_TEXT,

Line 709: cursor c1 is select rowid from IGS_AD_APPL_LTR_PHR

705: X_LETTER_PARAMETER_TYPE in VARCHAR2,
706: X_PHRASE_TEXT in VARCHAR2,
707: X_MODE in VARCHAR2 default 'R'
708: ) as
709: cursor c1 is select rowid from IGS_AD_APPL_LTR_PHR
710: where PERSON_ID = X_PERSON_ID
711: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
712: and CORRESPONDENCE_TYPE = X_CORRESPONDENCE_TYPE
713: and AAL_SEQUENCE_NUMBER = X_AAL_SEQUENCE_NUMBER

Line 758: delete from IGS_AD_APPL_LTR_PHR

754: Before_DML (
755: p_action => 'DELETE',
756: x_rowid => X_ROWID
757: );
758: delete from IGS_AD_APPL_LTR_PHR
759: where ROWID = X_ROWID;
760: if (sql%notfound) then
761: raise no_data_found;
762: end if;

Line 769: end IGS_AD_APPL_LTR_PHR_PKG;

765: x_rowid => X_ROWID
766: );
767: end delete_row;
768:
769: end IGS_AD_APPL_LTR_PHR_PKG;