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.PQP_RIW_COURSE_WRAPPER dependencies on HR_API

Line 30: l_course_rec.activity_id := hr_api.g_number;

26: g_date constant date := to_date('01-01-4712', 'DD-MM-SYYYY');
27: ==========================================================================
28: */
29: Hr_Utility.set_location(' Before : ', 5);
30: l_course_rec.activity_id := hr_api.g_number;
31: l_course_rec.superseded_by_act_version_id := hr_api.g_number;
32: l_course_rec.developer_organization_id := hr_api.g_number;
33: l_course_rec.controlling_person_id := hr_api.g_number;
34:

Line 31: l_course_rec.superseded_by_act_version_id := hr_api.g_number;

27: ==========================================================================
28: */
29: Hr_Utility.set_location(' Before : ', 5);
30: l_course_rec.activity_id := hr_api.g_number;
31: l_course_rec.superseded_by_act_version_id := hr_api.g_number;
32: l_course_rec.developer_organization_id := hr_api.g_number;
33: l_course_rec.controlling_person_id := hr_api.g_number;
34:
35: l_course_rec.version_name := hr_api.g_varchar2;

Line 32: l_course_rec.developer_organization_id := hr_api.g_number;

28: */
29: Hr_Utility.set_location(' Before : ', 5);
30: l_course_rec.activity_id := hr_api.g_number;
31: l_course_rec.superseded_by_act_version_id := hr_api.g_number;
32: l_course_rec.developer_organization_id := hr_api.g_number;
33: l_course_rec.controlling_person_id := hr_api.g_number;
34:
35: l_course_rec.version_name := hr_api.g_varchar2;
36: Hr_Utility.set_location(' l_course_rec.version_name: '||l_course_rec.version_name, 5);

Line 33: l_course_rec.controlling_person_id := hr_api.g_number;

29: Hr_Utility.set_location(' Before : ', 5);
30: l_course_rec.activity_id := hr_api.g_number;
31: l_course_rec.superseded_by_act_version_id := hr_api.g_number;
32: l_course_rec.developer_organization_id := hr_api.g_number;
33: l_course_rec.controlling_person_id := hr_api.g_number;
34:
35: l_course_rec.version_name := hr_api.g_varchar2;
36: Hr_Utility.set_location(' l_course_rec.version_name: '||l_course_rec.version_name, 5);
37: l_course_rec.comments := hr_api.g_varchar2;

Line 35: l_course_rec.version_name := hr_api.g_varchar2;

31: l_course_rec.superseded_by_act_version_id := hr_api.g_number;
32: l_course_rec.developer_organization_id := hr_api.g_number;
33: l_course_rec.controlling_person_id := hr_api.g_number;
34:
35: l_course_rec.version_name := hr_api.g_varchar2;
36: Hr_Utility.set_location(' l_course_rec.version_name: '||l_course_rec.version_name, 5);
37: l_course_rec.comments := hr_api.g_varchar2;
38: Hr_Utility.set_location(' l_course_rec.comments: '||l_course_rec.comments, 5);
39: l_course_rec.description := hr_api.g_varchar2;

Line 37: l_course_rec.comments := hr_api.g_varchar2;

33: l_course_rec.controlling_person_id := hr_api.g_number;
34:
35: l_course_rec.version_name := hr_api.g_varchar2;
36: Hr_Utility.set_location(' l_course_rec.version_name: '||l_course_rec.version_name, 5);
37: l_course_rec.comments := hr_api.g_varchar2;
38: Hr_Utility.set_location(' l_course_rec.comments: '||l_course_rec.comments, 5);
39: l_course_rec.description := hr_api.g_varchar2;
40: Hr_Utility.set_location(' l_course_rec.description: '||l_course_rec.description, 5);
41: l_course_rec.duration_units := hr_api.g_varchar2;

Line 39: l_course_rec.description := hr_api.g_varchar2;

35: l_course_rec.version_name := hr_api.g_varchar2;
36: Hr_Utility.set_location(' l_course_rec.version_name: '||l_course_rec.version_name, 5);
37: l_course_rec.comments := hr_api.g_varchar2;
38: Hr_Utility.set_location(' l_course_rec.comments: '||l_course_rec.comments, 5);
39: l_course_rec.description := hr_api.g_varchar2;
40: Hr_Utility.set_location(' l_course_rec.description: '||l_course_rec.description, 5);
41: l_course_rec.duration_units := hr_api.g_varchar2;
42: Hr_Utility.set_location(' l_course_rec.duration_units: '||l_course_rec.expenses_allowed, 5);
43: -- l_course_rec.duration := hr_api.g_number;

Line 41: l_course_rec.duration_units := hr_api.g_varchar2;

37: l_course_rec.comments := hr_api.g_varchar2;
38: Hr_Utility.set_location(' l_course_rec.comments: '||l_course_rec.comments, 5);
39: l_course_rec.description := hr_api.g_varchar2;
40: Hr_Utility.set_location(' l_course_rec.description: '||l_course_rec.description, 5);
41: l_course_rec.duration_units := hr_api.g_varchar2;
42: Hr_Utility.set_location(' l_course_rec.duration_units: '||l_course_rec.expenses_allowed, 5);
43: -- l_course_rec.duration := hr_api.g_number;
44: Hr_Utility.set_location(' l_course_rec.duration: '||l_course_rec.duration, 5);
45: l_course_rec.end_date := hr_api.g_date;

Line 43: -- l_course_rec.duration := hr_api.g_number;

39: l_course_rec.description := hr_api.g_varchar2;
40: Hr_Utility.set_location(' l_course_rec.description: '||l_course_rec.description, 5);
41: l_course_rec.duration_units := hr_api.g_varchar2;
42: Hr_Utility.set_location(' l_course_rec.duration_units: '||l_course_rec.expenses_allowed, 5);
43: -- l_course_rec.duration := hr_api.g_number;
44: Hr_Utility.set_location(' l_course_rec.duration: '||l_course_rec.duration, 5);
45: l_course_rec.end_date := hr_api.g_date;
46: l_course_rec.intended_audience := hr_api.g_varchar2;
47: l_course_rec.language_id := hr_api.g_number;

Line 45: l_course_rec.end_date := hr_api.g_date;

41: l_course_rec.duration_units := hr_api.g_varchar2;
42: Hr_Utility.set_location(' l_course_rec.duration_units: '||l_course_rec.expenses_allowed, 5);
43: -- l_course_rec.duration := hr_api.g_number;
44: Hr_Utility.set_location(' l_course_rec.duration: '||l_course_rec.duration, 5);
45: l_course_rec.end_date := hr_api.g_date;
46: l_course_rec.intended_audience := hr_api.g_varchar2;
47: l_course_rec.language_id := hr_api.g_number;
48: l_course_rec.maximum_attendees := hr_api.g_number;
49: l_course_rec.minimum_attendees := hr_api.g_number;

Line 46: l_course_rec.intended_audience := hr_api.g_varchar2;

42: Hr_Utility.set_location(' l_course_rec.duration_units: '||l_course_rec.expenses_allowed, 5);
43: -- l_course_rec.duration := hr_api.g_number;
44: Hr_Utility.set_location(' l_course_rec.duration: '||l_course_rec.duration, 5);
45: l_course_rec.end_date := hr_api.g_date;
46: l_course_rec.intended_audience := hr_api.g_varchar2;
47: l_course_rec.language_id := hr_api.g_number;
48: l_course_rec.maximum_attendees := hr_api.g_number;
49: l_course_rec.minimum_attendees := hr_api.g_number;
50: l_course_rec.objectives := hr_api.g_varchar2;

Line 47: l_course_rec.language_id := hr_api.g_number;

43: -- l_course_rec.duration := hr_api.g_number;
44: Hr_Utility.set_location(' l_course_rec.duration: '||l_course_rec.duration, 5);
45: l_course_rec.end_date := hr_api.g_date;
46: l_course_rec.intended_audience := hr_api.g_varchar2;
47: l_course_rec.language_id := hr_api.g_number;
48: l_course_rec.maximum_attendees := hr_api.g_number;
49: l_course_rec.minimum_attendees := hr_api.g_number;
50: l_course_rec.objectives := hr_api.g_varchar2;
51: Hr_Utility.set_location(' l_course_rec.objectives: '||l_course_rec.expenses_allowed, 5);

Line 48: l_course_rec.maximum_attendees := hr_api.g_number;

44: Hr_Utility.set_location(' l_course_rec.duration: '||l_course_rec.duration, 5);
45: l_course_rec.end_date := hr_api.g_date;
46: l_course_rec.intended_audience := hr_api.g_varchar2;
47: l_course_rec.language_id := hr_api.g_number;
48: l_course_rec.maximum_attendees := hr_api.g_number;
49: l_course_rec.minimum_attendees := hr_api.g_number;
50: l_course_rec.objectives := hr_api.g_varchar2;
51: Hr_Utility.set_location(' l_course_rec.objectives: '||l_course_rec.expenses_allowed, 5);
52: l_course_rec.start_date := hr_api.g_date;

Line 49: l_course_rec.minimum_attendees := hr_api.g_number;

45: l_course_rec.end_date := hr_api.g_date;
46: l_course_rec.intended_audience := hr_api.g_varchar2;
47: l_course_rec.language_id := hr_api.g_number;
48: l_course_rec.maximum_attendees := hr_api.g_number;
49: l_course_rec.minimum_attendees := hr_api.g_number;
50: l_course_rec.objectives := hr_api.g_varchar2;
51: Hr_Utility.set_location(' l_course_rec.objectives: '||l_course_rec.expenses_allowed, 5);
52: l_course_rec.start_date := hr_api.g_date;
53: l_course_rec.success_criteria := hr_api.g_varchar2;

Line 50: l_course_rec.objectives := hr_api.g_varchar2;

46: l_course_rec.intended_audience := hr_api.g_varchar2;
47: l_course_rec.language_id := hr_api.g_number;
48: l_course_rec.maximum_attendees := hr_api.g_number;
49: l_course_rec.minimum_attendees := hr_api.g_number;
50: l_course_rec.objectives := hr_api.g_varchar2;
51: Hr_Utility.set_location(' l_course_rec.objectives: '||l_course_rec.expenses_allowed, 5);
52: l_course_rec.start_date := hr_api.g_date;
53: l_course_rec.success_criteria := hr_api.g_varchar2;
54: l_course_rec.user_status := hr_api.g_varchar2;

Line 52: l_course_rec.start_date := hr_api.g_date;

48: l_course_rec.maximum_attendees := hr_api.g_number;
49: l_course_rec.minimum_attendees := hr_api.g_number;
50: l_course_rec.objectives := hr_api.g_varchar2;
51: Hr_Utility.set_location(' l_course_rec.objectives: '||l_course_rec.expenses_allowed, 5);
52: l_course_rec.start_date := hr_api.g_date;
53: l_course_rec.success_criteria := hr_api.g_varchar2;
54: l_course_rec.user_status := hr_api.g_varchar2;
55: l_course_rec.vendor_id := hr_api.g_number;
56: l_course_rec.actual_cost := hr_api.g_number;

Line 53: l_course_rec.success_criteria := hr_api.g_varchar2;

49: l_course_rec.minimum_attendees := hr_api.g_number;
50: l_course_rec.objectives := hr_api.g_varchar2;
51: Hr_Utility.set_location(' l_course_rec.objectives: '||l_course_rec.expenses_allowed, 5);
52: l_course_rec.start_date := hr_api.g_date;
53: l_course_rec.success_criteria := hr_api.g_varchar2;
54: l_course_rec.user_status := hr_api.g_varchar2;
55: l_course_rec.vendor_id := hr_api.g_number;
56: l_course_rec.actual_cost := hr_api.g_number;
57: l_course_rec.budget_cost := hr_api.g_number;

Line 54: l_course_rec.user_status := hr_api.g_varchar2;

50: l_course_rec.objectives := hr_api.g_varchar2;
51: Hr_Utility.set_location(' l_course_rec.objectives: '||l_course_rec.expenses_allowed, 5);
52: l_course_rec.start_date := hr_api.g_date;
53: l_course_rec.success_criteria := hr_api.g_varchar2;
54: l_course_rec.user_status := hr_api.g_varchar2;
55: l_course_rec.vendor_id := hr_api.g_number;
56: l_course_rec.actual_cost := hr_api.g_number;
57: l_course_rec.budget_cost := hr_api.g_number;
58: l_course_rec.budget_currency_code := hr_api.g_varchar2;

Line 55: l_course_rec.vendor_id := hr_api.g_number;

51: Hr_Utility.set_location(' l_course_rec.objectives: '||l_course_rec.expenses_allowed, 5);
52: l_course_rec.start_date := hr_api.g_date;
53: l_course_rec.success_criteria := hr_api.g_varchar2;
54: l_course_rec.user_status := hr_api.g_varchar2;
55: l_course_rec.vendor_id := hr_api.g_number;
56: l_course_rec.actual_cost := hr_api.g_number;
57: l_course_rec.budget_cost := hr_api.g_number;
58: l_course_rec.budget_currency_code := hr_api.g_varchar2;
59: l_course_rec.expenses_allowed := hr_api.g_varchar2;

Line 56: l_course_rec.actual_cost := hr_api.g_number;

52: l_course_rec.start_date := hr_api.g_date;
53: l_course_rec.success_criteria := hr_api.g_varchar2;
54: l_course_rec.user_status := hr_api.g_varchar2;
55: l_course_rec.vendor_id := hr_api.g_number;
56: l_course_rec.actual_cost := hr_api.g_number;
57: l_course_rec.budget_cost := hr_api.g_number;
58: l_course_rec.budget_currency_code := hr_api.g_varchar2;
59: l_course_rec.expenses_allowed := hr_api.g_varchar2;
60:

Line 57: l_course_rec.budget_cost := hr_api.g_number;

53: l_course_rec.success_criteria := hr_api.g_varchar2;
54: l_course_rec.user_status := hr_api.g_varchar2;
55: l_course_rec.vendor_id := hr_api.g_number;
56: l_course_rec.actual_cost := hr_api.g_number;
57: l_course_rec.budget_cost := hr_api.g_number;
58: l_course_rec.budget_currency_code := hr_api.g_varchar2;
59: l_course_rec.expenses_allowed := hr_api.g_varchar2;
60:
61: l_course_rec.professional_credit_type := hr_api.g_varchar2;

Line 58: l_course_rec.budget_currency_code := hr_api.g_varchar2;

54: l_course_rec.user_status := hr_api.g_varchar2;
55: l_course_rec.vendor_id := hr_api.g_number;
56: l_course_rec.actual_cost := hr_api.g_number;
57: l_course_rec.budget_cost := hr_api.g_number;
58: l_course_rec.budget_currency_code := hr_api.g_varchar2;
59: l_course_rec.expenses_allowed := hr_api.g_varchar2;
60:
61: l_course_rec.professional_credit_type := hr_api.g_varchar2;
62: l_course_rec.professional_credits := hr_api.g_number;

Line 59: l_course_rec.expenses_allowed := hr_api.g_varchar2;

55: l_course_rec.vendor_id := hr_api.g_number;
56: l_course_rec.actual_cost := hr_api.g_number;
57: l_course_rec.budget_cost := hr_api.g_number;
58: l_course_rec.budget_currency_code := hr_api.g_varchar2;
59: l_course_rec.expenses_allowed := hr_api.g_varchar2;
60:
61: l_course_rec.professional_credit_type := hr_api.g_varchar2;
62: l_course_rec.professional_credits := hr_api.g_number;
63: l_course_rec.maximum_internal_attendees := hr_api.g_number;

Line 61: l_course_rec.professional_credit_type := hr_api.g_varchar2;

57: l_course_rec.budget_cost := hr_api.g_number;
58: l_course_rec.budget_currency_code := hr_api.g_varchar2;
59: l_course_rec.expenses_allowed := hr_api.g_varchar2;
60:
61: l_course_rec.professional_credit_type := hr_api.g_varchar2;
62: l_course_rec.professional_credits := hr_api.g_number;
63: l_course_rec.maximum_internal_attendees := hr_api.g_number;
64: l_course_rec.tav_information_category := hr_api.g_varchar2;
65: l_course_rec.tav_information1 := hr_api.g_varchar2;

Line 62: l_course_rec.professional_credits := hr_api.g_number;

58: l_course_rec.budget_currency_code := hr_api.g_varchar2;
59: l_course_rec.expenses_allowed := hr_api.g_varchar2;
60:
61: l_course_rec.professional_credit_type := hr_api.g_varchar2;
62: l_course_rec.professional_credits := hr_api.g_number;
63: l_course_rec.maximum_internal_attendees := hr_api.g_number;
64: l_course_rec.tav_information_category := hr_api.g_varchar2;
65: l_course_rec.tav_information1 := hr_api.g_varchar2;
66: l_course_rec.tav_information2 := hr_api.g_varchar2;

Line 63: l_course_rec.maximum_internal_attendees := hr_api.g_number;

59: l_course_rec.expenses_allowed := hr_api.g_varchar2;
60:
61: l_course_rec.professional_credit_type := hr_api.g_varchar2;
62: l_course_rec.professional_credits := hr_api.g_number;
63: l_course_rec.maximum_internal_attendees := hr_api.g_number;
64: l_course_rec.tav_information_category := hr_api.g_varchar2;
65: l_course_rec.tav_information1 := hr_api.g_varchar2;
66: l_course_rec.tav_information2 := hr_api.g_varchar2;
67: l_course_rec.tav_information3 := hr_api.g_varchar2;

Line 64: l_course_rec.tav_information_category := hr_api.g_varchar2;

60:
61: l_course_rec.professional_credit_type := hr_api.g_varchar2;
62: l_course_rec.professional_credits := hr_api.g_number;
63: l_course_rec.maximum_internal_attendees := hr_api.g_number;
64: l_course_rec.tav_information_category := hr_api.g_varchar2;
65: l_course_rec.tav_information1 := hr_api.g_varchar2;
66: l_course_rec.tav_information2 := hr_api.g_varchar2;
67: l_course_rec.tav_information3 := hr_api.g_varchar2;
68: l_course_rec.tav_information4 := hr_api.g_varchar2;

Line 65: l_course_rec.tav_information1 := hr_api.g_varchar2;

61: l_course_rec.professional_credit_type := hr_api.g_varchar2;
62: l_course_rec.professional_credits := hr_api.g_number;
63: l_course_rec.maximum_internal_attendees := hr_api.g_number;
64: l_course_rec.tav_information_category := hr_api.g_varchar2;
65: l_course_rec.tav_information1 := hr_api.g_varchar2;
66: l_course_rec.tav_information2 := hr_api.g_varchar2;
67: l_course_rec.tav_information3 := hr_api.g_varchar2;
68: l_course_rec.tav_information4 := hr_api.g_varchar2;
69: l_course_rec.tav_information5 := hr_api.g_varchar2;

Line 66: l_course_rec.tav_information2 := hr_api.g_varchar2;

62: l_course_rec.professional_credits := hr_api.g_number;
63: l_course_rec.maximum_internal_attendees := hr_api.g_number;
64: l_course_rec.tav_information_category := hr_api.g_varchar2;
65: l_course_rec.tav_information1 := hr_api.g_varchar2;
66: l_course_rec.tav_information2 := hr_api.g_varchar2;
67: l_course_rec.tav_information3 := hr_api.g_varchar2;
68: l_course_rec.tav_information4 := hr_api.g_varchar2;
69: l_course_rec.tav_information5 := hr_api.g_varchar2;
70: l_course_rec.tav_information6 := hr_api.g_varchar2;

Line 67: l_course_rec.tav_information3 := hr_api.g_varchar2;

63: l_course_rec.maximum_internal_attendees := hr_api.g_number;
64: l_course_rec.tav_information_category := hr_api.g_varchar2;
65: l_course_rec.tav_information1 := hr_api.g_varchar2;
66: l_course_rec.tav_information2 := hr_api.g_varchar2;
67: l_course_rec.tav_information3 := hr_api.g_varchar2;
68: l_course_rec.tav_information4 := hr_api.g_varchar2;
69: l_course_rec.tav_information5 := hr_api.g_varchar2;
70: l_course_rec.tav_information6 := hr_api.g_varchar2;
71: l_course_rec.tav_information7 := hr_api.g_varchar2;

Line 68: l_course_rec.tav_information4 := hr_api.g_varchar2;

64: l_course_rec.tav_information_category := hr_api.g_varchar2;
65: l_course_rec.tav_information1 := hr_api.g_varchar2;
66: l_course_rec.tav_information2 := hr_api.g_varchar2;
67: l_course_rec.tav_information3 := hr_api.g_varchar2;
68: l_course_rec.tav_information4 := hr_api.g_varchar2;
69: l_course_rec.tav_information5 := hr_api.g_varchar2;
70: l_course_rec.tav_information6 := hr_api.g_varchar2;
71: l_course_rec.tav_information7 := hr_api.g_varchar2;
72: l_course_rec.tav_information8 := hr_api.g_varchar2;

Line 69: l_course_rec.tav_information5 := hr_api.g_varchar2;

65: l_course_rec.tav_information1 := hr_api.g_varchar2;
66: l_course_rec.tav_information2 := hr_api.g_varchar2;
67: l_course_rec.tav_information3 := hr_api.g_varchar2;
68: l_course_rec.tav_information4 := hr_api.g_varchar2;
69: l_course_rec.tav_information5 := hr_api.g_varchar2;
70: l_course_rec.tav_information6 := hr_api.g_varchar2;
71: l_course_rec.tav_information7 := hr_api.g_varchar2;
72: l_course_rec.tav_information8 := hr_api.g_varchar2;
73: l_course_rec.tav_information9 := hr_api.g_varchar2;

Line 70: l_course_rec.tav_information6 := hr_api.g_varchar2;

66: l_course_rec.tav_information2 := hr_api.g_varchar2;
67: l_course_rec.tav_information3 := hr_api.g_varchar2;
68: l_course_rec.tav_information4 := hr_api.g_varchar2;
69: l_course_rec.tav_information5 := hr_api.g_varchar2;
70: l_course_rec.tav_information6 := hr_api.g_varchar2;
71: l_course_rec.tav_information7 := hr_api.g_varchar2;
72: l_course_rec.tav_information8 := hr_api.g_varchar2;
73: l_course_rec.tav_information9 := hr_api.g_varchar2;
74: l_course_rec.tav_information10 := hr_api.g_varchar2;

Line 71: l_course_rec.tav_information7 := hr_api.g_varchar2;

67: l_course_rec.tav_information3 := hr_api.g_varchar2;
68: l_course_rec.tav_information4 := hr_api.g_varchar2;
69: l_course_rec.tav_information5 := hr_api.g_varchar2;
70: l_course_rec.tav_information6 := hr_api.g_varchar2;
71: l_course_rec.tav_information7 := hr_api.g_varchar2;
72: l_course_rec.tav_information8 := hr_api.g_varchar2;
73: l_course_rec.tav_information9 := hr_api.g_varchar2;
74: l_course_rec.tav_information10 := hr_api.g_varchar2;
75: l_course_rec.tav_information11 := hr_api.g_varchar2;

Line 72: l_course_rec.tav_information8 := hr_api.g_varchar2;

68: l_course_rec.tav_information4 := hr_api.g_varchar2;
69: l_course_rec.tav_information5 := hr_api.g_varchar2;
70: l_course_rec.tav_information6 := hr_api.g_varchar2;
71: l_course_rec.tav_information7 := hr_api.g_varchar2;
72: l_course_rec.tav_information8 := hr_api.g_varchar2;
73: l_course_rec.tav_information9 := hr_api.g_varchar2;
74: l_course_rec.tav_information10 := hr_api.g_varchar2;
75: l_course_rec.tav_information11 := hr_api.g_varchar2;
76: l_course_rec.tav_information12 := hr_api.g_varchar2;

Line 73: l_course_rec.tav_information9 := hr_api.g_varchar2;

69: l_course_rec.tav_information5 := hr_api.g_varchar2;
70: l_course_rec.tav_information6 := hr_api.g_varchar2;
71: l_course_rec.tav_information7 := hr_api.g_varchar2;
72: l_course_rec.tav_information8 := hr_api.g_varchar2;
73: l_course_rec.tav_information9 := hr_api.g_varchar2;
74: l_course_rec.tav_information10 := hr_api.g_varchar2;
75: l_course_rec.tav_information11 := hr_api.g_varchar2;
76: l_course_rec.tav_information12 := hr_api.g_varchar2;
77: l_course_rec.tav_information13 := hr_api.g_varchar2;

Line 74: l_course_rec.tav_information10 := hr_api.g_varchar2;

70: l_course_rec.tav_information6 := hr_api.g_varchar2;
71: l_course_rec.tav_information7 := hr_api.g_varchar2;
72: l_course_rec.tav_information8 := hr_api.g_varchar2;
73: l_course_rec.tav_information9 := hr_api.g_varchar2;
74: l_course_rec.tav_information10 := hr_api.g_varchar2;
75: l_course_rec.tav_information11 := hr_api.g_varchar2;
76: l_course_rec.tav_information12 := hr_api.g_varchar2;
77: l_course_rec.tav_information13 := hr_api.g_varchar2;
78: l_course_rec.tav_information14 := hr_api.g_varchar2;

Line 75: l_course_rec.tav_information11 := hr_api.g_varchar2;

71: l_course_rec.tav_information7 := hr_api.g_varchar2;
72: l_course_rec.tav_information8 := hr_api.g_varchar2;
73: l_course_rec.tav_information9 := hr_api.g_varchar2;
74: l_course_rec.tav_information10 := hr_api.g_varchar2;
75: l_course_rec.tav_information11 := hr_api.g_varchar2;
76: l_course_rec.tav_information12 := hr_api.g_varchar2;
77: l_course_rec.tav_information13 := hr_api.g_varchar2;
78: l_course_rec.tav_information14 := hr_api.g_varchar2;
79: l_course_rec.tav_information15 := hr_api.g_varchar2;

Line 76: l_course_rec.tav_information12 := hr_api.g_varchar2;

72: l_course_rec.tav_information8 := hr_api.g_varchar2;
73: l_course_rec.tav_information9 := hr_api.g_varchar2;
74: l_course_rec.tav_information10 := hr_api.g_varchar2;
75: l_course_rec.tav_information11 := hr_api.g_varchar2;
76: l_course_rec.tav_information12 := hr_api.g_varchar2;
77: l_course_rec.tav_information13 := hr_api.g_varchar2;
78: l_course_rec.tav_information14 := hr_api.g_varchar2;
79: l_course_rec.tav_information15 := hr_api.g_varchar2;
80: l_course_rec.tav_information16 := hr_api.g_varchar2;

Line 77: l_course_rec.tav_information13 := hr_api.g_varchar2;

73: l_course_rec.tav_information9 := hr_api.g_varchar2;
74: l_course_rec.tav_information10 := hr_api.g_varchar2;
75: l_course_rec.tav_information11 := hr_api.g_varchar2;
76: l_course_rec.tav_information12 := hr_api.g_varchar2;
77: l_course_rec.tav_information13 := hr_api.g_varchar2;
78: l_course_rec.tav_information14 := hr_api.g_varchar2;
79: l_course_rec.tav_information15 := hr_api.g_varchar2;
80: l_course_rec.tav_information16 := hr_api.g_varchar2;
81: l_course_rec.tav_information17 := hr_api.g_varchar2;

Line 78: l_course_rec.tav_information14 := hr_api.g_varchar2;

74: l_course_rec.tav_information10 := hr_api.g_varchar2;
75: l_course_rec.tav_information11 := hr_api.g_varchar2;
76: l_course_rec.tav_information12 := hr_api.g_varchar2;
77: l_course_rec.tav_information13 := hr_api.g_varchar2;
78: l_course_rec.tav_information14 := hr_api.g_varchar2;
79: l_course_rec.tav_information15 := hr_api.g_varchar2;
80: l_course_rec.tav_information16 := hr_api.g_varchar2;
81: l_course_rec.tav_information17 := hr_api.g_varchar2;
82: l_course_rec.tav_information18 := hr_api.g_varchar2;

Line 79: l_course_rec.tav_information15 := hr_api.g_varchar2;

75: l_course_rec.tav_information11 := hr_api.g_varchar2;
76: l_course_rec.tav_information12 := hr_api.g_varchar2;
77: l_course_rec.tav_information13 := hr_api.g_varchar2;
78: l_course_rec.tav_information14 := hr_api.g_varchar2;
79: l_course_rec.tav_information15 := hr_api.g_varchar2;
80: l_course_rec.tav_information16 := hr_api.g_varchar2;
81: l_course_rec.tav_information17 := hr_api.g_varchar2;
82: l_course_rec.tav_information18 := hr_api.g_varchar2;
83: l_course_rec.tav_information19 := hr_api.g_varchar2;

Line 80: l_course_rec.tav_information16 := hr_api.g_varchar2;

76: l_course_rec.tav_information12 := hr_api.g_varchar2;
77: l_course_rec.tav_information13 := hr_api.g_varchar2;
78: l_course_rec.tav_information14 := hr_api.g_varchar2;
79: l_course_rec.tav_information15 := hr_api.g_varchar2;
80: l_course_rec.tav_information16 := hr_api.g_varchar2;
81: l_course_rec.tav_information17 := hr_api.g_varchar2;
82: l_course_rec.tav_information18 := hr_api.g_varchar2;
83: l_course_rec.tav_information19 := hr_api.g_varchar2;
84: l_course_rec.tav_information20 := hr_api.g_varchar2;

Line 81: l_course_rec.tav_information17 := hr_api.g_varchar2;

77: l_course_rec.tav_information13 := hr_api.g_varchar2;
78: l_course_rec.tav_information14 := hr_api.g_varchar2;
79: l_course_rec.tav_information15 := hr_api.g_varchar2;
80: l_course_rec.tav_information16 := hr_api.g_varchar2;
81: l_course_rec.tav_information17 := hr_api.g_varchar2;
82: l_course_rec.tav_information18 := hr_api.g_varchar2;
83: l_course_rec.tav_information19 := hr_api.g_varchar2;
84: l_course_rec.tav_information20 := hr_api.g_varchar2;
85: l_course_rec.inventory_item_id := hr_api.g_number;

Line 82: l_course_rec.tav_information18 := hr_api.g_varchar2;

78: l_course_rec.tav_information14 := hr_api.g_varchar2;
79: l_course_rec.tav_information15 := hr_api.g_varchar2;
80: l_course_rec.tav_information16 := hr_api.g_varchar2;
81: l_course_rec.tav_information17 := hr_api.g_varchar2;
82: l_course_rec.tav_information18 := hr_api.g_varchar2;
83: l_course_rec.tav_information19 := hr_api.g_varchar2;
84: l_course_rec.tav_information20 := hr_api.g_varchar2;
85: l_course_rec.inventory_item_id := hr_api.g_number;
86: l_course_rec.organization_id := hr_api.g_number;

Line 83: l_course_rec.tav_information19 := hr_api.g_varchar2;

79: l_course_rec.tav_information15 := hr_api.g_varchar2;
80: l_course_rec.tav_information16 := hr_api.g_varchar2;
81: l_course_rec.tav_information17 := hr_api.g_varchar2;
82: l_course_rec.tav_information18 := hr_api.g_varchar2;
83: l_course_rec.tav_information19 := hr_api.g_varchar2;
84: l_course_rec.tav_information20 := hr_api.g_varchar2;
85: l_course_rec.inventory_item_id := hr_api.g_number;
86: l_course_rec.organization_id := hr_api.g_number;
87: l_course_rec.rco_id := hr_api.g_number;

Line 84: l_course_rec.tav_information20 := hr_api.g_varchar2;

80: l_course_rec.tav_information16 := hr_api.g_varchar2;
81: l_course_rec.tav_information17 := hr_api.g_varchar2;
82: l_course_rec.tav_information18 := hr_api.g_varchar2;
83: l_course_rec.tav_information19 := hr_api.g_varchar2;
84: l_course_rec.tav_information20 := hr_api.g_varchar2;
85: l_course_rec.inventory_item_id := hr_api.g_number;
86: l_course_rec.organization_id := hr_api.g_number;
87: l_course_rec.rco_id := hr_api.g_number;
88: l_course_rec.version_code := hr_api.g_varchar2;

Line 85: l_course_rec.inventory_item_id := hr_api.g_number;

81: l_course_rec.tav_information17 := hr_api.g_varchar2;
82: l_course_rec.tav_information18 := hr_api.g_varchar2;
83: l_course_rec.tav_information19 := hr_api.g_varchar2;
84: l_course_rec.tav_information20 := hr_api.g_varchar2;
85: l_course_rec.inventory_item_id := hr_api.g_number;
86: l_course_rec.organization_id := hr_api.g_number;
87: l_course_rec.rco_id := hr_api.g_number;
88: l_course_rec.version_code := hr_api.g_varchar2;
89: l_course_rec.keywords := hr_api.g_varchar2;

Line 86: l_course_rec.organization_id := hr_api.g_number;

82: l_course_rec.tav_information18 := hr_api.g_varchar2;
83: l_course_rec.tav_information19 := hr_api.g_varchar2;
84: l_course_rec.tav_information20 := hr_api.g_varchar2;
85: l_course_rec.inventory_item_id := hr_api.g_number;
86: l_course_rec.organization_id := hr_api.g_number;
87: l_course_rec.rco_id := hr_api.g_number;
88: l_course_rec.version_code := hr_api.g_varchar2;
89: l_course_rec.keywords := hr_api.g_varchar2;
90: l_course_rec.business_group_id := hr_api.g_number;

Line 87: l_course_rec.rco_id := hr_api.g_number;

83: l_course_rec.tav_information19 := hr_api.g_varchar2;
84: l_course_rec.tav_information20 := hr_api.g_varchar2;
85: l_course_rec.inventory_item_id := hr_api.g_number;
86: l_course_rec.organization_id := hr_api.g_number;
87: l_course_rec.rco_id := hr_api.g_number;
88: l_course_rec.version_code := hr_api.g_varchar2;
89: l_course_rec.keywords := hr_api.g_varchar2;
90: l_course_rec.business_group_id := hr_api.g_number;
91: l_course_rec.data_source := hr_api.g_varchar2;

Line 88: l_course_rec.version_code := hr_api.g_varchar2;

84: l_course_rec.tav_information20 := hr_api.g_varchar2;
85: l_course_rec.inventory_item_id := hr_api.g_number;
86: l_course_rec.organization_id := hr_api.g_number;
87: l_course_rec.rco_id := hr_api.g_number;
88: l_course_rec.version_code := hr_api.g_varchar2;
89: l_course_rec.keywords := hr_api.g_varchar2;
90: l_course_rec.business_group_id := hr_api.g_number;
91: l_course_rec.data_source := hr_api.g_varchar2;
92: l_course_rec.competency_update_level := hr_api.g_varchar2;

Line 89: l_course_rec.keywords := hr_api.g_varchar2;

85: l_course_rec.inventory_item_id := hr_api.g_number;
86: l_course_rec.organization_id := hr_api.g_number;
87: l_course_rec.rco_id := hr_api.g_number;
88: l_course_rec.version_code := hr_api.g_varchar2;
89: l_course_rec.keywords := hr_api.g_varchar2;
90: l_course_rec.business_group_id := hr_api.g_number;
91: l_course_rec.data_source := hr_api.g_varchar2;
92: l_course_rec.competency_update_level := hr_api.g_varchar2;
93:

Line 90: l_course_rec.business_group_id := hr_api.g_number;

86: l_course_rec.organization_id := hr_api.g_number;
87: l_course_rec.rco_id := hr_api.g_number;
88: l_course_rec.version_code := hr_api.g_varchar2;
89: l_course_rec.keywords := hr_api.g_varchar2;
90: l_course_rec.business_group_id := hr_api.g_number;
91: l_course_rec.data_source := hr_api.g_varchar2;
92: l_course_rec.competency_update_level := hr_api.g_varchar2;
93:
94: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

Line 91: l_course_rec.data_source := hr_api.g_varchar2;

87: l_course_rec.rco_id := hr_api.g_number;
88: l_course_rec.version_code := hr_api.g_varchar2;
89: l_course_rec.keywords := hr_api.g_varchar2;
90: l_course_rec.business_group_id := hr_api.g_number;
91: l_course_rec.data_source := hr_api.g_varchar2;
92: l_course_rec.competency_update_level := hr_api.g_varchar2;
93:
94: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
95: return l_course_rec;

Line 92: l_course_rec.competency_update_level := hr_api.g_varchar2;

88: l_course_rec.version_code := hr_api.g_varchar2;
89: l_course_rec.keywords := hr_api.g_varchar2;
90: l_course_rec.business_group_id := hr_api.g_number;
91: l_course_rec.data_source := hr_api.g_varchar2;
92: l_course_rec.competency_update_level := hr_api.g_varchar2;
93:
94: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
95: return l_course_rec;
96: exception

Line 276: ,p_validate in number default hr_api.g_false_num

272: -- |------------------------< InsUpd_Course >-----------------------|
273: -- ----------------------------------------------------------------------------
274: PROCEDURE InsUpd_Course
275: (p_effective_date in date
276: ,p_validate in number default hr_api.g_false_num
277: ,p_activity_id in number
278: ,p_superseded_by_act_version_id in number default null
279: ,p_developer_organization_id in number
280: ,p_controlling_person_id in number default null

Line 412: hr_api.constant_to_boolean

408: --
409: -- Convert constant values to their corresponding boolean value
410: --
411: l_validate :=
412: hr_api.constant_to_boolean
413: (p_constant_value => p_validate);
414: --
415: -- Register Surrogate ID or user key values
416: --