APPS.IGS_RE_CAND_SEO_CLS_PKG dependencies on IGS_RE_CAND_SEO_CLS

Line 1: package body IGS_RE_CAND_SEO_CLS_PKG as

1: package body IGS_RE_CAND_SEO_CLS_PKG as
2: /* $Header: IGSRI02B.pls 120.1 2005/07/04 00:40:58 appldev ship $ */
3: -------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What

Line 10: old_references IGS_RE_CAND_SEO_CLS%RowType;

6: --smadathi 24-AUG-2001 Bug No. 1956374 .The call to igs_re_val_csc.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_CAND_SEO_CLS%RowType;
11: new_references IGS_RE_CAND_SEO_CLS%RowType;
12:
13: PROCEDURE Set_Column_Values (
14: p_action IN VARCHAR2,

Line 11: new_references IGS_RE_CAND_SEO_CLS%RowType;

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

Line 29: FROM IGS_RE_CAND_SEO_CLS

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

Line 190: FROM IGS_RE_CAND_SEO_CLS

186: ) RETURN BOOLEAN AS
187:
188: CURSOR cur_rowid IS
189: SELECT rowid
190: FROM IGS_RE_CAND_SEO_CLS
191: WHERE person_id = x_person_id
192: AND ca_sequence_number = x_ca_sequence_number
193: AND seo_class_cd = x_seo_class_cd
194: FOR UPDATE NOWAIT;

Line 218: FROM IGS_RE_CAND_SEO_CLS

214: ) AS
215:
216: CURSOR cur_rowid IS
217: SELECT rowid
218: FROM IGS_RE_CAND_SEO_CLS
219: WHERE person_id = x_person_id
220: AND ca_sequence_number = x_sequence_number ;
221:
222: lv_rowid cur_rowid%RowType;

Line 245: FROM IGS_RE_CAND_SEO_CLS

241: ) AS
242:
243: CURSOR cur_rowid IS
244: SELECT rowid
245: FROM IGS_RE_CAND_SEO_CLS
246: WHERE seo_class_cd = x_seo_class_cd ;
247:
248: lv_rowid cur_rowid%RowType;
249:

Line 341: cursor C is select ROWID from IGS_RE_CAND_SEO_CLS

337: X_SEO_CLASS_CD in VARCHAR2,
338: X_PERCENTAGE in NUMBER,
339: X_MODE in VARCHAR2 default 'R'
340: ) as
341: cursor C is select ROWID from IGS_RE_CAND_SEO_CLS
342: where PERSON_ID = X_PERSON_ID
343: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
344: and SEO_CLASS_CD = X_SEO_CLASS_CD;
345: X_LAST_UPDATE_DATE DATE;

Line 385: insert into IGS_RE_CAND_SEO_CLS (

381:
382: IF (x_mode = 'S') THEN
383: igs_sc_gen_001.set_ctx('R');
384: END IF;
385: insert into IGS_RE_CAND_SEO_CLS (
386: PERSON_ID,
387: CA_SEQUENCE_NUMBER,
388: SEO_CLASS_CD,
389: PERCENTAGE,

Line 442: from IGS_RE_CAND_SEO_CLS

438: X_PERCENTAGE in NUMBER
439: ) as
440: cursor c1 is select
441: PERCENTAGE
442: from IGS_RE_CAND_SEO_CLS
443: where ROWID = X_ROWID
444: for update nowait;
445: tlinfo c1%rowtype;
446:

Line 516: update IGS_RE_CAND_SEO_CLS set

512:
513: IF (x_mode = 'S') THEN
514: igs_sc_gen_001.set_ctx('R');
515: END IF;
516: update IGS_RE_CAND_SEO_CLS set
517: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
518: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
519: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
520: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 557: cursor c1 is select rowid from IGS_RE_CAND_SEO_CLS

553: X_SEO_CLASS_CD in VARCHAR2,
554: X_PERCENTAGE in NUMBER,
555: X_MODE in VARCHAR2 default 'R'
556: ) as
557: cursor c1 is select rowid from IGS_RE_CAND_SEO_CLS
558: where PERSON_ID = X_PERSON_ID
559: and CA_SEQUENCE_NUMBER = X_CA_SEQUENCE_NUMBER
560: and SEO_CLASS_CD = X_SEO_CLASS_CD
561: ;

Line 599: delete from IGS_RE_CAND_SEO_CLS

595:
596: IF (x_mode = 'S') THEN
597: igs_sc_gen_001.set_ctx('R');
598: END IF;
599: delete from IGS_RE_CAND_SEO_CLS
600: where ROWID = X_ROWID;
601: if (sql%notfound) then
602: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
603: igs_ge_msg_stack.add;

Line 614: end IGS_RE_CAND_SEO_CLS_PKG;

610:
611:
612: end DELETE_ROW;
613:
614: end IGS_RE_CAND_SEO_CLS_PKG;