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

Line 19: PROCEDURE validate_usec_notes(p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type,

15: g_n_user_id igs_ps_unit_ver_all.created_by%TYPE := NVL(fnd_global.user_id,-1);
16: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1);
17:
18:
19: PROCEDURE validate_usec_notes(p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type,
20: p_n_uoo_id IN NUMBER)
21: AS
22: /***********************************************************************************************
23: Created By : Sommukhe

Line 50: PROCEDURE validate_usec_assmnt ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type,

46:
47: END validate_usec_notes;
48:
49:
50: PROCEDURE validate_usec_assmnt ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type,
51: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
52: p_d_exam_start_time igs_ps_usec_as.exam_start_time%TYPE,
53: p_d_exam_end_time igs_ps_usec_as.exam_end_time%TYPE,
54: p_n_building_id NUMBER,

Line 157: PROCEDURE validate_tch_rsp_ovrd ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type,

153:
154: END validate_usec_assmnt;
155:
156:
157: PROCEDURE validate_tch_rsp_ovrd ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type,
158: p_n_uoo_id IN NUMBER)
159: AS
160: /***********************************************************************************************
161: Created By : sommukhe

Line 193: PROCEDURE validate_as_us_ai_group (p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,

189: END IF;
190: END validate_tch_rsp_ovrd;
191:
192: ---validations before inserting/updating Unit Section Assessment item group records
193: PROCEDURE validate_as_us_ai_group (p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,
194: p_n_uoo_id NUMBER)
195: AS
196: /***********************************************************************************************
197: Created By : sommukhe

Line 312: PROCEDURE validate_unitass_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,

308:
309: END validate_as_us_ai_group;
310:
311: -- validations before inserting/updating Unit Section Assessment item records
312: PROCEDURE validate_unitass_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,
313: p_cal_type IN VARCHAR2,
314: p_ci_sequence_number NUMBER,
315: p_n_uoo_id NUMBER,
316: p_insert VARCHAR2)

Line 610: PROCEDURE validate_uso_clas_meet ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,

606:
607: END validate_unitass_item;
608:
609:
610: PROCEDURE validate_uso_clas_meet ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,
611: p_n_uoo_id NUMBER,
612: p_n_class_meet_group_id NUMBER,
613: p_c_cal_type VARCHAR2,
614: p_n_seq_num NUMBER)

Line 851: FUNCTION post_usec_meet_with(p_tab_usec_meet_with IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_tbl_type,

847: x_abort_flag => l_cur_usec.abort_flag
848: );
849: END update_usec_status;
850:
851: FUNCTION post_usec_meet_with(p_tab_usec_meet_with IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_tbl_type,
852: p_class_meet_tab IN igs_ps_create_generic_pkg.class_meet_rec_tbl_type) RETURN BOOLEAN
853: AS
854: /***********************************************************************************************
855: Created By : sommukhe

Line 1093: PROCEDURE validate_uso_cm_grp ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,

1089:
1090: END post_usec_meet_with;
1091:
1092:
1093: PROCEDURE validate_uso_cm_grp ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,
1094: p_c_cal_type VARCHAR2,
1095: p_n_seq_num NUMBER,
1096: p_insert_update VARCHAR2,
1097: p_class_meet_rec IN OUT NOCOPY igs_ps_create_generic_pkg.class_meet_rec_type )

Line 1225: PROCEDURE validate_usec_x_grpmem ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,

1221: END validate_uso_cm_grp;
1222:
1223:
1224: --Validations of crosslisted unit sections
1225: PROCEDURE validate_usec_x_grpmem ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,
1226: p_n_uoo_id NUMBER,
1227: p_n_usec_x_listed_group_id NUMBER,
1228: p_c_cal_type VARCHAR2,
1229: p_n_seq_num NUMBER)

Line 1406: FUNCTION post_usec_cross_group(p_tab_usec_cross_group IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_tbl_type,

1402:
1403: END validate_usec_x_grpmem;
1404:
1405:
1406: FUNCTION post_usec_cross_group(p_tab_usec_cross_group IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_tbl_type,
1407: p_cross_group_tab IN igs_ps_create_generic_pkg.cross_group_rec_tbl_type) RETURN BOOLEAN
1408: AS
1409: /***********************************************************************************************
1410: Created By : sommukhe

Line 1661: PROCEDURE validate_usec_x_grp ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,

1657: END post_usec_cross_group;
1658:
1659:
1660:
1661: PROCEDURE validate_usec_x_grp ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,
1662: p_c_cal_type VARCHAR2,
1663: p_n_seq_num NUMBER,
1664: p_insert_update VARCHAR2,
1665: p_cross_group_rec IN OUT NOCOPY igs_ps_create_generic_pkg.cross_group_rec_type )

Line 1793: FUNCTION post_as_us_ai ( p_tab_as_us_ai IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_tbl_type,

1789:
1790: END validate_usec_x_grp;
1791:
1792:
1793: FUNCTION post_as_us_ai ( p_tab_as_us_ai IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_tbl_type,
1794: p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN
1795: AS
1796: /***********************************************************************************************
1797: Created By : sommukhe

Line 1823: CURSOR cur_group (cp_rec_as_us_ai igs_ps_generic_pub.usec_ass_item_grp_rec_type) IS

1819: FROM igs_ps_unitass_item
1820: WHERE us_ass_item_group_id = cp_us_ass_item_group_id
1821: AND logical_delete_dt IS NULL;
1822:
1823: CURSOR cur_group (cp_rec_as_us_ai igs_ps_generic_pub.usec_ass_item_grp_rec_type) IS
1824: SELECT a.us_ass_item_group_id
1825: FROM igs_as_us_ai_group a, igs_ps_unit_ofr_opt_all b, igs_ca_inst_all c
1826: WHERE a.group_name = cp_rec_as_us_ai.group_name
1827: AND a.uoo_id =b.uoo_id

Line 1935: FUNCTION post_tch_rsp_ovrd ( p_tab_tch_rsp_ovrd IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_tbl_type,

1931:
1932: END post_as_us_ai;
1933:
1934:
1935: FUNCTION post_tch_rsp_ovrd ( p_tab_tch_rsp_ovrd IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_tbl_type,
1936: p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN
1937: AS
1938: /***********************************************************************************************
1939: Created By : sommukhe

Line 1954: CURSOR c_uoo_id (cp_usec_tch_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type) IS

1950: FROM igs_ps_tch_resp_ovrd_all
1951: WHERE uoo_id=cp_uoo_id;
1952: c_tro_perc_sum_rec c_tro_perc_sum%ROWTYPE;
1953:
1954: CURSOR c_uoo_id (cp_usec_tch_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type) IS
1955: SELECT uoo_id
1956: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
1957: WHERE a.unit_cd = cp_usec_tch_resp_rec.unit_cd
1958: AND a.version_number = cp_usec_tch_resp_rec.version_number

Line 2001: FUNCTION post_usec_rsv ( p_tab_usec_rsv IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_tbl_type,

1997:
1998: END post_tch_rsp_ovrd;
1999:
2000:
2001: FUNCTION post_usec_rsv ( p_tab_usec_rsv IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_tbl_type,
2002: p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN
2003: AS
2004: /***********************************************************************************************
2005: Created By : sommukhe

Line 2043: CURSOR c_uoo_id (cp_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type) IS

2039: WHERE rsv_usec_pri_id = cp_rsv_usec_pri_id
2040: ORDER BY preference_order;
2041: l_c_usec_rsvprfc_ser c_usec_rsvprfc_ser%ROWTYPE;
2042:
2043: CURSOR c_uoo_id (cp_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type) IS
2044: SELECT uoo_id
2045: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
2046: WHERE a.unit_cd = cp_usec_rsv_rec.unit_cd
2047: AND a.version_number = cp_usec_rsv_rec.version_number

Line 2183: FUNCTION post_usec_wlst ( p_tab_usec_wlst IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_tbl_type,

2179:
2180:
2181:
2182: --post insert/update validations for Unit section Waitlist
2183: FUNCTION post_usec_wlst ( p_tab_usec_wlst IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_tbl_type,
2184: p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN
2185: AS
2186: /***********************************************************************************************
2187: Created By : sommukhe

Line 2217: CURSOR c_uoo_id (cp_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type) IS

2213: WHERE unit_sec_waitlist_priority_id = cp_waitlist_priority_id
2214: ORDER BY preference_order;
2215: l_c_usec_wlstprfc_ser c_usec_wlstprfc_ser%ROWTYPE;
2216:
2217: CURSOR c_uoo_id (cp_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type) IS
2218: SELECT uoo_id
2219: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
2220: WHERE a.unit_cd = cp_usec_wlst_rec.unit_cd
2221: AND a.version_number = cp_usec_wlst_rec.version_number

Line 2332: PROCEDURE validate_facility (p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type,

2328:
2329:
2330: -- Validate Unit Section Occurence Facility Records before inserting them
2331:
2332: PROCEDURE validate_facility (p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type,
2333: p_n_uoo_id IN NUMBER,
2334: p_uso_id IN NUMBER,
2335: p_calling_context IN VARCHAR2)
2336: AS

Line 2410: PROCEDURE validate_category (p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type,

2406:
2407:
2408: END validate_facility;
2409:
2410: PROCEDURE validate_category (p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type,
2411: p_n_uoo_id IN NUMBER)
2412: AS
2413: /***********************************************************************************************
2414: Created By : SOMMUKHE

Line 2449: PROCEDURE validate_usec_rsvpri(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,

2445: CLOSE c_category;
2446:
2447: END validate_category;
2448:
2449: PROCEDURE validate_usec_rsvpri(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,
2450: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
2451: p_insert_update IN VARCHAR2)
2452: AS
2453: /***********************************************************************************************

Line 2504: PROCEDURE validate_usec_rsvprf(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,

2500: END IF;
2501:
2502: END validate_usec_rsvpri;
2503:
2504: PROCEDURE validate_usec_rsvprf(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,
2505: p_insert_update IN VARCHAR2)
2506: AS
2507: /***********************************************************************************************
2508: Created By : Sommukhe

Line 2653: PROCEDURE validate_usec_wlstprf(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,

2649:
2650: END validate_usec_rsvprf;
2651:
2652:
2653: PROCEDURE validate_usec_wlstprf(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,
2654: p_insert_update IN VARCHAR2) AS
2655:
2656: /***********************************************************************************************
2657: Created By : Sommukhe

Line 2780: PROCEDURE validate_usec_wlstpri(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,

2776: END validate_usec_wlstprf;
2777:
2778:
2779: --Validations for Unit section waitlist
2780: PROCEDURE validate_usec_wlstpri(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,
2781: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
2782: p_insert_update VARCHAR2)
2783: AS
2784: /***********************************************************************************************