DBA Data[Home] [Help]

APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on IGS_PS_GENERIC_PUB

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

146: p_n_ovr_max igs_ps_unit_ver_all.override_enrollment_max%TYPE,
147: p_n_adv_max igs_ps_unit_ver_all.advance_maximum%TYPE,
148: p_c_rec_status IN OUT NOCOPY VARCHAR2) ;
149:
150: PROCEDURE unit_version(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,
151: p_coord_person_id IN igs_ps_unit_ver_all.coord_person_id%TYPE) AS
152: /***********************************************************************************************
153:
154: Created By: sarakshi

Line 462: FUNCTION post_teach_resp ( p_tab_teach_resp IN OUT NOCOPY igs_ps_generic_pub.unit_tr_tbl_type

458: validate_enr_lmts (p_unit_ver_rec.enrollment_minimum, p_unit_ver_rec.enrollment_maximum, p_unit_ver_rec.override_enrollment_max, p_unit_ver_rec.advance_maximum, p_unit_ver_rec.status);
459:
460: END unit_version;
461:
462: FUNCTION post_teach_resp ( p_tab_teach_resp IN OUT NOCOPY igs_ps_generic_pub.unit_tr_tbl_type
463: ) RETURN BOOLEAN AS
464:
465: /***********************************************************************************************
466: Created By : shtatiko

Line 504: FUNCTION post_unit_discip ( p_tab_unit_dscp IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_tbl_type

500: RETURN TRUE;
501:
502: END post_teach_resp;
503:
504: FUNCTION post_unit_discip ( p_tab_unit_dscp IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_tbl_type
505: ) RETURN BOOLEAN AS
506:
507: /***********************************************************************************************
508: Created By : shtatiko

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

541: RETURN TRUE;
542:
543: END post_unit_discip;
544:
545: PROCEDURE validate_unit_grd_sch ( p_unit_gs_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type )
546: AS
547: /***********************************************************************************************
548: Created By : shtatiko
549: Date Created By: 15-NOV-2002

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

563: RETURN;
564: END IF;
565: END validate_unit_grd_sch;
566:
567: FUNCTION post_unit_grd_sch ( p_tab_grd_sch IN OUT NOCOPY igs_ps_generic_pub.unit_gs_tbl_type ) RETURN BOOLEAN
568: AS
569: /***********************************************************************************************
570: Created By : shtatiko
571: Date Created By: 18-NOV-2002

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

621: END post_unit_grd_sch;
622:
623:
624: -- Validate Unit Offer Option Records before inserting them
625: PROCEDURE validate_uoo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
626: p_c_cal_type IN igs_ca_type.cal_type%TYPE,
627: p_n_seq_num IN igs_ca_inst_all.sequence_number%TYPE,
628: p_n_sup_uoo_id IN OUT NOCOPY igs_ps_unit_ofr_opt_all.sup_uoo_id%TYPE,
629: p_insert_update VARCHAR2,

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

1286:
1287:
1288:
1289: -- Validate Unit Section Credit Points Records before inserting them
1290: PROCEDURE validate_cps ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
1291: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1292: p_insert_update VARCHAR2) AS
1293:
1294: /***********************************************************************************************

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

1399:
1400: END validate_cps;
1401:
1402: -- Validate Unit Section Referece Records before inserting them
1403: PROCEDURE validate_ref ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
1404: p_n_subtitle_id OUT NOCOPY igs_ps_unit_subtitle.subtitle_id%TYPE,
1405: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1406: p_insert_update VARCHAR2)
1407: AS

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

1598: END IF;
1599: END IF;
1600: END validate_ref;
1601:
1602: PROCEDURE validate_usec_grd_sch ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type,
1603: p_n_uoo_id IN NUMBER)
1604: AS
1605: /***********************************************************************************************
1606: Created By : shtatiko

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

1637: END IF;
1638:
1639: END validate_usec_grd_sch;
1640:
1641: FUNCTION post_usec_grd_sch ( p_tab_usec_gs IN OUT NOCOPY igs_ps_generic_pub.usec_gs_tbl_type,
1642: p_tab_uoo IN igs_ps_create_generic_pkg.uoo_tbl_type) RETURN BOOLEAN
1643: AS
1644: /***********************************************************************************************
1645: Created By : Sommukhe

Line 1661: CURSOR c_uoo_id (cp_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type) IS

1657: WHERE uoo_id = cp_uoo_id
1658: AND default_flag = 'Y';
1659: rec_usec_gs_count c_usec_gs_count%ROWTYPE;
1660:
1661: CURSOR c_uoo_id (cp_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type) IS
1662: SELECT uoo_id
1663: FROM igs_ps_unit_ofr_opt_all a,igs_ca_inst_all b
1664: WHERE a.unit_cd = cp_usec_gs_rec.unit_cd
1665: AND a.version_number = cp_usec_gs_rec.version_number

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

1704: RETURN l_b_status;
1705:
1706: END post_usec_grd_sch;
1707:
1708: PROCEDURE validate_usec_occurs ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,
1709: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
1710: p_d_start_date IN igs_ca_inst_all.start_dt%TYPE,
1711: p_d_end_date IN igs_ca_inst_all.end_dt%TYPE,
1712: p_n_building_code IN NUMBER,

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

2958: END IF;
2959:
2960: END validate_enr_lmts;
2961:
2962: PROCEDURE validate_usec_el(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
2963: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
2964: p_insert_update VARCHAR2) AS
2965:
2966: /***********************************************************************************************

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

3215:
3216:
3217: END validate_usec_el;
3218:
3219: PROCEDURE post_usec_limits(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
3220: p_calling_context IN VARCHAR2,
3221: p_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
3222: p_insert_update VARCHAR2) AS
3223:

Line 3274: p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type,

3270: END post_usec_limits;
3271:
3272: PROCEDURE post_uso_ins (p_n_ins_id IN igs_ps_uso_instrctrs.instructor_id%TYPE,
3273: p_n_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE,
3274: p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type,
3275: p_n_index IN NUMBER) AS
3276: /***********************************************************************************************
3277: Created By : jbegum
3278: Date Created By: 02-June-2003

Line 3578: FUNCTION post_uso_ins_busi (p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type) RETURN BOOLEAN AS

3574: END IF;
3575: END IF;
3576: END post_uso_ins;
3577:
3578: FUNCTION post_uso_ins_busi (p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type) RETURN BOOLEAN AS
3579: /***********************************************************************************************
3580: Created By : jbegum
3581: Date Created By: 02-June-2003
3582: Purpose : Bug # 2972950.

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

3752: RETURN TRUE;
3753: END IF;
3754: END post_uso_ins_busi;
3755:
3756: PROCEDURE validate_unit_reference(p_unit_ref_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type,
3757: p_n_uoo_id IN NUMBER,
3758: p_n_uso_id IN NUMBER,
3759: p_calling_context IN VARCHAR2) IS
3760: CURSOR c_ref_flag (cp_c_ref_cd_type igs_ge_ref_cd_type.reference_cd_type%TYPE) IS