APPS.IGS_ST_UNT_LOAD_APPO_PKG dependencies on IGS_ST_UNT_LOAD_APPO

Line 1: package body IGS_ST_UNT_LOAD_APPO_PKG as

1: package body IGS_ST_UNT_LOAD_APPO_PKG as
2: /* $Header: IGSVI12B.pls 115.4 2002/11/29 04:33:50 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_UNT_LOAD_APPO%RowType;

Line 5: old_references IGS_ST_UNT_LOAD_APPO%RowType;

1: package body IGS_ST_UNT_LOAD_APPO_PKG as
2: /* $Header: IGSVI12B.pls 115.4 2002/11/29 04:33:50 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_UNT_LOAD_APPO%RowType;
6: new_references IGS_ST_UNT_LOAD_APPO%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_ST_UNT_LOAD_APPO%RowType;

2: /* $Header: IGSVI12B.pls 115.4 2002/11/29 04:33:50 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_ST_UNT_LOAD_APPO%RowType;
6: new_references IGS_ST_UNT_LOAD_APPO%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 27: FROM IGS_ST_UNT_LOAD_APPO

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

Line 74: v_dla_cal_type IGS_ST_UNT_LOAD_APPO.dla_cal_type%TYPE;

70: p_updating IN BOOLEAN DEFAULT FALSE,
71: p_deleting IN BOOLEAN DEFAULT FALSE
72: ) as
73: v_message_name VARCHAR2(30);
74: v_dla_cal_type IGS_ST_UNT_LOAD_APPO.dla_cal_type%TYPE;
75: v_ci_sequence_number IGS_ST_UNT_LOAD_APPO.ci_sequence_number%TYPE;
76: BEGIN
77: IF p_inserting OR p_updating THEN
78: v_dla_cal_type := new_references.dla_cal_type;

Line 75: v_ci_sequence_number IGS_ST_UNT_LOAD_APPO.ci_sequence_number%TYPE;

71: p_deleting IN BOOLEAN DEFAULT FALSE
72: ) as
73: v_message_name VARCHAR2(30);
74: v_dla_cal_type IGS_ST_UNT_LOAD_APPO.dla_cal_type%TYPE;
75: v_ci_sequence_number IGS_ST_UNT_LOAD_APPO.ci_sequence_number%TYPE;
76: BEGIN
77: IF p_inserting OR p_updating THEN
78: v_dla_cal_type := new_references.dla_cal_type;
79: v_ci_sequence_number := new_references.ci_sequence_number;

Line 236: FROM IGS_ST_UNT_LOAD_APPO

232: )return BOOLEAN as
233:
234: CURSOR cur_rowid IS
235: SELECT rowid
236: FROM IGS_ST_UNT_LOAD_APPO
237: WHERE dla_cal_type = x_dla_cal_type
238: AND ci_sequence_number = x_ci_sequence_number
239: AND unit_cd = x_unit_cd
240: AND version_number = x_version_number

Line 268: FROM IGS_ST_UNT_LOAD_APPO

264: ) as
265:
266: CURSOR cur_rowid IS
267: SELECT rowid
268: FROM IGS_ST_UNT_LOAD_APPO
269: WHERE dla_cal_type = x_cal_type
270: AND ci_sequence_number = x_ci_sequence_number
271: AND teach_cal_type = x_teach_cal_type ;
272:

Line 298: FROM IGS_ST_UNT_LOAD_APPO

294: ) as
295:
296: CURSOR cur_rowid IS
297: SELECT rowid
298: FROM IGS_ST_UNT_LOAD_APPO
299: WHERE unit_cd = x_unit_cd
300: AND version_number = x_version_number
301: AND teach_cal_type = x_cal_type ;
302:

Line 416: cursor C is select ROWID from IGS_ST_UNT_LOAD_APPO

412: X_PERCENTAGE in NUMBER,
413: X_SECOND_PERCENTAGE in NUMBER,
414: X_MODE in VARCHAR2 default 'R'
415: ) as
416: cursor C is select ROWID from IGS_ST_UNT_LOAD_APPO
417: where DLA_CAL_TYPE = X_DLA_CAL_TYPE
418: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
419: and UNIT_CD = X_UNIT_CD
420: and VERSION_NUMBER = X_VERSION_NUMBER

Line 461: insert into IGS_ST_UNT_LOAD_APPO (

457: x_last_updated_by => X_LAST_UPDATED_BY,
458: x_last_update_login => X_LAST_UPDATE_LOGIN
459: );
460:
461: insert into IGS_ST_UNT_LOAD_APPO (
462: DLA_CAL_TYPE,
463: CI_SEQUENCE_NUMBER,
464: UNIT_CD,
465: VERSION_NUMBER,

Line 516: from IGS_ST_UNT_LOAD_APPO

512: ) as
513: cursor c1 is select
514: PERCENTAGE,
515: SECOND_PERCENTAGE
516: from IGS_ST_UNT_LOAD_APPO
517: where ROWID = X_ROWID for update nowait;
518: tlinfo c1%rowtype;
519:
520: begin

Line 595: update IGS_ST_UNT_LOAD_APPO set

591: x_last_update_date => X_LAST_UPDATE_DATE,
592: x_last_updated_by => X_LAST_UPDATED_BY,
593: x_last_update_login => X_LAST_UPDATE_LOGIN
594: );
595: update IGS_ST_UNT_LOAD_APPO set
596: PERCENTAGE = NEW_REFERENCES.PERCENTAGE,
597: SECOND_PERCENTAGE = NEW_REFERENCES.SECOND_PERCENTAGE,
598: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
599: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 623: cursor c1 is select rowid from IGS_ST_UNT_LOAD_APPO

619: X_PERCENTAGE in NUMBER,
620: X_SECOND_PERCENTAGE in NUMBER,
621: X_MODE in VARCHAR2 default 'R'
622: ) as
623: cursor c1 is select rowid from IGS_ST_UNT_LOAD_APPO
624: where DLA_CAL_TYPE = X_DLA_CAL_TYPE
625: and CI_SEQUENCE_NUMBER = X_CI_SEQUENCE_NUMBER
626: and UNIT_CD = X_UNIT_CD
627: and VERSION_NUMBER = X_VERSION_NUMBER

Line 668: delete from IGS_ST_UNT_LOAD_APPO

664: Before_DML (
665: p_action => 'DELETE',
666: x_rowid => X_ROWID
667: );
668: delete from IGS_ST_UNT_LOAD_APPO
669: where ROWID = X_ROWID;
670: if (sql%notfound) then
671: raise no_data_found;
672: end if;

Line 679: end IGS_ST_UNT_LOAD_APPO_PKG;

675: x_rowid => X_ROWID
676: );
677: end DELETE_ROW;
678:
679: end IGS_ST_UNT_LOAD_APPO_PKG;