DBA Data[Home] [Help]

APPS.IGS_AS_SUAO_LGCY_PUB dependencies on IGS_PE_PERSON

Line 54: p_person_id IN OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE ,

50: */
51:
52: FUNCTION derive_unit_outcome_data (
53: p_lgcy_suo_rec IN OUT NOCOPY LGCY_SUO_REC_TYPE ,
54: p_person_id IN OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE ,
55: p_cal_type IN OUT NOCOPY IGS_CA_INST.CAL_TYPE%TYPE ,
56: p_sequence_number IN OUT NOCOPY IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
57: p_start_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_START_DT%TYPE ,
58: p_end_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_END_DT%TYPE ,

Line 78: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,

74: Performs all data integrity validations on the table igs_as_su_stmptout_all
75: It is called from the procedure create_unit_outcome.
76: */
77: FUNCTION validate_suao_db_cons (
78: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
79: p_lgcy_suo_rec IN LGCY_SUO_REC_TYPE ,
80: p_cal_type IN IGS_CA_INST.CAL_TYPE%TYPE ,
81: p_sequence_number IN IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
82: p_translated_version_number IN IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,

Line 111: p_person_id IGS_PE_PERSON.PERSON_ID%TYPE ,

107: Called from the procedure create_unit_outcome
108: */
109:
110: PROCEDURE create_post_unit_outcome (
111: p_person_id IGS_PE_PERSON.PERSON_ID%TYPE ,
112: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
113: p_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
114: p_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ,
115: p_lgcy_suo_rec LGCY_SUO_REC_TYPE

Line 235: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE ;

231: *************************************************************************************************************************/
232: IS
233: l_api_name CONSTANT VARCHAR2(30) := 'create_unit_outcome' ;
234: l_api_version CONSTANT NUMBER := 1.0 ;
235: l_person_id IGS_PE_PERSON.PERSON_ID%TYPE ;
236: l_cal_type IGS_CA_INST.CAL_TYPE%TYPE ;
237: l_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ;
238: l_start_dt IGS_AS_SU_STMPTOUT_ALL.CI_START_DT%TYPE ;
239: l_end_dt IGS_AS_SU_STMPTOUT_ALL.CI_END_DT%TYPE ;

Line 958: p_person_id IN OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE ,

954:
955:
956: FUNCTION derive_unit_outcome_data (
957: p_lgcy_suo_rec IN OUT NOCOPY LGCY_SUO_REC_TYPE ,
958: p_person_id IN OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE ,
959: p_cal_type IN OUT NOCOPY IGS_CA_INST.CAL_TYPE%TYPE ,
960: p_sequence_number IN OUT NOCOPY IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
961: p_start_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_START_DT%TYPE ,
962: p_end_dt OUT NOCOPY IGS_AS_SU_STMPTOUT_ALL.CI_END_DT%TYPE ,

Line 1447: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,

1443:
1444: END derive_unit_outcome_data;
1445:
1446: FUNCTION validate_suao_db_cons (
1447: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
1448: p_lgcy_suo_rec IN LGCY_SUO_REC_TYPE ,
1449: p_cal_type IN IGS_CA_INST.CAL_TYPE%TYPE ,
1450: p_sequence_number IN IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
1451: p_translated_version_number IN IGS_AS_SU_STMPTOUT_ALL.TRANSLATED_VERSION_NUMBER%TYPE ,

Line 1815: p_person_id IGS_PE_PERSON.PERSON_ID%TYPE ,

1811:
1812: END validate_unit_outcome;
1813:
1814: PROCEDURE create_post_unit_outcome (
1815: p_person_id IGS_PE_PERSON.PERSON_ID%TYPE ,
1816: p_cal_type IGS_CA_INST.CAL_TYPE%TYPE ,
1817: p_sequence_number IGS_CA_INST.SEQUENCE_NUMBER%TYPE ,
1818: p_unit_attempt_status IGS_EN_SU_ATTEMPT_ALL.UNIT_ATTEMPT_STATUS%TYPE ,
1819: p_lgcy_suo_rec LGCY_SUO_REC_TYPE