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_VALIDATE_LGCY_PKG dependencies on IGS_PS_GENERIC_PUB

Line 29: PROCEDURE unit_version(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,

25: As a part of Bug # 2721495
26: ********************************************************************************************** */
27:
28: -- This function does validations before inserting Unit Version Records
29: PROCEDURE unit_version(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,
30: p_coord_person_id IN igs_ps_unit_ver_all.coord_person_id%TYPE);
31:
32: -- This function does validations after inserting Teaching Responsibility Records
33: FUNCTION post_teach_resp ( p_tab_teach_resp IN OUT NOCOPY igs_ps_generic_pub.unit_tr_tbl_type ) RETURN BOOLEAN;

Line 33: FUNCTION post_teach_resp ( p_tab_teach_resp IN OUT NOCOPY igs_ps_generic_pub.unit_tr_tbl_type ) RETURN BOOLEAN;

29: PROCEDURE unit_version(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,
30: p_coord_person_id IN igs_ps_unit_ver_all.coord_person_id%TYPE);
31:
32: -- This function does validations after inserting Teaching Responsibility Records
33: FUNCTION post_teach_resp ( p_tab_teach_resp IN OUT NOCOPY igs_ps_generic_pub.unit_tr_tbl_type ) RETURN BOOLEAN;
34:
35: -- This function does validations after inserting Unit Discipline Records
36: FUNCTION post_unit_discip ( p_tab_unit_dscp IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_tbl_type ) RETURN BOOLEAN;
37:

Line 36: FUNCTION post_unit_discip ( p_tab_unit_dscp IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_tbl_type ) RETURN BOOLEAN;

32: -- This function does validations after inserting Teaching Responsibility Records
33: FUNCTION post_teach_resp ( p_tab_teach_resp IN OUT NOCOPY igs_ps_generic_pub.unit_tr_tbl_type ) RETURN BOOLEAN;
34:
35: -- This function does validations after inserting Unit Discipline Records
36: FUNCTION post_unit_discip ( p_tab_unit_dscp IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_tbl_type ) RETURN BOOLEAN;
37:
38: -- This procedure validates before inserting Unit Grading Schema records
39: PROCEDURE validate_unit_grd_sch ( p_unit_gs_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type );
40:

Line 39: PROCEDURE validate_unit_grd_sch ( p_unit_gs_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type );

35: -- This function does validations after inserting Unit Discipline Records
36: FUNCTION post_unit_discip ( p_tab_unit_dscp IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_tbl_type ) RETURN BOOLEAN;
37:
38: -- This procedure validates before inserting Unit Grading Schema records
39: PROCEDURE validate_unit_grd_sch ( p_unit_gs_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type );
40:
41: -- This function does validations after inserting Unit Grading Schema Records
42: FUNCTION post_unit_grd_sch ( p_tab_grd_sch IN OUT NOCOPY igs_ps_generic_pub.unit_gs_tbl_type ) RETURN BOOLEAN;
43:

Line 42: FUNCTION post_unit_grd_sch ( p_tab_grd_sch IN OUT NOCOPY igs_ps_generic_pub.unit_gs_tbl_type ) RETURN BOOLEAN;

38: -- This procedure validates before inserting Unit Grading Schema records
39: PROCEDURE validate_unit_grd_sch ( p_unit_gs_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type );
40:
41: -- This function does validations after inserting Unit Grading Schema Records
42: FUNCTION post_unit_grd_sch ( p_tab_grd_sch IN OUT NOCOPY igs_ps_generic_pub.unit_gs_tbl_type ) RETURN BOOLEAN;
43:
44: -- Validate Unit Offer Option Records before inserting them
45: PROCEDURE validate_uoo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
46: p_c_cal_type IN igs_ca_type.cal_type%TYPE,

Line 45: PROCEDURE validate_uoo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,

41: -- This function does validations after inserting Unit Grading Schema Records
42: FUNCTION post_unit_grd_sch ( p_tab_grd_sch IN OUT NOCOPY igs_ps_generic_pub.unit_gs_tbl_type ) RETURN BOOLEAN;
43:
44: -- Validate Unit Offer Option Records before inserting them
45: PROCEDURE validate_uoo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
46: p_c_cal_type IN igs_ca_type.cal_type%TYPE,
47: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
48: p_n_sup_uoo_id IN OUT NOCOPY igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE,
49: p_insert_update VARCHAR2,

Line 53: PROCEDURE validate_cps ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,

49: p_insert_update VARCHAR2,
50: p_conc_flag OUT NOCOPY BOOLEAN);
51:
52: -- Validate Unit Section Credit Points Records before inserting them
53: PROCEDURE validate_cps ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
54: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
55: p_insert_update VARCHAR2) ;
56:
57: -- Validate Unit Section Referece Records before inserting them

Line 58: PROCEDURE validate_ref ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,

54: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
55: p_insert_update VARCHAR2) ;
56:
57: -- Validate Unit Section Referece Records before inserting them
58: PROCEDURE validate_ref ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
59: p_n_subtitle_id OUT NOCOPY igs_ps_unit_subtitle.subtitle_id%TYPE,
60: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
61: p_insert_update VARCHAR2);
62:

Line 64: PROCEDURE validate_usec_grd_sch ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type,

60: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
61: p_insert_update VARCHAR2);
62:
63: -- This procedure validates before inserting Unit Section Grading Schema records
64: PROCEDURE validate_usec_grd_sch ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type,
65: p_n_uoo_id IN NUMBER);
66:
67: -- This function does validations after inserting Unit Section Grading Schema Records
68: FUNCTION post_usec_grd_sch ( p_tab_usec_gs IN OUT NOCOPY igs_ps_generic_pub.usec_gs_tbl_type,

Line 68: FUNCTION post_usec_grd_sch ( p_tab_usec_gs IN OUT NOCOPY igs_ps_generic_pub.usec_gs_tbl_type,

64: PROCEDURE validate_usec_grd_sch ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type,
65: p_n_uoo_id IN NUMBER);
66:
67: -- This function does validations after inserting Unit Section Grading Schema Records
68: FUNCTION post_usec_grd_sch ( p_tab_usec_gs IN OUT NOCOPY igs_ps_generic_pub.usec_gs_tbl_type,
69: p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN ;
70:
71: -- This procedure validates before inserting records of Unit Section Occurrence.
72: PROCEDURE validate_usec_occurs ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,

Line 72: PROCEDURE validate_usec_occurs ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,

68: FUNCTION post_usec_grd_sch ( p_tab_usec_gs IN OUT NOCOPY igs_ps_generic_pub.usec_gs_tbl_type,
69: p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN ;
70:
71: -- This procedure validates before inserting records of Unit Section Occurrence.
72: PROCEDURE validate_usec_occurs ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,
73: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
74: p_d_start_date IN igs_ca_inst_all.start_dt%TYPE,
75: p_d_end_date IN igs_ca_inst_all.end_dt%TYPE,
76: p_n_building_code IN NUMBER,

Line 90: PROCEDURE validate_unit_reference(p_unit_ref_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type,

86: p_schedule_status IN OUT NOCOPY VARCHAR2
87: );
88:
89: -- This procedure does the business validation for Unit / Unit Section / Unit Section Occurrence reference codes.
90: PROCEDURE validate_unit_reference(p_unit_ref_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type,
91: p_n_uoo_id IN NUMBER,
92: p_n_uso_id IN NUMBER,
93: p_calling_context IN VARCHAR2);
94:

Line 138: PROCEDURE validate_usec_el(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,

134:
135: PROCEDURE get_party_id(p_c_person_number IN hz_parties.party_number%TYPE,
136: p_n_person_id OUT NOCOPY hz_parties.party_id%TYPE) ;
137: --
138: PROCEDURE validate_usec_el(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
139: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
140: p_insert_update VARCHAR2);
141:
142: PROCEDURE post_usec_limits(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,

Line 142: PROCEDURE post_usec_limits(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,

138: PROCEDURE validate_usec_el(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
139: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
140: p_insert_update VARCHAR2);
141:
142: PROCEDURE post_usec_limits(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
143: p_calling_context IN VARCHAR2,
144: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
145: p_insert_update VARCHAR2);
146:

Line 150: p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type,

146:
147: -- Procedure to do the post unit section occurrence instructor validation.
148: PROCEDURE post_uso_ins( p_n_ins_id IN igs_ps_uso_instrctrs.instructor_id%TYPE,
149: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
150: p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type,
151: p_n_index IN NUMBER);
152:
153: -- Procedure to do validate the unit section section teaching responsibility record after importing unit section occurrence instructors.
154: FUNCTION post_uso_ins_busi( p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type) RETURN BOOLEAN;

Line 154: FUNCTION post_uso_ins_busi( p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type) RETURN BOOLEAN;

150: p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type,
151: p_n_index IN NUMBER);
152:
153: -- Procedure to do validate the unit section section teaching responsibility record after importing unit section occurrence instructors.
154: FUNCTION post_uso_ins_busi( p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type) RETURN BOOLEAN;
155:
156: -- This Function will returns true if waitlist is allowed otherwise false.
157: FUNCTION is_waitlist_allowed RETURN BOOLEAN;
158: