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_PR_PROUT_LGCY_PUB dependencies on IGS_PR_STDNT_PR_OU

Line 88: p_outcome_sequence_number OUT NOCOPY igs_pr_stdnt_pr_ou_all.sequence_number%TYPE,

84: p_lgcy_prout_rec IN OUT NOCOPY lgcy_prout_rec_type,
85: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
86: p_prg_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
87: p_prg_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
88: p_outcome_sequence_number OUT NOCOPY igs_pr_stdnt_pr_ou_all.sequence_number%TYPE,
89: p_hold_effect_type OUT NOCOPY igs_fi_enc_dflt_eft.s_encmb_effect_type%TYPE,
90: p_org_start_dt OUT NOCOPY igs_pe_hz_parties.ou_start_dt%TYPE,
91: x_return_value OUT NOCOPY BOOLEAN
92: ) IS

Line 96: FROM igs_pr_stdnt_pr_ou_all

92: ) IS
93: --
94: CURSOR cur_sequence_number IS
95: SELECT sequence_number
96: FROM igs_pr_stdnt_pr_ou_all
97: WHERE person_id = p_person_id
98: AND progression_outcome_type = p_lgcy_prout_rec.progression_outcome_type
99: AND course_cd = p_lgcy_prout_rec.program_cd
100: AND prg_cal_type = p_prg_cal_type

Line 171: -- igs_pr_stdnt_pr_ou_all.sequence_number else assign the new sequence value

167: -- Derive the Outcome Sequence Number.
168: -- Check for the existance of Student Progression Outcome in OSS which
169: -- matches with the record in interface table. If the record exists then
170: -- assign p_outcome_sequence_number with
171: -- igs_pr_stdnt_pr_ou_all.sequence_number else assign the new sequence value
172: -- from igs_pr_spo_seq_num_s sequence.
173: --
174: OPEN cur_sequence_number;
175: FETCH cur_sequence_number INTO p_outcome_sequence_number;

Line 234: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE,

230: --
231: FUNCTION validate_spo_db_cons (
232: p_lgcy_prout_rec IN lgcy_prout_rec_type,
233: p_person_id IN igs_pe_person.person_id%TYPE,
234: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE,
235: p_org_start_dt IN igs_pe_hz_parties.ou_start_dt%TYPE
236:
237: ) RETURN BOOLEAN IS
238: --

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 424: -- the table IGS_PR_STDNT_PR_OU.

420: --
421: END validate_spo_db_cons;
422: --
423: -- This function validates all the business rules before inserting a record in
424: -- the table IGS_PR_STDNT_PR_OU.
425: --
426: FUNCTION validate_stdnt_prg_otcm (
427: p_lgcy_prout_rec IN lgcy_prout_rec_type,
428: p_person_id IN igs_pe_person.person_id%TYPE,

Line 431: p_outcome_sequence_number IN igs_pr_stdnt_pr_ou_all.sequence_number%TYPE,

427: p_lgcy_prout_rec IN lgcy_prout_rec_type,
428: p_person_id IN igs_pe_person.person_id%TYPE,
429: p_prg_cal_type IN igs_ca_inst.cal_type%TYPE,
430: p_prg_sequence_number IN igs_ca_inst.sequence_number%TYPE,
431: p_outcome_sequence_number IN igs_pr_stdnt_pr_ou_all.sequence_number%TYPE,
432: p_hold_effect_type IN VARCHAR2,
433: p_decision_ou_start_dt IN igs_pe_hz_parties.ou_start_dt%TYPE
434: ) RETURN BOOLEAN IS
435: --

Line 895: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE

891: --
892: FUNCTION validate_prg_db_cons (
893: p_lgcy_prout_rec IN lgcy_prout_rec_type,
894: p_person_id IN igs_pe_person.person_id%TYPE,
895: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE
896: ) RETURN BOOLEAN IS
897: --
898: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
899: --

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 987: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE

983: --
984: FUNCTION validate_uset_db_cons (
985: p_lgcy_prout_rec IN lgcy_prout_rec_type,
986: p_person_id IN igs_pe_person.person_id%TYPE,
987: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE
988: ) RETURN BOOLEAN IS
989: --
990: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
991: --

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 1052: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE,

1048: --
1049: FUNCTION validate_unit_set (
1050: p_lgcy_prout_rec IN lgcy_prout_rec_type,
1051: p_person_id IN igs_pe_person.person_id%TYPE,
1052: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE,
1053: p_hold_effect_type IN VARCHAR2
1054: ) RETURN BOOLEAN IS
1055: --
1056: CURSOR cur_us_uss IS

Line 1118: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE

1114: --
1115: FUNCTION validate_unit_db_cons (
1116: p_lgcy_prout_rec IN lgcy_prout_rec_type,
1117: p_person_id IN igs_pe_person.person_id%TYPE,
1118: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE
1119: ) RETURN BOOLEAN IS
1120: --
1121: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
1122: --

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 1237: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE

1233: --
1234: FUNCTION validate_awd_db_cons (
1235: p_lgcy_prout_rec IN lgcy_prout_rec_type,
1236: p_person_id IN igs_pe_person.person_id%TYPE,
1237: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE
1238: ) RETURN BOOLEAN IS
1239: --
1240: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
1241: --

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 1355: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE

1351: --
1352: FUNCTION validate_fnd_db_cons (
1353: p_lgcy_prout_rec IN lgcy_prout_rec_type,
1354: p_person_id IN igs_pe_person.person_id%TYPE,
1355: p_sequence_number IN igs_pr_stdnt_pr_ou.sequence_number%TYPE
1356: ) RETURN BOOLEAN IS
1357: --
1358: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);
1359: --

Line 1412: l_outcome_sequence_number igs_pr_stdnt_pr_ou_all.sequence_number%TYPE;

1408: -- Local params
1409: l_person_id igs_pe_person.person_id%TYPE;
1410: l_prg_cal_type igs_ca_inst.cal_type%TYPE;
1411: l_prg_sequence_number igs_ca_inst.sequence_number%TYPE;
1412: l_outcome_sequence_number igs_pr_stdnt_pr_ou_all.sequence_number%TYPE;
1413: l_hold_effect_type VARCHAR2(2000);
1414: l_org_start_dt igs_pe_hz_parties.ou_start_dt%TYPE;
1415: l_return_value VARCHAR2(1);
1416: l_return_boolean_value BOOLEAN;

Line 1483: -- Validate all the business rules before inserting a record IGS_PR_STDNT_PR_OU

1479: x_return_status := FND_API.G_RET_STS_ERROR;
1480: RAISE FND_API.G_EXC_ERROR;
1481: END IF;
1482: --
1483: -- Validate all the business rules before inserting a record IGS_PR_STDNT_PR_OU
1484: --
1485: IF (NOT validate_stdnt_prg_otcm (
1486: p_lgcy_prout_rec => p_lgcy_prout_rec,
1487: p_person_id => l_person_id,

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,