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_TYPE_PKG dependencies on IGS_PS_TYPE_ALL

Line 6: old_references IGS_PS_TYPE_ALL%RowType;

2: /* $Header: IGSPI36B.pls 115.16 2003/06/05 12:54:01 sarakshi ship $ */
3:
4:
5: l_rowid VARCHAR2(25);
6: old_references IGS_PS_TYPE_ALL%RowType;
7: new_references IGS_PS_TYPE_ALL%RowType;
8:
9: PROCEDURE Set_Column_Values (
10: p_action IN VARCHAR2,

Line 7: new_references IGS_PS_TYPE_ALL%RowType;

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

Line 33: FROM IGS_PS_TYPE_ALL

29: ) AS
30:
31: CURSOR cur_old_ref_values IS
32: SELECT *
33: FROM IGS_PS_TYPE_ALL
34: WHERE rowid = x_rowid;
35:
36: BEGIN
37:

Line 83: v_description IGS_PS_TYPE_ALL.description%TYPE;

79: p_inserting IN BOOLEAN ,
80: p_updating IN BOOLEAN
81: ) AS
82: v_message_name VARCHAR2(30);
83: v_description IGS_PS_TYPE_ALL.description%TYPE;
84: v_govt_course_type IGS_PS_TYPE_ALL.govt_course_type%TYPE;
85: v_course_type_group_cd IGS_PS_TYPE_ALL.course_type_group_cd%TYPE;
86: v_tac_course_level IGS_PS_TYPE_ALL.tac_course_level%TYPE;
87: v_closed_ind IGS_PS_TYPE_ALL.closed_ind%TYPE;

Line 84: v_govt_course_type IGS_PS_TYPE_ALL.govt_course_type%TYPE;

80: p_updating IN BOOLEAN
81: ) AS
82: v_message_name VARCHAR2(30);
83: v_description IGS_PS_TYPE_ALL.description%TYPE;
84: v_govt_course_type IGS_PS_TYPE_ALL.govt_course_type%TYPE;
85: v_course_type_group_cd IGS_PS_TYPE_ALL.course_type_group_cd%TYPE;
86: v_tac_course_level IGS_PS_TYPE_ALL.tac_course_level%TYPE;
87: v_closed_ind IGS_PS_TYPE_ALL.closed_ind%TYPE;
88: v_award_course_ind IGS_PS_TYPE_ALL.award_course_ind%TYPE;

Line 85: v_course_type_group_cd IGS_PS_TYPE_ALL.course_type_group_cd%TYPE;

81: ) AS
82: v_message_name VARCHAR2(30);
83: v_description IGS_PS_TYPE_ALL.description%TYPE;
84: v_govt_course_type IGS_PS_TYPE_ALL.govt_course_type%TYPE;
85: v_course_type_group_cd IGS_PS_TYPE_ALL.course_type_group_cd%TYPE;
86: v_tac_course_level IGS_PS_TYPE_ALL.tac_course_level%TYPE;
87: v_closed_ind IGS_PS_TYPE_ALL.closed_ind%TYPE;
88: v_award_course_ind IGS_PS_TYPE_ALL.award_course_ind%TYPE;
89: v_research_type_ind IGS_PS_TYPE_ALL.research_type_ind%TYPE;

Line 86: v_tac_course_level IGS_PS_TYPE_ALL.tac_course_level%TYPE;

82: v_message_name VARCHAR2(30);
83: v_description IGS_PS_TYPE_ALL.description%TYPE;
84: v_govt_course_type IGS_PS_TYPE_ALL.govt_course_type%TYPE;
85: v_course_type_group_cd IGS_PS_TYPE_ALL.course_type_group_cd%TYPE;
86: v_tac_course_level IGS_PS_TYPE_ALL.tac_course_level%TYPE;
87: v_closed_ind IGS_PS_TYPE_ALL.closed_ind%TYPE;
88: v_award_course_ind IGS_PS_TYPE_ALL.award_course_ind%TYPE;
89: v_research_type_ind IGS_PS_TYPE_ALL.research_type_ind%TYPE;
90: v_primary_auto_select IGS_PS_TYPE_ALL.primary_auto_select%TYPE;

Line 87: v_closed_ind IGS_PS_TYPE_ALL.closed_ind%TYPE;

83: v_description IGS_PS_TYPE_ALL.description%TYPE;
84: v_govt_course_type IGS_PS_TYPE_ALL.govt_course_type%TYPE;
85: v_course_type_group_cd IGS_PS_TYPE_ALL.course_type_group_cd%TYPE;
86: v_tac_course_level IGS_PS_TYPE_ALL.tac_course_level%TYPE;
87: v_closed_ind IGS_PS_TYPE_ALL.closed_ind%TYPE;
88: v_award_course_ind IGS_PS_TYPE_ALL.award_course_ind%TYPE;
89: v_research_type_ind IGS_PS_TYPE_ALL.research_type_ind%TYPE;
90: v_primary_auto_select IGS_PS_TYPE_ALL.primary_auto_select%TYPE;
91: v_enrolment_cat IGS_PS_TYPE_ALL.enrolment_cat%TYPE;

Line 88: v_award_course_ind IGS_PS_TYPE_ALL.award_course_ind%TYPE;

84: v_govt_course_type IGS_PS_TYPE_ALL.govt_course_type%TYPE;
85: v_course_type_group_cd IGS_PS_TYPE_ALL.course_type_group_cd%TYPE;
86: v_tac_course_level IGS_PS_TYPE_ALL.tac_course_level%TYPE;
87: v_closed_ind IGS_PS_TYPE_ALL.closed_ind%TYPE;
88: v_award_course_ind IGS_PS_TYPE_ALL.award_course_ind%TYPE;
89: v_research_type_ind IGS_PS_TYPE_ALL.research_type_ind%TYPE;
90: v_primary_auto_select IGS_PS_TYPE_ALL.primary_auto_select%TYPE;
91: v_enrolment_cat IGS_PS_TYPE_ALL.enrolment_cat%TYPE;
92: x_rowid VARCHAR2(25);

Line 89: v_research_type_ind IGS_PS_TYPE_ALL.research_type_ind%TYPE;

85: v_course_type_group_cd IGS_PS_TYPE_ALL.course_type_group_cd%TYPE;
86: v_tac_course_level IGS_PS_TYPE_ALL.tac_course_level%TYPE;
87: v_closed_ind IGS_PS_TYPE_ALL.closed_ind%TYPE;
88: v_award_course_ind IGS_PS_TYPE_ALL.award_course_ind%TYPE;
89: v_research_type_ind IGS_PS_TYPE_ALL.research_type_ind%TYPE;
90: v_primary_auto_select IGS_PS_TYPE_ALL.primary_auto_select%TYPE;
91: v_enrolment_cat IGS_PS_TYPE_ALL.enrolment_cat%TYPE;
92: x_rowid VARCHAR2(25);
93:

Line 90: v_primary_auto_select IGS_PS_TYPE_ALL.primary_auto_select%TYPE;

86: v_tac_course_level IGS_PS_TYPE_ALL.tac_course_level%TYPE;
87: v_closed_ind IGS_PS_TYPE_ALL.closed_ind%TYPE;
88: v_award_course_ind IGS_PS_TYPE_ALL.award_course_ind%TYPE;
89: v_research_type_ind IGS_PS_TYPE_ALL.research_type_ind%TYPE;
90: v_primary_auto_select IGS_PS_TYPE_ALL.primary_auto_select%TYPE;
91: v_enrolment_cat IGS_PS_TYPE_ALL.enrolment_cat%TYPE;
92: x_rowid VARCHAR2(25);
93:
94: CURSOR SPTH_CUR IS SELECT Rowid

Line 91: v_enrolment_cat IGS_PS_TYPE_ALL.enrolment_cat%TYPE;

87: v_closed_ind IGS_PS_TYPE_ALL.closed_ind%TYPE;
88: v_award_course_ind IGS_PS_TYPE_ALL.award_course_ind%TYPE;
89: v_research_type_ind IGS_PS_TYPE_ALL.research_type_ind%TYPE;
90: v_primary_auto_select IGS_PS_TYPE_ALL.primary_auto_select%TYPE;
91: v_enrolment_cat IGS_PS_TYPE_ALL.enrolment_cat%TYPE;
92: x_rowid VARCHAR2(25);
93:
94: CURSOR SPTH_CUR IS SELECT Rowid
95: FROM IGS_PS_TYPE_HIST_ALL

Line 353: FROM IGS_PS_TYPE_ALL

349: ) RETURN BOOLEAN AS
350:
351: CURSOR cur_rowid IS
352: SELECT rowid
353: FROM IGS_PS_TYPE_ALL
354: WHERE course_type = x_course_type;
355:
356: lv_rowid cur_rowid%RowType;
357:

Line 378: FROM IGS_PS_TYPE_ALL

374: ) AS
375:
376: CURSOR cur_rowid IS
377: SELECT rowid
378: FROM IGS_PS_TYPE_ALL
379: WHERE course_type_group_cd = x_course_type_group_cd ;
380:
381: lv_rowid cur_rowid%RowType;
382:

Line 404: FROM IGS_PS_TYPE_ALL

400: ) AS
401:
402: CURSOR cur_rowid IS
403: SELECT rowid
404: FROM IGS_PS_TYPE_ALL
405: WHERE govt_course_type = x_govt_course_type ;
406:
407: lv_rowid cur_rowid%RowType;
408:

Line 429: FROM IGS_PS_TYPE_ALL

425: x_enrolment_cat IN VARCHAR2) AS
426:
427: CURSOR cur_rowid IS
428: SELECT rowid
429: FROM IGS_PS_TYPE_ALL
430: WHERE enrolment_cat = x_enrolment_cat ;
431:
432: lv_rowid cur_rowid%RowType;
433:

Line 555: cursor C is select ROWID from IGS_PS_TYPE_ALL

551: X_PRIMARY_AUTO_SELECT IN VARCHAR2 ,
552: X_FIN_AID_PROGRAM_TYPE IN VARCHAR2 ,
553: X_ENROLMENT_CAT in VARCHAR2
554: ) AS
555: cursor C is select ROWID from IGS_PS_TYPE_ALL
556: where COURSE_TYPE = X_COURSE_TYPE;
557: X_LAST_UPDATE_DATE DATE;
558: X_LAST_UPDATED_BY NUMBER;
559: X_LAST_UPDATE_LOGIN NUMBER;

Line 599: insert into IGS_PS_TYPE_ALL (

595: x_primary_auto_select => X_PRIMARY_AUTO_SELECT,
596: x_fin_aid_program_type=>X_FIN_AID_PROGRAM_TYPE,
597: x_enrolment_cat => X_ENROLMENT_CAT
598: );
599: insert into IGS_PS_TYPE_ALL (
600: COURSE_TYPE,
601: DESCRIPTION,
602: GOVT_COURSE_TYPE,
603: AWARD_COURSE_IND,

Line 677: from IGS_PS_TYPE_ALL

673: CLOSED_IND,
674: PRIMARY_AUTO_SELECT,
675: FIN_AID_PROGRAM_TYPE,
676: ENROLMENT_CAT
677: from IGS_PS_TYPE_ALL
678: where ROWID = X_ROWID for update nowait;
679: tlinfo c1%rowtype;
680:
681: begin

Line 778: update IGS_PS_TYPE_ALL set

774: x_primary_auto_select => X_PRIMARY_AUTO_SELECT,
775: x_fin_aid_program_type=> X_FIN_AID_PROGRAM_TYPE,
776: x_enrolment_cat => X_ENROLMENT_CAT
777: );
778: update IGS_PS_TYPE_ALL set
779: DESCRIPTION = NEW_REFERENCES.DESCRIPTION,
780: GOVT_COURSE_TYPE = NEW_REFERENCES.GOVT_COURSE_TYPE,
781: AWARD_COURSE_IND = NEW_REFERENCES.AWARD_COURSE_IND,
782: COURSE_TYPE_GROUP_CD = NEW_REFERENCES.COURSE_TYPE_GROUP_CD,

Line 821: cursor c1 is select rowid from IGS_PS_TYPE_ALL

817: X_PRIMARY_AUTO_SELECT in VARCHAR2,
818: X_FIN_AID_PROGRAM_TYPE IN VARCHAR2,
819: X_ENROLMENT_CAT in VARCHAR2
820: ) AS
821: cursor c1 is select rowid from IGS_PS_TYPE_ALL
822: where COURSE_TYPE = X_COURSE_TYPE
823: ;
824: begin
825: open c1;