APPS.IGS_RE_SCHOLARSHIP_PKG dependencies on IGS_RE_SCHOLARSHIP_ALL

Line 12: old_references IGS_RE_SCHOLARSHIP_ALL%RowType;

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

Line 13: new_references IGS_RE_SCHOLARSHIP_ALL%RowType;

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

Line 37: FROM IGS_RE_SCHOLARSHIP_ALL

33: ) AS
34:
35: CURSOR cur_old_ref_values IS
36: SELECT *
37: FROM IGS_RE_SCHOLARSHIP_ALL
38: WHERE rowid = x_rowid;
39:
40: BEGIN
41:

Line 228: FROM IGS_RE_SCHOLARSHIP_ALL

224: AS
225:
226: CURSOR cur_rowid IS
227: SELECT rowid
228: FROM IGS_RE_SCHOLARSHIP_ALL
229: WHERE person_id = x_person_id
230: AND ca_sequence_number = x_ca_sequence_number
231: AND scholarship_type = x_scholarship_type
232: AND start_dt = x_start_dt

Line 258: FROM IGS_RE_SCHOLARSHIP_ALL

254: ) AS
255:
256: CURSOR cur_rowid IS
257: SELECT rowid
258: FROM IGS_RE_SCHOLARSHIP_ALL
259: WHERE person_id = x_person_id
260: AND ca_sequence_number = x_sequence_number ;
261:
262: lv_rowid cur_rowid%RowType;

Line 285: FROM IGS_RE_SCHOLARSHIP_ALL

281: ) AS
282:
283: CURSOR cur_rowid IS
284: SELECT rowid
285: FROM IGS_RE_SCHOLARSHIP_ALL
286: WHERE scholarship_type = x_scholarship_type ;
287:
288: lv_rowid cur_rowid%RowType;
289:

Line 411: cursor C is select ROWID from IGS_RE_SCHOLARSHIP_ALL

407: X_CONDITIONS in VARCHAR2,
408: X_MODE in VARCHAR2 default 'R',
409: X_ORG_ID in NUMBER
410: ) as
411: cursor C is select ROWID from IGS_RE_SCHOLARSHIP_ALL
412: where PERSON_ID = X_PERSON_ID
413: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
414: and SCHOLARSHIP_TYPE = X_SCHOLARSHIP_TYPE
415: and START_DT = X_START_DT;

Line 462: insert into IGS_RE_SCHOLARSHIP_ALL (

458:
459: IF (x_mode = 'S') THEN
460: igs_sc_gen_001.set_ctx('R');
461: END IF;
462: insert into IGS_RE_SCHOLARSHIP_ALL (
463: PERSON_ID,
464: CA_SEQUENCE_NUMBER,
465: SCHOLARSHIP_TYPE,
466: START_DT,

Line 547: from IGS_RE_SCHOLARSHIP_ALL

543: DOLLAR_VALUE,
544: DESCRIPTION,
545: OTHER_BENEFITS,
546: CONDITIONS
547: from IGS_RE_SCHOLARSHIP_ALL
548: where ROWID = X_ROWID
549: for update nowait;
550: tlinfo c1%rowtype;
551:

Line 645: update IGS_RE_SCHOLARSHIP_ALL set

641: );
642: IF (x_mode = 'S') THEN
643: igs_sc_gen_001.set_ctx('R');
644: END IF;
645: update IGS_RE_SCHOLARSHIP_ALL set
646: END_DT = NEW_REFERENCES.END_DT,
647: DOLLAR_VALUE = NEW_REFERENCES.DOLLAR_VALUE,
648: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
649: OTHER_BENEFITS = NEW_REFERENCES.OTHER_BENEFITS,

Line 696: cursor c1 is select rowid from IGS_RE_SCHOLARSHIP_ALL

692: X_CONDITIONS in VARCHAR2,
693: X_MODE in VARCHAR2 default 'R',
694: X_ORG_ID in NUMBER
695: ) as
696: cursor c1 is select rowid from IGS_RE_SCHOLARSHIP_ALL
697: where PERSON_ID = X_PERSON_ID
698: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
699: and SCHOLARSHIP_TYPE = X_SCHOLARSHIP_TYPE
700: and START_DT = X_START_DT

Line 751: delete from IGS_RE_SCHOLARSHIP_ALL

747:
748: IF (x_mode = 'S') THEN
749: igs_sc_gen_001.set_ctx('R');
750: END IF;
751: delete from IGS_RE_SCHOLARSHIP_ALL
752: where ROWID = X_ROWID;
753: if (sql%notfound) then
754: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
755: igs_ge_msg_stack.add;