APPS.IGS_GR_CRM_ROUND_PRD_PKG dependencies on IGS_GR_CRM_ROUND_PRD

Line 1: package body IGS_GR_CRM_ROUND_PRD_PKG as

1: package body IGS_GR_CRM_ROUND_PRD_PKG as
2: /* $Header: IGSGI10B.pls 120.0 2005/07/05 11:33:41 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_CRM_ROUND_PRD%RowType;
5: new_references IGS_GR_CRM_ROUND_PRD%RowType;

Line 4: old_references IGS_GR_CRM_ROUND_PRD%RowType;

1: package body IGS_GR_CRM_ROUND_PRD_PKG as
2: /* $Header: IGSGI10B.pls 120.0 2005/07/05 11:33:41 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_CRM_ROUND_PRD%RowType;
5: new_references IGS_GR_CRM_ROUND_PRD%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_GR_CRM_ROUND_PRD%RowType;

1: package body IGS_GR_CRM_ROUND_PRD_PKG as
2: /* $Header: IGSGI10B.pls 120.0 2005/07/05 11:33:41 appldev noship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_GR_CRM_ROUND_PRD%RowType;
5: new_references IGS_GR_CRM_ROUND_PRD%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 23: FROM IGS_GR_CRM_ROUND_PRD

19: ) AS
20:
21: CURSOR cur_old_ref_values IS
22: SELECT *
23: FROM IGS_GR_CRM_ROUND_PRD
24: WHERE rowid = x_rowid;
25:
26: BEGIN
27:

Line 64: -- ON IGS_GR_CRM_ROUND_PRD

60:
61: -- Trigger description :-
62: -- "OSS_TST".trg_crdp_br_iu
63: -- BEFORE INSERT OR UPDATE
64: -- ON IGS_GR_CRM_ROUND_PRD
65: -- FOR EACH ROW
66:
67: PROCEDURE BeforeRowInsertUpdate1(
68: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 203: FROM IGS_GR_CRM_ROUND_PRD

199: )RETURN BOOLEAN AS
200:
201: CURSOR cur_rowid IS
202: SELECT rowid
203: FROM IGS_GR_CRM_ROUND_PRD
204: WHERE grd_cal_type = x_grd_cal_type
205: AND grd_ci_sequence_number = x_grd_ci_sequence_number
206: AND completion_year = x_completion_year
207: AND completion_period = x_completion_period

Line 233: FROM IGS_GR_CRM_ROUND_PRD

229: ) AS
230:
231: CURSOR cur_rowid IS
232: SELECT rowid
233: FROM IGS_GR_CRM_ROUND_PRD
234: WHERE grd_cal_type = x_grd_cal_type
235: AND grd_ci_sequence_number = x_grd_ci_sequence_number ;
236:
237: lv_rowid cur_rowid%RowType;

Line 333: cursor C is select ROWID from IGS_GR_CRM_ROUND_PRD

329: X_COMPLETION_YEAR in NUMBER,
330: X_COMPLETION_PERIOD in out NOCOPY VARCHAR2,
331: X_MODE in VARCHAR2 default 'R'
332: ) AS
333: cursor C is select ROWID from IGS_GR_CRM_ROUND_PRD
334: where GRD_CAL_TYPE = X_GRD_CAL_TYPE
335: and GRD_CI_SEQUENCE_NUMBER = X_GRD_CI_SEQUENCE_NUMBER
336: and COMPLETION_YEAR = X_COMPLETION_YEAR
337: and COMPLETION_PERIOD = NEW_REFERENCES.COMPLETION_PERIOD;

Line 375: insert into IGS_GR_CRM_ROUND_PRD (

371: x_last_updated_by => X_LAST_UPDATED_BY,
372: x_last_update_login => X_LAST_UPDATE_LOGIN
373: );
374:
375: insert into IGS_GR_CRM_ROUND_PRD (
376: GRD_CAL_TYPE,
377: GRD_CI_SEQUENCE_NUMBER,
378: COMPLETION_YEAR,
379: COMPLETION_PERIOD,

Line 416: from IGS_GR_CRM_ROUND_PRD

412: X_COMPLETION_PERIOD in VARCHAR2
413: ) AS
414: cursor c1 is select
415: rowid
416: from IGS_GR_CRM_ROUND_PRD
417: where ROWID = X_ROWID for update nowait;
418: tlinfo c1%rowtype;
419:
420: begin

Line 439: delete from IGS_GR_CRM_ROUND_PRD

435: X_ROWID in VARCHAR2
436: ) AS
437: begin
438:
439: delete from IGS_GR_CRM_ROUND_PRD
440: where ROWID = X_ROWID;
441: if (sql%notfound) then
442: raise no_data_found;
443: end if;

Line 446: end IGS_GR_CRM_ROUND_PRD_PKG;

442: raise no_data_found;
443: end if;
444: end;
445:
446: end IGS_GR_CRM_ROUND_PRD_PKG;