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

Line 61: PROCEDURE create_unit_version(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,

57: l_tbl_uso uso_tbl_type;
58:
59:
60:
61: PROCEDURE create_unit_version(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,
62: p_rec_status OUT NOCOPY VARCHAR2) AS
63: /***********************************************************************************************
64:
65: Created By: sarakshi

Line 95: PROCEDURE trim_values (p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS

91: l_n_seq_num_enrol_load_cal igs_ps_unit_ver_all.sequence_num_enrol_load_cal%TYPE;
92: l_c_cal_type_offer_load_cal igs_ps_unit_ver_all.cal_type_offer_load_cal%TYPE;
93: l_n_seq_num_offer_load_cal igs_ps_unit_ver_all.sequence_num_offer_load_cal%TYPE;
94:
95: PROCEDURE trim_values (p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS
96: BEGIN
97: p_unit_ver_rec.unit_cd := TRIM(p_unit_ver_rec.unit_cd);
98: p_unit_ver_rec.version_number := TRIM(p_unit_ver_rec.version_number);
99: p_unit_ver_rec.start_dt := TRUNC(p_unit_ver_rec.start_dt);

Line 204: PROCEDURE validate_parameters(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS

200: p_unit_ver_rec.workload_val_code := TRIM(p_unit_ver_rec.workload_val_code);
201: p_unit_ver_rec.billing_hrs := TRIM(p_unit_ver_rec.billing_hrs);
202: END trim_values ;
203:
204: PROCEDURE validate_parameters(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS
205: /***********************************************************************************************
206:
207: Created By: sarakshi
208: Date Created By: 11-Nov-2002

Line 293: PROCEDURE validate_derivations(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS

289:
290: END validate_parameters;
291:
292:
293: PROCEDURE validate_derivations(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS
294: /***********************************************************************************************
295:
296: Created By: sarakshi
297: Date Created By: 11-Nov-2002

Line 520: PROCEDURE validate_db_cons(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS

516:
517:
518: END validate_derivations;
519:
520: PROCEDURE validate_db_cons(p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type) AS
521: /***********************************************************************************************
522:
523: Created By: sarakshi
524: Date Created By: 12-Nov-2002

Line 1613: PROCEDURE create_teach_resp ( p_tab_teach_resp IN OUT NOCOPY igs_ps_generic_pub.unit_tr_tbl_type,

1609: END IF;
1610:
1611: END create_unit_version;
1612:
1613: PROCEDURE create_teach_resp ( p_tab_teach_resp IN OUT NOCOPY igs_ps_generic_pub.unit_tr_tbl_type,
1614: p_c_rec_status OUT NOCOPY VARCHAR2 ) AS
1615:
1616: /***********************************************************************************************
1617: Created By : shtatiko

Line 1641: PROCEDURE trim_values ( p_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_tr_rec_type ) AS

1637: AND b.s_org_status <> 'INACTIVE';
1638: c_org_rec c_org%ROWTYPE;
1639:
1640: /* Private Procedures for create_teach_resp */
1641: PROCEDURE trim_values ( p_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_tr_rec_type ) AS
1642: BEGIN
1643: p_teach_resp_rec.unit_cd := trim(p_teach_resp_rec.unit_cd);
1644: p_teach_resp_rec.version_number := trim(p_teach_resp_rec.version_number);
1645: p_teach_resp_rec.org_unit_cd := trim(p_teach_resp_rec.org_unit_cd);

Line 1650: PROCEDURE validate_parameters ( p_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_tr_rec_type ) AS

1646: p_teach_resp_rec.percentage := trim(p_teach_resp_rec.percentage);
1647:
1648: END trim_values;
1649: -- validate parameters passed.
1650: PROCEDURE validate_parameters ( p_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_tr_rec_type ) AS
1651: BEGIN
1652: /* Check for Mandatory Parameters */
1653: IF p_teach_resp_rec.unit_cd IS NULL THEN
1654: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);

Line 1672: PROCEDURE validate_derivations ( p_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_tr_rec_type ) AS

1668: END IF;
1669: END validate_parameters;
1670:
1671: -- Carry out derivations and validate them
1672: PROCEDURE validate_derivations ( p_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_tr_rec_type ) AS
1673: BEGIN
1674: IF NOT igs_re_val_rsup.get_org_unit_dtls ( p_teach_resp_rec.org_unit_cd, l_d_ou_start_dt ) THEN
1675: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'ORG_UNIT_CD', 'LEGACY_TOKENS', FALSE);
1676: p_teach_resp_rec.status := 'E';

Line 1681: PROCEDURE validate_db_cons ( p_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_tr_rec_type ) AS

1677: END IF;
1678: END validate_derivations;
1679:
1680: -- Validate Database Constraints
1681: PROCEDURE validate_db_cons ( p_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_tr_rec_type ) AS
1682: BEGIN
1683:
1684: /* Validate PK Constraints */
1685: IF igs_ps_tch_resp_pkg.get_pk_for_validation (

Line 1869: PROCEDURE create_unit_discip ( p_tab_unit_dscp IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_tbl_type,

1865:
1866: END create_teach_resp;
1867:
1868:
1869: PROCEDURE create_unit_discip ( p_tab_unit_dscp IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_tbl_type,
1870: p_c_rec_status OUT NOCOPY VARCHAR2 ) AS
1871:
1872: /***********************************************************************************************
1873: Created By : shtatiko

Line 1887: PROCEDURE trim_values ( p_unit_dscp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_rec_type ) AS

1883:
1884: l_c_message_name VARCHAR2(30);
1885:
1886: /* Private Procedures for create_unit_dscp */
1887: PROCEDURE trim_values ( p_unit_dscp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_rec_type ) AS
1888: BEGIN
1889: p_unit_dscp_rec.unit_cd := TRIM(p_unit_dscp_rec.unit_cd);
1890: p_unit_dscp_rec.version_number := TRIM(p_unit_dscp_rec.version_number);
1891: p_unit_dscp_rec.discipline_group_cd := TRIM(p_unit_dscp_rec.discipline_group_cd);

Line 1896: PROCEDURE validate_parameters ( p_unit_dscp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_rec_type ) AS

1892: p_unit_dscp_rec.percentage := TRIM(p_unit_dscp_rec.percentage);
1893: END trim_values;
1894:
1895: -- validate parameters passed.
1896: PROCEDURE validate_parameters ( p_unit_dscp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_rec_type ) AS
1897: BEGIN
1898: /* Check for Mandatory Parameters */
1899: IF p_unit_dscp_rec.unit_cd IS NULL THEN
1900: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);

Line 1918: PROCEDURE validate_db_cons ( p_unit_dscp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_rec_type ) AS

1914: END IF;
1915: END validate_parameters;
1916:
1917: -- Validate Database Constraints
1918: PROCEDURE validate_db_cons ( p_unit_dscp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_dscp_rec_type ) AS
1919: BEGIN
1920:
1921: /* Validate PK Constraints */
1922: IF igs_ps_unit_dscp_pkg.get_pk_for_validation (

Line 2078: PROCEDURE create_unit_grd_sch ( p_tab_grd_sch IN OUT NOCOPY igs_ps_generic_pub.unit_gs_tbl_type,

2074: END IF;
2075:
2076: END create_unit_discip;
2077:
2078: PROCEDURE create_unit_grd_sch ( p_tab_grd_sch IN OUT NOCOPY igs_ps_generic_pub.unit_gs_tbl_type,
2079: p_c_rec_status OUT NOCOPY VARCHAR2 ) AS
2080:
2081: /***********************************************************************************************
2082: Created By : shtatiko

Line 2092: PROCEDURE trim_values ( p_grd_sch_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type ) AS

2088: Who When What
2089: ********************************************************************************************** */
2090:
2091: /* Private Procedures for create_unit_grd_sch */
2092: PROCEDURE trim_values ( p_grd_sch_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type ) AS
2093: BEGIN
2094: p_grd_sch_rec.unit_cd := trim(p_grd_sch_rec.unit_cd);
2095: p_grd_sch_rec.version_number := trim(p_grd_sch_rec.version_number);
2096: p_grd_sch_rec.grading_schema_code := trim(p_grd_sch_rec.grading_schema_code);

Line 2102: PROCEDURE validate_parameters ( p_grd_sch_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type ) AS

2098: p_grd_sch_rec.default_flag := trim(p_grd_sch_rec.default_flag);
2099: END trim_values;
2100:
2101: -- Validation of Parameters passed.
2102: PROCEDURE validate_parameters ( p_grd_sch_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type ) AS
2103: BEGIN
2104:
2105: /* Check for Mandatory Parameters */
2106: IF p_grd_sch_rec.unit_cd IS NULL THEN

Line 2130: PROCEDURE validate_db_cons ( p_grd_sch_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type ) AS

2126:
2127: END validate_parameters;
2128:
2129: -- Validate Database Constraints.
2130: PROCEDURE validate_db_cons ( p_grd_sch_rec IN OUT NOCOPY igs_ps_generic_pub.unit_gs_rec_type ) AS
2131: BEGIN
2132:
2133: /* Unique Key Validation */
2134: IF igs_ps_unit_grd_schm_pkg.get_uk_for_validation (

Line 2275: p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,

2271:
2272: END create_unit_grd_sch;
2273:
2274: PROCEDURE validate_unit_dtls (
2275: p_unit_ver_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ver_rec_type,
2276: p_rec_status OUT NOCOPY VARCHAR2) AS
2277:
2278: /***********************************************************************************************
2279: Created By : smvk

Line 2347: PROCEDURE create_unit_section ( p_usec_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_tbl_type,

2343:
2344: END validate_unit_dtls;
2345:
2346:
2347: PROCEDURE create_unit_section ( p_usec_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_tbl_type,
2348: p_c_rec_status OUT NOCOPY VARCHAR2,
2349: p_calling_context IN VARCHAR2
2350: ) AS
2351:

Line 2371: PROCEDURE trim_values ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS

2367: l_b_uop_deleted BOOLEAN;
2368:
2369:
2370: /* Private Procedures for create_unit_section */
2371: PROCEDURE trim_values ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2372: /***********************************************************************************************
2373: Created By :
2374: Date Created By:
2375: Purpose :

Line 2484: PROCEDURE validate_uo_parameters ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS

2480:
2481: -- Private procedures for Unit Offering Records
2482:
2483: -- This procedure validates UO parameter values in Unit Section record
2484: PROCEDURE validate_uo_parameters ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2485: BEGIN
2486: /* Check for Mandatory Fields */
2487: IF p_usec_rec.unit_cd IS NULL OR p_usec_rec.unit_cd = FND_API.G_MISS_CHAR THEN
2488: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);

Line 2502: PROCEDURE validate_uo_derivations ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS

2498: END IF;
2499: END validate_uo_parameters;
2500:
2501: -- This procedure will derive values required for Unit Offering.
2502: PROCEDURE validate_uo_derivations ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2503: l_c_message VARCHAR2(30);
2504: BEGIN
2505: -- Derive Calander Type and Sequence Number
2506: igs_ge_gen_003.get_calendar_instance ( p_alternate_cd => p_usec_rec.teach_cal_alternate_code,

Line 2520: PROCEDURE validate_uo_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS

2516: l_c_message := NULL;
2517: END validate_uo_derivations;
2518:
2519: -- Validate UO Database Constraints
2520: PROCEDURE validate_uo_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2521: /***********************************************************************************************
2522: Created By :
2523: Date Created By:
2524: Purpose :

Line 2574: PROCEDURE create_uo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )

2570: END validate_uo_db_cons;
2571:
2572: -- Main private procedure to create records of Unit Offering.
2573:
2574: PROCEDURE create_uo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )
2575: AS
2576: /***********************************************************************************************
2577: Created By :
2578: Date Created By:

Line 2679: PROCEDURE validate_uop_derivations ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS

2675: END create_uo;
2676:
2677: -- Private procedures for Unit Offering Pattern Record
2678: -- This procedure will derive values required for Unit Offering Pattern.
2679: PROCEDURE validate_uop_derivations ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2680:
2681: BEGIN
2682:
2683: -- Default waitlist_allowed and max students per waitlist

Line 2695: PROCEDURE validate_uop_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS

2691:
2692: END validate_uop_derivations;
2693:
2694: -- Procedure to validate Database constraints for Unit Offering Pattern Records.
2695: PROCEDURE validate_uop_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2696:
2697: CURSOR cur_rowid ( cp_c_unit_cd IN igs_ps_unit_ofr_pat.unit_cd%TYPE,
2698: cp_n_ver_num IN igs_ps_unit_ofr_pat.version_number%TYPE,
2699: cp_c_cal_type IN igs_ps_unit_ofr_pat.cal_type%TYPE,

Line 2770: PROCEDURE create_uop ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )

2766: END validate_uop_db_cons;
2767:
2768: -- Main private procedure to create records of Unit Offering Pattern.
2769:
2770: PROCEDURE create_uop ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )
2771: AS
2772: BEGIN
2773:
2774: validate_uop_derivations ( p_usec_rec );

Line 2910: PROCEDURE validate_uoo_parameters ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS

2906:
2907: -- Private procedures for Unit Offering Option Records
2908:
2909: -- This procedure validates UOO parameter values in Unit Section record
2910: PROCEDURE validate_uoo_parameters ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2911: BEGIN
2912:
2913: /* Check for Mandatory Fields */
2914: IF p_usec_rec.location_cd IS NULL OR p_usec_rec.location_cd = FND_API.G_MISS_CHAR THEN

Line 2926: PROCEDURE validate_uoo_derivations ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS

2922:
2923: END validate_uoo_parameters;
2924:
2925: -- This procedure will derive values required for Unit Offering Option.
2926: PROCEDURE validate_uoo_derivations ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
2927:
2928: /***********************************************************************************************
2929: Created By :
2930: Date Created By:

Line 2997: PROCEDURE validate_uoo_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS

2993:
2994: END validate_uoo_derivations;
2995:
2996: -- Procedure to validate Database constraints for Unit Offering Option Records.
2997: PROCEDURE validate_uoo_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS
2998: /***********************************************************************************************
2999: Created By :
3000: Date Created By:
3001: Purpose :

Line 3220: PROCEDURE create_uoo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )

3216:
3217:
3218: -- Main private procedure to create records of Unit Offering Option.
3219:
3220: PROCEDURE create_uoo ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )
3221: /***********************************************************************************************
3222: Created By :
3223: Date Created By:
3224: Purpose :

Line 3275: FUNCTION check_insert_update ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type) RETURN VARCHAR2 IS

3271: AND abort_flag='N';
3272: l_cur_int_usec cur_int_usec%ROWTYPE;
3273:
3274:
3275: FUNCTION check_insert_update ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type) RETURN VARCHAR2 IS
3276: CURSOR c_usec(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS
3277: SELECT 'X'
3278: FROM igs_ps_unit_ofr_opt_all
3279: WHERE unit_cd = p_usec_rec.unit_cd

Line 3300: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS

3296: END IF;
3297:
3298: END check_insert_update;
3299:
3300: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS
3301:
3302: CURSOR c_usec(cp_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE,cp_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE) IS
3303: SELECT *
3304: FROM igs_ps_unit_ofr_opt_all

Line 4051: PROCEDURE get_uoo_id ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type) AS

4047:
4048: END create_uoo;
4049:
4050: -- This procedure will derive values required for Unit Section Credit Points.
4051: PROCEDURE get_uoo_id ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type) AS
4052: l_c_message VARCHAR2(30);
4053: BEGIN
4054: -- Derive uoo_id
4055: igs_ps_validate_lgcy_pkg.get_uoo_id ( p_unit_cd => p_usec_rec.unit_cd,

Line 4073: PROCEDURE validate_cp_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS

4069:
4070: END get_uoo_id;
4071:
4072: -- Procedure to validate Database constraints for Unit Section Credit Points Records.
4073: PROCEDURE validate_cp_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS
4074: --sarakshi 15-May-2006 Bug#3064563, modified the format mask(clock_hours,continuing_education_units,work_load_cp_lecture,work_load_cp_lab,contact_hrs_lab) as specified in the bug.
4075: BEGIN
4076:
4077: IF p_insert_update = 'I' THEN

Line 4308: PROCEDURE create_cp ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )

4304: END validate_cp_db_cons;
4305:
4306: -- Main private procedure to create records of Unit Section Credit Points.
4307:
4308: PROCEDURE create_cp ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )
4309: AS
4310: FUNCTION check_insert_update (p_usec_rec IN igs_ps_generic_pub.usec_rec_type ) RETURN VARCHAR2 IS
4311:
4312: CURSOR c_usec_cp(cp_n_uoo_id NUMBER) IS

Line 4310: FUNCTION check_insert_update (p_usec_rec IN igs_ps_generic_pub.usec_rec_type ) RETURN VARCHAR2 IS

4306: -- Main private procedure to create records of Unit Section Credit Points.
4307:
4308: PROCEDURE create_cp ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )
4309: AS
4310: FUNCTION check_insert_update (p_usec_rec IN igs_ps_generic_pub.usec_rec_type ) RETURN VARCHAR2 IS
4311:
4312: CURSOR c_usec_cp(cp_n_uoo_id NUMBER) IS
4313: SELECT *
4314: FROM igs_ps_usec_cps

Line 4330: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,

4326: RETURN 'U';
4327: END IF;
4328:
4329: END check_insert_update;
4330: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
4331: p_insert_update VARCHAR2 ) AS
4332: CURSOR c_usec_cp(p_n_uoo_id NUMBER) IS
4333: SELECT *
4334: FROM igs_ps_usec_cps

Line 4660: PROCEDURE validate_ref_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS

4656:
4657: END create_cp;
4658:
4659: -- Procedure to validate Database constraints for Unit Section Reference Records.
4660: PROCEDURE validate_ref_db_cons ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS
4661: BEGIN
4662: IF p_insert_update = 'I' THEN
4663: /* Check for Unique Key Constraints */
4664: IF igs_ps_usec_ref_pkg.get_uk_for_validation ( l_n_uoo_id ) THEN

Line 4713: PROCEDURE create_ref ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )

4709: END validate_ref_db_cons;
4710:
4711: -- Main private procedure to create records of Unit Section Reference .
4712:
4713: PROCEDURE create_ref ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )
4714: AS
4715:
4716: FUNCTION check_insert_update (p_usec_rec IN igs_ps_generic_pub.usec_rec_type ) RETURN VARCHAR2 IS
4717:

Line 4716: FUNCTION check_insert_update (p_usec_rec IN igs_ps_generic_pub.usec_rec_type ) RETURN VARCHAR2 IS

4712:
4713: PROCEDURE create_ref ( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type )
4714: AS
4715:
4716: FUNCTION check_insert_update (p_usec_rec IN igs_ps_generic_pub.usec_rec_type ) RETURN VARCHAR2 IS
4717:
4718: CURSOR c_usec_ref(p_n_uoo_id NUMBER) IS
4719: SELECT 'X'
4720: FROM igs_ps_usec_ref

Line 4738: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,

4734: END IF;
4735:
4736: END check_insert_update;
4737:
4738: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
4739: p_insert_update VARCHAR2 ) AS
4740: CURSOR c_usec_ref(p_n_uoo_id NUMBER) IS
4741: SELECT *
4742: FROM igs_ps_usec_ref

Line 5104: PROCEDURE create_usec_el(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS

5100: END IF;
5101:
5102: END create_ref;
5103: -- Adding the new procedure to import unit section enrollment limits
5104: PROCEDURE create_usec_el(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type ) AS
5105: /***********************************************************************************************
5106:
5107: Created By: SMVK
5108: Date Created By: 28-May-2003

Line 5118: FUNCTION check_insert_update (p_usec_rec IN igs_ps_generic_pub.usec_rec_type ) RETURN VARCHAR2 IS

5114:
5115: Who When What
5116:
5117: ***********************************************************************************************/
5118: FUNCTION check_insert_update (p_usec_rec IN igs_ps_generic_pub.usec_rec_type ) RETURN VARCHAR2 IS
5119: CURSOR c_usec_lim(p_n_uoo_id NUMBER) IS
5120: SELECT 'X'
5121: FROM igs_ps_usec_lim_wlst
5122: WHERE uoo_id = p_n_uoo_id;

Line 5139: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,

5135: END IF;
5136:
5137: END check_insert_update;
5138:
5139: PROCEDURE Assign_default( p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,
5140: p_insert_update VARCHAR2 ) AS
5141: CURSOR c_uop(cp_c_unit_cd IN igs_ps_unit_ofr_pat_all.unit_cd%TYPE,
5142: cp_n_ver_num IN igs_ps_unit_ofr_pat_all.version_number%TYPE,
5143: cp_c_cal_type IN igs_ps_unit_ofr_pat_all.cal_type%TYPE,

Line 5231: PROCEDURE validate_db_cons(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS

5227:
5228: END Assign_default;
5229:
5230:
5231: PROCEDURE validate_db_cons(p_usec_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rec_type,p_insert_update VARCHAR2 ) AS
5232: BEGIN
5233: IF p_insert_update = 'I' THEN
5234: IF igs_ps_usec_lim_wlst_pkg.get_uk_for_validation(l_n_uoo_id) THEN
5235: p_usec_rec.status :='W';

Line 5657: p_tab_usec_gs IN OUT NOCOPY igs_ps_generic_pub.usec_gs_tbl_type,

5653: END create_unit_section;
5654:
5655:
5656: PROCEDURE create_usec_grd_sch (
5657: p_tab_usec_gs IN OUT NOCOPY igs_ps_generic_pub.usec_gs_tbl_type,
5658: p_c_rec_status OUT NOCOPY VARCHAR2,
5659: p_calling_context IN VARCHAR2
5660: ) AS
5661: /***********************************************************************************************

Line 5675: PROCEDURE trim_values ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS

5671: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
5672: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
5673:
5674: /* Private Procedures for create_usec_grd_sch */
5675: PROCEDURE trim_values ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS
5676: BEGIN
5677: p_usec_gs_rec.unit_cd := trim(p_usec_gs_rec.unit_cd);
5678: p_usec_gs_rec.version_number := trim(p_usec_gs_rec.version_number);
5679: p_usec_gs_rec.teach_cal_alternate_code := trim(p_usec_gs_rec.teach_cal_alternate_code);

Line 5688: PROCEDURE validate_parameters ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS

5684: p_usec_gs_rec.default_flag := trim(p_usec_gs_rec.default_flag);
5685: END trim_values;
5686:
5687: -- validate parameters passed.
5688: PROCEDURE validate_parameters ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS
5689: BEGIN
5690:
5691: /* Check for Mandatory Parameters */
5692: IF p_usec_gs_rec.unit_cd IS NULL OR p_usec_gs_rec.unit_cd = FND_API.G_MISS_CHAR THEN

Line 5727: FUNCTION check_insert_update ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) RETURN VARCHAR2 IS

5723: END IF;
5724: END validate_parameters;
5725:
5726: -- Check for Update
5727: FUNCTION check_insert_update ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) RETURN VARCHAR2 IS
5728: CURSOR c_usec_gs(p_grading_schema_code IN VARCHAR2,p_grd_schm_version_number NUMBER ,p_n_uoo_id NUMBER) IS
5729: SELECT 'X'
5730: FROM igs_ps_usec_grd_schm
5731: WHERE grading_schema_code =p_grading_schema_code

Line 5751: PROCEDURE validate_derivations ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS

5747:
5748: END check_insert_update;
5749:
5750: -- Carry out derivations and validate them
5751: PROCEDURE validate_derivations ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type ) AS
5752: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5753: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5754: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
5755: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

Line 5791: PROCEDURE validate_db_cons ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type,p_insert_update VARCHAR2 ) AS

5787:
5788: END validate_derivations;
5789:
5790: -- Validate Database Constraints
5791: PROCEDURE validate_db_cons ( p_usec_gs_rec IN OUT NOCOPY igs_ps_generic_pub.usec_gs_rec_type,p_insert_update VARCHAR2 ) AS
5792: BEGIN
5793: IF (p_insert_update = 'I') THEN
5794: /* Unique Key Validation */
5795: IF igs_ps_usec_grd_schm_pkg.get_uk_for_validation ( x_grading_schema_code => p_usec_gs_rec.grading_schema_code,

Line 6034: PROCEDURE create_usec_occur ( p_tab_usec_occur IN OUT NOCOPY igs_ps_generic_pub.uso_tbl_type,

6030:
6031:
6032: END create_usec_grd_sch;
6033:
6034: PROCEDURE create_usec_occur ( p_tab_usec_occur IN OUT NOCOPY igs_ps_generic_pub.uso_tbl_type,
6035: p_c_rec_status OUT NOCOPY VARCHAR2,
6036: p_calling_context IN VARCHAR2) AS
6037:
6038: /***********************************************************************************************

Line 6080: PROCEDURE trim_values ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) AS

6076: l_n_tbl_cnt NUMBER;
6077:
6078:
6079:
6080: PROCEDURE trim_values ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) AS
6081: BEGIN
6082: p_uso_rec.unit_cd := trim(p_uso_rec.unit_cd);
6083: p_uso_rec.version_number := trim(p_uso_rec.version_number);
6084: p_uso_rec.teach_cal_alternate_code := trim(p_uso_rec.teach_cal_alternate_code);

Line 6131: PROCEDURE validate_parameters ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) AS

6127:
6128: END trim_values;
6129:
6130: /* Private Procedures for create_usec_occur */
6131: PROCEDURE validate_parameters ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) AS
6132: BEGIN
6133:
6134: /* Check for Mandatory Parameters */
6135: IF p_uso_rec.unit_cd IS NULL OR p_uso_rec.unit_cd = FND_API.G_MISS_CHAR THEN

Line 6162: PROCEDURE validate_derivations ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) AS

6158: END IF;
6159:
6160: END validate_parameters;
6161:
6162: PROCEDURE validate_derivations ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) AS
6163:
6164: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
6165: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
6166: SELECT building_id

Line 6292: PROCEDURE validate_db_cons ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,p_insert IN VARCHAR2 ) AS

6288:
6289: END validate_derivations;
6290:
6291: -- Validate Database Constraints
6292: PROCEDURE validate_db_cons ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type,p_insert IN VARCHAR2 ) AS
6293: BEGIN
6294:
6295: /* Validate Check Constraints */
6296:

Line 6455: FUNCTION check_insert_update ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) RETURN VARCHAR2 IS

6451: END validate_db_cons;
6452:
6453: ---
6454: -- Check for Update/Insert
6455: FUNCTION check_insert_update ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type ) RETURN VARCHAR2 IS
6456:
6457: CURSOR c_occr IS
6458: SELECT unit_section_occurrence_id
6459: FROM igs_ps_usec_occurs_all

Line 6480: PROCEDURE assign_defaults ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type, p_insert IN VARCHAR2) IS

6476: END IF;
6477:
6478: END check_insert_update;
6479:
6480: PROCEDURE assign_defaults ( p_uso_rec IN OUT NOCOPY igs_ps_generic_pub.uso_rec_type, p_insert IN VARCHAR2) IS
6481: CURSOR cur_usec_ocurs ( cp_uso_id IN NUMBER) IS
6482: SELECT *
6483: FROM igs_ps_usec_occurs_all
6484: WHERE unit_section_occurrence_id = cp_uso_id;

Line 7312: PROCEDURE create_unit_ref_code( p_tab_ref_cd IN OUT NOCOPY igs_ps_generic_pub.unit_ref_tbl_type,

7308: END IF;
7309:
7310: END create_usec_occur;
7311:
7312: PROCEDURE create_unit_ref_code( p_tab_ref_cd IN OUT NOCOPY igs_ps_generic_pub.unit_ref_tbl_type,
7313: p_c_rec_status OUT NOCOPY VARCHAR2,
7314: p_calling_context IN VARCHAR2) AS
7315:
7316: /***********************************************************************************************

Line 7356: PROCEDURE trim_values ( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS

7352: WHERE reference_cd_type = cp_c_ref_type;
7353:
7354: rec_res_flag c_res_flag%ROWTYPE;
7355:
7356: PROCEDURE trim_values ( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7357: BEGIN
7358: p_ref_cd_rec.unit_cd := trim(p_ref_cd_rec.unit_cd);
7359: p_ref_cd_rec.version_number := trim(p_ref_cd_rec.version_number);
7360: p_ref_cd_rec.data_type := trim(p_ref_cd_rec.data_type);

Line 7373: PROCEDURE validate_unit_parameters( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS

7369:
7370: END trim_values ;
7371:
7372: -- Validate the Mandatory Parameters for creation of unit referrence code
7373: PROCEDURE validate_unit_parameters( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7374: BEGIN
7375: IF p_ref_cd_rec.unit_cd IS NULL OR p_ref_cd_rec.unit_cd = FND_API.G_MISS_CHAR THEN
7376: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD','LEGACY_TOKENS', FALSE);
7377: p_ref_cd_rec.status := 'E';

Line 7398: PROCEDURE validate_usec_parameters( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS

7394: END IF;
7395: END validate_unit_parameters;
7396:
7397: -- Validate the Mandatory Parameters for Unit Section / Unit Section Occurrence
7398: PROCEDURE validate_usec_parameters( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7399: BEGIN
7400: validate_unit_parameters( p_ref_cd_rec );
7401: IF p_ref_cd_rec.teach_cal_alternate_code IS NULL OR p_ref_cd_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN
7402: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'TEACH_CAL_ALTERNATE_CD','LEGACY_TOKENS', FALSE);

Line 7430: PROCEDURE validate_parameters( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS

7426:
7427: END validate_usec_parameters;
7428:
7429: -- Validate the Mandatory Parameters
7430: PROCEDURE validate_parameters( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7431: BEGIN
7432: IF p_ref_cd_rec.data_type IS NULL OR p_ref_cd_rec.data_type = 'UNIT' THEN
7433: validate_unit_parameters(p_ref_cd_rec);
7434: ELSIF p_ref_cd_rec.data_type = 'SECTION' OR p_ref_cd_rec.data_type = 'OCCURRENCE' THEN

Line 7447: PROCEDURE validate_usec_derivations( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS

7443: --For the PSP Enhancements TD:
7444: --Removed the cursor c_ref_cd_id and its reference from validate_usec_derivations
7445:
7446: -- Derivation of values required to create Unit Section Referrence.
7447: PROCEDURE validate_usec_derivations( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7448:
7449: CURSOR c_usec_ref_id (cp_uoo_id IN igs_ps_unit_ofr_opt_all.uoo_id%TYPE) IS
7450: SELECT A.unit_section_reference_id
7451: FROM igs_ps_usec_ref A

Line 7500: PROCEDURE validate_occur_deri_busi( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS

7496: -- jbegum 04-June-2003 Enh#2972950
7497: -- For PSP Scheduling Enhancements TD:
7498: -- Modified the cursor's c_tba_count,c_tba_uso_id,c_count,c_uso_id.
7499: -- Added 2 new cursor's c_nsd_count,c_nsd_uso_id.
7500: PROCEDURE validate_occur_deri_busi( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7501:
7502: l_d_start DATE;
7503: l_d_end DATE;
7504: l_ret_status VARCHAR2(30);

Line 7550: PROCEDURE validate_derivation( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS

7546:
7547: END validate_occur_deri_busi;
7548:
7549: -- Decides to call the derivation procedures based on the datatype
7550: PROCEDURE validate_derivation( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7551:
7552: -- Following cursor added as part of bug#2972950 for the PSP Enhancements TD
7553: CURSOR c_ref_des (cp_c_ref_type igs_ge_ref_cd_type_all.reference_cd_type%TYPE,
7554: cp_c_ref_cd igs_ge_ref_cd.reference_cd%TYPE) IS

Line 7599: PROCEDURE validate_unit_db_cons(p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS

7595:
7596: END validate_derivation;
7597:
7598: -- Validate the database constraints for the Unit Referrence code
7599: PROCEDURE validate_unit_db_cons(p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type) AS
7600:
7601: BEGIN
7602: -- Unique Key Validation
7603: IF p_ref_cd_rec.gen_ref_flag = 'Y' THEN -- if generic reference code

Line 7677: PROCEDURE validate_usec_db_cons(p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type,p_insert IN VARCHAR2) AS

7673:
7674: END validate_unit_db_cons;
7675:
7676: -- Validate the database constraints for the Unit Section Occurrence Referrence code
7677: PROCEDURE validate_usec_db_cons(p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type,p_insert IN VARCHAR2) AS
7678:
7679: BEGIN
7680:
7681: IF p_insert = 'I' THEN

Line 7732: PROCEDURE validate_occur_db_cons(p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type,p_insert IN VARCHAR2) AS

7728:
7729: END validate_usec_db_cons;
7730:
7731: -- Validate the database constraints for the Unit Section Occurrence Referrence code
7732: PROCEDURE validate_occur_db_cons(p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type,p_insert IN VARCHAR2) AS
7733:
7734: BEGIN
7735: IF p_insert = 'I' THEN
7736: -- Unique Key Validation

Line 7777: PROCEDURE validate_db_cons( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type,p_insert IN VARCHAR2) AS

7773: END validate_occur_db_cons;
7774:
7775:
7776: -- Decides to call the database constraint procedures based on the datatype
7777: PROCEDURE validate_db_cons( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type,p_insert IN VARCHAR2) AS
7778: BEGIN
7779: IF p_ref_cd_rec.data_type = 'UNIT' THEN
7780: validate_unit_db_cons(p_ref_cd_rec);
7781: ELSIF p_ref_cd_rec.data_type = 'SECTION' THEN

Line 7790: FUNCTION check_insert_update ( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type ) RETURN VARCHAR2 IS

7786: END validate_db_cons;
7787:
7788: ---
7789: -- Check for Update/Insert
7790: FUNCTION check_insert_update ( p_ref_cd_rec IN OUT NOCOPY igs_ps_generic_pub.unit_ref_rec_type ) RETURN VARCHAR2 IS
7791: --For IGS_PS_USEC_REF_CD record
7792: CURSOR c_gen IS
7793: SELECT rc.restricted_flag,ur.reference_code_desc
7794: FROM igs_ps_usec_ref_cd ur, igs_ge_ref_cd_type_all rc

Line 8271: PROCEDURE create_uso_ins( p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type,

8267: END create_unit_ref_code;
8268:
8269: --This procedure is a sub process to create Unit Section Occurrence Instructors
8270: --in production table(IGS_PS_USO_INSTRCTRS)
8271: PROCEDURE create_uso_ins( p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type,
8272: p_c_rec_status OUT NOCOPY VARCHAR2 ) AS
8273: /***********************************************************************************************
8274:
8275: Created By: smvk

Line 8324: PROCEDURE trim_values ( p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS

8320: END LOOP;
8321: RETURN FALSE;
8322: END usoexists;
8323:
8324: PROCEDURE trim_values ( p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
8325: BEGIN
8326: p_uso_ins_rec.instructor_person_number := TRIM(p_uso_ins_rec.instructor_person_number);
8327: p_uso_ins_rec.production_uso_id := TRIM(p_uso_ins_rec.production_uso_id);
8328: p_uso_ins_rec.unit_cd := TRIM(p_uso_ins_rec.unit_cd);

Line 8343: PROCEDURE validate_parameters(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS

8339: p_uso_ins_rec.lead_instructor_flag := TRIM(p_uso_ins_rec.lead_instructor_flag);
8340:
8341: END trim_values;
8342:
8343: PROCEDURE validate_parameters(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
8344: /***********************************************************************************************
8345:
8346: Created By: smvk
8347: Date Created By: 20-May-2003

Line 8412: PROCEDURE validate_derivation(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS

8408:
8409:
8410: END validate_parameters;
8411:
8412: PROCEDURE validate_derivation(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
8413: /***********************************************************************************************
8414:
8415: Created By: smvk
8416: Date Created By: 20-May-2003

Line 8504: PROCEDURE validate_db_cons(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS

8500:
8501: END IF;
8502: END validate_derivation;
8503:
8504: PROCEDURE validate_db_cons(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
8505: CURSOR c_unit_ver (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
8506: SELECT a.unit_cd, a.version_number
8507: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b
8508: WHERE a.uoo_id = b.uoo_id