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

Line 43: p_usec_res_seat_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_tbl_type,

39: g_n_login_id igs_ps_unit_ver_all.last_update_login%TYPE := NVL(fnd_global.login_id,-1); -- Stores the Login Id
40:
41:
42: PROCEDURE create_usec_res_seat(
43: p_usec_res_seat_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_tbl_type,
44: p_c_rec_status OUT NOCOPY VARCHAR2,
45: p_calling_context IN VARCHAR2
46: ) AS
47: /***********************************************************************************************

Line 68: PROCEDURE trim_values ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS

64: l_n_group_id igs_pe_persid_group_all.group_id%TYPE;
65:
66: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
67:
68: PROCEDURE trim_values ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS
69: BEGIN
70:
71: p_usec_rsv_rec.unit_cd := trim(p_usec_rsv_rec.unit_cd);
72: p_usec_rsv_rec.version_number := trim(p_usec_rsv_rec.version_number);

Line 85: PROCEDURE create_rsvpri( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS

81: p_usec_rsv_rec.percentage_reserved := trim(p_usec_rsv_rec.percentage_reserved);
82: END trim_values;
83:
84:
85: PROCEDURE create_rsvpri( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS
86:
87: -- validate parameters passed reserved seating
88: PROCEDURE validate_parameters ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS
89: BEGIN

Line 88: PROCEDURE validate_parameters ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS

84:
85: PROCEDURE create_rsvpri( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS
86:
87: -- validate parameters passed reserved seating
88: PROCEDURE validate_parameters ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS
89: BEGIN
90:
91: /* Check for Mandatory Parameters */
92: IF p_usec_rsv_rec.unit_cd IS NULL OR p_usec_rsv_rec.unit_cd = FND_API.G_MISS_CHAR THEN

Line 126: PROCEDURE validate_derivations_pri ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS

122: END validate_parameters ;
123:
124:
125: --validate derivations of priority
126: PROCEDURE validate_derivations_pri ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
127: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
128: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
129: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
130: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

Line 161: FUNCTION check_insert_update ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_n_rsv_usec_pri_id NUMBER) RETURN VARCHAR2 IS

157: END IF;
158: END validate_derivations_pri;
159:
160: -- Check for Update
161: FUNCTION check_insert_update ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_n_rsv_usec_pri_id NUMBER) RETURN VARCHAR2 IS
162: CURSOR c_usec_rsv_pri(cp_n_uoo_id NUMBER,cp_priority_value VARCHAR2) IS
163: SELECT 'X'
164: FROM igs_ps_rsv_usec_pri
165: WHERE uoo_id = cp_n_uoo_id

Line 181: PROCEDURE Assign_default(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS

177: RETURN 'U';
178: END IF;
179: END check_insert_update;
180:
181: PROCEDURE Assign_default(p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
182:
183: CURSOR c_usprv(cp_n_uoo_id NUMBER,cp_priority_value VARCHAR2) IS
184: SELECT priority_order
185: FROM igs_ps_rsv_usec_pri

Line 210: PROCEDURE validate_db_cons_rsvpri ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS

206:
207: END Assign_default;
208:
209: -- Validate Database Constraints for reserved seating priority.
210: PROCEDURE validate_db_cons_rsvpri ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
211: BEGIN
212: IF(p_insert_update = 'I') THEN
213: /* Unique Key Validation */
214: IF igs_ps_rsv_usec_pri_pkg.get_uk_for_validation (x_uoo_id => l_n_uoo_id,

Line 410: PROCEDURE create_rsvprf( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS

406: END IF;
407:
408: END create_rsvpri;
409:
410: PROCEDURE create_rsvprf( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS
411:
412: PROCEDURE validate_parameters_prf ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS
413: BEGIN
414:

Line 412: PROCEDURE validate_parameters_prf ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS

408: END create_rsvpri;
409:
410: PROCEDURE create_rsvprf( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS
411:
412: PROCEDURE validate_parameters_prf ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type ) AS
413: BEGIN
414:
415: /* Check for Mandatory Parameters */
416: IF p_usec_rsv_rec.preference_order IS NULL OR p_usec_rsv_rec.preference_order = FND_API.G_MISS_NUM THEN

Line 446: PROCEDURE validate_derivations_prf ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS

442:
443: END validate_parameters_prf ;
444:
445: -- Carry out derivations and validate them
446: PROCEDURE validate_derivations_prf ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
447: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
448: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
449: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
450: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

Line 468: FUNCTION check_insert_update ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_n_rsv_usec_pri_id NUMBER) RETURN VARCHAR2 IS

464:
465: END validate_derivations_prf;
466:
467:
468: FUNCTION check_insert_update ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_n_rsv_usec_pri_id NUMBER) RETURN VARCHAR2 IS
469: CURSOR c_usec_rsv_prf(p_rsv_usec_pri_id NUMBER,p_preference_code VARCHAR2) IS
470: SELECT 'X'
471: FROM igs_ps_rsv_usec_prf
472: WHERE rsv_usec_pri_id = p_rsv_usec_pri_id

Line 510: PROCEDURE validate_db_cons_rsvprf ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS

506: END IF;
507: END check_insert_update;
508:
509: -- Validate Database Constraints for reserved seating preference.
510: PROCEDURE validate_db_cons_rsvprf ( p_usec_rsv_rec IN OUT NOCOPY igs_ps_generic_pub.usec_res_seat_rec_type,p_insert_update VARCHAR2 ) AS
511: CURSOR cur_hzp(cp_preference_code VARCHAR2) IS
512: SELECT 'x'
513: FROM hz_parties hp, igs_pe_hz_parties pe
514: WHERE hp.party_id = pe.party_id

Line 823: PROCEDURE create_uso_facility (p_usec_occurs_facility_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_tbl_type,

819: END IF;
820:
821: END create_usec_res_seat;
822:
823: PROCEDURE create_uso_facility (p_usec_occurs_facility_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_tbl_type,
824: p_c_rec_status OUT NOCOPY VARCHAR2,
825: p_calling_context IN VARCHAR2
826: ) AS
827:

Line 842: PROCEDURE trim_values ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS

838: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
839: l_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE;
840:
841: /* Private Procedures for create_uso_facility */
842: PROCEDURE trim_values ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS
843: BEGIN
844:
845: p_uso_fclt_rec.unit_cd := TRIM(p_uso_fclt_rec.unit_cd);
846: p_uso_fclt_rec.version_number := TRIM(p_uso_fclt_rec.version_number);

Line 856: PROCEDURE validate_parameters (p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS

852: p_uso_fclt_rec.facility_code := TRIM(p_uso_fclt_rec.facility_code);
853: END trim_values;
854:
855: -- validate parameters passed.
856: PROCEDURE validate_parameters (p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS
857: BEGIN
858: /* Check for Mandatory Parameters */
859: IF p_uso_fclt_rec.unit_cd IS NULL OR p_uso_fclt_rec.unit_cd = FND_API.G_MISS_CHAR THEN
860: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);

Line 890: PROCEDURE validate_derivations ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS

886: END IF;
887:
888: END validate_parameters;
889:
890: PROCEDURE validate_derivations ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS
891: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
892: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
893: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
894: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

Line 950: PROCEDURE validate_db_cons ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS

946:
947: END validate_derivations;
948:
949: -- Validate Database Constraints
950: PROCEDURE validate_db_cons ( p_uso_fclt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_occurs_facility_rec_type ) AS
951: BEGIN
952:
953: /* Validate UK Constraints */
954: IF igs_ps_uso_facility_pkg.get_uk_for_validation (

Line 1120: p_usec_cat_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_cat_tbl_type,

1116:
1117:
1118:
1119: PROCEDURE create_usec_cat (
1120: p_usec_cat_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_cat_tbl_type,
1121: p_c_rec_status OUT NOCOPY VARCHAR2,
1122: p_calling_context IN VARCHAR2
1123: ) AS
1124:

Line 1138: PROCEDURE trim_values ( p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS

1134: ********************************************************************************************** */
1135: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
1136:
1137: /* Private Procedures for create_usec_cat */
1138: PROCEDURE trim_values ( p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS
1139: BEGIN
1140: p_usec_cat_rec.unit_cd := TRIM(p_usec_cat_rec.unit_cd);
1141: p_usec_cat_rec.version_number := TRIM(p_usec_cat_rec.version_number);
1142: p_usec_cat_rec.teach_cal_alternate_code := TRIM(p_usec_cat_rec.teach_cal_alternate_code);

Line 1149: PROCEDURE validate_parameters (p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS

1145: p_usec_cat_rec.unit_cat := TRIM(p_usec_cat_rec.unit_cat);
1146: END trim_values;
1147:
1148: -- validate parameters passed.
1149: PROCEDURE validate_parameters (p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS
1150: BEGIN
1151: /* Check for Mandatory Parameters */
1152: IF p_usec_cat_rec.unit_cd IS NULL OR p_usec_cat_rec.unit_cd = FND_API.G_MISS_CHAR THEN
1153: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_MANDATORY', 'UNIT_CD', 'LEGACY_TOKENS', FALSE);

Line 1179: PROCEDURE validate_derivations ( p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS

1175: END IF;
1176:
1177: END validate_parameters;
1178:
1179: PROCEDURE validate_derivations ( p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS
1180: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
1181: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
1182: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
1183: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

Line 1223: PROCEDURE validate_db_cons ( p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS

1219:
1220: END validate_derivations;
1221:
1222: -- Validate Database Constraints
1223: PROCEDURE validate_db_cons ( p_usec_cat_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cat_rec_type ) AS
1224: BEGIN
1225:
1226: /* Validate UK Constraints */
1227: IF igs_ps_usec_category_pkg.get_uk_for_validation (

Line 1387: p_usec_teach_resp_ovrd_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_tbl_type,

1383:
1384:
1385: /*teaching responsibility ovrd*/
1386: PROCEDURE create_usec_teach_resp_ovrd (
1387: p_usec_teach_resp_ovrd_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_tbl_type,
1388: p_c_rec_status OUT NOCOPY VARCHAR2,
1389: p_calling_context IN VARCHAR2
1390: ) AS
1391: /***********************************************************************************************

Line 1430: PROCEDURE trim_values ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type ) AS

1426:
1427: c_tch_rsp_ovrd_rec c_tch_rsp_ovrd%ROWTYPE;
1428:
1429: /* Private Procedures for create_usec_teach_resp_ovrd */
1430: PROCEDURE trim_values ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type ) AS
1431: BEGIN
1432: p_tch_rsp_ovrd_rec.unit_cd := trim(p_tch_rsp_ovrd_rec.unit_cd);
1433: p_tch_rsp_ovrd_rec.version_number := trim(p_tch_rsp_ovrd_rec.version_number);
1434: p_tch_rsp_ovrd_rec.teach_cal_alternate_code := trim(p_tch_rsp_ovrd_rec.teach_cal_alternate_code);

Line 1443: PROCEDURE validate_parameters ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type ) AS

1439: p_tch_rsp_ovrd_rec.percentage := trim(p_tch_rsp_ovrd_rec.percentage);
1440: END trim_values;
1441:
1442: -- validate parameters passed.
1443: PROCEDURE validate_parameters ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type ) AS
1444: BEGIN
1445:
1446: /* Check for Mandatory Parameters */
1447: IF p_tch_rsp_ovrd_rec.unit_cd IS NULL OR p_tch_rsp_ovrd_rec.unit_cd = FND_API.G_MISS_CHAR THEN

Line 1483: FUNCTION check_insert_update ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type ) RETURN VARCHAR2 IS

1479: END validate_parameters;
1480:
1481:
1482: -- Check for Update
1483: FUNCTION check_insert_update ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type ) RETURN VARCHAR2 IS
1484: CURSOR c_tch_resp_ovrd(p_unit_cd IN VARCHAR2,
1485: p_version_number NUMBER,
1486: p_cal_type VARCHAR2,
1487: p_ci_sequence_number NUMBER,

Line 1528: PROCEDURE validate_derivations ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type ) AS

1524:
1525: END check_insert_update;
1526:
1527: -- Carry out derivations and validate them
1528: PROCEDURE validate_derivations ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type ) AS
1529: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
1530: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
1531: l_c_message VARCHAR2(30);
1532: BEGIN

Line 1566: PROCEDURE validate_db_cons ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type,p_insert_update VARCHAR2 ) AS

1562:
1563: END validate_derivations;
1564:
1565: -- Validate Database Constraints
1566: PROCEDURE validate_db_cons ( p_tch_rsp_ovrd_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_ovrd_rec_type,p_insert_update VARCHAR2 ) AS
1567: BEGIN
1568: IF (p_insert_update = 'I') THEN
1569:
1570: /* Unique Key Validation */

Line 1895: p_usec_ass_item_grp_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_tbl_type,

1891:
1892: /*Unit Section assessment item groups*/
1893:
1894: PROCEDURE create_usec_ass_item_grp(
1895: p_usec_ass_item_grp_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_tbl_type,
1896: p_c_rec_status OUT NOCOPY VARCHAR2,
1897: p_calling_context IN VARCHAR2
1898: ) AS
1899: /***********************************************************************************************

Line 1914: PROCEDURE trim_values ( p_as_us_ai_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS

1910: l_insert_update VARCHAR2(1);
1911:
1912:
1913: /* Private Procedures for create_usec_grd_sch */
1914: PROCEDURE trim_values ( p_as_us_ai_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS
1915: BEGIN
1916: p_as_us_ai_rec.unit_cd := trim(p_as_us_ai_rec.unit_cd);
1917: p_as_us_ai_rec.version_number := trim(p_as_us_ai_rec.version_number);
1918: p_as_us_ai_rec.teach_cal_alternate_code := trim(p_as_us_ai_rec.teach_cal_alternate_code);

Line 1948: PROCEDURE create_group( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS

1944:
1945:
1946: END trim_values;
1947:
1948: PROCEDURE create_group( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS
1949: -- validate parameters passed.
1950: PROCEDURE validate_parameters ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS
1951: BEGIN
1952:

Line 1950: PROCEDURE validate_parameters ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS

1946: END trim_values;
1947:
1948: PROCEDURE create_group( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS
1949: -- validate parameters passed.
1950: PROCEDURE validate_parameters ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS
1951: BEGIN
1952:
1953: /* Check for Mandatory Parameters */
1954: IF p_as_us_ai_group_rec.unit_cd IS NULL OR p_as_us_ai_group_rec.unit_cd = FND_API.G_MISS_CHAR THEN

Line 1984: FUNCTION check_insert_update ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) RETURN VARCHAR2 IS

1980: END validate_parameters;
1981:
1982:
1983: -- Check for Update
1984: FUNCTION check_insert_update ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) RETURN VARCHAR2 IS
1985: CURSOR c_us_ai_group(cp_group_name VARCHAR2 ,cp_n_uoo_id NUMBER) IS
1986: SELECT 'X'
1987: FROM igs_as_us_ai_group
1988: WHERE group_name = cp_group_name

Line 2008: PROCEDURE validate_derivations ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type) AS

2004:
2005: END check_insert_update;
2006:
2007: -- Carry out derivations and validate them
2008: PROCEDURE validate_derivations ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type) AS
2009: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
2010: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
2011: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
2012: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

Line 2060: PROCEDURE Assign_default( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS

2056: p_as_us_ai_group_rec.status := 'E';
2057: END IF;
2058: END validate_derivations;
2059:
2060: PROCEDURE Assign_default( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS
2061:
2062: CURSOR c_us_ai_group(cp_group_name VARCHAR2 ,cp_n_uoo_id NUMBER) IS
2063: SELECT *
2064: FROM igs_as_us_ai_group

Line 2118: PROCEDURE validate_db_cons ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS

2114:
2115: END Assign_default;
2116:
2117: -- Validate Database Constraints
2118: PROCEDURE validate_db_cons ( p_as_us_ai_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS
2119: BEGIN
2120: IF (p_insert_update = 'I') THEN
2121: /* Unique Key Validation */
2122: IF igs_as_us_ai_group_pkg.get_uk_for_validation (x_uoo_id => l_n_uoo_id,

Line 2380: PROCEDURE create_item( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS

2376: END IF;
2377:
2378: END create_group;
2379:
2380: PROCEDURE create_item( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS
2381: CURSOR c_unitass_item(cp_n_uoo_id NUMBER ,cp_assessment_id NUMBER,cp_sequence_number NUMBER) IS
2382: SELECT *
2383: FROM igs_ps_unitass_item
2384: WHERE uoo_id = cp_n_uoo_id

Line 2400: PROCEDURE validate_parameters_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS

2396:
2397: l_n_us_ass_item_group_id igs_ps_unitass_item.us_ass_item_group_id%type;
2398:
2399: -- validate parameters passed.
2400: PROCEDURE validate_parameters_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) AS
2401: BEGIN
2402:
2403: /* Check for Mandatory Parameters */
2404: IF p_unitass_item_rec.assessment_id IS NULL OR p_unitass_item_rec.assessment_id = FND_API.G_MISS_NUM THEN

Line 2421: FUNCTION check_insert_update_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) RETURN VARCHAR2 IS

2417: END validate_parameters_item;
2418:
2419:
2420: -- Check for Update
2421: FUNCTION check_insert_update_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type ) RETURN VARCHAR2 IS
2422: CURSOR c_unitass_item(cp_n_uoo_id NUMBER ,cp_assessment_id NUMBER,cp_sequence_number NUMBER) IS
2423: SELECT 'X'
2424: FROM igs_ps_unitass_item
2425: WHERE uoo_id = cp_n_uoo_id

Line 2444: PROCEDURE validate_derivations_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type) AS

2440:
2441: END check_insert_update_item;
2442:
2443: -- Carry out derivations and validate them
2444: PROCEDURE validate_derivations_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type) AS
2445:
2446: l_c_message VARCHAR2(30);
2447:
2448: CURSOR c_uaig_id(cp_uoo_id NUMBER,cp_group_name VARCHAR2) IS

Line 2476: PROCEDURE Assign_default( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS

2472: CLOSE c_uaig_id;
2473: END IF;
2474: END validate_derivations_item;
2475:
2476: PROCEDURE Assign_default( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS
2477: CURSOR c_unitass_item(cp_n_uoo_id NUMBER ,cp_assessment_id NUMBER,cp_sequence_number NUMBER) IS
2478: SELECT *
2479: FROM igs_ps_unitass_item
2480: WHERE uoo_id = cp_n_uoo_id

Line 2699: PROCEDURE validate_db_cons_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS

2695:
2696: END Assign_default;
2697:
2698: -- Validate Database Constraints
2699: PROCEDURE validate_db_cons_item ( p_unitass_item_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ass_item_grp_rec_type,p_insert_update VARCHAR2 ) AS
2700: CURSOR c_assessment_id(cp_assessment_id igs_as_assessmnt_itm.ass_id%TYPE)IS
2701: SELECT 'X'
2702: FROM igs_as_assessmnt_itm
2703: WHERE ass_id =cp_assessment_id;

Line 3066: p_usec_meet_with_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_tbl_type,

3062: /* END OF UNIT SECTION ASSESMENT ITEM GROUPS */
3063:
3064: --start of Meet with class group
3065: PROCEDURE create_usec_meet_with(
3066: p_usec_meet_with_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_tbl_type,
3067: p_c_rec_status OUT NOCOPY VARCHAR2,
3068: p_calling_context IN VARCHAR2
3069: ) AS
3070: /***********************************************************************************************

Line 3101: PROCEDURE trim_values ( p_usec_meet_with_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS

3097: END ifexists;
3098:
3099:
3100: /* Private Procedures for create_usec_grd_sch */
3101: PROCEDURE trim_values ( p_usec_meet_with_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS
3102: BEGIN
3103: p_usec_meet_with_rec.unit_cd := trim(p_usec_meet_with_rec.unit_cd);
3104: p_usec_meet_with_rec.version_number := trim(p_usec_meet_with_rec.version_number);
3105: p_usec_meet_with_rec.teach_cal_alternate_code := trim(p_usec_meet_with_rec.teach_cal_alternate_code);

Line 3116: PROCEDURE create_uso_cm_grp( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS

3112:
3113: END trim_values;
3114:
3115:
3116: PROCEDURE create_uso_cm_grp( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS
3117:
3118: l_n_tbl_cnt NUMBER;
3119:
3120: PROCEDURE validate_parameters ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS

Line 3120: PROCEDURE validate_parameters ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS

3116: PROCEDURE create_uso_cm_grp( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS
3117:
3118: l_n_tbl_cnt NUMBER;
3119:
3120: PROCEDURE validate_parameters ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS
3121: BEGIN
3122:
3123: /* Check for Mandatory Parameters */
3124: IF p_uso_cm_grp_rec.teach_cal_alternate_code IS NULL OR p_uso_cm_grp_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN

Line 3136: FUNCTION check_insert_update ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) RETURN VARCHAR2 IS

3132:
3133: END validate_parameters;
3134:
3135: -- Check for Update
3136: FUNCTION check_insert_update ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) RETURN VARCHAR2 IS
3137: CURSOR c_uso_cm_grp(cp_cm_grp_name VARCHAR2) IS
3138: SELECT 'X'
3139: FROM igs_ps_uso_cm_grp
3140: WHERE class_meet_group_name =cp_cm_grp_name

Line 3161: PROCEDURE validate_derivations ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type) AS

3157:
3158: END check_insert_update;
3159:
3160: -- Carry out derivations and validate them
3161: PROCEDURE validate_derivations ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type) AS
3162:
3163: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3164: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3165: l_c_message VARCHAR2(30);

Line 3184: PROCEDURE Assign_default( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,p_insert_update VARCHAR2 ) AS

3180:
3181:
3182: END validate_derivations;
3183:
3184: PROCEDURE Assign_default( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,p_insert_update VARCHAR2 ) AS
3185:
3186: CURSOR c_uso_cm_grp(cp_cm_grp_name VARCHAR2) IS
3187: SELECT *
3188: FROM igs_ps_uso_cm_grp

Line 3220: PROCEDURE validate_db_cons ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,p_insert_update VARCHAR2 ) AS

3216:
3217: END Assign_default;
3218:
3219: -- Validate Database Constraints
3220: PROCEDURE validate_db_cons ( p_uso_cm_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,p_insert_update VARCHAR2 ) AS
3221: BEGIN
3222: IF (p_insert_update = 'I') THEN
3223: /* Unique Key Validation */
3224: IF igs_ps_uso_cm_grp_pkg.get_uk_for_validation (x_class_meet_group_name=>p_uso_cm_grp_rec.class_meet_group_name,

Line 3467: PROCEDURE create_uso_clas_meet( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS

3463: END IF;
3464:
3465: END create_uso_cm_grp;
3466:
3467: PROCEDURE create_uso_clas_meet( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS
3468:
3469: PROCEDURE validate_parameters_item ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS
3470: BEGIN
3471:

Line 3469: PROCEDURE validate_parameters_item ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS

3465: END create_uso_cm_grp;
3466:
3467: PROCEDURE create_uso_clas_meet( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS
3468:
3469: PROCEDURE validate_parameters_item ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) AS
3470: BEGIN
3471:
3472: /* Check for Mandatory Parameters */
3473: IF p_uso_clas_meet_rec.unit_cd IS NULL OR p_uso_clas_meet_rec.unit_cd = FND_API.G_MISS_CHAR THEN

Line 3501: FUNCTION check_insert_update_item ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) RETURN VARCHAR2 IS

3497:
3498: END validate_parameters_item;
3499:
3500: -- Check for Update
3501: FUNCTION check_insert_update_item ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type ) RETURN VARCHAR2 IS
3502: CURSOR c_uso_clas_meet(cp_n_uoo_id NUMBER) IS
3503: SELECT 'X'
3504: FROM igs_ps_uso_clas_meet
3505: WHERE uoo_id = cp_n_uoo_id;

Line 3522: PROCEDURE validate_derivations_item ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type) AS

3518:
3519: END check_insert_update_item;
3520:
3521: -- Carry out derivations and validate them
3522: PROCEDURE validate_derivations_item ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type) AS
3523:
3524: l_c_message VARCHAR2(30);
3525:
3526: BEGIN

Line 3547: PROCEDURE validate_db_cons_cm ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,p_insert_update VARCHAR2 ) AS

3543: END validate_derivations_item;
3544:
3545:
3546: -- Validate Database Constraints
3547: PROCEDURE validate_db_cons_cm ( p_uso_clas_meet_rec IN OUT NOCOPY igs_ps_generic_pub.usec_meet_with_rec_type,p_insert_update VARCHAR2 ) AS
3548: BEGIN
3549: IF (p_insert_update = 'I') THEN
3550: /* Unique Key Validation */
3551: IF igs_ps_uso_clas_meet_pkg.get_uk_for_validation (x_uoo_id =>l_n_uoo_id) THEN

Line 3815: p_usec_cross_group_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_tbl_type,

3811: END create_usec_meet_with;
3812:
3813: --This procedure is a sub process to import records of Cross-listed Unit Section Group .
3814: PROCEDURE create_usec_cross_group(
3815: p_usec_cross_group_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_tbl_type,
3816: p_c_rec_status OUT NOCOPY VARCHAR2,
3817: p_calling_context IN VARCHAR2
3818: ) AS
3819: /***********************************************************************************************

Line 3850: PROCEDURE trim_values ( p_usec_cross_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS

3846: END ifexists;
3847:
3848:
3849: /* Private Procedures for create_usec_grd_sch */
3850: PROCEDURE trim_values ( p_usec_cross_group_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS
3851: BEGIN
3852: p_usec_cross_group_rec.unit_cd := trim(p_usec_cross_group_rec.unit_cd);
3853: p_usec_cross_group_rec.version_number := trim(p_usec_cross_group_rec.version_number);
3854: p_usec_cross_group_rec.teach_cal_alternate_code := trim(p_usec_cross_group_rec.teach_cal_alternate_code);

Line 3866: PROCEDURE create_usec_x_grp( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS

3862:
3863: END trim_values;
3864:
3865:
3866: PROCEDURE create_usec_x_grp( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS
3867:
3868: l_n_tbl_cnt NUMBER;
3869:
3870: PROCEDURE validate_parameters ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS

Line 3870: PROCEDURE validate_parameters ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS

3866: PROCEDURE create_usec_x_grp( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS
3867:
3868: l_n_tbl_cnt NUMBER;
3869:
3870: PROCEDURE validate_parameters ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS
3871: BEGIN
3872:
3873: /* Check for Mandatory Parameters */
3874: IF p_usec_x_grp_rec.teach_cal_alternate_code IS NULL OR p_usec_x_grp_rec.teach_cal_alternate_code = FND_API.G_MISS_CHAR THEN

Line 3887: FUNCTION check_insert_update ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) RETURN VARCHAR2 IS

3883:
3884: END validate_parameters;
3885:
3886: -- Check for Update
3887: FUNCTION check_insert_update ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) RETURN VARCHAR2 IS
3888: CURSOR c_usec_x_grp(cp_x_grp_name VARCHAR2) IS
3889: SELECT 'X'
3890: FROM igs_ps_usec_x_grp
3891: WHERE usec_x_listed_group_name = cp_x_grp_name

Line 3908: PROCEDURE validate_derivations ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type) AS

3904: END IF;
3905: END check_insert_update;
3906:
3907: -- Carry out derivations and validate them
3908: PROCEDURE validate_derivations ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type) AS
3909: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
3910: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
3911: l_c_message VARCHAR2(30);
3912: BEGIN

Line 3929: PROCEDURE Assign_default( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,p_insert_update VARCHAR2 ) AS

3925:
3926:
3927: END validate_derivations;
3928:
3929: PROCEDURE Assign_default( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,p_insert_update VARCHAR2 ) AS
3930:
3931: CURSOR c_usec_x_grp(cp_x_grp_name VARCHAR2) IS
3932: SELECT *
3933: FROM igs_ps_usec_x_grp

Line 3970: PROCEDURE validate_db_cons ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,p_insert_update VARCHAR2 ) AS

3966:
3967: END Assign_default;
3968:
3969: -- Validate Database Constraints
3970: PROCEDURE validate_db_cons ( p_usec_x_grp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,p_insert_update VARCHAR2 ) AS
3971: BEGIN
3972: IF (p_insert_update = 'I') THEN
3973: /* Unique Key Validation */
3974: IF igs_ps_usec_x_grp_pkg.get_uk_for_validation (x_usec_x_listed_group_name=>p_usec_x_grp_rec.usec_x_listed_group_name,

Line 4217: PROCEDURE create_usec_x_grpmem( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS

4213: END IF;
4214:
4215: END create_usec_x_grp;
4216:
4217: PROCEDURE create_usec_x_grpmem( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS
4218:
4219:
4220:
4221:

Line 4223: PROCEDURE validate_parameters_item ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS

4219:
4220:
4221:
4222:
4223: PROCEDURE validate_parameters_item ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) AS
4224: BEGIN
4225:
4226: /* Check for Mandatory Parameters */
4227: IF p_usec_x_grpmem.unit_cd IS NULL OR p_usec_x_grpmem.unit_cd = FND_API.G_MISS_CHAR THEN

Line 4255: FUNCTION check_insert_update_item ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) RETURN VARCHAR2 IS

4251:
4252: END validate_parameters_item;
4253:
4254: -- Check for Update
4255: FUNCTION check_insert_update_item ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type ) RETURN VARCHAR2 IS
4256: CURSOR c_usec_x_grpmem(cp_n_uoo_id NUMBER) IS
4257: SELECT 'X'
4258: FROM igs_ps_usec_x_grpmem
4259: WHERE uoo_id = cp_n_uoo_id;

Line 4276: PROCEDURE validate_derivations_item ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type) AS

4272:
4273: END check_insert_update_item;
4274:
4275: -- Carry out derivations and validate them
4276: PROCEDURE validate_derivations_item ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type) AS
4277:
4278: l_c_message VARCHAR2(30);
4279:
4280: BEGIN

Line 4301: PROCEDURE validate_db_cons_cm ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,p_insert_update VARCHAR2 ) AS

4297: END validate_derivations_item;
4298:
4299:
4300: -- Validate Database Constraints
4301: PROCEDURE validate_db_cons_cm ( p_usec_x_grpmem IN OUT NOCOPY igs_ps_generic_pub.usec_cross_group_rec_type,p_insert_update VARCHAR2 ) AS
4302: BEGIN
4303:
4304: IF (p_insert_update = 'I') THEN
4305: /* Unique Key Validation */

Line 4574: p_usec_waitlist_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_tbl_type,

4570:
4571:
4572: --Unit Section Waitlist
4573: PROCEDURE create_usec_waitlist(
4574: p_usec_waitlist_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_tbl_type,
4575: p_c_rec_status OUT NOCOPY VARCHAR2,
4576: p_calling_context IN VARCHAR2
4577: ) AS
4578: /***********************************************************************************************

Line 4597: PROCEDURE trim_values ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS

4593: l_n_wlst_usec_pri_id igs_ps_usec_wlst_pri.unit_sec_waitlist_priority_id%type;
4594: l_tbl_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
4595:
4596: /* Private Procedures for create_usec_waitlist */
4597: PROCEDURE trim_values ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS
4598: BEGIN
4599: p_usec_wlst_rec.unit_cd := trim(p_usec_wlst_rec.unit_cd);
4600: p_usec_wlst_rec.version_number := trim(p_usec_wlst_rec.version_number);
4601: p_usec_wlst_rec.teach_cal_alternate_code := trim(p_usec_wlst_rec.teach_cal_alternate_code);

Line 4612: PROCEDURE create_wlstpri( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS

4608: p_usec_wlst_rec.preference_version := trim(p_usec_wlst_rec.preference_version);
4609:
4610: END trim_values;
4611:
4612: PROCEDURE create_wlstpri( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS
4613:
4614: -- validate parameters passed waitlist Priority
4615: PROCEDURE validate_parameters( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS
4616: BEGIN

Line 4615: PROCEDURE validate_parameters( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS

4611:
4612: PROCEDURE create_wlstpri( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS
4613:
4614: -- validate parameters passed waitlist Priority
4615: PROCEDURE validate_parameters( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS
4616: BEGIN
4617:
4618: /* Check for Mandatory Parameters */
4619: IF p_usec_wlst_rec.unit_cd IS NULL OR p_usec_wlst_rec.unit_cd = FND_API.G_MISS_CHAR THEN

Line 4648: PROCEDURE validate_derivations_pri ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS

4644: END validate_parameters ;
4645:
4646:
4647: --Validate the derivations
4648: PROCEDURE validate_derivations_pri ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
4649: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
4650: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
4651: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
4652: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;

Line 4684: FUNCTION check_insert_update ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_n_wlst_usec_pri_id NUMBER) RETURN VARCHAR2 IS

4680: END IF;
4681: END validate_derivations_pri;
4682:
4683: -- Check for Update
4684: FUNCTION check_insert_update ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_n_wlst_usec_pri_id NUMBER) RETURN VARCHAR2 IS
4685: CURSOR c_usec_wlst_pri(cp_n_uoo_id NUMBER,cp_priority_value VARCHAR2) IS
4686: SELECT 'X'
4687: FROM igs_ps_usec_wlst_pri
4688: WHERE uoo_id = cp_n_uoo_id

Line 4706: PROCEDURE Assign_default(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS

4702: END IF;
4703:
4704: END check_insert_update;
4705:
4706: PROCEDURE Assign_default(p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
4707:
4708: CURSOR c_usprv(cp_n_uoo_id NUMBER,cp_priority_value VARCHAR2) IS
4709: SELECT priority_number
4710: FROM igs_ps_usec_wlst_pri

Line 4733: PROCEDURE validate_db_cons_wlstpri ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS

4729: END IF;
4730: END Assign_default;
4731:
4732: -- Validate Database Constraints for Waitlist seating priority.
4733: PROCEDURE validate_db_cons_wlstpri ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
4734: BEGIN
4735: IF(p_insert_update = 'I') THEN
4736: /* Unique Key Validation */
4737: IF igs_ps_usec_wlst_pri_pkg.get_uk_for_validation ( x_priority_value =>p_usec_wlst_rec.priority_value,

Line 4909: PROCEDURE create_wlstprf( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS

4905: END IF;
4906:
4907: END create_wlstpri;
4908:
4909: PROCEDURE create_wlstprf( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS
4910:
4911: -- validate parameters passed waitlist Priority
4912: PROCEDURE validate_parameters( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS
4913: BEGIN

Line 4912: PROCEDURE validate_parameters( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS

4908:
4909: PROCEDURE create_wlstprf( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS
4910:
4911: -- validate parameters passed waitlist Priority
4912: PROCEDURE validate_parameters( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type ) AS
4913: BEGIN
4914:
4915: /* Check for Mandatory Parameters */
4916: IF p_usec_wlst_rec.preference_order IS NULL OR p_usec_wlst_rec.preference_order = FND_API.G_MISS_NUM THEN

Line 4941: PROCEDURE validate_derivations_prf ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS

4937: END validate_parameters ;
4938:
4939:
4940: -- Carry out derivations and validate them
4941: PROCEDURE validate_derivations_prf ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
4942:
4943: CURSOR c_pri_id(cp_uoo_id NUMBER, cp_priority_value igs_ps_usec_wlst_pri.priority_value%type) IS
4944: SELECT unit_sec_waitlist_priority_id
4945: FROM igs_ps_usec_wlst_pri

Line 4956: FUNCTION check_insert_update ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_n_wlst_usec_pri_id NUMBER) RETURN VARCHAR2 IS

4952: CLOSE c_pri_id;
4953: END validate_derivations_prf;
4954:
4955:
4956: FUNCTION check_insert_update ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_n_wlst_usec_pri_id NUMBER) RETURN VARCHAR2 IS
4957:
4958: CURSOR c_usec_wlst_prf(cp_n_wlst_usec_pri_id NUMBER,cp_preference_code VARCHAR2) IS
4959: SELECT 'X'
4960: FROM igs_ps_usec_wlst_prf

Line 5002: PROCEDURE validate_db_cons_wlstprf ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS

4998: END check_insert_update;
4999:
5000:
5001: -- Validate Database Constraints for waitlist preference.
5002: PROCEDURE validate_db_cons_wlstprf ( p_usec_wlst_rec IN OUT NOCOPY igs_ps_generic_pub.usec_waitlist_rec_type,p_insert_update VARCHAR2 ) AS
5003: CURSOR cur_hzp(cp_preference_code VARCHAR2) IS
5004: SELECT 'x'
5005: FROM hz_parties hp, igs_pe_hz_parties pe
5006: WHERE hp.party_id = pe.party_id

Line 5295: p_usec_notes_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_notes_tbl_type,

5291:
5292:
5293: --Unit Section Notes
5294: PROCEDURE create_usec_notes(
5295: p_usec_notes_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_notes_tbl_type,
5296: p_c_rec_status OUT NOCOPY VARCHAR2,
5297: p_calling_context IN VARCHAR2
5298: ) AS
5299: /***********************************************************************************************

Line 5315: PROCEDURE trim_values ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) AS

5311: l_c_cal_type igs_ps_unit_ofr_opt_all.cal_type%TYPE;
5312: l_n_seq_num igs_ps_unit_ofr_opt_all.ci_sequence_number%TYPE;
5313:
5314: /* Private Procedures for create_usec_notes */
5315: PROCEDURE trim_values ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) AS
5316: BEGIN
5317: p_usec_notes_rec.unit_cd := trim(p_usec_notes_rec.unit_cd);
5318: p_usec_notes_rec.version_number := trim(p_usec_notes_rec.version_number);
5319: p_usec_notes_rec.teach_cal_alternate_code := trim(p_usec_notes_rec.teach_cal_alternate_code);

Line 5329: PROCEDURE validate_parameters ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) AS

5325:
5326: END trim_values;
5327:
5328: -- validate parameters passed.
5329: PROCEDURE validate_parameters ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) AS
5330: BEGIN
5331:
5332: /* Check for Mandatory Parameters */
5333: IF p_usec_notes_rec.unit_cd IS NULL OR p_usec_notes_rec.unit_cd = FND_API.G_MISS_CHAR THEN

Line 5362: FUNCTION check_insert_update ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) RETURN VARCHAR2 IS

5358: END validate_parameters;
5359:
5360:
5361: -- Check for Update
5362: FUNCTION check_insert_update ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) RETURN VARCHAR2 IS
5363:
5364: BEGIN
5365:
5366: IF p_usec_notes_rec.reference_number IS NULL THEN

Line 5374: PROCEDURE validate_derivations ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) AS

5370: END IF;
5371: END check_insert_update;
5372:
5373: -- Carry out derivations and validate them
5374: PROCEDURE validate_derivations ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type ) AS
5375: l_d_start_dt igs_ca_inst_all.start_dt%TYPE;
5376: l_d_end_dt igs_ca_inst_all.end_dt%TYPE;
5377: l_c_message VARCHAR2(30);
5378: BEGIN

Line 5413: PROCEDURE validate_db_cons ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type,p_insert_update VARCHAR2 ) AS

5409:
5410: END validate_derivations;
5411:
5412: -- Validate Database Constraints
5413: PROCEDURE validate_db_cons ( p_usec_notes_rec IN OUT NOCOPY igs_ps_generic_pub.usec_notes_rec_type,p_insert_update VARCHAR2 ) AS
5414: CURSOR cur_ref_num(cp_uoo_id igs_ps_unt_ofr_opt_n.uoo_id%TYPE,
5415: cp_reference_number igs_ps_unt_ofr_opt_n.reference_number%TYPE) IS
5416: SELECT b.note_text
5417: FROM igs_ps_unt_ofr_opt_n a,igs_ge_note b

Line 5676: p_usec_assmnt_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_tbl_type,

5672: END create_usec_notes;
5673:
5674: ---Unit section assesment
5675: PROCEDURE create_usec_assmnt(
5676: p_usec_assmnt_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_tbl_type,
5677: p_c_rec_status OUT NOCOPY VARCHAR2,
5678: p_calling_context IN VARCHAR2
5679: )AS
5680:

Line 5698: PROCEDURE trim_values ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS

5694: l_d_exam_start_time igs_ps_usec_as.exam_start_time%TYPE;
5695: l_d_exam_end_time igs_ps_usec_as.exam_end_time%TYPE;
5696:
5697: /* Private Procedures for create_usec_assmnt */
5698: PROCEDURE trim_values ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS
5699: BEGIN
5700:
5701: p_usec_assmnt_rec.unit_cd := trim(p_usec_assmnt_rec.unit_cd);
5702: p_usec_assmnt_rec.version_number := trim(p_usec_assmnt_rec.version_number);

Line 5716: PROCEDURE validate_parameters ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS

5712:
5713: END trim_values;
5714:
5715: -- validate parameters passed.
5716: PROCEDURE validate_parameters ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS
5717: BEGIN
5718:
5719: /* Check for Mandatory Parameters */
5720: IF p_usec_assmnt_rec.unit_cd IS NULL OR p_usec_assmnt_rec.unit_cd = FND_API.G_MISS_CHAR THEN

Line 5761: FUNCTION check_insert_update ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) RETURN VARCHAR2 IS

5757: END validate_parameters;
5758:
5759:
5760: -- Check for Update
5761: FUNCTION check_insert_update ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) RETURN VARCHAR2 IS
5762: CURSOR c_usec_as(cp_n_uoo_id NUMBER) IS
5763: SELECT 'X'
5764: FROM igs_ps_usec_as
5765: WHERE uoo_id = cp_n_uoo_id;

Line 5781: PROCEDURE validate_derivations ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS

5777: END IF;
5778: END check_insert_update;
5779:
5780: -- Carry out derivations and validate them
5781: PROCEDURE validate_derivations ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type ) AS
5782:
5783: CURSOR c_bld_id ( cp_building_cd igs_ad_building_all.building_cd%TYPE,
5784: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
5785: SELECT building_id

Line 5890: PROCEDURE assign_defaults ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type, p_insert IN VARCHAR2) IS

5886:
5887: END validate_derivations;
5888:
5889:
5890: PROCEDURE assign_defaults ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type, p_insert IN VARCHAR2) IS
5891: CURSOR cur_usec_exam ( cp_uoo_id IN NUMBER) IS
5892: SELECT *
5893: FROM igs_ps_usec_as
5894: WHERE uoo_id = cp_uoo_id;

Line 5936: PROCEDURE validate_db_cons ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type,p_insert_update VARCHAR2 ) AS

5932:
5933: END assign_defaults;
5934:
5935: -- Validate Database Constraints
5936: PROCEDURE validate_db_cons ( p_usec_assmnt_rec IN OUT NOCOPY igs_ps_generic_pub.usec_assmnt_rec_type,p_insert_update VARCHAR2 ) AS
5937: CURSOR c_loc_cd(cp_location_cd igs_ad_location_all.location_cd%TYPE) IS
5938: SELECT 'X'
5939: FROM igs_ad_location_all
5940: WHERE location_cd = cp_location_cd

Line 6199: PROCEDURE create_uso_ins_ovrd(p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type

6195:
6196: END create_usec_assmnt;
6197:
6198:
6199: PROCEDURE create_uso_ins_ovrd(p_tab_uso_ins IN OUT NOCOPY igs_ps_generic_pub.uso_ins_tbl_type
6200: ,p_c_rec_status OUT NOCOPY VARCHAR2
6201: ,p_calling_context IN VARCHAR2) IS
6202: /***********************************************************************************************
6203:

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

6218: l_insert_status BOOLEAN;
6219: l_delete_status BOOLEAN;
6220: l_message_name VARCHAR2(30);
6221:
6222: PROCEDURE trim_values ( p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
6223: BEGIN
6224: p_uso_ins_rec.instructor_person_number := TRIM(p_uso_ins_rec.instructor_person_number);
6225: p_uso_ins_rec.production_uso_id := TRIM(p_uso_ins_rec.production_uso_id);
6226: p_uso_ins_rec.unit_cd := TRIM(p_uso_ins_rec.unit_cd);

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

6237: p_uso_ins_rec.lead_instructor_flag := TRIM(p_uso_ins_rec.lead_instructor_flag);
6238:
6239: END trim_values;
6240:
6241: PROCEDURE validate_parameters(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
6242: /***********************************************************************************************
6243:
6244: Created By: smvk
6245: Date Created By: 20-May-2003

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

6306:
6307:
6308: END validate_parameters;
6309:
6310: PROCEDURE validate_derivation(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
6311: /***********************************************************************************************
6312:
6313: Created By: smvk
6314: Date Created By: 20-May-2003

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

6398:
6399: END IF;
6400: END validate_derivation;
6401:
6402: PROCEDURE validate_db_cons(p_uso_ins_rec IN OUT NOCOPY igs_ps_generic_pub.uso_ins_rec_type) AS
6403: CURSOR c_unit_ver (cp_n_uso_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
6404: SELECT a.unit_cd, a.version_number
6405: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b
6406: WHERE a.uoo_id = b.uoo_id

Line 6756: PROCEDURE create_usec_teach_resp(p_usec_teach_resp_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_tbl_type

6752:
6753:
6754: END create_uso_ins_ovrd;
6755:
6756: PROCEDURE create_usec_teach_resp(p_usec_teach_resp_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_tbl_type
6757: ,p_c_rec_status OUT NOCOPY VARCHAR2
6758: ,p_calling_context IN VARCHAR2) IS
6759: /***********************************************************************************************
6760:

Line 6782: PROCEDURE trim_values ( p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS

6778: instr_index NUMBER);
6779: TYPE usec_sr_tbltype IS TABLE OF usec_sr_rectype INDEX BY BINARY_INTEGER;
6780: v_tab_usec_sr usec_sr_tbltype;
6781:
6782: PROCEDURE trim_values ( p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
6783: BEGIN
6784: p_usec_teach_resp_rec.instructor_person_number := TRIM(p_usec_teach_resp_rec.instructor_person_number);
6785: p_usec_teach_resp_rec.unit_cd := TRIM(p_usec_teach_resp_rec.unit_cd);
6786: p_usec_teach_resp_rec.version_number := TRIM(p_usec_teach_resp_rec.version_number);

Line 6799: PROCEDURE validate_parameters(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS

6795: p_usec_teach_resp_rec.lead_instructor_flag := TRIM(p_usec_teach_resp_rec.lead_instructor_flag);
6796:
6797: END trim_values;
6798:
6799: PROCEDURE validate_parameters(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
6800:
6801: BEGIN
6802: p_usec_teach_resp_rec.status:='S';
6803:

Line 6838: PROCEDURE validate_derivation(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS

6834: END IF;
6835:
6836: END validate_parameters;
6837:
6838: PROCEDURE validate_derivation(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
6839:
6840: l_c_cal_type igs_ca_inst_all.cal_type%TYPE;
6841: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
6842: l_d_start igs_ca_inst_all.start_dt%TYPE;

Line 6877: PROCEDURE validate_db_cons(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS

6873: END IF;
6874:
6875: END validate_derivation;
6876:
6877: PROCEDURE validate_db_cons(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
6878:
6879: BEGIN
6880:
6881: -- Check Constraints

Line 6973: PROCEDURE Assign_default(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS

6969: END IF;
6970:
6971: END validate_db_cons;
6972:
6973: PROCEDURE Assign_default(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
6974: CURSOR cur_resp(cp_n_uoo_id IN NUMBER,cp_n_ins_id IN NUMBER) IS
6975: SELECT *
6976: FROM igs_ps_usec_tch_resp
6977: WHERE instructor_id = cp_n_ins_id

Line 7031: PROCEDURE Business_validation(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS

7027: CLOSE cur_resp;
7028:
7029: END Assign_default;
7030:
7031: PROCEDURE Business_validation(p_usec_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_rec_type) AS
7032: CURSOR c_lead_cnd (cp_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%type) IS
7033: SELECT COUNT(*)
7034: FROM IGS_PS_USEC_TCH_RESP
7035: WHERE lead_instructor_flag='Y'

Line 7145: FUNCTION post_uso_resp_busi (p_usec_teach_resp_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_tbl_type) RETURN BOOLEAN AS

7141:
7142:
7143: END Business_validation;
7144:
7145: FUNCTION post_uso_resp_busi (p_usec_teach_resp_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_teach_resp_tbl_type) RETURN BOOLEAN AS
7146:
7147:
7148: l_tab_uoo igs_ps_create_generic_pkg.uoo_tbl_type;
7149:

Line 7464: PROCEDURE create_usec_sp_fee(p_usec_sp_fee_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_tbl_type

7460:
7461: END create_usec_teach_resp;
7462:
7463:
7464: PROCEDURE create_usec_sp_fee(p_usec_sp_fee_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_tbl_type
7465: ,p_c_rec_status OUT NOCOPY VARCHAR2
7466: ,p_calling_context IN VARCHAR2) IS
7467: /***********************************************************************************************
7468:

Line 7486: PROCEDURE trim_values ( p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) AS

7482: l_n_seq_num igs_ca_inst_all.sequence_number%TYPE;
7483: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
7484: l_insert_update VARCHAR2(1);
7485:
7486: PROCEDURE trim_values ( p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) AS
7487: BEGIN
7488:
7489: p_usec_sp_fee_rec.unit_cd := TRIM(p_usec_sp_fee_rec.unit_cd);
7490: p_usec_sp_fee_rec.version_number := TRIM(p_usec_sp_fee_rec.version_number);

Line 7500: PROCEDURE validate_parameters(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) AS

7496: p_usec_sp_fee_rec.closed_flag := TRIM(p_usec_sp_fee_rec.closed_flag);
7497:
7498: END trim_values;
7499:
7500: PROCEDURE validate_parameters(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) AS
7501:
7502: BEGIN
7503: p_usec_sp_fee_rec.status:='S';
7504:

Line 7543: PROCEDURE validate_derivation(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) AS

7539: END IF;
7540:
7541: END validate_parameters;
7542:
7543: PROCEDURE validate_derivation(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) AS
7544:
7545: l_d_start igs_ca_inst_all.start_dt%TYPE;
7546: l_d_end igs_ca_inst_all.end_dt%TYPE;
7547: l_c_ret_status VARCHAR2(30);

Line 7568: PROCEDURE validate_db_cons(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type,p_insert_update IN VARCHAR2) AS

7564: END IF;
7565:
7566: END validate_derivation;
7567:
7568: PROCEDURE validate_db_cons(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type,p_insert_update IN VARCHAR2) AS
7569:
7570: BEGIN
7571:
7572: IF p_insert_update = 'I' THEN

Line 7631: FUNCTION check_insert_update ( p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) RETURN VARCHAR2 IS

7627:
7628: END validate_db_cons;
7629:
7630: -- Check for Update/Insert
7631: FUNCTION check_insert_update ( p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type) RETURN VARCHAR2 IS
7632:
7633: CURSOR c_sp_fee IS
7634: SELECT 'X'
7635: FROM igs_ps_usec_sp_fees

Line 7655: PROCEDURE Assign_default(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type,p_insert_update IN VARCHAR2) AS

7651: END IF;
7652:
7653: END check_insert_update;
7654:
7655: PROCEDURE Assign_default(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type,p_insert_update IN VARCHAR2) AS
7656: CURSOR cur_sp_fees(cp_n_uoo_id IN NUMBER,cp_c_fee_type IN VARCHAR2) IS
7657: SELECT *
7658: FROM igs_ps_usec_sp_fees
7659: WHERE uoo_id = cp_n_uoo_id

Line 7687: PROCEDURE Business_validation(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type,p_insert_update IN VARCHAR2) AS

7683: END IF;
7684:
7685: END Assign_default;
7686:
7687: PROCEDURE Business_validation(p_usec_sp_fee_rec IN OUT NOCOPY igs_ps_generic_pub.usec_sp_fee_rec_type,p_insert_update IN VARCHAR2) AS
7688:
7689: CURSOR c_fee_type_exists(cp_source_fee_type igs_fi_fee_type.fee_type%TYPE) IS
7690: SELECT ci.cal_type cal_type,ci.sequence_number sequence_number
7691: FROM igs_fi_fee_type ft,

Line 7998: PROCEDURE create_usec_plus_hr(p_usec_plus_hr_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_tbl_type

7994:
7995:
7996: END create_usec_sp_fee;
7997:
7998: PROCEDURE create_usec_plus_hr(p_usec_plus_hr_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_tbl_type
7999: ,p_c_rec_status OUT NOCOPY VARCHAR2
8000: ,p_calling_context IN VARCHAR2) IS
8001: /***********************************************************************************************
8002:

Line 8019: PROCEDURE trim_values ( p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS

8015: l_n_room_id NUMBER;
8016: l_n_ins_id NUMBER;
8017: l_insert_update VARCHAR2(1);
8018:
8019: PROCEDURE trim_values ( p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS
8020: BEGIN
8021:
8022: p_usec_plus_hr_rec.unit_cd := TRIM(p_usec_plus_hr_rec.unit_cd);
8023: p_usec_plus_hr_rec.version_number := TRIM(p_usec_plus_hr_rec.version_number);

Line 8038: PROCEDURE validate_parameters(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS

8034: p_usec_plus_hr_rec.instructor_number := TRIM(p_usec_plus_hr_rec.instructor_number);
8035:
8036: END trim_values;
8037:
8038: PROCEDURE validate_parameters(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS
8039:
8040: BEGIN
8041: p_usec_plus_hr_rec.status:='S';
8042:

Line 8107: PROCEDURE validate_derivation(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS

8103:
8104:
8105: END validate_parameters;
8106:
8107: PROCEDURE validate_derivation(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS
8108: l_c_cal_type VARCHAR2(10);
8109: l_n_seq_num NUMBER;
8110: l_d_start igs_ca_inst_all.start_dt%TYPE;
8111: l_d_end igs_ca_inst_all.end_dt%TYPE;

Line 8184: PROCEDURE validate_db_cons(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type,p_insert_update IN VARCHAR2) AS

8180:
8181:
8182: END validate_derivation;
8183:
8184: PROCEDURE validate_db_cons(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type,p_insert_update IN VARCHAR2) AS
8185:
8186: BEGIN
8187:
8188: IF p_insert_update = 'I' THEN

Line 8270: FUNCTION check_insert_update ( p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) RETURN VARCHAR2 IS

8266:
8267: END validate_db_cons;
8268:
8269: -- Check for Update/Insert
8270: FUNCTION check_insert_update ( p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) RETURN VARCHAR2 IS
8271:
8272: CURSOR c_plus_hr IS
8273: SELECT 'X'
8274: FROM igs_ps_us_unsched_cl

Line 8298: PROCEDURE Assign_default(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type,p_insert_update IN VARCHAR2) AS

8294: END IF;
8295:
8296: END check_insert_update;
8297:
8298: PROCEDURE Assign_default(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type,p_insert_update IN VARCHAR2) AS
8299: CURSOR cur_plus_hr IS
8300: SELECT *
8301: FROM IGS_PS_US_UNSCHED_CL
8302: WHERE uoo_id = l_n_uoo_id

Line 8333: PROCEDURE Business_validation(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS

8329: END IF;
8330:
8331: END Assign_default;
8332:
8333: PROCEDURE Business_validation(p_usec_plus_hr_rec IN OUT NOCOPY igs_ps_generic_pub.usec_plus_hr_rec_type) AS
8334:
8335: l_message_name VARCHAR2(30);
8336: l_preferred_name igs_pe_person.preferred_name%TYPE;
8337: BEGIN

Line 8576: PROCEDURE create_usec_rule(p_usec_rule_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_rule_tbl_type,

8572: END IF;
8573:
8574: END create_usec_plus_hr;
8575:
8576: PROCEDURE create_usec_rule(p_usec_rule_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_rule_tbl_type,
8577: p_c_rec_status OUT NOCOPY VARCHAR2,
8578: p_calling_context IN VARCHAR2) IS
8579: /***********************************************************************************************
8580:

Line 8599: PROCEDURE trim_values ( p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS

8595: l_c_rule_unprocessed VARCHAR2(4500);
8596: l_n_lov_number NUMBER;
8597: l_insert_update VARCHAR2(1);
8598:
8599: PROCEDURE trim_values ( p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS
8600: BEGIN
8601:
8602: p_usec_rule_rec.unit_cd := TRIM(p_usec_rule_rec.unit_cd);
8603: p_usec_rule_rec.version_number := TRIM(p_usec_rule_rec.version_number);

Line 8612: PROCEDURE validate_parameters(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS

8608: p_usec_rule_rec.rule_text := TRIM(p_usec_rule_rec.rule_text);
8609:
8610: END trim_values;
8611:
8612: PROCEDURE validate_parameters(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS
8613:
8614: BEGIN
8615: p_usec_rule_rec.status:='S';
8616:

Line 8655: PROCEDURE validate_derivation(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS

8651: END IF;
8652:
8653: END validate_parameters;
8654:
8655: PROCEDURE validate_derivation(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS
8656: l_c_cal_type VARCHAR2(10);
8657: l_n_seq_num NUMBER;
8658: l_d_start igs_ca_inst_all.start_dt%TYPE;
8659: l_d_end igs_ca_inst_all.end_dt%TYPE;

Line 8683: PROCEDURE validate_db_cons(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type,p_insert_update IN VARCHAR2) AS

8679:
8680:
8681: END validate_derivation;
8682:
8683: PROCEDURE validate_db_cons(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type,p_insert_update IN VARCHAR2) AS
8684:
8685: BEGIN
8686:
8687: IF p_insert_update = 'I' THEN

Line 8713: FUNCTION check_insert_update ( p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) RETURN VARCHAR2 IS

8709:
8710: END validate_db_cons;
8711:
8712: -- Check for Update/Insert
8713: FUNCTION check_insert_update ( p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) RETURN VARCHAR2 IS
8714:
8715: CURSOR c_rule IS
8716: SELECT rul_sequence_number
8717: FROM igs_ps_usec_ru

Line 8736: PROCEDURE Business_validation(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS

8732:
8733: END check_insert_update;
8734:
8735:
8736: PROCEDURE Business_validation(p_usec_rule_rec IN OUT NOCOPY igs_ps_generic_pub.usec_rule_rec_type) AS
8737:
8738: CURSOR cur_rule_check IS
8739: SELECT rc.select_group,rd.rule_description
8740: FROM igs_ru_call rc,igs_ru_description rd

Line 8958: PROCEDURE create_usec_enr_dead(p_usec_enr_dead_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_tbl_type,

8954:
8955: END create_usec_rule;
8956:
8957:
8958: PROCEDURE create_usec_enr_dead(p_usec_enr_dead_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_tbl_type,
8959: p_c_rec_status OUT NOCOPY VARCHAR2,
8960: p_calling_context IN VARCHAR2) IS
8961: /***********************************************************************************************
8962:

Line 8986: PROCEDURE trim_values ( p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS

8982: l_n_offset_days igs_en_nstd_usec_dl.enr_dl_offset_days%TYPE;
8983: l_d_enr_dl_date igs_en_nstd_usec_dl.enr_dl_date%TYPE;
8984: l_insert_update VARCHAR2(1);
8985:
8986: PROCEDURE trim_values ( p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS
8987: BEGIN
8988:
8989: p_usec_enr_dead_rec.unit_cd := TRIM(p_usec_enr_dead_rec.unit_cd);
8990: p_usec_enr_dead_rec.version_number := TRIM(p_usec_enr_dead_rec.version_number);

Line 8999: PROCEDURE validate_parameters( p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS

8995: p_usec_enr_dead_rec.enr_dl_date := TRUNC(p_usec_enr_dead_rec.enr_dl_date);
8996:
8997: END trim_values;
8998:
8999: PROCEDURE validate_parameters( p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS
9000:
9001: BEGIN
9002: p_usec_enr_dead_rec.status:='S';
9003:

Line 9043: PROCEDURE validate_derivation(p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS

9039: END IF;
9040:
9041: END validate_parameters;
9042:
9043: PROCEDURE validate_derivation(p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS
9044:
9045: l_c_cal_type VARCHAR2(10);
9046: l_n_seq_num NUMBER;
9047: l_d_start igs_ca_inst_all.start_dt%TYPE;

Line 9071: PROCEDURE validate_db_cons(p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type,p_insert_update IN VARCHAR2) AS

9067: END IF;
9068:
9069: END validate_derivation;
9070:
9071: PROCEDURE validate_db_cons(p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type,p_insert_update IN VARCHAR2) AS
9072:
9073: BEGIN
9074:
9075: IF p_insert_update = 'I' THEN

Line 9103: FUNCTION check_insert_update ( p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) RETURN VARCHAR2 IS

9099:
9100: END validate_db_cons;
9101:
9102: -- Check for Update/Insert
9103: FUNCTION check_insert_update ( p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) RETURN VARCHAR2 IS
9104:
9105: CURSOR c_enr_dead IS
9106: SELECT 'X'
9107: FROM igs_en_nstd_usec_dl

Line 9126: PROCEDURE Assign_defaults (p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type,p_insert_update IN VARCHAR2) AS

9122: END IF;
9123:
9124: END check_insert_update;
9125:
9126: PROCEDURE Assign_defaults (p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type,p_insert_update IN VARCHAR2) AS
9127:
9128: CURSOR cur_usec(cp_uoo_id IN NUMBER) IS
9129: SELECT owner_org_unit_cd
9130: FROM igs_ps_unit_ofr_opt_all

Line 9265: PROCEDURE Business_validation(p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS

9261: END IF; --insert/update
9262:
9263: END Assign_defaults;
9264:
9265: PROCEDURE Business_validation(p_usec_enr_dead_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dead_rec_type) AS
9266: CURSOR cur_check_ns_usec(cp_n_uoo_id IN NUMBER) IS
9267: SELECT 'X'
9268: FROM igs_ps_unit_ofr_opt_all
9269: WHERE uoo_id = cp_n_uoo_id

Line 9525: PROCEDURE create_usec_enr_dis(p_usec_enr_dis_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_tbl_type,

9521: END IF;
9522:
9523: END create_usec_enr_dead;
9524:
9525: PROCEDURE create_usec_enr_dis(p_usec_enr_dis_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_tbl_type,
9526: p_c_rec_status OUT NOCOPY VARCHAR2,
9527: p_calling_context IN VARCHAR2) IS
9528:
9529: /***********************************************************************************************

Line 9554: PROCEDURE trim_values ( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS

9550: l_n_offset_days igs_en_nstd_usec_dl.enr_dl_offset_days%TYPE;
9551: l_d_enr_dl_date igs_en_nstd_usec_dl.enr_dl_date%TYPE;
9552: l_insert_update VARCHAR2(1);
9553:
9554: PROCEDURE trim_values ( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS
9555: BEGIN
9556:
9557: p_usec_enr_dis_rec.unit_cd := TRIM(p_usec_enr_dis_rec.unit_cd);
9558: p_usec_enr_dis_rec.version_number := TRIM(p_usec_enr_dis_rec.version_number);

Line 9567: PROCEDURE validate_parameters( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS

9563: p_usec_enr_dis_rec.usec_disc_dl_date := TRUNC(p_usec_enr_dis_rec.usec_disc_dl_date);
9564:
9565: END trim_values;
9566:
9567: PROCEDURE validate_parameters( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS
9568:
9569: BEGIN
9570: p_usec_enr_dis_rec.status:='S';
9571:

Line 9606: PROCEDURE validate_derivation(p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS

9602:
9603:
9604: END validate_parameters;
9605:
9606: PROCEDURE validate_derivation(p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS
9607:
9608: l_c_cal_type VARCHAR2(10);
9609: l_n_seq_num NUMBER;
9610: l_d_start igs_ca_inst_all.start_dt%TYPE;

Line 9634: PROCEDURE validate_db_cons(p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type,p_insert_update IN VARCHAR2) AS

9630: END IF;
9631:
9632: END validate_derivation;
9633:
9634: PROCEDURE validate_db_cons(p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type,p_insert_update IN VARCHAR2) AS
9635: CURSOR cur_amd_unit_stat(cp_administrative_unit_status IN igs_ad_adm_unit_stat.administrative_unit_status%TYPE) IS
9636: SELECT 'X'
9637: FROM igs_ad_adm_unit_stat aus
9638: WHERE aus.administrative_unit_status = cp_administrative_unit_status

Line 9682: FUNCTION check_insert_update ( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) RETURN VARCHAR2 IS

9678:
9679: END validate_db_cons;
9680:
9681: -- Check for Update/Insert
9682: FUNCTION check_insert_update ( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) RETURN VARCHAR2 IS
9683:
9684: CURSOR c_enr_disc IS
9685: SELECT 'X'
9686: FROM igs_en_usec_disc_dl

Line 9706: PROCEDURE Assign_defaults ( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type,p_insert_update IN VARCHAR2) AS

9702: END IF;
9703:
9704: END check_insert_update;
9705:
9706: PROCEDURE Assign_defaults ( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type,p_insert_update IN VARCHAR2) AS
9707:
9708: CURSOR cur_usec(cp_uoo_id IN NUMBER) IS
9709: SELECT owner_org_unit_cd
9710: FROM igs_ps_unit_ofr_opt_all

Line 9846: PROCEDURE Business_validation(p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS

9842: END IF; --insert/update
9843:
9844: END Assign_defaults;
9845:
9846: PROCEDURE Business_validation(p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) AS
9847: CURSOR cur_check_ns_usec(cp_n_uoo_id IN NUMBER) IS
9848: SELECT 'X'
9849: FROM igs_ps_unit_ofr_opt_all
9850: WHERE uoo_id = cp_n_uoo_id

Line 10105: PROCEDURE create_usec_ret(p_usec_ret_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ret_tbl_type,

10101:
10102: END create_usec_enr_dis;
10103:
10104:
10105: PROCEDURE create_usec_ret(p_usec_ret_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ret_tbl_type,
10106: p_c_rec_status OUT NOCOPY VARCHAR2,
10107: p_calling_context IN VARCHAR2) IS
10108: /***********************************************************************************************
10109:

Line 10125: PROCEDURE trim_values ( p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) AS

10121: l_n_uoo_id igs_ps_unit_ofr_opt_all.uoo_id%TYPE;
10122: l_n_non_std_usec_rtn_id NUMBER;
10123: l_insert_update VARCHAR2(1);
10124:
10125: PROCEDURE trim_values ( p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) AS
10126: BEGIN
10127:
10128: p_usec_ret_rec.unit_cd := TRIM(p_usec_ret_rec.unit_cd);
10129: p_usec_ret_rec.version_number := TRIM(p_usec_ret_rec.version_number);

Line 10141: PROCEDURE validate_parameters( p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) AS

10137: p_usec_ret_rec.incl_wkend_duration_flag := TRIM(p_usec_ret_rec.incl_wkend_duration_flag);
10138:
10139: END trim_values;
10140:
10141: PROCEDURE validate_parameters( p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) AS
10142:
10143: BEGIN
10144: p_usec_ret_rec.status:='S';
10145:

Line 10211: PROCEDURE validate_derivation(p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) AS

10207: END IF;
10208:
10209: END validate_parameters;
10210:
10211: PROCEDURE validate_derivation(p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) AS
10212:
10213: l_d_start igs_ca_inst_all.start_dt%TYPE;
10214: l_d_end igs_ca_inst_all.end_dt%TYPE;
10215: l_c_ret_status VARCHAR2(30);

Line 10237: PROCEDURE validate_db_cons(p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type,p_insert_update IN VARCHAR2) AS

10233: END IF;
10234:
10235: END validate_derivation;
10236:
10237: PROCEDURE validate_db_cons(p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type,p_insert_update IN VARCHAR2) AS
10238:
10239: BEGIN
10240:
10241: IF p_insert_update = 'I' AND p_usec_ret_rec.definition_level='UNIT_SECTION_FEE_TYPE' THEN

Line 10297: FUNCTION check_insert_update ( p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) RETURN VARCHAR2 IS

10293:
10294: END validate_db_cons;
10295:
10296: -- Check for Update/Insert
10297: FUNCTION check_insert_update ( p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type) RETURN VARCHAR2 IS
10298:
10299: CURSOR c_ret_usec IS
10300: SELECT non_std_usec_rtn_id
10301: FROM igs_ps_nsus_rtn

Line 10337: PROCEDURE Business_validation(p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type,p_insert_update IN VARCHAR2) AS

10333: END IF;
10334:
10335: END check_insert_update;
10336:
10337: PROCEDURE Business_validation(p_usec_ret_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_rec_type,p_insert_update IN VARCHAR2) AS
10338: CURSOR cur_check_ns_usec(cp_n_uoo_id IN NUMBER) IS
10339: SELECT 'X'
10340: FROM igs_ps_unit_ofr_opt_all
10341: WHERE uoo_id = cp_n_uoo_id

Line 10709: PROCEDURE create_usec_ret_dtl(p_usec_ret_dtl_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_tbl_type,

10705: END IF;
10706:
10707: END create_usec_ret;
10708:
10709: PROCEDURE create_usec_ret_dtl(p_usec_ret_dtl_tbl IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_tbl_type,
10710: p_c_rec_status OUT NOCOPY VARCHAR2,
10711: p_calling_context IN VARCHAR2) IS
10712: /***********************************************************************************************
10713:

Line 10727: PROCEDURE trim_values ( p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) AS

10723: l_n_non_std_usec_rtn_id NUMBER;
10724: l_d_offset_date DATE;
10725: l_insert_update VARCHAR2(1);
10726:
10727: PROCEDURE trim_values ( p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) AS
10728: BEGIN
10729:
10730: p_usec_ret_dtl_rec.unit_cd := TRIM(p_usec_ret_dtl_rec.unit_cd);
10731: p_usec_ret_dtl_rec.version_number := TRIM(p_usec_ret_dtl_rec.version_number);

Line 10745: PROCEDURE validate_parameters( p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) AS

10741: p_usec_ret_dtl_rec.offset_date := TRUNC(p_usec_ret_dtl_rec.offset_date);
10742:
10743: END trim_values;
10744:
10745: PROCEDURE validate_parameters( p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) AS
10746:
10747: BEGIN
10748: p_usec_ret_dtl_rec.status:='S';
10749:

Line 10820: PROCEDURE validate_derivation(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) AS

10816: END IF;
10817:
10818: END validate_parameters;
10819:
10820: PROCEDURE validate_derivation(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) AS
10821: l_c_cal_type VARCHAR2(10);
10822: l_n_seq_num NUMBER;
10823: l_d_start igs_ca_inst_all.start_dt%TYPE;
10824: l_d_end igs_ca_inst_all.end_dt%TYPE;

Line 10894: PROCEDURE validate_db_cons(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type,p_insert_update IN VARCHAR2) AS

10890: END IF;
10891:
10892: END validate_derivation;
10893:
10894: PROCEDURE validate_db_cons(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type,p_insert_update IN VARCHAR2) AS
10895:
10896: BEGIN
10897:
10898: IF p_insert_update = 'I' THEN

Line 10968: FUNCTION check_insert_update ( p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) RETURN VARCHAR2 IS

10964:
10965: END validate_db_cons;
10966:
10967: -- Check for Update/Insert
10968: FUNCTION check_insert_update ( p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type) RETURN VARCHAR2 IS
10969:
10970: CURSOR c_ret_det_usec IS
10971: SELECT 'X'
10972: FROM igs_ps_nsus_rtn_dtl

Line 10992: PROCEDURE Assign_defaults(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type,p_insert_update IN VARCHAR2) AS

10988: END IF;
10989:
10990: END check_insert_update;
10991:
10992: PROCEDURE Assign_defaults(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type,p_insert_update IN VARCHAR2) AS
10993: CURSOR cur_ret_det IS
10994: SELECT *
10995: FROM igs_ps_nsus_rtn_dtl
10996: WHERE non_std_usec_rtn_id = l_n_non_std_usec_rtn_id

Line 11024: PROCEDURE Business_validation(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type,p_insert_update IN VARCHAR2) AS

11020: END IF;
11021:
11022: END Assign_defaults;
11023:
11024: PROCEDURE Business_validation(p_usec_ret_dtl_rec IN OUT NOCOPY igs_ps_generic_pub.usec_ret_dtl_rec_type,p_insert_update IN VARCHAR2) AS
11025: CURSOR cur_check_ns_usec(cp_n_uoo_id IN NUMBER) IS
11026: SELECT 'X'
11027: FROM igs_ps_unit_ofr_opt_all
11028: WHERE uoo_id = cp_n_uoo_id