eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_ANL_LOAD_PKG dependencies on IGS_PS_ANL_LOAD

Line 1: package body IGS_PS_ANL_LOAD_PKG AS

1: package body IGS_PS_ANL_LOAD_PKG AS
2: /* $Header: IGSPI04B.pls 115.5 2003/02/05 10:24:07 sarakshi ship $ */
3:
4:
5: l_rowid VARCHAR2(25);

Line 6: old_references IGS_PS_ANL_LOAD%RowType;

2: /* $Header: IGSPI04B.pls 115.5 2003/02/05 10:24:07 sarakshi ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_ANL_LOAD%RowType;
7: new_references IGS_PS_ANL_LOAD%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_PS_ANL_LOAD%RowType;

3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_ANL_LOAD%RowType;
7: new_references IGS_PS_ANL_LOAD%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,
11: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 27: FROM IGS_PS_ANL_LOAD

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

Line 70: -- ON IGS_PS_ANL_LOAD

66:
67: -- Trigger description :-
68: -- "OSS_TST".trg_cal_br_iud
69: -- BEFORE INSERT OR DELETE OR UPDATE
70: -- ON IGS_PS_ANL_LOAD
71: -- FOR EACH ROW
72:
73:
74: FUNCTION validate_overlapping(p_course_cd igs_ps_anl_load.course_cd%TYPE,

Line 74: FUNCTION validate_overlapping(p_course_cd igs_ps_anl_load.course_cd%TYPE,

70: -- ON IGS_PS_ANL_LOAD
71: -- FOR EACH ROW
72:
73:
74: FUNCTION validate_overlapping(p_course_cd igs_ps_anl_load.course_cd%TYPE,
75: p_version_number igs_ps_anl_load.version_number%TYPE,
76: p_yr_num igs_ps_anl_load.yr_num%TYPE,
77: p_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
78: p_end_dt igs_ps_anl_load.effective_end_dt%TYPE,

Line 75: p_version_number igs_ps_anl_load.version_number%TYPE,

71: -- FOR EACH ROW
72:
73:
74: FUNCTION validate_overlapping(p_course_cd igs_ps_anl_load.course_cd%TYPE,
75: p_version_number igs_ps_anl_load.version_number%TYPE,
76: p_yr_num igs_ps_anl_load.yr_num%TYPE,
77: p_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
78: p_end_dt igs_ps_anl_load.effective_end_dt%TYPE,
79: p_row_id VARCHAR2)

Line 76: p_yr_num igs_ps_anl_load.yr_num%TYPE,

72:
73:
74: FUNCTION validate_overlapping(p_course_cd igs_ps_anl_load.course_cd%TYPE,
75: p_version_number igs_ps_anl_load.version_number%TYPE,
76: p_yr_num igs_ps_anl_load.yr_num%TYPE,
77: p_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
78: p_end_dt igs_ps_anl_load.effective_end_dt%TYPE,
79: p_row_id VARCHAR2)
80: RETURN BOOLEAN AS

Line 77: p_start_dt igs_ps_anl_load.effective_start_dt%TYPE,

73:
74: FUNCTION validate_overlapping(p_course_cd igs_ps_anl_load.course_cd%TYPE,
75: p_version_number igs_ps_anl_load.version_number%TYPE,
76: p_yr_num igs_ps_anl_load.yr_num%TYPE,
77: p_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
78: p_end_dt igs_ps_anl_load.effective_end_dt%TYPE,
79: p_row_id VARCHAR2)
80: RETURN BOOLEAN AS
81: /*

Line 78: p_end_dt igs_ps_anl_load.effective_end_dt%TYPE,

74: FUNCTION validate_overlapping(p_course_cd igs_ps_anl_load.course_cd%TYPE,
75: p_version_number igs_ps_anl_load.version_number%TYPE,
76: p_yr_num igs_ps_anl_load.yr_num%TYPE,
77: p_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
78: p_end_dt igs_ps_anl_load.effective_end_dt%TYPE,
79: p_row_id VARCHAR2)
80: RETURN BOOLEAN AS
81: /*
82: || Created By : sarakshi

Line 91: CURSOR cur_overlapping_u(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,

87: || Who When What
88: || (reverse chronological order - newest change first)
89: */
90:
91: CURSOR cur_overlapping_u(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,
92: cp_version_number igs_ps_anl_load.version_number%TYPE ,
93: cp_yr_num igs_ps_anl_load.yr_num%TYPE,
94: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
95: cp_row_id VARCHAR2 ) IS

Line 92: cp_version_number igs_ps_anl_load.version_number%TYPE ,

88: || (reverse chronological order - newest change first)
89: */
90:
91: CURSOR cur_overlapping_u(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,
92: cp_version_number igs_ps_anl_load.version_number%TYPE ,
93: cp_yr_num igs_ps_anl_load.yr_num%TYPE,
94: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
95: cp_row_id VARCHAR2 ) IS
96: SELECT 'X'

Line 93: cp_yr_num igs_ps_anl_load.yr_num%TYPE,

89: */
90:
91: CURSOR cur_overlapping_u(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,
92: cp_version_number igs_ps_anl_load.version_number%TYPE ,
93: cp_yr_num igs_ps_anl_load.yr_num%TYPE,
94: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
95: cp_row_id VARCHAR2 ) IS
96: SELECT 'X'
97: FROM igs_ps_anl_load

Line 94: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,

90:
91: CURSOR cur_overlapping_u(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,
92: cp_version_number igs_ps_anl_load.version_number%TYPE ,
93: cp_yr_num igs_ps_anl_load.yr_num%TYPE,
94: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
95: cp_row_id VARCHAR2 ) IS
96: SELECT 'X'
97: FROM igs_ps_anl_load
98: WHERE course_cd=cp_course_cd

Line 97: FROM igs_ps_anl_load

93: cp_yr_num igs_ps_anl_load.yr_num%TYPE,
94: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
95: cp_row_id VARCHAR2 ) IS
96: SELECT 'X'
97: FROM igs_ps_anl_load
98: WHERE course_cd=cp_course_cd
99: AND version_number=cp_version_number
100: AND yr_num = cp_yr_num
101: AND cp_start_dt >= effective_start_dt AND cp_start_dt <= NVL(effective_end_dt,cp_start_dt)

Line 104: CURSOR cur_overlapping_u1(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,

100: AND yr_num = cp_yr_num
101: AND cp_start_dt >= effective_start_dt AND cp_start_dt <= NVL(effective_end_dt,cp_start_dt)
102: AND (rowid <> cp_row_id OR (cp_row_id IS NULL));
103:
104: CURSOR cur_overlapping_u1(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,
105: cp_version_number igs_ps_anl_load.version_number%TYPE ,
106: cp_yr_num igs_ps_anl_load.yr_num%TYPE,
107: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
108: cp_end_dt igs_ps_anl_load.effective_end_dt%TYPE,

Line 105: cp_version_number igs_ps_anl_load.version_number%TYPE ,

101: AND cp_start_dt >= effective_start_dt AND cp_start_dt <= NVL(effective_end_dt,cp_start_dt)
102: AND (rowid <> cp_row_id OR (cp_row_id IS NULL));
103:
104: CURSOR cur_overlapping_u1(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,
105: cp_version_number igs_ps_anl_load.version_number%TYPE ,
106: cp_yr_num igs_ps_anl_load.yr_num%TYPE,
107: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
108: cp_end_dt igs_ps_anl_load.effective_end_dt%TYPE,
109: cp_row_id VARCHAR2 ) IS

Line 106: cp_yr_num igs_ps_anl_load.yr_num%TYPE,

102: AND (rowid <> cp_row_id OR (cp_row_id IS NULL));
103:
104: CURSOR cur_overlapping_u1(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,
105: cp_version_number igs_ps_anl_load.version_number%TYPE ,
106: cp_yr_num igs_ps_anl_load.yr_num%TYPE,
107: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
108: cp_end_dt igs_ps_anl_load.effective_end_dt%TYPE,
109: cp_row_id VARCHAR2 ) IS
110: SELECT 'X'

Line 107: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,

103:
104: CURSOR cur_overlapping_u1(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,
105: cp_version_number igs_ps_anl_load.version_number%TYPE ,
106: cp_yr_num igs_ps_anl_load.yr_num%TYPE,
107: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
108: cp_end_dt igs_ps_anl_load.effective_end_dt%TYPE,
109: cp_row_id VARCHAR2 ) IS
110: SELECT 'X'
111: FROM igs_ps_anl_load

Line 108: cp_end_dt igs_ps_anl_load.effective_end_dt%TYPE,

104: CURSOR cur_overlapping_u1(cp_course_cd igs_ps_anl_load.course_cd%TYPE ,
105: cp_version_number igs_ps_anl_load.version_number%TYPE ,
106: cp_yr_num igs_ps_anl_load.yr_num%TYPE,
107: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
108: cp_end_dt igs_ps_anl_load.effective_end_dt%TYPE,
109: cp_row_id VARCHAR2 ) IS
110: SELECT 'X'
111: FROM igs_ps_anl_load
112: WHERE course_cd=cp_course_cd

Line 111: FROM igs_ps_anl_load

107: cp_start_dt igs_ps_anl_load.effective_start_dt%TYPE,
108: cp_end_dt igs_ps_anl_load.effective_end_dt%TYPE,
109: cp_row_id VARCHAR2 ) IS
110: SELECT 'X'
111: FROM igs_ps_anl_load
112: WHERE course_cd=cp_course_cd
113: AND version_number=cp_version_number
114: AND yr_num = cp_yr_num
115: AND (cp_end_dt >= effective_start_dt OR (cp_end_dt IS NULL)) AND cp_start_dt <= effective_start_dt

Line 152: v_course_cd IGS_PS_ANL_LOAD.course_cd%TYPE;

148: p_updating IN BOOLEAN DEFAULT FALSE,
149: p_deleting IN BOOLEAN DEFAULT FALSE
150: ) AS
151: v_message_name varchar2(30);
152: v_course_cd IGS_PS_ANL_LOAD.course_cd%TYPE;
153: v_version_number IGS_PS_ANL_LOAD.version_number%TYPE;
154: BEGIN
155: -- Set variables.
156: IF p_deleting THEN

Line 153: v_version_number IGS_PS_ANL_LOAD.version_number%TYPE;

149: p_deleting IN BOOLEAN DEFAULT FALSE
150: ) AS
151: v_message_name varchar2(30);
152: v_course_cd IGS_PS_ANL_LOAD.course_cd%TYPE;
153: v_version_number IGS_PS_ANL_LOAD.version_number%TYPE;
154: BEGIN
155: -- Set variables.
156: IF p_deleting THEN
157: v_course_cd := old_references.course_cd;

Line 196: -- ON IGS_PS_ANL_LOAD

192:
193: -- Trigger description :-
194: -- "OSS_TST".trg_cal_ar_iu
195: -- AFTER INSERT OR UPDATE
196: -- ON IGS_PS_ANL_LOAD
197: -- FOR EACH ROW
198:
199: PROCEDURE AfterRowInsertUpdate2(
200: p_inserting IN BOOLEAN DEFAULT FALSE,

Line 294: IGS_PS_ANL_LOAD_U_LN_PKG.GET_FK_IGS_PS_ANL_LOAD (

290:
291: PROCEDURE Check_Child_Existance AS
292: BEGIN
293:
294: IGS_PS_ANL_LOAD_U_LN_PKG.GET_FK_IGS_PS_ANL_LOAD (
295: old_references.course_cd,
296: old_references.version_number,
297: old_references.yr_num,
298: old_references.effective_start_dt

Line 313: FROM IGS_PS_ANL_LOAD

309: RETURN BOOLEAN AS
310:
311: CURSOR cur_rowid IS
312: SELECT rowid
313: FROM IGS_PS_ANL_LOAD
314: WHERE course_cd = x_course_cd
315: AND version_number = x_version_number
316: AND yr_num = x_yr_num
317: AND effective_start_dt = x_effective_start_dt

Line 343: FROM IGS_PS_ANL_LOAD

339: ) AS
340:
341: CURSOR cur_rowid IS
342: SELECT rowid
343: FROM IGS_PS_ANL_LOAD
344: WHERE course_cd = x_course_cd
345: AND version_number = x_version_number ;
346:
347: lv_rowid cur_rowid%RowType;

Line 470: cursor C is select ROWID from IGS_PS_ANL_LOAD

466: X_EFFECTIVE_END_DT in DATE,
467: X_ANNUAL_LOAD_VAL in NUMBER,
468: X_MODE in VARCHAR2 default 'R'
469: ) AS
470: cursor C is select ROWID from IGS_PS_ANL_LOAD
471: where VERSION_NUMBER = X_VERSION_NUMBER
472: and COURSE_CD = X_COURSE_CD
473: and YR_NUM = X_YR_NUM
474: and EFFECTIVE_START_DT = X_EFFECTIVE_START_DT;

Line 514: insert into IGS_PS_ANL_LOAD (

510: x_last_updated_by => X_LAST_UPDATED_BY ,
511: x_last_update_login => X_LAST_UPDATE_LOGIN
512: );
513:
514: insert into IGS_PS_ANL_LOAD (
515: VERSION_NUMBER,
516: COURSE_CD,
517: YR_NUM,
518: EFFECTIVE_START_DT,

Line 567: from IGS_PS_ANL_LOAD

563: ) AS
564: cursor c1 is select
565: EFFECTIVE_END_DT,
566: ANNUAL_LOAD_VAL
567: from IGS_PS_ANL_LOAD
568: where ROWID = X_ROWID
569: for update nowait;
570: tlinfo c1%rowtype;
571:

Line 647: update IGS_PS_ANL_LOAD set

643: x_last_updated_by => X_LAST_UPDATED_BY ,
644: x_last_update_login => X_LAST_UPDATE_LOGIN
645: );
646:
647: update IGS_PS_ANL_LOAD set
648: EFFECTIVE_END_DT = NEW_REFERENCES.EFFECTIVE_END_DT,
649: ANNUAL_LOAD_VAL = NEW_REFERENCES.ANNUAL_LOAD_VAL,
650: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
651: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 676: cursor c1 is select rowid from IGS_PS_ANL_LOAD

672: X_EFFECTIVE_END_DT in DATE,
673: X_ANNUAL_LOAD_VAL in NUMBER,
674: X_MODE in VARCHAR2 default 'R'
675: ) AS
676: cursor c1 is select rowid from IGS_PS_ANL_LOAD
677: where VERSION_NUMBER = X_VERSION_NUMBER
678: and COURSE_CD = X_COURSE_CD
679: and YR_NUM = X_YR_NUM
680: and EFFECTIVE_START_DT = X_EFFECTIVE_START_DT

Line 719: delete from IGS_PS_ANL_LOAD

715: p_action => 'DELETE',
716: x_rowid => X_ROWID
717: );
718:
719: delete from IGS_PS_ANL_LOAD
720: where ROWID = X_ROWID;
721: if (sql%notfound) then
722: raise no_data_found;
723: end if;

Line 732: end IGS_PS_ANL_LOAD_PKG;

728: );
729:
730: end DELETE_ROW;
731:
732: end IGS_PS_ANL_LOAD_PKG;