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.

[Home] [Help]

APPS.IGS_PR_PROUT_LGCY_PUB dependencies on IGS_PR_LGCY_SPO_INT

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

1: PACKAGE igs_pr_prout_lgcy_pub AS
2: /* $Header: IGSPPR1S.pls 120.1 2006/01/17 03:54:01 ijeddy noship $ */
3: /*#
4: * The Progression Outcome 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_PR_LGCY_SPO_INT interface table.
6: * @rep:scope public
7: * @rep:product IGS
8: * @rep:displayname Import Legacy Progression Outcome
9: * @rep:lifecycle active

Line 41: person_number igs_pr_lgcy_spo_int.person_number%TYPE,

37: --
38: -- End of comments
39: --
40: TYPE lgcy_prout_rec_type IS RECORD (
41: person_number igs_pr_lgcy_spo_int.person_number%TYPE,
42: program_cd igs_pr_lgcy_spo_int.program_cd%TYPE,
43: prg_cal_alternate_code igs_pr_lgcy_spo_int.prg_cal_alternate_code%TYPE,
44: progression_outcome_type igs_pr_lgcy_spo_int.progression_outcome_type%TYPE,
45: duration igs_pr_lgcy_spo_int.duration%TYPE,

Line 42: program_cd igs_pr_lgcy_spo_int.program_cd%TYPE,

38: -- End of comments
39: --
40: TYPE lgcy_prout_rec_type IS RECORD (
41: person_number igs_pr_lgcy_spo_int.person_number%TYPE,
42: program_cd igs_pr_lgcy_spo_int.program_cd%TYPE,
43: prg_cal_alternate_code igs_pr_lgcy_spo_int.prg_cal_alternate_code%TYPE,
44: progression_outcome_type igs_pr_lgcy_spo_int.progression_outcome_type%TYPE,
45: duration igs_pr_lgcy_spo_int.duration%TYPE,
46: duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,

Line 43: prg_cal_alternate_code igs_pr_lgcy_spo_int.prg_cal_alternate_code%TYPE,

39: --
40: TYPE lgcy_prout_rec_type IS RECORD (
41: person_number igs_pr_lgcy_spo_int.person_number%TYPE,
42: program_cd igs_pr_lgcy_spo_int.program_cd%TYPE,
43: prg_cal_alternate_code igs_pr_lgcy_spo_int.prg_cal_alternate_code%TYPE,
44: progression_outcome_type igs_pr_lgcy_spo_int.progression_outcome_type%TYPE,
45: duration igs_pr_lgcy_spo_int.duration%TYPE,
46: duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,
47: decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,

Line 44: progression_outcome_type igs_pr_lgcy_spo_int.progression_outcome_type%TYPE,

40: TYPE lgcy_prout_rec_type IS RECORD (
41: person_number igs_pr_lgcy_spo_int.person_number%TYPE,
42: program_cd igs_pr_lgcy_spo_int.program_cd%TYPE,
43: prg_cal_alternate_code igs_pr_lgcy_spo_int.prg_cal_alternate_code%TYPE,
44: progression_outcome_type igs_pr_lgcy_spo_int.progression_outcome_type%TYPE,
45: duration igs_pr_lgcy_spo_int.duration%TYPE,
46: duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,
47: decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,
48: decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,

Line 45: duration igs_pr_lgcy_spo_int.duration%TYPE,

41: person_number igs_pr_lgcy_spo_int.person_number%TYPE,
42: program_cd igs_pr_lgcy_spo_int.program_cd%TYPE,
43: prg_cal_alternate_code igs_pr_lgcy_spo_int.prg_cal_alternate_code%TYPE,
44: progression_outcome_type igs_pr_lgcy_spo_int.progression_outcome_type%TYPE,
45: duration igs_pr_lgcy_spo_int.duration%TYPE,
46: duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,
47: decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,
48: decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,
49: decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,

Line 46: duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,

42: program_cd igs_pr_lgcy_spo_int.program_cd%TYPE,
43: prg_cal_alternate_code igs_pr_lgcy_spo_int.prg_cal_alternate_code%TYPE,
44: progression_outcome_type igs_pr_lgcy_spo_int.progression_outcome_type%TYPE,
45: duration igs_pr_lgcy_spo_int.duration%TYPE,
46: duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,
47: decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,
48: decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,
49: decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,
50: show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,

Line 47: decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,

43: prg_cal_alternate_code igs_pr_lgcy_spo_int.prg_cal_alternate_code%TYPE,
44: progression_outcome_type igs_pr_lgcy_spo_int.progression_outcome_type%TYPE,
45: duration igs_pr_lgcy_spo_int.duration%TYPE,
46: duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,
47: decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,
48: decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,
49: decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,
50: show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,
51: show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,

Line 48: decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,

44: progression_outcome_type igs_pr_lgcy_spo_int.progression_outcome_type%TYPE,
45: duration igs_pr_lgcy_spo_int.duration%TYPE,
46: duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,
47: decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,
48: decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,
49: decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,
50: show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,
51: show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,
52: show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,

Line 49: decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,

45: duration igs_pr_lgcy_spo_int.duration%TYPE,
46: duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,
47: decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,
48: decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,
49: decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,
50: show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,
51: show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,
52: show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,
53: show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,

Line 50: show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,

46: duration_type igs_pr_lgcy_spo_int.duration_type%TYPE,
47: decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,
48: decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,
49: decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,
50: show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,
51: show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,
52: show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,
53: show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,
54: appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,

Line 51: show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,

47: decision_status igs_pr_lgcy_spo_int.decision_status%TYPE,
48: decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,
49: decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,
50: show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,
51: show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,
52: show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,
53: show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,
54: appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,
55: appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,

Line 52: show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,

48: decision_dt igs_pr_lgcy_spo_int.decision_dt%TYPE,
49: decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,
50: show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,
51: show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,
52: show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,
53: show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,
54: appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,
55: appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,
56: appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,

Line 53: show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,

49: decision_org_unit_cd igs_pr_lgcy_spo_int.decision_org_unit_cd%TYPE,
50: show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,
51: show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,
52: show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,
53: show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,
54: appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,
55: appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,
56: appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,
57: appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,

Line 54: appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,

50: show_cause_expiry_dt igs_pr_lgcy_spo_int.show_cause_expiry_dt%TYPE,
51: show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,
52: show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,
53: show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,
54: appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,
55: appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,
56: appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,
57: appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,
58: encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,

Line 55: appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,

51: show_cause_dt igs_pr_lgcy_spo_int.show_cause_dt%TYPE,
52: show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,
53: show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,
54: appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,
55: appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,
56: appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,
57: appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,
58: encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,
59: restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,

Line 56: appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,

52: show_cause_outcome_dt igs_pr_lgcy_spo_int.show_cause_outcome_dt%TYPE,
53: show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,
54: appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,
55: appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,
56: appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,
57: appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,
58: encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,
59: restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,
60: restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,

Line 57: appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,

53: show_cause_outcome_type igs_pr_lgcy_spo_int.show_cause_outcome_type%TYPE,
54: appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,
55: appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,
56: appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,
57: appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,
58: encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,
59: restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,
60: restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,
61: comments igs_pr_lgcy_spo_int.comments%TYPE,

Line 58: encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,

54: appeal_expiry_dt igs_pr_lgcy_spo_int.appeal_expiry_dt%TYPE,
55: appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,
56: appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,
57: appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,
58: encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,
59: restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,
60: restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,
61: comments igs_pr_lgcy_spo_int.comments%TYPE,
62: show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,

Line 59: restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,

55: appeal_dt igs_pr_lgcy_spo_int.appeal_dt%TYPE,
56: appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,
57: appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,
58: encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,
59: restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,
60: restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,
61: comments igs_pr_lgcy_spo_int.comments%TYPE,
62: show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,
63: appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,

Line 60: restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,

56: appeal_outcome_dt igs_pr_lgcy_spo_int.appeal_outcome_dt%TYPE,
57: appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,
58: encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,
59: restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,
60: restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,
61: comments igs_pr_lgcy_spo_int.comments%TYPE,
62: show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,
63: appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,
64: expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,

Line 61: comments igs_pr_lgcy_spo_int.comments%TYPE,

57: appeal_outcome_type igs_pr_lgcy_spo_int.appeal_outcome_type%TYPE,
58: encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,
59: restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,
60: restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,
61: comments igs_pr_lgcy_spo_int.comments%TYPE,
62: show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,
63: appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,
64: expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,
65: award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,

Line 62: show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,

58: encmb_program_group_cd igs_pr_lgcy_spo_int.encmb_program_group_cd%TYPE,
59: restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,
60: restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,
61: comments igs_pr_lgcy_spo_int.comments%TYPE,
62: show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,
63: appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,
64: expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,
65: award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,
66: spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,

Line 63: appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,

59: restricted_enrolment_cp igs_pr_lgcy_spo_int.restricted_enrolment_cp%TYPE,
60: restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,
61: comments igs_pr_lgcy_spo_int.comments%TYPE,
62: show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,
63: appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,
64: expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,
65: award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,
66: spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,
67: unit_cd igs_pr_lgcy_spo_int.unit_cd%TYPE,

Line 64: expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,

60: restricted_attendance_type igs_pr_lgcy_spo_int.restricted_attendance_type%TYPE,
61: comments igs_pr_lgcy_spo_int.comments%TYPE,
62: show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,
63: appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,
64: expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,
65: award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,
66: spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,
67: unit_cd igs_pr_lgcy_spo_int.unit_cd%TYPE,
68: s_unit_type igs_pr_lgcy_spo_int.s_unit_type%TYPE,

Line 65: award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,

61: comments igs_pr_lgcy_spo_int.comments%TYPE,
62: show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,
63: appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,
64: expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,
65: award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,
66: spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,
67: unit_cd igs_pr_lgcy_spo_int.unit_cd%TYPE,
68: s_unit_type igs_pr_lgcy_spo_int.s_unit_type%TYPE,
69: unit_set_cd igs_pr_lgcy_spo_int.unit_set_cd%TYPE,

Line 66: spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,

62: show_cause_comments igs_pr_lgcy_spo_int.show_cause_comments%TYPE,
63: appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,
64: expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,
65: award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,
66: spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,
67: unit_cd igs_pr_lgcy_spo_int.unit_cd%TYPE,
68: s_unit_type igs_pr_lgcy_spo_int.s_unit_type%TYPE,
69: unit_set_cd igs_pr_lgcy_spo_int.unit_set_cd%TYPE,
70: us_version_number igs_pr_lgcy_spo_int.us_version_number%TYPE,

Line 67: unit_cd igs_pr_lgcy_spo_int.unit_cd%TYPE,

63: appeal_comments igs_pr_lgcy_spo_int.appeal_comments%TYPE,
64: expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,
65: award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,
66: spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,
67: unit_cd igs_pr_lgcy_spo_int.unit_cd%TYPE,
68: s_unit_type igs_pr_lgcy_spo_int.s_unit_type%TYPE,
69: unit_set_cd igs_pr_lgcy_spo_int.unit_set_cd%TYPE,
70: us_version_number igs_pr_lgcy_spo_int.us_version_number%TYPE,
71: --anilk, Bug# 3021236, adding fund_code

Line 68: s_unit_type igs_pr_lgcy_spo_int.s_unit_type%TYPE,

64: expiry_dt igs_pr_lgcy_spo_int.expiry_dt%TYPE,
65: award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,
66: spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,
67: unit_cd igs_pr_lgcy_spo_int.unit_cd%TYPE,
68: s_unit_type igs_pr_lgcy_spo_int.s_unit_type%TYPE,
69: unit_set_cd igs_pr_lgcy_spo_int.unit_set_cd%TYPE,
70: us_version_number igs_pr_lgcy_spo_int.us_version_number%TYPE,
71: --anilk, Bug# 3021236, adding fund_code
72: fund_code igs_pr_lgcy_spo_int.fund_code%TYPE

Line 69: unit_set_cd igs_pr_lgcy_spo_int.unit_set_cd%TYPE,

65: award_cd igs_pr_lgcy_spo_int.award_cd%TYPE,
66: spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,
67: unit_cd igs_pr_lgcy_spo_int.unit_cd%TYPE,
68: s_unit_type igs_pr_lgcy_spo_int.s_unit_type%TYPE,
69: unit_set_cd igs_pr_lgcy_spo_int.unit_set_cd%TYPE,
70: us_version_number igs_pr_lgcy_spo_int.us_version_number%TYPE,
71: --anilk, Bug# 3021236, adding fund_code
72: fund_code igs_pr_lgcy_spo_int.fund_code%TYPE
73: );

Line 70: us_version_number igs_pr_lgcy_spo_int.us_version_number%TYPE,

66: spo_program_cd igs_pr_lgcy_spo_int.spo_program_cd%TYPE,
67: unit_cd igs_pr_lgcy_spo_int.unit_cd%TYPE,
68: s_unit_type igs_pr_lgcy_spo_int.s_unit_type%TYPE,
69: unit_set_cd igs_pr_lgcy_spo_int.unit_set_cd%TYPE,
70: us_version_number igs_pr_lgcy_spo_int.us_version_number%TYPE,
71: --anilk, Bug# 3021236, adding fund_code
72: fund_code igs_pr_lgcy_spo_int.fund_code%TYPE
73: );
74: --

Line 72: fund_code igs_pr_lgcy_spo_int.fund_code%TYPE

68: s_unit_type igs_pr_lgcy_spo_int.s_unit_type%TYPE,
69: unit_set_cd igs_pr_lgcy_spo_int.unit_set_cd%TYPE,
70: us_version_number igs_pr_lgcy_spo_int.us_version_number%TYPE,
71: --anilk, Bug# 3021236, adding fund_code
72: fund_code igs_pr_lgcy_spo_int.fund_code%TYPE
73: );
74: --
75: /*#
76: * The Progression Outcome Legacy import process is a public API designed for use in populating rows with data during a system conversion.

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

73: );
74: --
75: /*#
76: * The Progression Outcome Legacy import process is a public API designed for use in populating rows with data during a system conversion.
77: * This API is also used by the Legacy Import Process for Enrollment and Records when importing rows from the IGS_PR_LGCY_SPO_INT interface table.
78: * @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.
79: * @param p_init_msg_list Set to FND_API.G_TRUE to have API automatically to initialize message list.
80: * @param p_commit Set to FND_API.G_TRUE to have API to commit automatically.
81: * @param p_validation_level Public API will always perform full level of validation.

Line 85: * @param p_lgcy_prout_rec Legacy Progression Outcome record type. Refer to IGS_PR_LGCY_SPO_INT for detail column descriptions.

81: * @param p_validation_level Public API will always perform full level of validation.
82: * @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.
83: * @param x_msg_count Message count.
84: * @param x_msg_data Message data.
85: * @param p_lgcy_prout_rec Legacy Progression Outcome record type. Refer to IGS_PR_LGCY_SPO_INT for detail column descriptions.
86: * @rep:scope public
87: * @rep:lifecycle active
88: * @rep:displayname Import Legacy Progression Outcome
89: */