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_AS_SUARC_LGCY_PUB dependencies on IGS_AS_LGCY_SUARC_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_SUARC_INT interface table.

1: PACKAGE IGS_AS_SUARC_LGCY_PUB AS
2: /* $Header: IGSPAS2S.pls 120.2 2006/01/17 03:52:49 ijeddy noship $ */
3: /*#
4: * The Unit Attempt Reference Codes Legacy 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_SUARC_INT interface table.
6: * @rep:scope public
7: * @rep:product IGS
8: * @rep:displayname Import Legacy Student Unit Attempt Reference Codes
9: * @rep:lifecycle active

Line 30: | Record type of the table IGS_AS_LGCY_SUARC_INT |

26: ************************************************************************************************/
27: TYPE sua_refcd_rec_type IS RECORD
28: /*===========================================================================+
29: | Object Type |
30: | Record type of the table IGS_AS_LGCY_SUARC_INT |
31: | |
32: | DESCRIPTION |
33: | Record type of the table IGS_AS_LGCY_SUARC_INT | |
34: | SCOPE - PUBLIC |

Line 33: | Record type of the table IGS_AS_LGCY_SUARC_INT | |

29: | Object Type |
30: | Record type of the table IGS_AS_LGCY_SUARC_INT |
31: | |
32: | DESCRIPTION |
33: | Record type of the table IGS_AS_LGCY_SUARC_INT | |
34: | SCOPE - PUBLIC |
35: | |
36: | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
37: | |

Line 45: person_number IGS_AS_LGCY_SUARC_INT.person_number%TYPE ,

41: | bradhakr 02-Jul-2005 |
42: | MODIFICATION HISTORY |
43: +===========================================================================*/
44: (
45: person_number IGS_AS_LGCY_SUARC_INT.person_number%TYPE ,
46: program_cd IGS_AS_LGCY_SUARC_INT.program_cd%TYPE ,
47: unit_cd IGS_AS_LGCY_SUARC_INT.unit_cd%TYPE ,
48: version_number IGS_AS_LGCY_SUARC_INT.version_number%TYPE ,
49: teach_cal_alt_code IGS_AS_LGCY_SUARC_INT.teach_cal_alt_code%TYPE ,

Line 46: program_cd IGS_AS_LGCY_SUARC_INT.program_cd%TYPE ,

42: | MODIFICATION HISTORY |
43: +===========================================================================*/
44: (
45: person_number IGS_AS_LGCY_SUARC_INT.person_number%TYPE ,
46: program_cd IGS_AS_LGCY_SUARC_INT.program_cd%TYPE ,
47: unit_cd IGS_AS_LGCY_SUARC_INT.unit_cd%TYPE ,
48: version_number IGS_AS_LGCY_SUARC_INT.version_number%TYPE ,
49: teach_cal_alt_code IGS_AS_LGCY_SUARC_INT.teach_cal_alt_code%TYPE ,
50: location_cd IGS_AS_LGCY_SUARC_INT.location_cd%TYPE ,

Line 47: unit_cd IGS_AS_LGCY_SUARC_INT.unit_cd%TYPE ,

43: +===========================================================================*/
44: (
45: person_number IGS_AS_LGCY_SUARC_INT.person_number%TYPE ,
46: program_cd IGS_AS_LGCY_SUARC_INT.program_cd%TYPE ,
47: unit_cd IGS_AS_LGCY_SUARC_INT.unit_cd%TYPE ,
48: version_number IGS_AS_LGCY_SUARC_INT.version_number%TYPE ,
49: teach_cal_alt_code IGS_AS_LGCY_SUARC_INT.teach_cal_alt_code%TYPE ,
50: location_cd IGS_AS_LGCY_SUARC_INT.location_cd%TYPE ,
51: unit_class IGS_AS_LGCY_SUARC_INT.unit_class%TYPE ,

Line 48: version_number IGS_AS_LGCY_SUARC_INT.version_number%TYPE ,

44: (
45: person_number IGS_AS_LGCY_SUARC_INT.person_number%TYPE ,
46: program_cd IGS_AS_LGCY_SUARC_INT.program_cd%TYPE ,
47: unit_cd IGS_AS_LGCY_SUARC_INT.unit_cd%TYPE ,
48: version_number IGS_AS_LGCY_SUARC_INT.version_number%TYPE ,
49: teach_cal_alt_code IGS_AS_LGCY_SUARC_INT.teach_cal_alt_code%TYPE ,
50: location_cd IGS_AS_LGCY_SUARC_INT.location_cd%TYPE ,
51: unit_class IGS_AS_LGCY_SUARC_INT.unit_class%TYPE ,
52: reference_cd_type IGS_AS_LGCY_SUARC_INT.reference_cd_type%TYPE ,

Line 49: teach_cal_alt_code IGS_AS_LGCY_SUARC_INT.teach_cal_alt_code%TYPE ,

45: person_number IGS_AS_LGCY_SUARC_INT.person_number%TYPE ,
46: program_cd IGS_AS_LGCY_SUARC_INT.program_cd%TYPE ,
47: unit_cd IGS_AS_LGCY_SUARC_INT.unit_cd%TYPE ,
48: version_number IGS_AS_LGCY_SUARC_INT.version_number%TYPE ,
49: teach_cal_alt_code IGS_AS_LGCY_SUARC_INT.teach_cal_alt_code%TYPE ,
50: location_cd IGS_AS_LGCY_SUARC_INT.location_cd%TYPE ,
51: unit_class IGS_AS_LGCY_SUARC_INT.unit_class%TYPE ,
52: reference_cd_type IGS_AS_LGCY_SUARC_INT.reference_cd_type%TYPE ,
53: reference_cd IGS_AS_LGCY_SUARC_INT.reference_cd%TYPE ,

Line 50: location_cd IGS_AS_LGCY_SUARC_INT.location_cd%TYPE ,

46: program_cd IGS_AS_LGCY_SUARC_INT.program_cd%TYPE ,
47: unit_cd IGS_AS_LGCY_SUARC_INT.unit_cd%TYPE ,
48: version_number IGS_AS_LGCY_SUARC_INT.version_number%TYPE ,
49: teach_cal_alt_code IGS_AS_LGCY_SUARC_INT.teach_cal_alt_code%TYPE ,
50: location_cd IGS_AS_LGCY_SUARC_INT.location_cd%TYPE ,
51: unit_class IGS_AS_LGCY_SUARC_INT.unit_class%TYPE ,
52: reference_cd_type IGS_AS_LGCY_SUARC_INT.reference_cd_type%TYPE ,
53: reference_cd IGS_AS_LGCY_SUARC_INT.reference_cd%TYPE ,
54: applied_program_cd IGS_AS_LGCY_SUARC_INT.applied_program_cd%TYPE ,

Line 51: unit_class IGS_AS_LGCY_SUARC_INT.unit_class%TYPE ,

47: unit_cd IGS_AS_LGCY_SUARC_INT.unit_cd%TYPE ,
48: version_number IGS_AS_LGCY_SUARC_INT.version_number%TYPE ,
49: teach_cal_alt_code IGS_AS_LGCY_SUARC_INT.teach_cal_alt_code%TYPE ,
50: location_cd IGS_AS_LGCY_SUARC_INT.location_cd%TYPE ,
51: unit_class IGS_AS_LGCY_SUARC_INT.unit_class%TYPE ,
52: reference_cd_type IGS_AS_LGCY_SUARC_INT.reference_cd_type%TYPE ,
53: reference_cd IGS_AS_LGCY_SUARC_INT.reference_cd%TYPE ,
54: applied_program_cd IGS_AS_LGCY_SUARC_INT.applied_program_cd%TYPE ,
55: import_status IGS_AS_LGCY_SUARC_INT.import_status%TYPE

Line 52: reference_cd_type IGS_AS_LGCY_SUARC_INT.reference_cd_type%TYPE ,

48: version_number IGS_AS_LGCY_SUARC_INT.version_number%TYPE ,
49: teach_cal_alt_code IGS_AS_LGCY_SUARC_INT.teach_cal_alt_code%TYPE ,
50: location_cd IGS_AS_LGCY_SUARC_INT.location_cd%TYPE ,
51: unit_class IGS_AS_LGCY_SUARC_INT.unit_class%TYPE ,
52: reference_cd_type IGS_AS_LGCY_SUARC_INT.reference_cd_type%TYPE ,
53: reference_cd IGS_AS_LGCY_SUARC_INT.reference_cd%TYPE ,
54: applied_program_cd IGS_AS_LGCY_SUARC_INT.applied_program_cd%TYPE ,
55: import_status IGS_AS_LGCY_SUARC_INT.import_status%TYPE
56: );

Line 53: reference_cd IGS_AS_LGCY_SUARC_INT.reference_cd%TYPE ,

49: teach_cal_alt_code IGS_AS_LGCY_SUARC_INT.teach_cal_alt_code%TYPE ,
50: location_cd IGS_AS_LGCY_SUARC_INT.location_cd%TYPE ,
51: unit_class IGS_AS_LGCY_SUARC_INT.unit_class%TYPE ,
52: reference_cd_type IGS_AS_LGCY_SUARC_INT.reference_cd_type%TYPE ,
53: reference_cd IGS_AS_LGCY_SUARC_INT.reference_cd%TYPE ,
54: applied_program_cd IGS_AS_LGCY_SUARC_INT.applied_program_cd%TYPE ,
55: import_status IGS_AS_LGCY_SUARC_INT.import_status%TYPE
56: );
57: PROCEDURE validate_parameters(p_suarc_dtls_rec IN sua_refcd_rec_type );

Line 54: applied_program_cd IGS_AS_LGCY_SUARC_INT.applied_program_cd%TYPE ,

50: location_cd IGS_AS_LGCY_SUARC_INT.location_cd%TYPE ,
51: unit_class IGS_AS_LGCY_SUARC_INT.unit_class%TYPE ,
52: reference_cd_type IGS_AS_LGCY_SUARC_INT.reference_cd_type%TYPE ,
53: reference_cd IGS_AS_LGCY_SUARC_INT.reference_cd%TYPE ,
54: applied_program_cd IGS_AS_LGCY_SUARC_INT.applied_program_cd%TYPE ,
55: import_status IGS_AS_LGCY_SUARC_INT.import_status%TYPE
56: );
57: PROCEDURE validate_parameters(p_suarc_dtls_rec IN sua_refcd_rec_type );
58: /*===========================================================================+

Line 55: import_status IGS_AS_LGCY_SUARC_INT.import_status%TYPE

51: unit_class IGS_AS_LGCY_SUARC_INT.unit_class%TYPE ,
52: reference_cd_type IGS_AS_LGCY_SUARC_INT.reference_cd_type%TYPE ,
53: reference_cd IGS_AS_LGCY_SUARC_INT.reference_cd%TYPE ,
54: applied_program_cd IGS_AS_LGCY_SUARC_INT.applied_program_cd%TYPE ,
55: import_status IGS_AS_LGCY_SUARC_INT.import_status%TYPE
56: );
57: PROCEDURE validate_parameters(p_suarc_dtls_rec IN sua_refcd_rec_type );
58: /*===========================================================================+
59: | PROCEDURE |

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

109: | MODIFICATION HISTORY |
110: +===========================================================================*/
111: /*#
112: * The Unit Attempt Reference Codes Legacy import process is a public API designed for use in populating rows with data during a system conversion.
113: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_AS_LGCY_SUARC_INT interface table.
114: * @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.
115: * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
116: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
117: * @param p_validation_level Public API will always perform full level of validation.

Line 118: * @param p_suarc_dtls_rec Legacy Unit Attempt Reference Code record type. Refer to IGS_AS_LGCY_SUARC_INT for detail column descriptions.

114: * @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.
115: * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
116: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
117: * @param p_validation_level Public API will always perform full level of validation.
118: * @param p_suarc_dtls_rec Legacy Unit Attempt Reference Code record type. Refer to IGS_AS_LGCY_SUARC_INT for detail column descriptions.
119: * @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.
120: * @param x_msg_count Message count.
121: * @param x_msg_data Message data.
122: * @rep:scope public