DBA Data[Home] [Help]

APPS.IGS_PR_PROUT_LGCY_PUB dependencies on IGS_PE_HZ_PARTIES

Line 90: p_org_start_dt OUT NOCOPY igs_pe_hz_parties.ou_start_dt%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
93: --
94: CURSOR cur_sequence_number IS

Line 235: p_org_start_dt IN igs_pe_hz_parties.ou_start_dt%TYPE

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: --
239: x_return_value BOOLEAN := FND_API.TO_BOOLEAN (FND_API.G_TRUE);

Line 433: p_decision_ou_start_dt IN igs_pe_hz_parties.ou_start_dt%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: --
436: CURSOR cur_sca IS
437: SELECT course_attempt_status

Line 1414: l_org_start_dt igs_pe_hz_parties.ou_start_dt%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;
1417: l_rowid VARCHAR2(25);
1418: --