APPS.IGS_GR_CRMN_PKG dependencies on IGS_GR_CRMN_ALL

Line 4: old_references IGS_GR_CRMN_ALL%RowType;

1: package body IGS_GR_CRMN_PKG as
2: /* $Header: IGSGI08B.pls 115.6 2002/11/29 00:35:36 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_CRMN_ALL%RowType;
5: new_references IGS_GR_CRMN_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_CRMN_ALL%RowType;

1: package body IGS_GR_CRMN_PKG as
2: /* $Header: IGSGI08B.pls 115.6 2002/11/29 00:35:36 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_CRMN_ALL%RowType;
5: new_references IGS_GR_CRMN_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 32: FROM IGS_GR_CRMN_ALL

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

Line 82: -- ON IGS_GR_CRMN_ALL

78:
79: -- Trigger description :-
80: -- "OSS_TST".trg_gc_br_iu
81: -- BEFORE INSERT OR UPDATE
82: -- ON IGS_GR_CRMN_ALL
83: -- FOR EACH ROW
84:
85: PROCEDURE BeforeRowInsertUpdate1(
86: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 153: -- ON IGS_GR_CRMN_ALL

149:
150: -- Trigger description :-
151: -- "OSS_TST".trg_gc_ar_iu
152: -- AFTER INSERT OR UPDATE
153: -- ON IGS_GR_CRMN_ALL
154: -- FOR EACH ROW
155:
156: PROCEDURE AfterRowInsertUpdate2(
157: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 417: FROM IGS_GR_CRMN_ALL

413: )RETURN BOOLEAN AS
414:
415: CURSOR cur_rowid IS
416: SELECT rowid
417: FROM IGS_GR_CRMN_ALL
418: WHERE grd_cal_type = x_grd_cal_type
419: AND grd_ci_sequence_number = x_grd_ci_sequence_number
420: AND ceremony_number = x_ceremony_number
421: FOR UPDATE NOWAIT;

Line 447: FROM IGS_GR_CRMN_ALL

443: ) AS
444:
445: CURSOR cur_rowid IS
446: SELECT rowid
447: FROM IGS_GR_CRMN_ALL
448: WHERE (ceremony_dt_alias = x_dt_alias
449: AND ceremony_dai_sequence_number = x_sequence_number
450: AND grd_cal_type = x_cal_type
451: AND grd_ci_sequence_number = x_ci_sequence_number)

Line 481: FROM IGS_GR_CRMN_ALL

477: ) AS
478:
479: CURSOR cur_rowid IS
480: SELECT rowid
481: FROM IGS_GR_CRMN_ALL
482: WHERE grd_cal_type = x_grd_cal_type
483: AND grd_ci_sequence_number = x_grd_ci_sequence_number ;
484:
485: lv_rowid cur_rowid%RowType;

Line 508: FROM IGS_GR_CRMN_ALL

504: ) AS
505:
506: CURSOR cur_rowid IS
507: SELECT rowid
508: FROM IGS_GR_CRMN_ALL
509: WHERE venue_cd = x_venue_cd ;
510:
511: lv_rowid cur_rowid%RowType;
512:

Line 655: cursor C is select ROWID from IGS_GR_CRMN_ALL

651: X_NUMBER_OF_GUESTS in NUMBER,
652: X_MODE in VARCHAR2 default 'R',
653: X_ORG_ID in NUMBER
654: ) AS
655: cursor C is select ROWID from IGS_GR_CRMN_ALL
656: where GRD_CAL_TYPE = X_GRD_CAL_TYPE
657: and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER
658: and CEREMONY_NUMBER = X_CEREMONY_NUMBER;
659: X_LAST_UPDATE_DATE DATE;

Line 705: insert into IGS_GR_CRMN_ALL (

701: x_last_update_login => X_LAST_UPDATE_LOGIN,
702: x_org_id => igs_ge_gen_003.get_org_id
703: );
704:
705: insert into IGS_GR_CRMN_ALL (
706: GRD_CAL_TYPE,
707: GRD_CI_SEQUENCE_NUMBER,
708: CEREMONY_NUMBER,
709: VENUE_CD,

Line 785: from IGS_GR_CRMN_ALL

781: CEREMONY_START_TIME,
782: CEREMONY_END_TIME,
783: CEREMONY_FEE,
784: NUMBER_OF_GUESTS
785: from IGS_GR_CRMN_ALL
786: where ROWID = X_ROWID for update nowait;
787: tlinfo c1%rowtype;
788:
789: begin

Line 884: update IGS_GR_CRMN_ALL set

880: x_last_updated_by => X_LAST_UPDATED_BY,
881: x_last_update_login => X_LAST_UPDATE_LOGIN
882: );
883:
884: update IGS_GR_CRMN_ALL set
885: VENUE_CD = NEW_REFERENCES.VENUE_CD,
886: CEREMONY_DT_ALIAS = NEW_REFERENCES.CEREMONY_DT_ALIAS,
887: CEREMONY_DAI_SEQUENCE_NUMBER = NEW_REFERENCES.CEREMONY_DAI_SEQUENCE_NUMBER,
888: CLOSING_DT_ALIAS = NEW_REFERENCES.CLOSING_DT_ALIAS,

Line 927: cursor c1 is select rowid from IGS_GR_CRMN_ALL

923: X_NUMBER_OF_GUESTS in NUMBER,
924: X_MODE in VARCHAR2 default 'R',
925: X_ORG_ID in NUMBER
926: ) AS
927: cursor c1 is select rowid from IGS_GR_CRMN_ALL
928: where GRD_CAL_TYPE = X_GRD_CAL_TYPE
929: and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER
930: and CEREMONY_NUMBER = X_CEREMONY_NUMBER
931: ;

Line 986: delete from IGS_GR_CRMN_ALL

982: p_action => 'DELETE',
983: x_rowid => X_ROWID
984: );
985:
986: delete from IGS_GR_CRMN_ALL
987: where ROWID = X_ROWID;
988: if (sql%notfound) then
989: raise no_data_found;
990: end if;