APPS.IGS_CA_DA_INST_PAIR_PKG dependencies on IGS_CA_DA_INST_PAIR

Line 1: package body IGS_CA_DA_INST_PAIR_PKG AS

1: package body IGS_CA_DA_INST_PAIR_PKG AS
2: /* $Header: IGSCI07B.pls 115.3 2002/11/28 23:01:08 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST_PAIR%RowType;
5: new_references IGS_CA_DA_INST_PAIR%RowType;

Line 4: old_references IGS_CA_DA_INST_PAIR%RowType;

1: package body IGS_CA_DA_INST_PAIR_PKG AS
2: /* $Header: IGSCI07B.pls 115.3 2002/11/28 23:01:08 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST_PAIR%RowType;
5: new_references IGS_CA_DA_INST_PAIR%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_CA_DA_INST_PAIR%RowType;

1: package body IGS_CA_DA_INST_PAIR_PKG AS
2: /* $Header: IGSCI07B.pls 115.3 2002/11/28 23:01:08 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_CA_DA_INST_PAIR%RowType;
5: new_references IGS_CA_DA_INST_PAIR%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 27: FROM IGS_CA_DA_INST_PAIR

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

Line 72: -- ON IGS_CA_DA_INST_PAIR

68:
69: -- Trigger description :-
70: -- "OSS_TST".trg_daip_br_iud
71: -- BEFORE INSERT OR DELETE OR UPDATE
72: -- ON IGS_CA_DA_INST_PAIR
73: -- FOR EACH ROW
74:
75: PROCEDURE BeforeRowInsertUpdateDelete1(
76: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 129: -- ON IGS_CA_DA_INST_PAIR

125:
126: -- Trigger description :-
127: -- "OSS_TST".trg_daip_as_iu
128: -- AFTER INSERT OR UPDATE
129: -- ON IGS_CA_DA_INST_PAIR
130:
131: PROCEDURE AfterStmtInsertUpdate3(
132: p_inserting IN BOOLEAN DEFAULT FALSE,
133: p_updating IN BOOLEAN DEFAULT FALSE,

Line 252: FROM IGS_CA_DA_INST_PAIR

248: )RETURN BOOLEAN AS
249:
250: CURSOR cur_rowid IS
251: SELECT rowid
252: FROM IGS_CA_DA_INST_PAIR
253: WHERE dt_alias = x_dt_alias
254: AND dai_sequence_number = x_dai_sequence_number
255: AND cal_type = x_cal_type
256: AND ci_sequence_number = x_ci_sequence_number

Line 355: FROM IGS_CA_DA_INST_PAIR

351: )RETURN BOOLEAN AS
352:
353: CURSOR cur_rowid IS
354: SELECT rowid
355: FROM IGS_CA_DA_INST_PAIR
356: WHERE dt_alias = x_dt_alias
357: AND dai_sequence_number = x_dai_sequence_number
358: AND cal_type = x_cal_type
359: AND ci_sequence_number = x_ci_sequence_number

Line 391: FROM IGS_CA_DA_INST_PAIR

387: ) AS
388:
389: CURSOR cur_rowid IS
390: SELECT rowid
391: FROM IGS_CA_DA_INST_PAIR
392: WHERE (dt_alias = x_dt_alias
393: AND dai_sequence_number = x_sequence_number
394: AND cal_type = x_cal_type
395: AND ci_sequence_number = x_ci_sequence_number)

Line 542: cursor C is select ROWID from IGS_CA_DA_INST_PAIR

538: X_RELATED_CAL_TYPE in VARCHAR2,
539: X_RELATED_CI_SEQUENCE_NUMBER in NUMBER,
540: X_MODE in VARCHAR2 default 'R'
541: ) AS
542: cursor C is select ROWID from IGS_CA_DA_INST_PAIR
543: where DT_ALIAS = X_DT_ALIAS
544: and DAI_SEQUENCE_NUMBER = X_DAI_SEQUENCE_NUMBER
545: and CAL_TYPE = X_CAL_TYPE
546: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER

Line 590: insert into IGS_CA_DA_INST_PAIR (

586: x_last_update_date =>X_LAST_UPDATE_DATE,
587: x_last_updated_by =>X_LAST_UPDATED_BY,
588: x_last_update_login =>X_LAST_UPDATE_LOGIN
589: );
590: insert into IGS_CA_DA_INST_PAIR (
591: DT_ALIAS,
592: DAI_SEQUENCE_NUMBER,
593: CAL_TYPE,
594: CI_SEQUENCE_NUMBER,

Line 646: from IGS_CA_DA_INST_PAIR

642: X_RELATED_CAL_TYPE in VARCHAR2,
643: X_RELATED_CI_SEQUENCE_NUMBER in NUMBER
644: ) AS
645: cursor c1 is select *
646: from IGS_CA_DA_INST_PAIR
647: where ROWID = X_ROWID
648: for update nowait;
649: tlinfo c1%rowtype;
650:

Line 674: delete from IGS_CA_DA_INST_PAIR

670: p_action =>'DELETE',
671: x_rowid =>X_ROWID
672: );
673:
674: delete from IGS_CA_DA_INST_PAIR
675: where ROWID=X_ROWID;
676: if (sql%notfound) then
677: raise no_data_found;
678: end if;

Line 686: end IGS_CA_DA_INST_PAIR_PKG;

682: );
683:
684: end DELETE_ROW;
685:
686: end IGS_CA_DA_INST_PAIR_PKG;