APPS.IGS_PR_PROUT_LGCY_PUB dependencies on IGS_PR_STDNT_PR_OU_PKG

Line 299: IF (igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (

295: END IF;
296: --
297: -- Primary Key validation
298: --
299: IF (igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (
300: p_person_id,
301: p_lgcy_prout_rec.program_cd,
302: p_sequence_number
303: )) THEN

Line 313: igs_pr_stdnt_pr_ou_pkg.check_constraints (

309: -- Valid Value Checks
310: --
311: IF (p_lgcy_prout_rec.duration IS NOT NULL) THEN
312: BEGIN
313: igs_pr_stdnt_pr_ou_pkg.check_constraints (
314: 'DURATION',
315: p_lgcy_prout_rec.duration
316: );
317: EXCEPTION

Line 331: igs_pr_stdnt_pr_ou_pkg.check_constraints (

327: END IF;
328: --
329: IF (p_lgcy_prout_rec.restricted_enrolment_cp IS NOT NULL) THEN
330: BEGIN
331: igs_pr_stdnt_pr_ou_pkg.check_constraints (
332: 'RESTRICTED_ENROLMENT_CP',
333: p_lgcy_prout_rec.restricted_enrolment_cp
334: );
335: EXCEPTION

Line 349: igs_pr_stdnt_pr_ou_pkg.check_constraints (

345: END IF;
346: --
347: IF (p_lgcy_prout_rec.duration_type IS NOT NULL) THEN
348: BEGIN
349: igs_pr_stdnt_pr_ou_pkg.check_constraints (
350: 'DURATION_TYPE',
351: p_lgcy_prout_rec.duration_type
352: );
353: EXCEPTION

Line 367: igs_pr_stdnt_pr_ou_pkg.check_constraints (

363: END IF;
364: --
365: IF (p_lgcy_prout_rec.decision_status IS NOT NULL) THEN
366: BEGIN
367: igs_pr_stdnt_pr_ou_pkg.check_constraints (
368: 'DECISION_STATUS',
369: p_lgcy_prout_rec.decision_status
370: );
371: EXCEPTION

Line 385: igs_pr_stdnt_pr_ou_pkg.check_constraints (

381: END IF;
382: --
383: IF (p_lgcy_prout_rec.show_cause_outcome_type IS NOT NULL) THEN
384: BEGIN
385: igs_pr_stdnt_pr_ou_pkg.check_constraints (
386: 'SHOW_CAUSE_OUTCOME_TYPE',
387: p_lgcy_prout_rec.show_cause_outcome_type
388: );
389: EXCEPTION

Line 403: igs_pr_stdnt_pr_ou_pkg.check_constraints (

399: END IF;
400: --
401: IF (p_lgcy_prout_rec.appeal_outcome_type IS NOT NULL) THEN
402: BEGIN
403: igs_pr_stdnt_pr_ou_pkg.check_constraints (
404: 'APPEAL_OUTCOME_TYPE',
405: p_lgcy_prout_rec.appeal_outcome_type
406: );
407: EXCEPTION

Line 919: (NOT igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (

915: --
916: IF ((p_person_id IS NOT NULL) AND
917: (p_lgcy_prout_rec.program_cd IS NOT NULL) AND
918: (p_sequence_number IS NOT NULL) AND
919: (NOT igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (
920: p_person_id,
921: p_lgcy_prout_rec.program_cd,
922: p_sequence_number
923: ))) THEN

Line 1013: (NOT igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (

1009: --
1010: IF ((p_person_id IS NOT NULL) AND
1011: (p_lgcy_prout_rec.program_cd IS NOT NULL) AND
1012: (p_sequence_number IS NOT NULL) AND
1013: (NOT igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (
1014: p_person_id,
1015: p_lgcy_prout_rec.program_cd,
1016: p_sequence_number
1017: ))) THEN

Line 1142: (NOT igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (

1138: --
1139: IF ((p_person_id IS NOT NULL) AND
1140: (p_lgcy_prout_rec.program_cd IS NOT NULL) AND
1141: (p_sequence_number IS NOT NULL) AND
1142: (NOT igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (
1143: p_person_id,
1144: p_lgcy_prout_rec.program_cd,
1145: p_sequence_number
1146: ))) THEN

Line 1261: (NOT igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (

1257: --
1258: IF ((p_person_id IS NOT NULL) AND
1259: (p_lgcy_prout_rec.program_cd IS NOT NULL) AND
1260: (p_sequence_number IS NOT NULL) AND
1261: (NOT igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (
1262: p_person_id,
1263: p_lgcy_prout_rec.program_cd,
1264: p_sequence_number
1265: ))) THEN

Line 1500: IF (NOT igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (

1496: END IF;
1497: --
1498: -- Create an entry in the Student Program Outcome table is does not already exist
1499: --
1500: IF (NOT igs_pr_stdnt_pr_ou_pkg.get_pk_for_validation (
1501: l_person_id,
1502: p_lgcy_prout_rec.program_cd,
1503: l_outcome_sequence_number
1504: )) THEN

Line 1506: igs_pr_stdnt_pr_ou_pkg.insert_row (

1502: p_lgcy_prout_rec.program_cd,
1503: l_outcome_sequence_number
1504: )) THEN
1505: l_rowid := NULL;
1506: igs_pr_stdnt_pr_ou_pkg.insert_row (
1507: x_rowid => l_rowid,
1508: x_person_id => l_person_id,
1509: x_course_cd => p_lgcy_prout_rec.program_cd,
1510: x_sequence_number => l_outcome_sequence_number,