APPS.IGS_PS_ANL_LOAD_U_LN_PKG dependencies on IGS_PS_ANL_LOAD_U_LN

Line 1: package body IGS_PS_ANL_LOAD_U_LN_PKG AS

1: package body IGS_PS_ANL_LOAD_U_LN_PKG AS
2: /* $Header: IGSPI05B.pls 115.3 2002/11/29 01:53:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_ANL_LOAD_U_LN%RowType;

Line 5: old_references IGS_PS_ANL_LOAD_U_LN%RowType;

1: package body IGS_PS_ANL_LOAD_U_LN_PKG AS
2: /* $Header: IGSPI05B.pls 115.3 2002/11/29 01:53:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_ANL_LOAD_U_LN%RowType;
6: new_references IGS_PS_ANL_LOAD_U_LN%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,

Line 6: new_references IGS_PS_ANL_LOAD_U_LN%RowType;

2: /* $Header: IGSPI05B.pls 115.3 2002/11/29 01:53:31 nsidana ship $ */
3:
4: l_rowid VARCHAR2(25);
5: old_references IGS_PS_ANL_LOAD_U_LN%RowType;
6: new_references IGS_PS_ANL_LOAD_U_LN%RowType;
7:
8: PROCEDURE Set_Column_Values (
9: p_action IN VARCHAR2,
10: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 26: FROM IGS_PS_ANL_LOAD_U_LN

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

Line 69: -- ON IGS_PS_ANL_LOAD_U_LN

65:
66: -- Trigger description :-
67: -- "OSS_TST".trg_calul_br_iud
68: -- BEFORE INSERT OR DELETE OR UPDATE
69: -- ON IGS_PS_ANL_LOAD_U_LN
70: -- FOR EACH ROW
71:
72: PROCEDURE BeforeRowInsertUpdateDelete1(
73: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 78: v_course_cd IGS_PS_ANL_LOAD_U_LN.course_cd%TYPE;

74: p_updating IN BOOLEAN DEFAULT FALSE,
75: p_deleting IN BOOLEAN DEFAULT FALSE
76: ) AS
77: v_message_name varchar2(30);
78: v_course_cd IGS_PS_ANL_LOAD_U_LN.course_cd%TYPE;
79: v_crv_version_number IGS_PS_ANL_LOAD_U_LN.crv_version_number%TYPE;
80: BEGIN
81:
82: -- Set variables.

Line 79: v_crv_version_number IGS_PS_ANL_LOAD_U_LN.crv_version_number%TYPE;

75: p_deleting IN BOOLEAN DEFAULT FALSE
76: ) AS
77: v_message_name varchar2(30);
78: v_course_cd IGS_PS_ANL_LOAD_U_LN.course_cd%TYPE;
79: v_crv_version_number IGS_PS_ANL_LOAD_U_LN.crv_version_number%TYPE;
80: BEGIN
81:
82: -- Set variables.
83: IF p_deleting THEN

Line 204: FROM IGS_PS_ANL_LOAD_U_LN

200: RETURN BOOLEAN AS
201:
202: CURSOR cur_rowid IS
203: SELECT rowid
204: FROM IGS_PS_ANL_LOAD_U_LN
205: WHERE course_cd = x_course_cd
206: AND crv_version_number = x_crv_version_number
207: AND yr_num = x_yr_num
208: AND effective_start_dt = x_effective_start_dt

Line 238: FROM IGS_PS_ANL_LOAD_U_LN

234: ) AS
235:
236: CURSOR cur_rowid IS
237: SELECT rowid
238: FROM IGS_PS_ANL_LOAD_U_LN
239: WHERE course_cd = x_course_cd
240: AND crv_version_number = x_version_number
241: AND yr_num = x_yr_num
242: AND effective_start_dt = x_effective_start_dt ;

Line 268: FROM IGS_PS_ANL_LOAD_U_LN

264: ) AS
265:
266: CURSOR cur_rowid IS
267: SELECT rowid
268: FROM IGS_PS_ANL_LOAD_U_LN
269: WHERE unit_cd = x_unit_cd
270: AND uv_version_number = x_version_number ;
271:
272: lv_rowid cur_rowid%RowType;

Line 385: cursor C is select ROWID from IGS_PS_ANL_LOAD_U_LN

381: X_UV_VERSION_NUMBER in NUMBER,
382: X_UNIT_CD in VARCHAR2,
383: X_MODE in VARCHAR2 default 'R'
384: ) AS
385: cursor C is select ROWID from IGS_PS_ANL_LOAD_U_LN
386: where COURSE_CD = X_COURSE_CD
387: and CRV_VERSION_NUMBER = X_CRV_VERSION_NUMBER
388: and EFFECTIVE_START_DT = X_EFFECTIVE_START_DT
389: and YR_NUM = X_YR_NUM

Line 431: insert into IGS_PS_ANL_LOAD_U_LN (

427: x_last_updated_by => X_LAST_UPDATED_BY ,
428: x_last_update_login => X_LAST_UPDATE_LOGIN
429: );
430:
431: insert into IGS_PS_ANL_LOAD_U_LN (
432: COURSE_CD,
433: CRV_VERSION_NUMBER,
434: YR_NUM,
435: EFFECTIVE_START_DT,

Line 482: from IGS_PS_ANL_LOAD_U_LN

478: X_UV_VERSION_NUMBER in NUMBER,
479: X_UNIT_CD in VARCHAR2
480: ) AS
481: cursor c1 is select ROWID
482: from IGS_PS_ANL_LOAD_U_LN
483: where ROWID = X_ROWID
484: for update nowait;
485: tlinfo c1%rowtype;
486:

Line 512: delete from IGS_PS_ANL_LOAD_U_LN

508: p_action => 'DELETE',
509: x_rowid => X_ROWID
510: );
511:
512: delete from IGS_PS_ANL_LOAD_U_LN
513: where ROWID = X_ROWID;
514: if (sql%notfound) then
515: raise no_data_found;
516: end if;

Line 525: end IGS_PS_ANL_LOAD_U_LN_PKG;

521: );
522:
523: end DELETE_ROW;
524:
525: end IGS_PS_ANL_LOAD_U_LN_PKG;