APPS.IGS_ST_GVTSEMLOAD_OV_PKG dependencies on IGS_ST_GVTSEMLOAD_OV

Line 1: package body IGS_ST_GVTSEMLOAD_OV_PKG AS

1: package body IGS_ST_GVTSEMLOAD_OV_PKG AS
2: /* $Header: IGSVI04B.pls 115.5 2002/11/29 04:31:41 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_ST_GVTSEMLOAD_OV%RowType;
5: new_references IGS_ST_GVTSEMLOAD_OV%RowType;

Line 4: old_references IGS_ST_GVTSEMLOAD_OV%RowType;

1: package body IGS_ST_GVTSEMLOAD_OV_PKG AS
2: /* $Header: IGSVI04B.pls 115.5 2002/11/29 04:31:41 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_ST_GVTSEMLOAD_OV%RowType;
5: new_references IGS_ST_GVTSEMLOAD_OV%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_ST_GVTSEMLOAD_OV%RowType;

1: package body IGS_ST_GVTSEMLOAD_OV_PKG AS
2: /* $Header: IGSVI04B.pls 115.5 2002/11/29 04:31:41 nsidana ship $ */
3: l_rowid VARCHAR2(25);
4: old_references IGS_ST_GVTSEMLOAD_OV%RowType;
5: new_references IGS_ST_GVTSEMLOAD_OV%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 25: FROM IGS_ST_GVTSEMLOAD_OV

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

Line 71: v_submission_yr IGS_ST_GVTSEMLOAD_OV.submission_yr%TYPE;

67: p_updating IN BOOLEAN DEFAULT FALSE,
68: p_deleting IN BOOLEAN DEFAULT FALSE
69: ) AS
70: v_message_name VARCHAR2(30);
71: v_submission_yr IGS_ST_GVTSEMLOAD_OV.submission_yr%TYPE;
72: v_submission_number IGS_ST_GVTSEMLOAD_OV.submission_number%TYPE;
73: BEGIN
74: IF p_inserting OR p_updating THEN
75: v_submission_yr := new_references.submission_yr;

Line 72: v_submission_number IGS_ST_GVTSEMLOAD_OV.submission_number%TYPE;

68: p_deleting IN BOOLEAN DEFAULT FALSE
69: ) AS
70: v_message_name VARCHAR2(30);
71: v_submission_yr IGS_ST_GVTSEMLOAD_OV.submission_yr%TYPE;
72: v_submission_number IGS_ST_GVTSEMLOAD_OV.submission_number%TYPE;
73: BEGIN
74: IF p_inserting OR p_updating THEN
75: v_submission_yr := new_references.submission_yr;
76: v_submission_number := new_references.submission_number;

Line 231: FROM IGS_ST_GVTSEMLOAD_OV

227: AS
228:
229: CURSOR cur_rowid IS
230: SELECT rowid
231: FROM IGS_ST_GVTSEMLOAD_OV
232: WHERE submission_yr = x_submission_yr
233: AND submission_number = x_submission_number
234: AND govt_semester = x_govt_semester
235: AND cal_type = x_cal_type

Line 266: FROM IGS_ST_GVTSEMLOAD_OV

262: RETURN BOOLEAN
263: AS
264: CURSOR cur_rowid IS
265: SELECT rowid
266: FROM IGS_ST_GVTSEMLOAD_OV
267: WHERE submission_yr = x_submission_yr
268: AND submission_number = x_submission_number
269: AND cal_type = x_cal_type
270: AND ci_sequence_number = x_ci_sequence_number

Line 299: FROM IGS_ST_GVTSEMLOAD_OV

295: ) AS
296:
297: CURSOR cur_rowid IS
298: SELECT rowid
299: FROM IGS_ST_GVTSEMLOAD_OV
300: WHERE cal_type = x_cal_type
301: AND ci_sequence_number = x_ci_sequence_number
302: AND teach_cal_type = x_teach_cal_type ;
303:

Line 329: FROM IGS_ST_GVTSEMLOAD_OV

325: ) AS
326:
327: CURSOR cur_rowid IS
328: SELECT rowid
329: FROM IGS_ST_GVTSEMLOAD_OV
330: WHERE submission_yr = x_submission_yr
331: AND submission_number = x_submission_number
332: AND govt_semester = x_govt_semester ;
333:

Line 449: cursor C is select ROWID from IGS_ST_GVTSEMLOAD_OV

445: X_CI_SEQUENCE_NUMBER in NUMBER,
446: X_TEACH_CAL_TYPE in VARCHAR2,
447: X_MODE in VARCHAR2 default 'R'
448: ) AS
449: cursor C is select ROWID from IGS_ST_GVTSEMLOAD_OV
450: where SUBMISSION_YR = X_SUBMISSION_YR
451: and SUBMISSION_NUMBER = X_SUBMISSION_NUMBER
452: and GOVT_SEMESTER = X_GOVT_SEMESTER
453: and CAL_TYPE = X_CAL_TYPE

Line 495: insert into IGS_ST_GVTSEMLOAD_OV (

491: x_last_updated_by => X_LAST_UPDATED_BY,
492: x_last_update_login => X_LAST_UPDATE_LOGIN
493: );
494:
495: insert into IGS_ST_GVTSEMLOAD_OV (
496: SUBMISSION_YR,
497: SUBMISSION_NUMBER,
498: GOVT_SEMESTER,
499: CAL_TYPE,

Line 545: from IGS_ST_GVTSEMLOAD_OV

541: X_TEACH_CAL_TYPE in VARCHAR2
542: ) AS
543: cursor c1 is select
544: rowid
545: from IGS_ST_GVTSEMLOAD_OV
546: where ROWID = X_ROWID for update nowait;
547: tlinfo c1%rowtype;
548:
549: begin

Line 572: delete from IGS_ST_GVTSEMLOAD_OV

568: Before_DML(
569: p_action => 'DELETE',
570: x_rowid => X_ROWID);
571:
572: delete from IGS_ST_GVTSEMLOAD_OV
573: where ROWID = X_ROWID;
574: if (sql%notfound) then
575: raise no_data_found;
576: end if;

Line 584: end IGS_ST_GVTSEMLOAD_OV_PKG;

580: );
581:
582: end DELETE_ROW;
583:
584: end IGS_ST_GVTSEMLOAD_OV_PKG;