APPS.IGS_EN_METHOD_TYPE_PKG dependencies on IGS_EN_METHOD_TYPE

Line 1: package body IGS_EN_METHOD_TYPE_PKG AS

1: package body IGS_EN_METHOD_TYPE_PKG AS
2: /* $Header: IGSEI07B.pls 120.0 2005/06/01 18:30:36 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_METHOD_TYPE%RowType;
5: new_references IGS_EN_METHOD_TYPE%RowType;

Line 4: old_references IGS_EN_METHOD_TYPE%RowType;

1: package body IGS_EN_METHOD_TYPE_PKG AS
2: /* $Header: IGSEI07B.pls 120.0 2005/06/01 18:30:36 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_METHOD_TYPE%RowType;
5: new_references IGS_EN_METHOD_TYPE%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2,

Line 5: new_references IGS_EN_METHOD_TYPE%RowType;

1: package body IGS_EN_METHOD_TYPE_PKG AS
2: /* $Header: IGSEI07B.pls 120.0 2005/06/01 18:30:36 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_EN_METHOD_TYPE%RowType;
5: new_references IGS_EN_METHOD_TYPE%RowType;
6: PROCEDURE Set_Column_Values (
7: p_action IN VARCHAR2,
8: x_rowid IN VARCHAR2,
9: x_enr_method_type IN VARCHAR2,

Line 26: FROM IGS_EN_METHOD_TYPE

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

Line 133: IGS_EN_CAT_PRC_DTL_PKG.GET_FK_IGS_EN_METHOD_TYPE (

129:
130: PROCEDURE Check_Child_Existance AS
131: BEGIN
132:
133: IGS_EN_CAT_PRC_DTL_PKG.GET_FK_IGS_EN_METHOD_TYPE (
134: old_references.enr_method_type
135: );
136:
137: igs_en_cpd_ext_pkg.get_fk_igs_en_method_type(

Line 137: igs_en_cpd_ext_pkg.get_fk_igs_en_method_type(

133: IGS_EN_CAT_PRC_DTL_PKG.GET_FK_IGS_EN_METHOD_TYPE (
134: old_references.enr_method_type
135: );
136:
137: igs_en_cpd_ext_pkg.get_fk_igs_en_method_type(
138: old_references.enr_method_type
139: );
140: END Check_Child_Existance;
141:

Line 148: FROM IGS_EN_METHOD_TYPE

144: ) RETURN BOOLEAN as
145:
146: CURSOR cur_rowid IS
147: SELECT rowid
148: FROM IGS_EN_METHOD_TYPE
149: WHERE enr_method_type = x_enr_method_type
150: FOR UPDATE NOWAIT;
151:
152: lv_rowid cur_rowid%RowType;

Line 274: cursor C is select ROWID from IGS_EN_METHOD_TYPE

270: X_BULK_JOB_IND IN VARCHAR2,
271: X_TRANSFER_FLAG IN VARCHAR2,
272: X_DFLT_TRANS_DETAILS_FLAG IN VARCHAR2
273: ) AS
274: cursor C is select ROWID from IGS_EN_METHOD_TYPE
275: where ENR_METHOD_TYPE = X_ENR_METHOD_TYPE;
276: X_LAST_UPDATE_DATE DATE;
277: X_LAST_UPDATED_BY NUMBER;
278: X_LAST_UPDATE_LOGIN NUMBER;

Line 315: insert into IGS_EN_METHOD_TYPE (

311: x_bulk_job_ind => NVL(x_bulk_job_ind,'N'),
312: x_transfer_flag => x_transfer_flag,
313: x_dflt_trans_details_flag => x_dflt_trans_details_flag
314: );
315: insert into IGS_EN_METHOD_TYPE (
316: ENR_METHOD_TYPE,
317: DESCRIPTION,
318: CLOSED_IND,
319: CREATION_DATE,

Line 378: from IGS_EN_METHOD_TYPE

374: SELF_SERVICE,
375: IVR_DISPLAY_IND,
376: TRANSFER_FLAG,
377: DFLT_TRANS_DETAILS_FLAG
378: from IGS_EN_METHOD_TYPE
379: where ROWID = X_ROWID
380: for update nowait;
381: tlinfo c1%rowtype;
382:

Line 471: update IGS_EN_METHOD_TYPE set

467: x_bulk_job_ind => X_BULK_JOB_IND,
468: x_transfer_flag => x_transfer_flag,
469: x_dflt_trans_details_flag => x_dflt_trans_details_flag
470: );
471: update IGS_EN_METHOD_TYPE set
472: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
473: CLOSED_IND = NEW_REFERENCES.CLOSED_IND,
474: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
475: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 505: cursor c1 is select rowid from IGS_EN_METHOD_TYPE

501: X_BULK_JOB_IND IN VARCHAR2,
502: X_TRANSFER_FLAG IN VARCHAR2,
503: X_DFLT_TRANS_DETAILS_FLAG IN VARCHAR2
504: ) AS
505: cursor c1 is select rowid from IGS_EN_METHOD_TYPE
506: where ENR_METHOD_TYPE = X_ENR_METHOD_TYPE
507: ;
508: begin
509: open c1;

Line 550: delete from IGS_EN_METHOD_TYPE

546: Before_DML (
547: p_action =>'DELETE',
548: x_rowid => X_ROWID
549: );
550: delete from IGS_EN_METHOD_TYPE
551: where ROWID = X_ROWID;
552: if (sql%notfound) then
553: raise no_data_found;
554: end if;

Line 561: end IGS_EN_METHOD_TYPE_PKG;

557: x_rowid => X_ROWID
558: );
559: end DELETE_ROW;
560:
561: end IGS_EN_METHOD_TYPE_PKG;