APPS.IGS_ST_GVT_SPSHT_CTL_PKG dependencies on IGS_ST_GVT_SPSHT_CTL_ALL

Line 4: old_references IGS_ST_GVT_SPSHT_CTL_ALL%RowType;

1: package body IGS_ST_GVT_SPSHT_CTL_PKG as
2: /* $Header: IGSVI08B.pls 115.6 2002/11/29 04:32:37 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_ST_GVT_SPSHT_CTL_ALL%RowType;
5: new_references IGS_ST_GVT_SPSHT_CTL_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_ST_GVT_SPSHT_CTL_ALL%RowType;

1: package body IGS_ST_GVT_SPSHT_CTL_PKG as
2: /* $Header: IGSVI08B.pls 115.6 2002/11/29 04:32:37 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_ST_GVT_SPSHT_CTL_ALL%RowType;
5: new_references IGS_ST_GVT_SPSHT_CTL_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 24: FROM IGS_ST_GVT_SPSHT_CTL_ALL

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

Line 169: FROM IGS_ST_GVT_SPSHT_CTL_ALL

165: RETURN BOOLEAN AS
166:
167: CURSOR cur_rowid IS
168: SELECT rowid
169: FROM IGS_ST_GVT_SPSHT_CTL_ALL
170: WHERE submission_yr = x_submission_yr
171: AND submission_number = x_submission_number
172: FOR UPDATE NOWAIT;
173:

Line 196: FROM IGS_ST_GVT_SPSHT_CTL_ALL

192: ) AS
193:
194: CURSOR cur_rowid IS
195: SELECT rowid
196: FROM IGS_ST_GVT_SPSHT_CTL_ALL
197: WHERE ess_snapshot_dt_time = x_ess_snapshot_dt_time;
198:
199: lv_rowid cur_rowid%RowType;
200:

Line 352: cursor C is select ROWID from IGS_ST_GVT_SPSHT_CTL_ALL

348: X_COMPLETION_DT in DATE,
349: x_org_id IN NUMBER,
350: X_MODE in VARCHAR2 default 'R'
351: ) AS
352: cursor C is select ROWID from IGS_ST_GVT_SPSHT_CTL_ALL
353: where SUBMISSION_YR = X_SUBMISSION_YR
354: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER;
355: X_LAST_UPDATE_DATE DATE;
356: X_LAST_UPDATED_BY NUMBER;

Line 408: insert into IGS_ST_GVT_SPSHT_CTL_ALL (

404: x_last_updated_by =>X_LAST_UPDATED_BY,
405: x_last_update_login =>X_LAST_UPDATE_LOGIN
406: );
407:
408: insert into IGS_ST_GVT_SPSHT_CTL_ALL (
409: SUBMISSION_YR,
410: SUBMISSION_NUMBER,
411: ESS_SNAPSHOT_DT_TIME,
412: COMPLETION_DT,

Line 465: from IGS_ST_GVT_SPSHT_CTL_ALL

461: ) AS
462: cursor c1 is select
463: ESS_SNAPSHOT_DT_TIME,
464: COMPLETION_DT
465: from IGS_ST_GVT_SPSHT_CTL_ALL
466: where ROWID = X_ROWID
467: for update nowait;
468: tlinfo c1%rowtype;
469:

Line 561: update IGS_ST_GVT_SPSHT_CTL_ALL set

557: else
558: X_PROGRAM_UPDATE_DATE := SYSDATE;
559: end if;
560: end if;
561: update IGS_ST_GVT_SPSHT_CTL_ALL set
562: ESS_SNAPSHOT_DT_TIME = NEW_REFERENCES.ESS_SNAPSHOT_DT_TIME,
563: COMPLETION_DT = NEW_REFERENCES.COMPLETION_DT,
564: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
565: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 593: cursor c1 is select rowid from IGS_ST_GVT_SPSHT_CTL_ALL

589: X_COMPLETION_DT in DATE,
590: X_ORG_ID in NUMBER,
591: X_MODE in VARCHAR2 default 'R'
592: ) AS
593: cursor c1 is select rowid from IGS_ST_GVT_SPSHT_CTL_ALL
594: where SUBMISSION_YR = X_SUBMISSION_YR
595: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
596: ;
597: begin

Line 632: delete from IGS_ST_GVT_SPSHT_CTL_ALL

628: p_action =>'DELETE',
629: x_rowid => X_ROWID
630: );
631:
632: delete from IGS_ST_GVT_SPSHT_CTL_ALL
633: where ROWID = X_ROWID;
634: if (sql%notfound) then
635: raise no_data_found;
636: end if;