APPS.IGS_PR_RU_CA_TYPE_PKG dependencies on IGS_PR_RU_CA_TYPE_ALL

Line 5: old_references IGS_PR_RU_CA_TYPE_ALL%RowType;

1: package body IGS_PR_RU_CA_TYPE_PKG AS
2: /* $Header: IGSQI12B.pls 115.6 2002/11/29 03:16:51 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_RU_CA_TYPE_ALL%RowType;
6: new_references IGS_PR_RU_CA_TYPE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PR_RU_CA_TYPE_ALL%RowType;

2: /* $Header: IGSQI12B.pls 115.6 2002/11/29 03:16:51 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PR_RU_CA_TYPE_ALL%RowType;
6: new_references IGS_PR_RU_CA_TYPE_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 28: FROM IGS_PR_RU_CA_TYPE_ALL

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

Line 197: FROM IGS_PR_RU_CA_TYPE_ALL

193: ) RETURN BOOLEAN AS
194:
195: CURSOR cur_rowid IS
196: SELECT rowid
197: FROM IGS_PR_RU_CA_TYPE_ALL
198: WHERE progression_rule_cat = x_progression_rule_cat
199: AND pra_sequence_number = x_pra_sequence_number
200: AND prg_cal_type = x_prg_cal_type
201: FOR UPDATE NOWAIT;

Line 225: FROM IGS_PR_RU_CA_TYPE_ALL

221: ) AS
222:
223: CURSOR cur_rowid IS
224: SELECT rowid
225: FROM IGS_PR_RU_CA_TYPE_ALL
226: WHERE prg_cal_type = x_cal_type ;
227:
228: lv_rowid cur_rowid%RowType;
229:

Line 253: FROM IGS_PR_RU_CA_TYPE_ALL

249: ) AS
250:
251: CURSOR cur_rowid IS
252: SELECT rowid
253: FROM IGS_PR_RU_CA_TYPE_ALL
254: WHERE ( prg_cal_type = x_cal_type
255: AND end_sequence_number = x_sequence_number )
256: OR (prg_cal_type = x_cal_type
257: AND start_sequence_number = x_sequence_number) ;

Line 284: FROM IGS_PR_RU_CA_TYPE_ALL

280: ) AS
281:
282: CURSOR cur_rowid IS
283: SELECT rowid
284: FROM IGS_PR_RU_CA_TYPE_ALL
285: WHERE progression_rule_cat = x_progression_rule_cat
286: AND pra_sequence_number = x_sequence_number ;
287:
288: lv_rowid cur_rowid%RowType;

Line 393: cursor C is select ROWID from IGS_PR_RU_CA_TYPE_ALL

389: X_NUM_OF_APPLICATIONS in NUMBER,
390: X_MODE in VARCHAR2 default 'R',
391: x_ORG_ID IN NUMBER
392: ) AS
393: cursor C is select ROWID from IGS_PR_RU_CA_TYPE_ALL
394: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
395: and PRA_SEQUENCE_NUMBER = X_PRA_SEQUENCE_NUMBER
396: and PRG_CAL_TYPE = X_PRG_CAL_TYPE;
397: X_LAST_UPDATE_DATE DATE;

Line 436: insert into IGS_PR_RU_CA_TYPE_ALL (

432: x_last_updated_by => x_last_updated_by,
433: x_last_update_login => x_last_update_login,
434: x_org_id => igs_ge_gen_003.get_org_id
435: );
436: insert into IGS_PR_RU_CA_TYPE_ALL (
437: PROGRESSION_RULE_CAT,
438: PRA_SEQUENCE_NUMBER,
439: PRG_CAL_TYPE,
440: START_SEQUENCE_NUMBER,

Line 490: from IGS_PR_RU_CA_TYPE_ALL

486: START_SEQUENCE_NUMBER,
487: END_SEQUENCE_NUMBER,
488: START_EFFECTIVE_PERIOD,
489: NUM_OF_APPLICATIONS
490: from IGS_PR_RU_CA_TYPE_ALL
491: where ROWID = X_ROWID for update nowait;
492: tlinfo c1%rowtype;
493:
494: begin

Line 579: update IGS_PR_RU_CA_TYPE_ALL set

575: x_last_updated_by => x_last_updated_by,
576: x_last_update_login => x_last_update_login
577: );
578:
579: update IGS_PR_RU_CA_TYPE_ALL set
580: START_SEQUENCE_NUMBER = NEW_REFERENCES.START_SEQUENCE_NUMBER,
581: END_SEQUENCE_NUMBER = NEW_REFERENCES.END_SEQUENCE_NUMBER,
582: START_EFFECTIVE_PERIOD = NEW_REFERENCES.START_EFFECTIVE_PERIOD,
583: NUM_OF_APPLICATIONS = NEW_REFERENCES.NUM_OF_APPLICATIONS,

Line 606: cursor c1 is select rowid from IGS_PR_RU_CA_TYPE_ALL

602: X_NUM_OF_APPLICATIONS in NUMBER,
603: X_MODE in VARCHAR2 default 'R',
604: X_ORG_ID IN NUMBER
605: ) AS
606: cursor c1 is select rowid from IGS_PR_RU_CA_TYPE_ALL
607: where PROGRESSION_RULE_CAT = X_PROGRESSION_RULE_CAT
608: and PRA_SEQUENCE_NUMBER = X_PRA_SEQUENCE_NUMBER
609: and PRG_CAL_TYPE = X_PRG_CAL_TYPE
610: ;

Line 652: delete from IGS_PR_RU_CA_TYPE_ALL

648: p_action => 'DELETE',
649: x_rowid => X_ROWID
650: );
651:
652: delete from IGS_PR_RU_CA_TYPE_ALL
653: where ROWID = X_ROWID;
654: if (sql%notfound) then
655: raise no_data_found;
656: end if;