APPS.IGS_RE_CDT_FLD_OF_SY_PKG dependencies on IGS_RE_CDT_FLD_OF_SY

Line 1: package body IGS_RE_CDT_FLD_OF_SY_PKG as

1: package body IGS_RE_CDT_FLD_OF_SY_PKG as
2: /* $Header: IGSRI04B.pls 120.1 2005/07/04 00:41:28 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 10: old_references IGS_RE_CDT_FLD_OF_SY%RowType;

6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_cafos.genp_val_sdtt_sess
7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references IGS_RE_CDT_FLD_OF_SY%RowType;
11: new_references IGS_RE_CDT_FLD_OF_SY%RowType;
12:
13: PROCEDURE Set_Column_Values (
14: p_action IN VARCHAR2,

Line 11: new_references IGS_RE_CDT_FLD_OF_SY%RowType;

7: -- is changed to igs_as_val_suaap.genp_val_sdtt_sess
8: -------------------------------------------------------------------------------------------
9: l_rowid VARCHAR2(25);
10: old_references IGS_RE_CDT_FLD_OF_SY%RowType;
11: new_references IGS_RE_CDT_FLD_OF_SY%RowType;
12:
13: PROCEDURE Set_Column_Values (
14: p_action IN VARCHAR2,
15: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 29: FROM IGS_RE_CDT_FLD_OF_SY

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

Line 195: FROM IGS_RE_CDT_FLD_OF_SY

191: RETURN BOOLEAN AS
192:
193: CURSOR cur_rowid IS
194: SELECT rowid
195: FROM IGS_RE_CDT_FLD_OF_SY
196: WHERE person_id = x_person_id
197: AND ca_sequence_number = x_ca_sequence_number
198: AND field_of_study = x_field_of_study
199: FOR UPDATE NOWAIT;

Line 224: FROM IGS_RE_CDT_FLD_OF_SY

220: ) AS
221:
222: CURSOR cur_rowid IS
223: SELECT rowid
224: FROM IGS_RE_CDT_FLD_OF_SY
225: WHERE person_id = x_person_id
226: AND ca_sequence_number = x_sequence_number ;
227:
228: lv_rowid cur_rowid%RowType;

Line 323: cursor C is select ROWID from IGS_RE_CDT_FLD_OF_SY

319: X_FIELD_OF_STUDY in VARCHAR2,
320: X_PERCENTAGE in NUMBER,
321: X_MODE in VARCHAR2 default 'R'
322: ) as
323: cursor C is select ROWID from IGS_RE_CDT_FLD_OF_SY
324: where PERSON_ID = X_PERSON_ID
325: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
326: and FIELD_OF_STUDY = X_FIELD_OF_STUDY;
327: X_LAST_UPDATE_DATE DATE;

Line 367: insert into IGS_RE_CDT_FLD_OF_SY (

363:
364: IF (x_mode = 'S') THEN
365: igs_sc_gen_001.set_ctx('R');
366: END IF;
367: insert into IGS_RE_CDT_FLD_OF_SY (
368: PERSON_ID,
369: CA_SEQUENCE_NUMBER,
370: FIELD_OF_STUDY,
371: PERCENTAGE,

Line 425: from IGS_RE_CDT_FLD_OF_SY

421: X_PERCENTAGE in NUMBER
422: ) as
423: cursor c1 is select
424: PERCENTAGE
425: from IGS_RE_CDT_FLD_OF_SY
426: where ROWID = X_ROWID
427: for update nowait;
428: tlinfo c1%rowtype;
429:

Line 499: update IGS_RE_CDT_FLD_OF_SY set

495:
496: IF (x_mode = 'S') THEN
497: igs_sc_gen_001.set_ctx('R');
498: END IF;
499: update IGS_RE_CDT_FLD_OF_SY set
500: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
501: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
502: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
503: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 540: cursor c1 is select rowid from IGS_RE_CDT_FLD_OF_SY

536: X_FIELD_OF_STUDY in VARCHAR2,
537: X_PERCENTAGE in NUMBER,
538: X_MODE in VARCHAR2 default 'R'
539: ) as
540: cursor c1 is select rowid from IGS_RE_CDT_FLD_OF_SY
541: where PERSON_ID = X_PERSON_ID
542: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
543: and FIELD_OF_STUDY = X_FIELD_OF_STUDY
544: ;

Line 583: delete from IGS_RE_CDT_FLD_OF_SY

579:
580: IF (x_mode = 'S') THEN
581: igs_sc_gen_001.set_ctx('R');
582: END IF;
583: delete from IGS_RE_CDT_FLD_OF_SY
584: where ROWID = X_ROWID;
585:
586: if (sql%notfound) then
587: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');

Line 599: end IGS_RE_CDT_FLD_OF_SY_PKG;

595:
596:
597: end DELETE_ROW;
598:
599: end IGS_RE_CDT_FLD_OF_SY_PKG;