DBA Data[Home] [Help]

APPS.IGS_AS_TRNCMT_LGCY_PUB dependencies on IGS_AS_LGCY_STC_INT

Line 5: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AS_LGCY_STC_INT interface table.

1: PACKAGE igs_as_trncmt_lgcy_pub AS
2: /* $Header: IGSAS56S.pls 120.1 2006/01/17 03:52:12 ijeddy noship $ */
3: /*#
4: * The Transcript Comments import process is a public API designed for use in populating rows with data during a system conversion.
5: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AS_LGCY_STC_INT interface table.
6: * @rep:scope public
7: * @rep:product IGS
8: * @rep:displayname Import Legacy Transcript Comment
9: * @rep:lifecycle active

Line 26: comment_type_code igs_as_lgcy_stc_int.comment_type_code%TYPE,

22: || (reverse chronological order - newest change first)
23: ******************************************************************************/
24:
25: TYPE lgcy_trncmt_rec_type IS RECORD (
26: comment_type_code igs_as_lgcy_stc_int.comment_type_code%TYPE,
27: comment_txt igs_as_lgcy_stc_int.comment_txt%TYPE,
28: person_number igs_as_lgcy_stc_int.person_number%TYPE,
29: program_cd igs_as_lgcy_stc_int.program_cd%TYPE,
30: program_type igs_as_lgcy_stc_int.program_type%TYPE,

Line 27: comment_txt igs_as_lgcy_stc_int.comment_txt%TYPE,

23: ******************************************************************************/
24:
25: TYPE lgcy_trncmt_rec_type IS RECORD (
26: comment_type_code igs_as_lgcy_stc_int.comment_type_code%TYPE,
27: comment_txt igs_as_lgcy_stc_int.comment_txt%TYPE,
28: person_number igs_as_lgcy_stc_int.person_number%TYPE,
29: program_cd igs_as_lgcy_stc_int.program_cd%TYPE,
30: program_type igs_as_lgcy_stc_int.program_type%TYPE,
31: award_cd igs_as_lgcy_stc_int.award_cd%TYPE,

Line 28: person_number igs_as_lgcy_stc_int.person_number%TYPE,

24:
25: TYPE lgcy_trncmt_rec_type IS RECORD (
26: comment_type_code igs_as_lgcy_stc_int.comment_type_code%TYPE,
27: comment_txt igs_as_lgcy_stc_int.comment_txt%TYPE,
28: person_number igs_as_lgcy_stc_int.person_number%TYPE,
29: program_cd igs_as_lgcy_stc_int.program_cd%TYPE,
30: program_type igs_as_lgcy_stc_int.program_type%TYPE,
31: award_cd igs_as_lgcy_stc_int.award_cd%TYPE,
32: load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,

Line 29: program_cd igs_as_lgcy_stc_int.program_cd%TYPE,

25: TYPE lgcy_trncmt_rec_type IS RECORD (
26: comment_type_code igs_as_lgcy_stc_int.comment_type_code%TYPE,
27: comment_txt igs_as_lgcy_stc_int.comment_txt%TYPE,
28: person_number igs_as_lgcy_stc_int.person_number%TYPE,
29: program_cd igs_as_lgcy_stc_int.program_cd%TYPE,
30: program_type igs_as_lgcy_stc_int.program_type%TYPE,
31: award_cd igs_as_lgcy_stc_int.award_cd%TYPE,
32: load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,
33: unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,

Line 30: program_type igs_as_lgcy_stc_int.program_type%TYPE,

26: comment_type_code igs_as_lgcy_stc_int.comment_type_code%TYPE,
27: comment_txt igs_as_lgcy_stc_int.comment_txt%TYPE,
28: person_number igs_as_lgcy_stc_int.person_number%TYPE,
29: program_cd igs_as_lgcy_stc_int.program_cd%TYPE,
30: program_type igs_as_lgcy_stc_int.program_type%TYPE,
31: award_cd igs_as_lgcy_stc_int.award_cd%TYPE,
32: load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,
33: unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,
34: us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,

Line 31: award_cd igs_as_lgcy_stc_int.award_cd%TYPE,

27: comment_txt igs_as_lgcy_stc_int.comment_txt%TYPE,
28: person_number igs_as_lgcy_stc_int.person_number%TYPE,
29: program_cd igs_as_lgcy_stc_int.program_cd%TYPE,
30: program_type igs_as_lgcy_stc_int.program_type%TYPE,
31: award_cd igs_as_lgcy_stc_int.award_cd%TYPE,
32: load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,
33: unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,
34: us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,
35: unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,

Line 32: load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,

28: person_number igs_as_lgcy_stc_int.person_number%TYPE,
29: program_cd igs_as_lgcy_stc_int.program_cd%TYPE,
30: program_type igs_as_lgcy_stc_int.program_type%TYPE,
31: award_cd igs_as_lgcy_stc_int.award_cd%TYPE,
32: load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,
33: unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,
34: us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,
35: unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,
36: version_number igs_as_lgcy_stc_int.version_number%TYPE,

Line 33: unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,

29: program_cd igs_as_lgcy_stc_int.program_cd%TYPE,
30: program_type igs_as_lgcy_stc_int.program_type%TYPE,
31: award_cd igs_as_lgcy_stc_int.award_cd%TYPE,
32: load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,
33: unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,
34: us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,
35: unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,
36: version_number igs_as_lgcy_stc_int.version_number%TYPE,
37: teach_cal_alternate_cd igs_as_lgcy_stc_int.teach_cal_alternate_cd%TYPE,

Line 34: us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,

30: program_type igs_as_lgcy_stc_int.program_type%TYPE,
31: award_cd igs_as_lgcy_stc_int.award_cd%TYPE,
32: load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,
33: unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,
34: us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,
35: unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,
36: version_number igs_as_lgcy_stc_int.version_number%TYPE,
37: teach_cal_alternate_cd igs_as_lgcy_stc_int.teach_cal_alternate_cd%TYPE,
38: location_cd igs_as_lgcy_stc_int.location_cd%TYPE,

Line 35: unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,

31: award_cd igs_as_lgcy_stc_int.award_cd%TYPE,
32: load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,
33: unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,
34: us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,
35: unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,
36: version_number igs_as_lgcy_stc_int.version_number%TYPE,
37: teach_cal_alternate_cd igs_as_lgcy_stc_int.teach_cal_alternate_cd%TYPE,
38: location_cd igs_as_lgcy_stc_int.location_cd%TYPE,
39: unit_class igs_as_lgcy_stc_int.unit_class%TYPE

Line 36: version_number igs_as_lgcy_stc_int.version_number%TYPE,

32: load_cal_alternate_cd igs_as_lgcy_stc_int.load_cal_alternate_cd%TYPE,
33: unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,
34: us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,
35: unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,
36: version_number igs_as_lgcy_stc_int.version_number%TYPE,
37: teach_cal_alternate_cd igs_as_lgcy_stc_int.teach_cal_alternate_cd%TYPE,
38: location_cd igs_as_lgcy_stc_int.location_cd%TYPE,
39: unit_class igs_as_lgcy_stc_int.unit_class%TYPE
40: );

Line 37: teach_cal_alternate_cd igs_as_lgcy_stc_int.teach_cal_alternate_cd%TYPE,

33: unit_set_cd igs_as_lgcy_stc_int.unit_set_cd%TYPE,
34: us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,
35: unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,
36: version_number igs_as_lgcy_stc_int.version_number%TYPE,
37: teach_cal_alternate_cd igs_as_lgcy_stc_int.teach_cal_alternate_cd%TYPE,
38: location_cd igs_as_lgcy_stc_int.location_cd%TYPE,
39: unit_class igs_as_lgcy_stc_int.unit_class%TYPE
40: );
41:

Line 38: location_cd igs_as_lgcy_stc_int.location_cd%TYPE,

34: us_version_number igs_as_lgcy_stc_int.us_version_number%TYPE,
35: unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,
36: version_number igs_as_lgcy_stc_int.version_number%TYPE,
37: teach_cal_alternate_cd igs_as_lgcy_stc_int.teach_cal_alternate_cd%TYPE,
38: location_cd igs_as_lgcy_stc_int.location_cd%TYPE,
39: unit_class igs_as_lgcy_stc_int.unit_class%TYPE
40: );
41:
42: /*#

Line 39: unit_class igs_as_lgcy_stc_int.unit_class%TYPE

35: unit_cd igs_as_lgcy_stc_int.unit_cd%TYPE,
36: version_number igs_as_lgcy_stc_int.version_number%TYPE,
37: teach_cal_alternate_cd igs_as_lgcy_stc_int.teach_cal_alternate_cd%TYPE,
38: location_cd igs_as_lgcy_stc_int.location_cd%TYPE,
39: unit_class igs_as_lgcy_stc_int.unit_class%TYPE
40: );
41:
42: /*#
43: * The Transcript Comments import process is a public API designed for use in populating rows with data during a system conversion.

Line 44: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AS_LGCY_STC_INT interface table.

40: );
41:
42: /*#
43: * The Transcript Comments import process is a public API designed for use in populating rows with data during a system conversion.
44: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AS_LGCY_STC_INT interface table.
45: * @param p_api_version The version number will be used to compare with claim public api's current version number.Unexpected error is raised if version in-compatibility exists.
46: * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
47: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
48: * @param p_validation_level Public API will always perform full level of validation.

Line 49: * @param p_lgcy_trncmt_rec Legacy Transcript Comment record type. Refer to IGS_AS_LGCY_STC_INT for detail column descriptions.

45: * @param p_api_version The version number will be used to compare with claim public api's current version number.Unexpected error is raised if version in-compatibility exists.
46: * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
47: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
48: * @param p_validation_level Public API will always perform full level of validation.
49: * @param p_lgcy_trncmt_rec Legacy Transcript Comment record type. Refer to IGS_AS_LGCY_STC_INT for detail column descriptions.
50: * @param x_return_status The return status values are as follows; Success - FND_API.G_RET_STS_SUCCESS ; Error - FND_API.G_RET_STS_ERROR ; Unexpected error - FND_API.G_RET_STS_UNEXP_ERROR.
51: * @param x_msg_count Message count.
52: * @param x_msg_data Message data.
53: * @rep:scope public