APPS.IGS_GR_CRMN_ROUND_PKG dependencies on IGS_GR_CRMN_ROUND_ALL

Line 5: old_references IGS_GR_CRMN_ROUND_ALL%RowType;

1: package body IGS_GR_CRMN_ROUND_PKG as
2: /* $Header: IGSGI07B.pls 115.9 2003/09/22 06:29:12 nalkumar ship $ */
3: -- BUG #1956374 , Procedure assp_val_ci_status reference is changed
4: l_rowid VARCHAR2(25);
5: old_references IGS_GR_CRMN_ROUND_ALL%RowType;
6: new_references IGS_GR_CRMN_ROUND_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_GR_CRMN_ROUND_ALL%RowType;

2: /* $Header: IGSGI07B.pls 115.9 2003/09/22 06:29:12 nalkumar ship $ */
3: -- BUG #1956374 , Procedure assp_val_ci_status reference is changed
4: l_rowid VARCHAR2(25);
5: old_references IGS_GR_CRMN_ROUND_ALL%RowType;
6: new_references IGS_GR_CRMN_ROUND_ALL%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 31: FROM IGS_GR_CRMN_ROUND_ALL

27: ) AS
28:
29: CURSOR cur_old_ref_values IS
30: SELECT *
31: FROM IGS_GR_CRMN_ROUND_ALL
32: WHERE rowid = x_rowid;
33:
34: BEGIN
35:

Line 79: -- ON IGS_GR_CRMN_ROUND_ALL

75:
76: -- Trigger description :-
77: -- "OSS_TST".trg_crd_br_iu
78: -- BEFORE INSERT OR UPDATE
79: -- ON IGS_GR_CRMN_ROUND_ALL
80: -- FOR EACH ROW
81:
82: PROCEDURE BeforeRowInsertUpdate1(
83: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 296: FROM IGS_GR_CRMN_ROUND_ALL

292: ) RETURN BOOLEAN AS
293:
294: CURSOR cur_rowid IS
295: SELECT rowid
296: FROM IGS_GR_CRMN_ROUND_ALL
297: WHERE grd_cal_type = x_grd_cal_type
298: AND grd_ci_sequence_number = x_grd_ci_sequence_number ;
299:
300: lv_rowid cur_rowid%RowType;

Line 322: FROM IGS_GR_CRMN_ROUND_ALL

318: ) AS
319:
320: CURSOR cur_rowid IS
321: SELECT rowid
322: FROM IGS_GR_CRMN_ROUND_ALL
323: WHERE grd_cal_type = x_cal_type
324: AND grd_ci_sequence_number = x_sequence_number ;
325:
326: lv_rowid cur_rowid%RowType;

Line 352: FROM IGS_GR_CRMN_ROUND_ALL

348: ) AS
349:
350: CURSOR cur_rowid IS
351: SELECT rowid
352: FROM IGS_GR_CRMN_ROUND_ALL
353: WHERE (end_dt_alias = x_dt_alias
354: AND end_dai_sequence_number = x_sequence_number
355: AND grd_cal_type = x_cal_type
356: AND grd_ci_sequence_number = x_ci_sequence_number)

Line 476: cursor C is select ROWID from IGS_GR_CRMN_ROUND_ALL

472: X_CONFERRAL_END_DATE IN DATE DEFAULT NULL,
473: X_COMPLETION_START_DATE IN DATE DEFAULT NULL,
474: X_COMPLETION_END_DATE IN DATE DEFAULT NULL
475: ) AS
476: cursor C is select ROWID from IGS_GR_CRMN_ROUND_ALL
477: where GRD_CAL_TYPE = X_GRD_CAL_TYPE
478: and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER;
479: X_LAST_UPDATE_DATE DATE;
480: X_LAST_UPDATED_BY NUMBER;

Line 523: insert into IGS_GR_CRMN_ROUND_ALL (

519: x_completion_start_date => X_COMPLETION_START_DATE,
520: x_completion_end_date => X_COMPLETION_END_DATE
521: );
522:
523: insert into IGS_GR_CRMN_ROUND_ALL (
524: GRD_CAL_TYPE,
525: GRD_CI_SEQUENCE_NUMBER,
526: START_DT_ALIAS,
527: START_DAI_SEQUENCE_NUMBER,

Line 587: from IGS_GR_CRMN_ROUND_ALL

583: START_DT_ALIAS,
584: START_DAI_SEQUENCE_NUMBER,
585: END_DT_ALIAS,
586: END_DAI_SEQUENCE_NUMBER
587: from IGS_GR_CRMN_ROUND_ALL
588: where ROWID = X_ROWID for update nowait;
589: tlinfo c1%rowtype;
590:
591: begin

Line 671: update IGS_GR_CRMN_ROUND_ALL set

667: x_completion_start_date => X_COMPLETION_START_DATE,
668: x_completion_end_date => X_COMPLETION_END_DATE
669: );
670:
671: update IGS_GR_CRMN_ROUND_ALL set
672: START_DT_ALIAS = NEW_REFERENCES.START_DT_ALIAS,
673: START_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.START_DAI_SEQUENCE_NUMBER,
674: END_DT_ALIAS = NEW_REFERENCES.END_DT_ALIAS,
675: END_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.END_DAI_SEQUENCE_NUMBER,

Line 706: cursor c1 is select rowid from IGS_GR_CRMN_ROUND_ALL

702: X_CONFERRAL_END_DATE IN DATE,
703: X_COMPLETION_START_DATE IN DATE,
704: X_COMPLETION_END_DATE IN DATE
705: ) AS
706: cursor c1 is select rowid from IGS_GR_CRMN_ROUND_ALL
707: where GRD_CAL_TYPE = X_GRD_CAL_TYPE
708: and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER
709: ;
710: