APPS.HR_FORM_TEMPLATES_API dependencies on HR_API

Line 48: ,p_language_code in varchar2 default hr_api.userenv_lang

44: procedure copy_template
45: (p_validate in boolean default false
46: ,p_effective_date in date
47: ,p_form_template_id_from in number
48: ,p_language_code in varchar2 default hr_api.userenv_lang
49: --,p_template_name in varchar2 default hr_api.g_varchar2
50: ,p_template_name in varchar2
51: ,p_user_template_name in varchar2 default hr_api.g_varchar2
52: ,p_description in varchar2 default hr_api.g_varchar2

Line 49: --,p_template_name in varchar2 default hr_api.g_varchar2

45: (p_validate in boolean default false
46: ,p_effective_date in date
47: ,p_form_template_id_from in number
48: ,p_language_code in varchar2 default hr_api.userenv_lang
49: --,p_template_name in varchar2 default hr_api.g_varchar2
50: ,p_template_name in varchar2
51: ,p_user_template_name in varchar2 default hr_api.g_varchar2
52: ,p_description in varchar2 default hr_api.g_varchar2
53: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

Line 51: ,p_user_template_name in varchar2 default hr_api.g_varchar2

47: ,p_form_template_id_from in number
48: ,p_language_code in varchar2 default hr_api.userenv_lang
49: --,p_template_name in varchar2 default hr_api.g_varchar2
50: ,p_template_name in varchar2
51: ,p_user_template_name in varchar2 default hr_api.g_varchar2
52: ,p_description in varchar2 default hr_api.g_varchar2
53: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
54: ,p_legislation_code in varchar2 default hr_api.g_varchar2
55: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 52: ,p_description in varchar2 default hr_api.g_varchar2

48: ,p_language_code in varchar2 default hr_api.userenv_lang
49: --,p_template_name in varchar2 default hr_api.g_varchar2
50: ,p_template_name in varchar2
51: ,p_user_template_name in varchar2 default hr_api.g_varchar2
52: ,p_description in varchar2 default hr_api.g_varchar2
53: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
54: ,p_legislation_code in varchar2 default hr_api.g_varchar2
55: ,p_attribute_category in varchar2 default hr_api.g_varchar2
56: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 53: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

49: --,p_template_name in varchar2 default hr_api.g_varchar2
50: ,p_template_name in varchar2
51: ,p_user_template_name in varchar2 default hr_api.g_varchar2
52: ,p_description in varchar2 default hr_api.g_varchar2
53: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
54: ,p_legislation_code in varchar2 default hr_api.g_varchar2
55: ,p_attribute_category in varchar2 default hr_api.g_varchar2
56: ,p_attribute1 in varchar2 default hr_api.g_varchar2
57: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 54: ,p_legislation_code in varchar2 default hr_api.g_varchar2

50: ,p_template_name in varchar2
51: ,p_user_template_name in varchar2 default hr_api.g_varchar2
52: ,p_description in varchar2 default hr_api.g_varchar2
53: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
54: ,p_legislation_code in varchar2 default hr_api.g_varchar2
55: ,p_attribute_category in varchar2 default hr_api.g_varchar2
56: ,p_attribute1 in varchar2 default hr_api.g_varchar2
57: ,p_attribute2 in varchar2 default hr_api.g_varchar2
58: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 55: ,p_attribute_category in varchar2 default hr_api.g_varchar2

51: ,p_user_template_name in varchar2 default hr_api.g_varchar2
52: ,p_description in varchar2 default hr_api.g_varchar2
53: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
54: ,p_legislation_code in varchar2 default hr_api.g_varchar2
55: ,p_attribute_category in varchar2 default hr_api.g_varchar2
56: ,p_attribute1 in varchar2 default hr_api.g_varchar2
57: ,p_attribute2 in varchar2 default hr_api.g_varchar2
58: ,p_attribute3 in varchar2 default hr_api.g_varchar2
59: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 56: ,p_attribute1 in varchar2 default hr_api.g_varchar2

52: ,p_description in varchar2 default hr_api.g_varchar2
53: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
54: ,p_legislation_code in varchar2 default hr_api.g_varchar2
55: ,p_attribute_category in varchar2 default hr_api.g_varchar2
56: ,p_attribute1 in varchar2 default hr_api.g_varchar2
57: ,p_attribute2 in varchar2 default hr_api.g_varchar2
58: ,p_attribute3 in varchar2 default hr_api.g_varchar2
59: ,p_attribute4 in varchar2 default hr_api.g_varchar2
60: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 57: ,p_attribute2 in varchar2 default hr_api.g_varchar2

53: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
54: ,p_legislation_code in varchar2 default hr_api.g_varchar2
55: ,p_attribute_category in varchar2 default hr_api.g_varchar2
56: ,p_attribute1 in varchar2 default hr_api.g_varchar2
57: ,p_attribute2 in varchar2 default hr_api.g_varchar2
58: ,p_attribute3 in varchar2 default hr_api.g_varchar2
59: ,p_attribute4 in varchar2 default hr_api.g_varchar2
60: ,p_attribute5 in varchar2 default hr_api.g_varchar2
61: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 58: ,p_attribute3 in varchar2 default hr_api.g_varchar2

54: ,p_legislation_code in varchar2 default hr_api.g_varchar2
55: ,p_attribute_category in varchar2 default hr_api.g_varchar2
56: ,p_attribute1 in varchar2 default hr_api.g_varchar2
57: ,p_attribute2 in varchar2 default hr_api.g_varchar2
58: ,p_attribute3 in varchar2 default hr_api.g_varchar2
59: ,p_attribute4 in varchar2 default hr_api.g_varchar2
60: ,p_attribute5 in varchar2 default hr_api.g_varchar2
61: ,p_attribute6 in varchar2 default hr_api.g_varchar2
62: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 59: ,p_attribute4 in varchar2 default hr_api.g_varchar2

55: ,p_attribute_category in varchar2 default hr_api.g_varchar2
56: ,p_attribute1 in varchar2 default hr_api.g_varchar2
57: ,p_attribute2 in varchar2 default hr_api.g_varchar2
58: ,p_attribute3 in varchar2 default hr_api.g_varchar2
59: ,p_attribute4 in varchar2 default hr_api.g_varchar2
60: ,p_attribute5 in varchar2 default hr_api.g_varchar2
61: ,p_attribute6 in varchar2 default hr_api.g_varchar2
62: ,p_attribute7 in varchar2 default hr_api.g_varchar2
63: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 60: ,p_attribute5 in varchar2 default hr_api.g_varchar2

56: ,p_attribute1 in varchar2 default hr_api.g_varchar2
57: ,p_attribute2 in varchar2 default hr_api.g_varchar2
58: ,p_attribute3 in varchar2 default hr_api.g_varchar2
59: ,p_attribute4 in varchar2 default hr_api.g_varchar2
60: ,p_attribute5 in varchar2 default hr_api.g_varchar2
61: ,p_attribute6 in varchar2 default hr_api.g_varchar2
62: ,p_attribute7 in varchar2 default hr_api.g_varchar2
63: ,p_attribute8 in varchar2 default hr_api.g_varchar2
64: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 61: ,p_attribute6 in varchar2 default hr_api.g_varchar2

57: ,p_attribute2 in varchar2 default hr_api.g_varchar2
58: ,p_attribute3 in varchar2 default hr_api.g_varchar2
59: ,p_attribute4 in varchar2 default hr_api.g_varchar2
60: ,p_attribute5 in varchar2 default hr_api.g_varchar2
61: ,p_attribute6 in varchar2 default hr_api.g_varchar2
62: ,p_attribute7 in varchar2 default hr_api.g_varchar2
63: ,p_attribute8 in varchar2 default hr_api.g_varchar2
64: ,p_attribute9 in varchar2 default hr_api.g_varchar2
65: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 62: ,p_attribute7 in varchar2 default hr_api.g_varchar2

58: ,p_attribute3 in varchar2 default hr_api.g_varchar2
59: ,p_attribute4 in varchar2 default hr_api.g_varchar2
60: ,p_attribute5 in varchar2 default hr_api.g_varchar2
61: ,p_attribute6 in varchar2 default hr_api.g_varchar2
62: ,p_attribute7 in varchar2 default hr_api.g_varchar2
63: ,p_attribute8 in varchar2 default hr_api.g_varchar2
64: ,p_attribute9 in varchar2 default hr_api.g_varchar2
65: ,p_attribute10 in varchar2 default hr_api.g_varchar2
66: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 63: ,p_attribute8 in varchar2 default hr_api.g_varchar2

59: ,p_attribute4 in varchar2 default hr_api.g_varchar2
60: ,p_attribute5 in varchar2 default hr_api.g_varchar2
61: ,p_attribute6 in varchar2 default hr_api.g_varchar2
62: ,p_attribute7 in varchar2 default hr_api.g_varchar2
63: ,p_attribute8 in varchar2 default hr_api.g_varchar2
64: ,p_attribute9 in varchar2 default hr_api.g_varchar2
65: ,p_attribute10 in varchar2 default hr_api.g_varchar2
66: ,p_attribute11 in varchar2 default hr_api.g_varchar2
67: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 64: ,p_attribute9 in varchar2 default hr_api.g_varchar2

60: ,p_attribute5 in varchar2 default hr_api.g_varchar2
61: ,p_attribute6 in varchar2 default hr_api.g_varchar2
62: ,p_attribute7 in varchar2 default hr_api.g_varchar2
63: ,p_attribute8 in varchar2 default hr_api.g_varchar2
64: ,p_attribute9 in varchar2 default hr_api.g_varchar2
65: ,p_attribute10 in varchar2 default hr_api.g_varchar2
66: ,p_attribute11 in varchar2 default hr_api.g_varchar2
67: ,p_attribute12 in varchar2 default hr_api.g_varchar2
68: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 65: ,p_attribute10 in varchar2 default hr_api.g_varchar2

61: ,p_attribute6 in varchar2 default hr_api.g_varchar2
62: ,p_attribute7 in varchar2 default hr_api.g_varchar2
63: ,p_attribute8 in varchar2 default hr_api.g_varchar2
64: ,p_attribute9 in varchar2 default hr_api.g_varchar2
65: ,p_attribute10 in varchar2 default hr_api.g_varchar2
66: ,p_attribute11 in varchar2 default hr_api.g_varchar2
67: ,p_attribute12 in varchar2 default hr_api.g_varchar2
68: ,p_attribute13 in varchar2 default hr_api.g_varchar2
69: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 66: ,p_attribute11 in varchar2 default hr_api.g_varchar2

62: ,p_attribute7 in varchar2 default hr_api.g_varchar2
63: ,p_attribute8 in varchar2 default hr_api.g_varchar2
64: ,p_attribute9 in varchar2 default hr_api.g_varchar2
65: ,p_attribute10 in varchar2 default hr_api.g_varchar2
66: ,p_attribute11 in varchar2 default hr_api.g_varchar2
67: ,p_attribute12 in varchar2 default hr_api.g_varchar2
68: ,p_attribute13 in varchar2 default hr_api.g_varchar2
69: ,p_attribute14 in varchar2 default hr_api.g_varchar2
70: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 67: ,p_attribute12 in varchar2 default hr_api.g_varchar2

63: ,p_attribute8 in varchar2 default hr_api.g_varchar2
64: ,p_attribute9 in varchar2 default hr_api.g_varchar2
65: ,p_attribute10 in varchar2 default hr_api.g_varchar2
66: ,p_attribute11 in varchar2 default hr_api.g_varchar2
67: ,p_attribute12 in varchar2 default hr_api.g_varchar2
68: ,p_attribute13 in varchar2 default hr_api.g_varchar2
69: ,p_attribute14 in varchar2 default hr_api.g_varchar2
70: ,p_attribute15 in varchar2 default hr_api.g_varchar2
71: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 68: ,p_attribute13 in varchar2 default hr_api.g_varchar2

64: ,p_attribute9 in varchar2 default hr_api.g_varchar2
65: ,p_attribute10 in varchar2 default hr_api.g_varchar2
66: ,p_attribute11 in varchar2 default hr_api.g_varchar2
67: ,p_attribute12 in varchar2 default hr_api.g_varchar2
68: ,p_attribute13 in varchar2 default hr_api.g_varchar2
69: ,p_attribute14 in varchar2 default hr_api.g_varchar2
70: ,p_attribute15 in varchar2 default hr_api.g_varchar2
71: ,p_attribute16 in varchar2 default hr_api.g_varchar2
72: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 69: ,p_attribute14 in varchar2 default hr_api.g_varchar2

65: ,p_attribute10 in varchar2 default hr_api.g_varchar2
66: ,p_attribute11 in varchar2 default hr_api.g_varchar2
67: ,p_attribute12 in varchar2 default hr_api.g_varchar2
68: ,p_attribute13 in varchar2 default hr_api.g_varchar2
69: ,p_attribute14 in varchar2 default hr_api.g_varchar2
70: ,p_attribute15 in varchar2 default hr_api.g_varchar2
71: ,p_attribute16 in varchar2 default hr_api.g_varchar2
72: ,p_attribute17 in varchar2 default hr_api.g_varchar2
73: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 70: ,p_attribute15 in varchar2 default hr_api.g_varchar2

66: ,p_attribute11 in varchar2 default hr_api.g_varchar2
67: ,p_attribute12 in varchar2 default hr_api.g_varchar2
68: ,p_attribute13 in varchar2 default hr_api.g_varchar2
69: ,p_attribute14 in varchar2 default hr_api.g_varchar2
70: ,p_attribute15 in varchar2 default hr_api.g_varchar2
71: ,p_attribute16 in varchar2 default hr_api.g_varchar2
72: ,p_attribute17 in varchar2 default hr_api.g_varchar2
73: ,p_attribute18 in varchar2 default hr_api.g_varchar2
74: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 71: ,p_attribute16 in varchar2 default hr_api.g_varchar2

67: ,p_attribute12 in varchar2 default hr_api.g_varchar2
68: ,p_attribute13 in varchar2 default hr_api.g_varchar2
69: ,p_attribute14 in varchar2 default hr_api.g_varchar2
70: ,p_attribute15 in varchar2 default hr_api.g_varchar2
71: ,p_attribute16 in varchar2 default hr_api.g_varchar2
72: ,p_attribute17 in varchar2 default hr_api.g_varchar2
73: ,p_attribute18 in varchar2 default hr_api.g_varchar2
74: ,p_attribute19 in varchar2 default hr_api.g_varchar2
75: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 72: ,p_attribute17 in varchar2 default hr_api.g_varchar2

68: ,p_attribute13 in varchar2 default hr_api.g_varchar2
69: ,p_attribute14 in varchar2 default hr_api.g_varchar2
70: ,p_attribute15 in varchar2 default hr_api.g_varchar2
71: ,p_attribute16 in varchar2 default hr_api.g_varchar2
72: ,p_attribute17 in varchar2 default hr_api.g_varchar2
73: ,p_attribute18 in varchar2 default hr_api.g_varchar2
74: ,p_attribute19 in varchar2 default hr_api.g_varchar2
75: ,p_attribute20 in varchar2 default hr_api.g_varchar2
76: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 73: ,p_attribute18 in varchar2 default hr_api.g_varchar2

69: ,p_attribute14 in varchar2 default hr_api.g_varchar2
70: ,p_attribute15 in varchar2 default hr_api.g_varchar2
71: ,p_attribute16 in varchar2 default hr_api.g_varchar2
72: ,p_attribute17 in varchar2 default hr_api.g_varchar2
73: ,p_attribute18 in varchar2 default hr_api.g_varchar2
74: ,p_attribute19 in varchar2 default hr_api.g_varchar2
75: ,p_attribute20 in varchar2 default hr_api.g_varchar2
76: ,p_attribute21 in varchar2 default hr_api.g_varchar2
77: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 74: ,p_attribute19 in varchar2 default hr_api.g_varchar2

70: ,p_attribute15 in varchar2 default hr_api.g_varchar2
71: ,p_attribute16 in varchar2 default hr_api.g_varchar2
72: ,p_attribute17 in varchar2 default hr_api.g_varchar2
73: ,p_attribute18 in varchar2 default hr_api.g_varchar2
74: ,p_attribute19 in varchar2 default hr_api.g_varchar2
75: ,p_attribute20 in varchar2 default hr_api.g_varchar2
76: ,p_attribute21 in varchar2 default hr_api.g_varchar2
77: ,p_attribute22 in varchar2 default hr_api.g_varchar2
78: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 75: ,p_attribute20 in varchar2 default hr_api.g_varchar2

71: ,p_attribute16 in varchar2 default hr_api.g_varchar2
72: ,p_attribute17 in varchar2 default hr_api.g_varchar2
73: ,p_attribute18 in varchar2 default hr_api.g_varchar2
74: ,p_attribute19 in varchar2 default hr_api.g_varchar2
75: ,p_attribute20 in varchar2 default hr_api.g_varchar2
76: ,p_attribute21 in varchar2 default hr_api.g_varchar2
77: ,p_attribute22 in varchar2 default hr_api.g_varchar2
78: ,p_attribute23 in varchar2 default hr_api.g_varchar2
79: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 76: ,p_attribute21 in varchar2 default hr_api.g_varchar2

72: ,p_attribute17 in varchar2 default hr_api.g_varchar2
73: ,p_attribute18 in varchar2 default hr_api.g_varchar2
74: ,p_attribute19 in varchar2 default hr_api.g_varchar2
75: ,p_attribute20 in varchar2 default hr_api.g_varchar2
76: ,p_attribute21 in varchar2 default hr_api.g_varchar2
77: ,p_attribute22 in varchar2 default hr_api.g_varchar2
78: ,p_attribute23 in varchar2 default hr_api.g_varchar2
79: ,p_attribute24 in varchar2 default hr_api.g_varchar2
80: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 77: ,p_attribute22 in varchar2 default hr_api.g_varchar2

73: ,p_attribute18 in varchar2 default hr_api.g_varchar2
74: ,p_attribute19 in varchar2 default hr_api.g_varchar2
75: ,p_attribute20 in varchar2 default hr_api.g_varchar2
76: ,p_attribute21 in varchar2 default hr_api.g_varchar2
77: ,p_attribute22 in varchar2 default hr_api.g_varchar2
78: ,p_attribute23 in varchar2 default hr_api.g_varchar2
79: ,p_attribute24 in varchar2 default hr_api.g_varchar2
80: ,p_attribute25 in varchar2 default hr_api.g_varchar2
81: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 78: ,p_attribute23 in varchar2 default hr_api.g_varchar2

74: ,p_attribute19 in varchar2 default hr_api.g_varchar2
75: ,p_attribute20 in varchar2 default hr_api.g_varchar2
76: ,p_attribute21 in varchar2 default hr_api.g_varchar2
77: ,p_attribute22 in varchar2 default hr_api.g_varchar2
78: ,p_attribute23 in varchar2 default hr_api.g_varchar2
79: ,p_attribute24 in varchar2 default hr_api.g_varchar2
80: ,p_attribute25 in varchar2 default hr_api.g_varchar2
81: ,p_attribute26 in varchar2 default hr_api.g_varchar2
82: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 79: ,p_attribute24 in varchar2 default hr_api.g_varchar2

75: ,p_attribute20 in varchar2 default hr_api.g_varchar2
76: ,p_attribute21 in varchar2 default hr_api.g_varchar2
77: ,p_attribute22 in varchar2 default hr_api.g_varchar2
78: ,p_attribute23 in varchar2 default hr_api.g_varchar2
79: ,p_attribute24 in varchar2 default hr_api.g_varchar2
80: ,p_attribute25 in varchar2 default hr_api.g_varchar2
81: ,p_attribute26 in varchar2 default hr_api.g_varchar2
82: ,p_attribute27 in varchar2 default hr_api.g_varchar2
83: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 80: ,p_attribute25 in varchar2 default hr_api.g_varchar2

76: ,p_attribute21 in varchar2 default hr_api.g_varchar2
77: ,p_attribute22 in varchar2 default hr_api.g_varchar2
78: ,p_attribute23 in varchar2 default hr_api.g_varchar2
79: ,p_attribute24 in varchar2 default hr_api.g_varchar2
80: ,p_attribute25 in varchar2 default hr_api.g_varchar2
81: ,p_attribute26 in varchar2 default hr_api.g_varchar2
82: ,p_attribute27 in varchar2 default hr_api.g_varchar2
83: ,p_attribute28 in varchar2 default hr_api.g_varchar2
84: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 81: ,p_attribute26 in varchar2 default hr_api.g_varchar2

77: ,p_attribute22 in varchar2 default hr_api.g_varchar2
78: ,p_attribute23 in varchar2 default hr_api.g_varchar2
79: ,p_attribute24 in varchar2 default hr_api.g_varchar2
80: ,p_attribute25 in varchar2 default hr_api.g_varchar2
81: ,p_attribute26 in varchar2 default hr_api.g_varchar2
82: ,p_attribute27 in varchar2 default hr_api.g_varchar2
83: ,p_attribute28 in varchar2 default hr_api.g_varchar2
84: ,p_attribute29 in varchar2 default hr_api.g_varchar2
85: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 82: ,p_attribute27 in varchar2 default hr_api.g_varchar2

78: ,p_attribute23 in varchar2 default hr_api.g_varchar2
79: ,p_attribute24 in varchar2 default hr_api.g_varchar2
80: ,p_attribute25 in varchar2 default hr_api.g_varchar2
81: ,p_attribute26 in varchar2 default hr_api.g_varchar2
82: ,p_attribute27 in varchar2 default hr_api.g_varchar2
83: ,p_attribute28 in varchar2 default hr_api.g_varchar2
84: ,p_attribute29 in varchar2 default hr_api.g_varchar2
85: ,p_attribute30 in varchar2 default hr_api.g_varchar2
86: ,p_form_template_id_to out nocopy number

Line 83: ,p_attribute28 in varchar2 default hr_api.g_varchar2

79: ,p_attribute24 in varchar2 default hr_api.g_varchar2
80: ,p_attribute25 in varchar2 default hr_api.g_varchar2
81: ,p_attribute26 in varchar2 default hr_api.g_varchar2
82: ,p_attribute27 in varchar2 default hr_api.g_varchar2
83: ,p_attribute28 in varchar2 default hr_api.g_varchar2
84: ,p_attribute29 in varchar2 default hr_api.g_varchar2
85: ,p_attribute30 in varchar2 default hr_api.g_varchar2
86: ,p_form_template_id_to out nocopy number
87: ,p_object_version_number out nocopy number

Line 84: ,p_attribute29 in varchar2 default hr_api.g_varchar2

80: ,p_attribute25 in varchar2 default hr_api.g_varchar2
81: ,p_attribute26 in varchar2 default hr_api.g_varchar2
82: ,p_attribute27 in varchar2 default hr_api.g_varchar2
83: ,p_attribute28 in varchar2 default hr_api.g_varchar2
84: ,p_attribute29 in varchar2 default hr_api.g_varchar2
85: ,p_attribute30 in varchar2 default hr_api.g_varchar2
86: ,p_form_template_id_to out nocopy number
87: ,p_object_version_number out nocopy number
88: ) is

Line 85: ,p_attribute30 in varchar2 default hr_api.g_varchar2

81: ,p_attribute26 in varchar2 default hr_api.g_varchar2
82: ,p_attribute27 in varchar2 default hr_api.g_varchar2
83: ,p_attribute28 in varchar2 default hr_api.g_varchar2
84: ,p_attribute29 in varchar2 default hr_api.g_varchar2
85: ,p_attribute30 in varchar2 default hr_api.g_varchar2
86: ,p_form_template_id_to out nocopy number
87: ,p_object_version_number out nocopy number
88: ) is
89: --

Line 136: ,DECODE(p_template_name,hr_api.g_varchar2,tmp.template_name,p_template_name)

132: CURSOR cur_tmplt_rec
133: IS
134: SELECT tmp.application_id
135: ,tmp.form_id
136: ,DECODE(p_template_name,hr_api.g_varchar2,tmp.template_name,p_template_name)
137: ,DECODE(p_enabled_flag,hr_api.g_varchar2,tmp.enabled_flag,p_enabled_flag)
138: ,DECODE(p_legislation_code,hr_api.g_varchar2,tmp.legislation_code,p_legislation_code)
139: ,DECODE(p_attribute_category,hr_api.g_varchar2,tmp.attribute_category,p_attribute_category)
140: ,DECODE(p_attribute1,hr_api.g_varchar2,tmp.attribute1,p_attribute1)

Line 137: ,DECODE(p_enabled_flag,hr_api.g_varchar2,tmp.enabled_flag,p_enabled_flag)

133: IS
134: SELECT tmp.application_id
135: ,tmp.form_id
136: ,DECODE(p_template_name,hr_api.g_varchar2,tmp.template_name,p_template_name)
137: ,DECODE(p_enabled_flag,hr_api.g_varchar2,tmp.enabled_flag,p_enabled_flag)
138: ,DECODE(p_legislation_code,hr_api.g_varchar2,tmp.legislation_code,p_legislation_code)
139: ,DECODE(p_attribute_category,hr_api.g_varchar2,tmp.attribute_category,p_attribute_category)
140: ,DECODE(p_attribute1,hr_api.g_varchar2,tmp.attribute1,p_attribute1)
141: ,DECODE(p_attribute2,hr_api.g_varchar2,tmp.attribute2,p_attribute2)

Line 138: ,DECODE(p_legislation_code,hr_api.g_varchar2,tmp.legislation_code,p_legislation_code)

134: SELECT tmp.application_id
135: ,tmp.form_id
136: ,DECODE(p_template_name,hr_api.g_varchar2,tmp.template_name,p_template_name)
137: ,DECODE(p_enabled_flag,hr_api.g_varchar2,tmp.enabled_flag,p_enabled_flag)
138: ,DECODE(p_legislation_code,hr_api.g_varchar2,tmp.legislation_code,p_legislation_code)
139: ,DECODE(p_attribute_category,hr_api.g_varchar2,tmp.attribute_category,p_attribute_category)
140: ,DECODE(p_attribute1,hr_api.g_varchar2,tmp.attribute1,p_attribute1)
141: ,DECODE(p_attribute2,hr_api.g_varchar2,tmp.attribute2,p_attribute2)
142: ,DECODE(p_attribute3,hr_api.g_varchar2,tmp.attribute3,p_attribute3)

Line 139: ,DECODE(p_attribute_category,hr_api.g_varchar2,tmp.attribute_category,p_attribute_category)

135: ,tmp.form_id
136: ,DECODE(p_template_name,hr_api.g_varchar2,tmp.template_name,p_template_name)
137: ,DECODE(p_enabled_flag,hr_api.g_varchar2,tmp.enabled_flag,p_enabled_flag)
138: ,DECODE(p_legislation_code,hr_api.g_varchar2,tmp.legislation_code,p_legislation_code)
139: ,DECODE(p_attribute_category,hr_api.g_varchar2,tmp.attribute_category,p_attribute_category)
140: ,DECODE(p_attribute1,hr_api.g_varchar2,tmp.attribute1,p_attribute1)
141: ,DECODE(p_attribute2,hr_api.g_varchar2,tmp.attribute2,p_attribute2)
142: ,DECODE(p_attribute3,hr_api.g_varchar2,tmp.attribute3,p_attribute3)
143: ,DECODE(p_attribute4,hr_api.g_varchar2,tmp.attribute4,p_attribute4)

Line 140: ,DECODE(p_attribute1,hr_api.g_varchar2,tmp.attribute1,p_attribute1)

136: ,DECODE(p_template_name,hr_api.g_varchar2,tmp.template_name,p_template_name)
137: ,DECODE(p_enabled_flag,hr_api.g_varchar2,tmp.enabled_flag,p_enabled_flag)
138: ,DECODE(p_legislation_code,hr_api.g_varchar2,tmp.legislation_code,p_legislation_code)
139: ,DECODE(p_attribute_category,hr_api.g_varchar2,tmp.attribute_category,p_attribute_category)
140: ,DECODE(p_attribute1,hr_api.g_varchar2,tmp.attribute1,p_attribute1)
141: ,DECODE(p_attribute2,hr_api.g_varchar2,tmp.attribute2,p_attribute2)
142: ,DECODE(p_attribute3,hr_api.g_varchar2,tmp.attribute3,p_attribute3)
143: ,DECODE(p_attribute4,hr_api.g_varchar2,tmp.attribute4,p_attribute4)
144: ,DECODE(p_attribute5,hr_api.g_varchar2,tmp.attribute5,p_attribute5)

Line 141: ,DECODE(p_attribute2,hr_api.g_varchar2,tmp.attribute2,p_attribute2)

137: ,DECODE(p_enabled_flag,hr_api.g_varchar2,tmp.enabled_flag,p_enabled_flag)
138: ,DECODE(p_legislation_code,hr_api.g_varchar2,tmp.legislation_code,p_legislation_code)
139: ,DECODE(p_attribute_category,hr_api.g_varchar2,tmp.attribute_category,p_attribute_category)
140: ,DECODE(p_attribute1,hr_api.g_varchar2,tmp.attribute1,p_attribute1)
141: ,DECODE(p_attribute2,hr_api.g_varchar2,tmp.attribute2,p_attribute2)
142: ,DECODE(p_attribute3,hr_api.g_varchar2,tmp.attribute3,p_attribute3)
143: ,DECODE(p_attribute4,hr_api.g_varchar2,tmp.attribute4,p_attribute4)
144: ,DECODE(p_attribute5,hr_api.g_varchar2,tmp.attribute5,p_attribute5)
145: ,DECODE(p_attribute6,hr_api.g_varchar2,tmp.attribute6,p_attribute6)

Line 142: ,DECODE(p_attribute3,hr_api.g_varchar2,tmp.attribute3,p_attribute3)

138: ,DECODE(p_legislation_code,hr_api.g_varchar2,tmp.legislation_code,p_legislation_code)
139: ,DECODE(p_attribute_category,hr_api.g_varchar2,tmp.attribute_category,p_attribute_category)
140: ,DECODE(p_attribute1,hr_api.g_varchar2,tmp.attribute1,p_attribute1)
141: ,DECODE(p_attribute2,hr_api.g_varchar2,tmp.attribute2,p_attribute2)
142: ,DECODE(p_attribute3,hr_api.g_varchar2,tmp.attribute3,p_attribute3)
143: ,DECODE(p_attribute4,hr_api.g_varchar2,tmp.attribute4,p_attribute4)
144: ,DECODE(p_attribute5,hr_api.g_varchar2,tmp.attribute5,p_attribute5)
145: ,DECODE(p_attribute6,hr_api.g_varchar2,tmp.attribute6,p_attribute6)
146: ,DECODE(p_attribute7,hr_api.g_varchar2,tmp.attribute7,p_attribute7)

Line 143: ,DECODE(p_attribute4,hr_api.g_varchar2,tmp.attribute4,p_attribute4)

139: ,DECODE(p_attribute_category,hr_api.g_varchar2,tmp.attribute_category,p_attribute_category)
140: ,DECODE(p_attribute1,hr_api.g_varchar2,tmp.attribute1,p_attribute1)
141: ,DECODE(p_attribute2,hr_api.g_varchar2,tmp.attribute2,p_attribute2)
142: ,DECODE(p_attribute3,hr_api.g_varchar2,tmp.attribute3,p_attribute3)
143: ,DECODE(p_attribute4,hr_api.g_varchar2,tmp.attribute4,p_attribute4)
144: ,DECODE(p_attribute5,hr_api.g_varchar2,tmp.attribute5,p_attribute5)
145: ,DECODE(p_attribute6,hr_api.g_varchar2,tmp.attribute6,p_attribute6)
146: ,DECODE(p_attribute7,hr_api.g_varchar2,tmp.attribute7,p_attribute7)
147: ,DECODE(p_attribute8,hr_api.g_varchar2,tmp.attribute8,p_attribute8)

Line 144: ,DECODE(p_attribute5,hr_api.g_varchar2,tmp.attribute5,p_attribute5)

140: ,DECODE(p_attribute1,hr_api.g_varchar2,tmp.attribute1,p_attribute1)
141: ,DECODE(p_attribute2,hr_api.g_varchar2,tmp.attribute2,p_attribute2)
142: ,DECODE(p_attribute3,hr_api.g_varchar2,tmp.attribute3,p_attribute3)
143: ,DECODE(p_attribute4,hr_api.g_varchar2,tmp.attribute4,p_attribute4)
144: ,DECODE(p_attribute5,hr_api.g_varchar2,tmp.attribute5,p_attribute5)
145: ,DECODE(p_attribute6,hr_api.g_varchar2,tmp.attribute6,p_attribute6)
146: ,DECODE(p_attribute7,hr_api.g_varchar2,tmp.attribute7,p_attribute7)
147: ,DECODE(p_attribute8,hr_api.g_varchar2,tmp.attribute8,p_attribute8)
148: ,DECODE(p_attribute9,hr_api.g_varchar2,tmp.attribute9,p_attribute9)

Line 145: ,DECODE(p_attribute6,hr_api.g_varchar2,tmp.attribute6,p_attribute6)

141: ,DECODE(p_attribute2,hr_api.g_varchar2,tmp.attribute2,p_attribute2)
142: ,DECODE(p_attribute3,hr_api.g_varchar2,tmp.attribute3,p_attribute3)
143: ,DECODE(p_attribute4,hr_api.g_varchar2,tmp.attribute4,p_attribute4)
144: ,DECODE(p_attribute5,hr_api.g_varchar2,tmp.attribute5,p_attribute5)
145: ,DECODE(p_attribute6,hr_api.g_varchar2,tmp.attribute6,p_attribute6)
146: ,DECODE(p_attribute7,hr_api.g_varchar2,tmp.attribute7,p_attribute7)
147: ,DECODE(p_attribute8,hr_api.g_varchar2,tmp.attribute8,p_attribute8)
148: ,DECODE(p_attribute9,hr_api.g_varchar2,tmp.attribute9,p_attribute9)
149: ,DECODE(p_attribute10,hr_api.g_varchar2,tmp.attribute10,p_attribute10)

Line 146: ,DECODE(p_attribute7,hr_api.g_varchar2,tmp.attribute7,p_attribute7)

142: ,DECODE(p_attribute3,hr_api.g_varchar2,tmp.attribute3,p_attribute3)
143: ,DECODE(p_attribute4,hr_api.g_varchar2,tmp.attribute4,p_attribute4)
144: ,DECODE(p_attribute5,hr_api.g_varchar2,tmp.attribute5,p_attribute5)
145: ,DECODE(p_attribute6,hr_api.g_varchar2,tmp.attribute6,p_attribute6)
146: ,DECODE(p_attribute7,hr_api.g_varchar2,tmp.attribute7,p_attribute7)
147: ,DECODE(p_attribute8,hr_api.g_varchar2,tmp.attribute8,p_attribute8)
148: ,DECODE(p_attribute9,hr_api.g_varchar2,tmp.attribute9,p_attribute9)
149: ,DECODE(p_attribute10,hr_api.g_varchar2,tmp.attribute10,p_attribute10)
150: ,DECODE(p_attribute11,hr_api.g_varchar2,tmp.attribute11,p_attribute11)

Line 147: ,DECODE(p_attribute8,hr_api.g_varchar2,tmp.attribute8,p_attribute8)

143: ,DECODE(p_attribute4,hr_api.g_varchar2,tmp.attribute4,p_attribute4)
144: ,DECODE(p_attribute5,hr_api.g_varchar2,tmp.attribute5,p_attribute5)
145: ,DECODE(p_attribute6,hr_api.g_varchar2,tmp.attribute6,p_attribute6)
146: ,DECODE(p_attribute7,hr_api.g_varchar2,tmp.attribute7,p_attribute7)
147: ,DECODE(p_attribute8,hr_api.g_varchar2,tmp.attribute8,p_attribute8)
148: ,DECODE(p_attribute9,hr_api.g_varchar2,tmp.attribute9,p_attribute9)
149: ,DECODE(p_attribute10,hr_api.g_varchar2,tmp.attribute10,p_attribute10)
150: ,DECODE(p_attribute11,hr_api.g_varchar2,tmp.attribute11,p_attribute11)
151: ,DECODE(p_attribute12,hr_api.g_varchar2,tmp.attribute12,p_attribute12)

Line 148: ,DECODE(p_attribute9,hr_api.g_varchar2,tmp.attribute9,p_attribute9)

144: ,DECODE(p_attribute5,hr_api.g_varchar2,tmp.attribute5,p_attribute5)
145: ,DECODE(p_attribute6,hr_api.g_varchar2,tmp.attribute6,p_attribute6)
146: ,DECODE(p_attribute7,hr_api.g_varchar2,tmp.attribute7,p_attribute7)
147: ,DECODE(p_attribute8,hr_api.g_varchar2,tmp.attribute8,p_attribute8)
148: ,DECODE(p_attribute9,hr_api.g_varchar2,tmp.attribute9,p_attribute9)
149: ,DECODE(p_attribute10,hr_api.g_varchar2,tmp.attribute10,p_attribute10)
150: ,DECODE(p_attribute11,hr_api.g_varchar2,tmp.attribute11,p_attribute11)
151: ,DECODE(p_attribute12,hr_api.g_varchar2,tmp.attribute12,p_attribute12)
152: ,DECODE(p_attribute13,hr_api.g_varchar2,tmp.attribute13,p_attribute13)

Line 149: ,DECODE(p_attribute10,hr_api.g_varchar2,tmp.attribute10,p_attribute10)

145: ,DECODE(p_attribute6,hr_api.g_varchar2,tmp.attribute6,p_attribute6)
146: ,DECODE(p_attribute7,hr_api.g_varchar2,tmp.attribute7,p_attribute7)
147: ,DECODE(p_attribute8,hr_api.g_varchar2,tmp.attribute8,p_attribute8)
148: ,DECODE(p_attribute9,hr_api.g_varchar2,tmp.attribute9,p_attribute9)
149: ,DECODE(p_attribute10,hr_api.g_varchar2,tmp.attribute10,p_attribute10)
150: ,DECODE(p_attribute11,hr_api.g_varchar2,tmp.attribute11,p_attribute11)
151: ,DECODE(p_attribute12,hr_api.g_varchar2,tmp.attribute12,p_attribute12)
152: ,DECODE(p_attribute13,hr_api.g_varchar2,tmp.attribute13,p_attribute13)
153: ,DECODE(p_attribute14,hr_api.g_varchar2,tmp.attribute14,p_attribute14)

Line 150: ,DECODE(p_attribute11,hr_api.g_varchar2,tmp.attribute11,p_attribute11)

146: ,DECODE(p_attribute7,hr_api.g_varchar2,tmp.attribute7,p_attribute7)
147: ,DECODE(p_attribute8,hr_api.g_varchar2,tmp.attribute8,p_attribute8)
148: ,DECODE(p_attribute9,hr_api.g_varchar2,tmp.attribute9,p_attribute9)
149: ,DECODE(p_attribute10,hr_api.g_varchar2,tmp.attribute10,p_attribute10)
150: ,DECODE(p_attribute11,hr_api.g_varchar2,tmp.attribute11,p_attribute11)
151: ,DECODE(p_attribute12,hr_api.g_varchar2,tmp.attribute12,p_attribute12)
152: ,DECODE(p_attribute13,hr_api.g_varchar2,tmp.attribute13,p_attribute13)
153: ,DECODE(p_attribute14,hr_api.g_varchar2,tmp.attribute14,p_attribute14)
154: ,DECODE(p_attribute15,hr_api.g_varchar2,tmp.attribute15,p_attribute15)

Line 151: ,DECODE(p_attribute12,hr_api.g_varchar2,tmp.attribute12,p_attribute12)

147: ,DECODE(p_attribute8,hr_api.g_varchar2,tmp.attribute8,p_attribute8)
148: ,DECODE(p_attribute9,hr_api.g_varchar2,tmp.attribute9,p_attribute9)
149: ,DECODE(p_attribute10,hr_api.g_varchar2,tmp.attribute10,p_attribute10)
150: ,DECODE(p_attribute11,hr_api.g_varchar2,tmp.attribute11,p_attribute11)
151: ,DECODE(p_attribute12,hr_api.g_varchar2,tmp.attribute12,p_attribute12)
152: ,DECODE(p_attribute13,hr_api.g_varchar2,tmp.attribute13,p_attribute13)
153: ,DECODE(p_attribute14,hr_api.g_varchar2,tmp.attribute14,p_attribute14)
154: ,DECODE(p_attribute15,hr_api.g_varchar2,tmp.attribute15,p_attribute15)
155: ,DECODE(p_attribute16,hr_api.g_varchar2,tmp.attribute16,p_attribute16)

Line 152: ,DECODE(p_attribute13,hr_api.g_varchar2,tmp.attribute13,p_attribute13)

148: ,DECODE(p_attribute9,hr_api.g_varchar2,tmp.attribute9,p_attribute9)
149: ,DECODE(p_attribute10,hr_api.g_varchar2,tmp.attribute10,p_attribute10)
150: ,DECODE(p_attribute11,hr_api.g_varchar2,tmp.attribute11,p_attribute11)
151: ,DECODE(p_attribute12,hr_api.g_varchar2,tmp.attribute12,p_attribute12)
152: ,DECODE(p_attribute13,hr_api.g_varchar2,tmp.attribute13,p_attribute13)
153: ,DECODE(p_attribute14,hr_api.g_varchar2,tmp.attribute14,p_attribute14)
154: ,DECODE(p_attribute15,hr_api.g_varchar2,tmp.attribute15,p_attribute15)
155: ,DECODE(p_attribute16,hr_api.g_varchar2,tmp.attribute16,p_attribute16)
156: ,DECODE(p_attribute17,hr_api.g_varchar2,tmp.attribute17,p_attribute17)

Line 153: ,DECODE(p_attribute14,hr_api.g_varchar2,tmp.attribute14,p_attribute14)

149: ,DECODE(p_attribute10,hr_api.g_varchar2,tmp.attribute10,p_attribute10)
150: ,DECODE(p_attribute11,hr_api.g_varchar2,tmp.attribute11,p_attribute11)
151: ,DECODE(p_attribute12,hr_api.g_varchar2,tmp.attribute12,p_attribute12)
152: ,DECODE(p_attribute13,hr_api.g_varchar2,tmp.attribute13,p_attribute13)
153: ,DECODE(p_attribute14,hr_api.g_varchar2,tmp.attribute14,p_attribute14)
154: ,DECODE(p_attribute15,hr_api.g_varchar2,tmp.attribute15,p_attribute15)
155: ,DECODE(p_attribute16,hr_api.g_varchar2,tmp.attribute16,p_attribute16)
156: ,DECODE(p_attribute17,hr_api.g_varchar2,tmp.attribute17,p_attribute17)
157: ,DECODE(p_attribute18,hr_api.g_varchar2,tmp.attribute18,p_attribute18)

Line 154: ,DECODE(p_attribute15,hr_api.g_varchar2,tmp.attribute15,p_attribute15)

150: ,DECODE(p_attribute11,hr_api.g_varchar2,tmp.attribute11,p_attribute11)
151: ,DECODE(p_attribute12,hr_api.g_varchar2,tmp.attribute12,p_attribute12)
152: ,DECODE(p_attribute13,hr_api.g_varchar2,tmp.attribute13,p_attribute13)
153: ,DECODE(p_attribute14,hr_api.g_varchar2,tmp.attribute14,p_attribute14)
154: ,DECODE(p_attribute15,hr_api.g_varchar2,tmp.attribute15,p_attribute15)
155: ,DECODE(p_attribute16,hr_api.g_varchar2,tmp.attribute16,p_attribute16)
156: ,DECODE(p_attribute17,hr_api.g_varchar2,tmp.attribute17,p_attribute17)
157: ,DECODE(p_attribute18,hr_api.g_varchar2,tmp.attribute18,p_attribute18)
158: ,DECODE(p_attribute19,hr_api.g_varchar2,tmp.attribute19,p_attribute19)

Line 155: ,DECODE(p_attribute16,hr_api.g_varchar2,tmp.attribute16,p_attribute16)

151: ,DECODE(p_attribute12,hr_api.g_varchar2,tmp.attribute12,p_attribute12)
152: ,DECODE(p_attribute13,hr_api.g_varchar2,tmp.attribute13,p_attribute13)
153: ,DECODE(p_attribute14,hr_api.g_varchar2,tmp.attribute14,p_attribute14)
154: ,DECODE(p_attribute15,hr_api.g_varchar2,tmp.attribute15,p_attribute15)
155: ,DECODE(p_attribute16,hr_api.g_varchar2,tmp.attribute16,p_attribute16)
156: ,DECODE(p_attribute17,hr_api.g_varchar2,tmp.attribute17,p_attribute17)
157: ,DECODE(p_attribute18,hr_api.g_varchar2,tmp.attribute18,p_attribute18)
158: ,DECODE(p_attribute19,hr_api.g_varchar2,tmp.attribute19,p_attribute19)
159: ,DECODE(p_attribute20,hr_api.g_varchar2,tmp.attribute20,p_attribute20)

Line 156: ,DECODE(p_attribute17,hr_api.g_varchar2,tmp.attribute17,p_attribute17)

152: ,DECODE(p_attribute13,hr_api.g_varchar2,tmp.attribute13,p_attribute13)
153: ,DECODE(p_attribute14,hr_api.g_varchar2,tmp.attribute14,p_attribute14)
154: ,DECODE(p_attribute15,hr_api.g_varchar2,tmp.attribute15,p_attribute15)
155: ,DECODE(p_attribute16,hr_api.g_varchar2,tmp.attribute16,p_attribute16)
156: ,DECODE(p_attribute17,hr_api.g_varchar2,tmp.attribute17,p_attribute17)
157: ,DECODE(p_attribute18,hr_api.g_varchar2,tmp.attribute18,p_attribute18)
158: ,DECODE(p_attribute19,hr_api.g_varchar2,tmp.attribute19,p_attribute19)
159: ,DECODE(p_attribute20,hr_api.g_varchar2,tmp.attribute20,p_attribute20)
160: ,DECODE(p_attribute21,hr_api.g_varchar2,tmp.attribute21,p_attribute21)

Line 157: ,DECODE(p_attribute18,hr_api.g_varchar2,tmp.attribute18,p_attribute18)

153: ,DECODE(p_attribute14,hr_api.g_varchar2,tmp.attribute14,p_attribute14)
154: ,DECODE(p_attribute15,hr_api.g_varchar2,tmp.attribute15,p_attribute15)
155: ,DECODE(p_attribute16,hr_api.g_varchar2,tmp.attribute16,p_attribute16)
156: ,DECODE(p_attribute17,hr_api.g_varchar2,tmp.attribute17,p_attribute17)
157: ,DECODE(p_attribute18,hr_api.g_varchar2,tmp.attribute18,p_attribute18)
158: ,DECODE(p_attribute19,hr_api.g_varchar2,tmp.attribute19,p_attribute19)
159: ,DECODE(p_attribute20,hr_api.g_varchar2,tmp.attribute20,p_attribute20)
160: ,DECODE(p_attribute21,hr_api.g_varchar2,tmp.attribute21,p_attribute21)
161: ,DECODE(p_attribute22,hr_api.g_varchar2,tmp.attribute22,p_attribute22)

Line 158: ,DECODE(p_attribute19,hr_api.g_varchar2,tmp.attribute19,p_attribute19)

154: ,DECODE(p_attribute15,hr_api.g_varchar2,tmp.attribute15,p_attribute15)
155: ,DECODE(p_attribute16,hr_api.g_varchar2,tmp.attribute16,p_attribute16)
156: ,DECODE(p_attribute17,hr_api.g_varchar2,tmp.attribute17,p_attribute17)
157: ,DECODE(p_attribute18,hr_api.g_varchar2,tmp.attribute18,p_attribute18)
158: ,DECODE(p_attribute19,hr_api.g_varchar2,tmp.attribute19,p_attribute19)
159: ,DECODE(p_attribute20,hr_api.g_varchar2,tmp.attribute20,p_attribute20)
160: ,DECODE(p_attribute21,hr_api.g_varchar2,tmp.attribute21,p_attribute21)
161: ,DECODE(p_attribute22,hr_api.g_varchar2,tmp.attribute22,p_attribute22)
162: ,DECODE(p_attribute23,hr_api.g_varchar2,tmp.attribute23,p_attribute23)

Line 159: ,DECODE(p_attribute20,hr_api.g_varchar2,tmp.attribute20,p_attribute20)

155: ,DECODE(p_attribute16,hr_api.g_varchar2,tmp.attribute16,p_attribute16)
156: ,DECODE(p_attribute17,hr_api.g_varchar2,tmp.attribute17,p_attribute17)
157: ,DECODE(p_attribute18,hr_api.g_varchar2,tmp.attribute18,p_attribute18)
158: ,DECODE(p_attribute19,hr_api.g_varchar2,tmp.attribute19,p_attribute19)
159: ,DECODE(p_attribute20,hr_api.g_varchar2,tmp.attribute20,p_attribute20)
160: ,DECODE(p_attribute21,hr_api.g_varchar2,tmp.attribute21,p_attribute21)
161: ,DECODE(p_attribute22,hr_api.g_varchar2,tmp.attribute22,p_attribute22)
162: ,DECODE(p_attribute23,hr_api.g_varchar2,tmp.attribute23,p_attribute23)
163: ,DECODE(p_attribute24,hr_api.g_varchar2,tmp.attribute24,p_attribute24)

Line 160: ,DECODE(p_attribute21,hr_api.g_varchar2,tmp.attribute21,p_attribute21)

156: ,DECODE(p_attribute17,hr_api.g_varchar2,tmp.attribute17,p_attribute17)
157: ,DECODE(p_attribute18,hr_api.g_varchar2,tmp.attribute18,p_attribute18)
158: ,DECODE(p_attribute19,hr_api.g_varchar2,tmp.attribute19,p_attribute19)
159: ,DECODE(p_attribute20,hr_api.g_varchar2,tmp.attribute20,p_attribute20)
160: ,DECODE(p_attribute21,hr_api.g_varchar2,tmp.attribute21,p_attribute21)
161: ,DECODE(p_attribute22,hr_api.g_varchar2,tmp.attribute22,p_attribute22)
162: ,DECODE(p_attribute23,hr_api.g_varchar2,tmp.attribute23,p_attribute23)
163: ,DECODE(p_attribute24,hr_api.g_varchar2,tmp.attribute24,p_attribute24)
164: ,DECODE(p_attribute25,hr_api.g_varchar2,tmp.attribute25,p_attribute25)

Line 161: ,DECODE(p_attribute22,hr_api.g_varchar2,tmp.attribute22,p_attribute22)

157: ,DECODE(p_attribute18,hr_api.g_varchar2,tmp.attribute18,p_attribute18)
158: ,DECODE(p_attribute19,hr_api.g_varchar2,tmp.attribute19,p_attribute19)
159: ,DECODE(p_attribute20,hr_api.g_varchar2,tmp.attribute20,p_attribute20)
160: ,DECODE(p_attribute21,hr_api.g_varchar2,tmp.attribute21,p_attribute21)
161: ,DECODE(p_attribute22,hr_api.g_varchar2,tmp.attribute22,p_attribute22)
162: ,DECODE(p_attribute23,hr_api.g_varchar2,tmp.attribute23,p_attribute23)
163: ,DECODE(p_attribute24,hr_api.g_varchar2,tmp.attribute24,p_attribute24)
164: ,DECODE(p_attribute25,hr_api.g_varchar2,tmp.attribute25,p_attribute25)
165: ,DECODE(p_attribute26,hr_api.g_varchar2,tmp.attribute26,p_attribute26)

Line 162: ,DECODE(p_attribute23,hr_api.g_varchar2,tmp.attribute23,p_attribute23)

158: ,DECODE(p_attribute19,hr_api.g_varchar2,tmp.attribute19,p_attribute19)
159: ,DECODE(p_attribute20,hr_api.g_varchar2,tmp.attribute20,p_attribute20)
160: ,DECODE(p_attribute21,hr_api.g_varchar2,tmp.attribute21,p_attribute21)
161: ,DECODE(p_attribute22,hr_api.g_varchar2,tmp.attribute22,p_attribute22)
162: ,DECODE(p_attribute23,hr_api.g_varchar2,tmp.attribute23,p_attribute23)
163: ,DECODE(p_attribute24,hr_api.g_varchar2,tmp.attribute24,p_attribute24)
164: ,DECODE(p_attribute25,hr_api.g_varchar2,tmp.attribute25,p_attribute25)
165: ,DECODE(p_attribute26,hr_api.g_varchar2,tmp.attribute26,p_attribute26)
166: ,DECODE(p_attribute27,hr_api.g_varchar2,tmp.attribute27,p_attribute27)

Line 163: ,DECODE(p_attribute24,hr_api.g_varchar2,tmp.attribute24,p_attribute24)

159: ,DECODE(p_attribute20,hr_api.g_varchar2,tmp.attribute20,p_attribute20)
160: ,DECODE(p_attribute21,hr_api.g_varchar2,tmp.attribute21,p_attribute21)
161: ,DECODE(p_attribute22,hr_api.g_varchar2,tmp.attribute22,p_attribute22)
162: ,DECODE(p_attribute23,hr_api.g_varchar2,tmp.attribute23,p_attribute23)
163: ,DECODE(p_attribute24,hr_api.g_varchar2,tmp.attribute24,p_attribute24)
164: ,DECODE(p_attribute25,hr_api.g_varchar2,tmp.attribute25,p_attribute25)
165: ,DECODE(p_attribute26,hr_api.g_varchar2,tmp.attribute26,p_attribute26)
166: ,DECODE(p_attribute27,hr_api.g_varchar2,tmp.attribute27,p_attribute27)
167: ,DECODE(p_attribute28,hr_api.g_varchar2,tmp.attribute28,p_attribute28)

Line 164: ,DECODE(p_attribute25,hr_api.g_varchar2,tmp.attribute25,p_attribute25)

160: ,DECODE(p_attribute21,hr_api.g_varchar2,tmp.attribute21,p_attribute21)
161: ,DECODE(p_attribute22,hr_api.g_varchar2,tmp.attribute22,p_attribute22)
162: ,DECODE(p_attribute23,hr_api.g_varchar2,tmp.attribute23,p_attribute23)
163: ,DECODE(p_attribute24,hr_api.g_varchar2,tmp.attribute24,p_attribute24)
164: ,DECODE(p_attribute25,hr_api.g_varchar2,tmp.attribute25,p_attribute25)
165: ,DECODE(p_attribute26,hr_api.g_varchar2,tmp.attribute26,p_attribute26)
166: ,DECODE(p_attribute27,hr_api.g_varchar2,tmp.attribute27,p_attribute27)
167: ,DECODE(p_attribute28,hr_api.g_varchar2,tmp.attribute28,p_attribute28)
168: ,DECODE(p_attribute29,hr_api.g_varchar2,tmp.attribute29,p_attribute29)

Line 165: ,DECODE(p_attribute26,hr_api.g_varchar2,tmp.attribute26,p_attribute26)

161: ,DECODE(p_attribute22,hr_api.g_varchar2,tmp.attribute22,p_attribute22)
162: ,DECODE(p_attribute23,hr_api.g_varchar2,tmp.attribute23,p_attribute23)
163: ,DECODE(p_attribute24,hr_api.g_varchar2,tmp.attribute24,p_attribute24)
164: ,DECODE(p_attribute25,hr_api.g_varchar2,tmp.attribute25,p_attribute25)
165: ,DECODE(p_attribute26,hr_api.g_varchar2,tmp.attribute26,p_attribute26)
166: ,DECODE(p_attribute27,hr_api.g_varchar2,tmp.attribute27,p_attribute27)
167: ,DECODE(p_attribute28,hr_api.g_varchar2,tmp.attribute28,p_attribute28)
168: ,DECODE(p_attribute29,hr_api.g_varchar2,tmp.attribute29,p_attribute29)
169: ,DECODE(p_attribute30,hr_api.g_varchar2,tmp.attribute30,p_attribute30)

Line 166: ,DECODE(p_attribute27,hr_api.g_varchar2,tmp.attribute27,p_attribute27)

162: ,DECODE(p_attribute23,hr_api.g_varchar2,tmp.attribute23,p_attribute23)
163: ,DECODE(p_attribute24,hr_api.g_varchar2,tmp.attribute24,p_attribute24)
164: ,DECODE(p_attribute25,hr_api.g_varchar2,tmp.attribute25,p_attribute25)
165: ,DECODE(p_attribute26,hr_api.g_varchar2,tmp.attribute26,p_attribute26)
166: ,DECODE(p_attribute27,hr_api.g_varchar2,tmp.attribute27,p_attribute27)
167: ,DECODE(p_attribute28,hr_api.g_varchar2,tmp.attribute28,p_attribute28)
168: ,DECODE(p_attribute29,hr_api.g_varchar2,tmp.attribute29,p_attribute29)
169: ,DECODE(p_attribute30,hr_api.g_varchar2,tmp.attribute30,p_attribute30)
170: FROM hr_form_templates_b tmp

Line 167: ,DECODE(p_attribute28,hr_api.g_varchar2,tmp.attribute28,p_attribute28)

163: ,DECODE(p_attribute24,hr_api.g_varchar2,tmp.attribute24,p_attribute24)
164: ,DECODE(p_attribute25,hr_api.g_varchar2,tmp.attribute25,p_attribute25)
165: ,DECODE(p_attribute26,hr_api.g_varchar2,tmp.attribute26,p_attribute26)
166: ,DECODE(p_attribute27,hr_api.g_varchar2,tmp.attribute27,p_attribute27)
167: ,DECODE(p_attribute28,hr_api.g_varchar2,tmp.attribute28,p_attribute28)
168: ,DECODE(p_attribute29,hr_api.g_varchar2,tmp.attribute29,p_attribute29)
169: ,DECODE(p_attribute30,hr_api.g_varchar2,tmp.attribute30,p_attribute30)
170: FROM hr_form_templates_b tmp
171: WHERE tmp.form_template_id = p_form_template_id_from;

Line 168: ,DECODE(p_attribute29,hr_api.g_varchar2,tmp.attribute29,p_attribute29)

164: ,DECODE(p_attribute25,hr_api.g_varchar2,tmp.attribute25,p_attribute25)
165: ,DECODE(p_attribute26,hr_api.g_varchar2,tmp.attribute26,p_attribute26)
166: ,DECODE(p_attribute27,hr_api.g_varchar2,tmp.attribute27,p_attribute27)
167: ,DECODE(p_attribute28,hr_api.g_varchar2,tmp.attribute28,p_attribute28)
168: ,DECODE(p_attribute29,hr_api.g_varchar2,tmp.attribute29,p_attribute29)
169: ,DECODE(p_attribute30,hr_api.g_varchar2,tmp.attribute30,p_attribute30)
170: FROM hr_form_templates_b tmp
171: WHERE tmp.form_template_id = p_form_template_id_from;
172:

Line 169: ,DECODE(p_attribute30,hr_api.g_varchar2,tmp.attribute30,p_attribute30)

165: ,DECODE(p_attribute26,hr_api.g_varchar2,tmp.attribute26,p_attribute26)
166: ,DECODE(p_attribute27,hr_api.g_varchar2,tmp.attribute27,p_attribute27)
167: ,DECODE(p_attribute28,hr_api.g_varchar2,tmp.attribute28,p_attribute28)
168: ,DECODE(p_attribute29,hr_api.g_varchar2,tmp.attribute29,p_attribute29)
169: ,DECODE(p_attribute30,hr_api.g_varchar2,tmp.attribute30,p_attribute30)
170: FROM hr_form_templates_b tmp
171: WHERE tmp.form_template_id = p_form_template_id_from;
172:
173: CURSOR cur_tmplt_tl

Line 177: ,DECODE(p_user_template_name,hr_api.g_varchar2,tmptl.user_template_name,p_user_template_name) user_template_name

173: CURSOR cur_tmplt_tl
174: IS
175: SELECT COUNT(0)
176: ,tmptl.source_lang
177: ,DECODE(p_user_template_name,hr_api.g_varchar2,tmptl.user_template_name,p_user_template_name) user_template_name
178: ,DECODE(p_description,hr_api.g_varchar2,tmptl.description,p_description) description
179: FROM hr_form_templates_tl tmptl
180: WHERE tmptl.form_template_id = p_form_template_id_from
181: GROUP BY tmptl.source_lang

Line 178: ,DECODE(p_description,hr_api.g_varchar2,tmptl.description,p_description) description

174: IS
175: SELECT COUNT(0)
176: ,tmptl.source_lang
177: ,DECODE(p_user_template_name,hr_api.g_varchar2,tmptl.user_template_name,p_user_template_name) user_template_name
178: ,DECODE(p_description,hr_api.g_varchar2,tmptl.description,p_description) description
179: FROM hr_form_templates_tl tmptl
180: WHERE tmptl.form_template_id = p_form_template_id_from
181: GROUP BY tmptl.source_lang
182: ,DECODE(p_user_template_name,hr_api.g_varchar2,tmptl.user_template_name,p_user_template_name)

Line 182: ,DECODE(p_user_template_name,hr_api.g_varchar2,tmptl.user_template_name,p_user_template_name)

178: ,DECODE(p_description,hr_api.g_varchar2,tmptl.description,p_description) description
179: FROM hr_form_templates_tl tmptl
180: WHERE tmptl.form_template_id = p_form_template_id_from
181: GROUP BY tmptl.source_lang
182: ,DECODE(p_user_template_name,hr_api.g_varchar2,tmptl.user_template_name,p_user_template_name)
183: ,DECODE(p_description,hr_api.g_varchar2,tmptl.description,p_description)
184: ORDER BY 1;
185:
186: CURSOR cur_tmplt_win

Line 183: ,DECODE(p_description,hr_api.g_varchar2,tmptl.description,p_description)

179: FROM hr_form_templates_tl tmptl
180: WHERE tmptl.form_template_id = p_form_template_id_from
181: GROUP BY tmptl.source_lang
182: ,DECODE(p_user_template_name,hr_api.g_varchar2,tmptl.user_template_name,p_user_template_name)
183: ,DECODE(p_description,hr_api.g_varchar2,tmptl.description,p_description)
184: ORDER BY 1;
185:
186: CURSOR cur_tmplt_win
187: IS

Line 244: hr_api.validate_language_code(p_language_code => l_language_code);

240: -- instead of p_language_code from now on, to allow an IN OUT parameter to
241: -- be passed through.
242: --
243: l_language_code := p_language_code;
244: hr_api.validate_language_code(p_language_code => l_language_code);
245: --
246: hr_utility.set_location(l_proc, 20);
247: --
248: --

Line 293: when hr_api.cannot_find_prog_unit then

289: ,p_attribute28 => p_attribute28
290: ,p_attribute29 => p_attribute29
291: ,p_attribute30 => p_attribute30);
292: exception
293: when hr_api.cannot_find_prog_unit then
294: hr_api.cannot_find_prog_unit_error
295: (p_module_name => 'copy_template'
296: ,p_hook_type => 'BP'
297: );

Line 294: hr_api.cannot_find_prog_unit_error

290: ,p_attribute29 => p_attribute29
291: ,p_attribute30 => p_attribute30);
292: exception
293: when hr_api.cannot_find_prog_unit then
294: hr_api.cannot_find_prog_unit_error
295: (p_module_name => 'copy_template'
296: ,p_hook_type => 'BP'
297: );
298: end;

Line 362: IF (p_user_template_name <> hr_api.g_varchar2

358: ,p_object_version_number => l_object_version_number);
359:
360: hr_utility.set_location('At:'|| l_proc, 40);
361:
362: IF (p_user_template_name <> hr_api.g_varchar2
363: AND p_description <> hr_api.g_varchar2) THEN
364:
365: hr_utility.set_location('At:'|| l_proc, 41);
366:

Line 363: AND p_description <> hr_api.g_varchar2) THEN

359:
360: hr_utility.set_location('At:'|| l_proc, 40);
361:
362: IF (p_user_template_name <> hr_api.g_varchar2
363: AND p_description <> hr_api.g_varchar2) THEN
364:
365: hr_utility.set_location('At:'|| l_proc, 41);
366:
367: hr_tmt_ins.ins_tl( p_language_code => l_language_code

Line 534: when hr_api.cannot_find_prog_unit then

530: ,p_attribute30 => p_attribute30
531: ,p_form_template_id_to => l_form_template_id_to
532: ,p_object_version_number => l_object_version_number);
533: exception
534: when hr_api.cannot_find_prog_unit then
535: hr_api.cannot_find_prog_unit_error
536: (p_module_name => 'copy_template'
537: ,p_hook_type => 'AP'
538: );

Line 535: hr_api.cannot_find_prog_unit_error

531: ,p_form_template_id_to => l_form_template_id_to
532: ,p_object_version_number => l_object_version_number);
533: exception
534: when hr_api.cannot_find_prog_unit then
535: hr_api.cannot_find_prog_unit_error
536: (p_module_name => 'copy_template'
537: ,p_hook_type => 'AP'
538: );
539: end;

Line 546: raise hr_api.validate_enabled;

542: --
543: hr_utility.set_location('At:'|| l_proc, 80);
544:
545: if p_validate then
546: raise hr_api.validate_enabled;
547: end if;
548: --
549: -- Set all output arguments
550: --

Line 556: when hr_api.validate_enabled then

552: p_object_version_number := l_object_version_number;
553: --
554: hr_utility.set_location(' Leaving:'||l_proc, 85);
555: exception
556: when hr_api.validate_enabled then
557: --
558: -- As the Validate_Enabled exception has been raised
559: -- we must rollback to the savepoint
560: --

Line 589: ,p_language_code in varchar2 default hr_api.userenv_lang

585: --
586: procedure create_template
587: (p_validate in boolean default false
588: ,p_effective_date in date
589: ,p_language_code in varchar2 default hr_api.userenv_lang
590: ,p_application_id in number
591: ,p_form_id in number
592: ,p_template_name in varchar2
593: ,p_enabled_flag in varchar2

Line 628: ,p_help_target in varchar2 default hr_api.g_varchar2

624: ,p_attribute27 in varchar2 default null
625: ,p_attribute28 in varchar2 default null
626: ,p_attribute29 in varchar2 default null
627: ,p_attribute30 in varchar2 default null
628: ,p_help_target in varchar2 default hr_api.g_varchar2
629: ,p_information_category in varchar2 default hr_api.g_varchar2
630: ,p_information1 in varchar2 default hr_api.g_varchar2
631: ,p_information2 in varchar2 default hr_api.g_varchar2
632: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 629: ,p_information_category in varchar2 default hr_api.g_varchar2

625: ,p_attribute28 in varchar2 default null
626: ,p_attribute29 in varchar2 default null
627: ,p_attribute30 in varchar2 default null
628: ,p_help_target in varchar2 default hr_api.g_varchar2
629: ,p_information_category in varchar2 default hr_api.g_varchar2
630: ,p_information1 in varchar2 default hr_api.g_varchar2
631: ,p_information2 in varchar2 default hr_api.g_varchar2
632: ,p_information3 in varchar2 default hr_api.g_varchar2
633: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 630: ,p_information1 in varchar2 default hr_api.g_varchar2

626: ,p_attribute29 in varchar2 default null
627: ,p_attribute30 in varchar2 default null
628: ,p_help_target in varchar2 default hr_api.g_varchar2
629: ,p_information_category in varchar2 default hr_api.g_varchar2
630: ,p_information1 in varchar2 default hr_api.g_varchar2
631: ,p_information2 in varchar2 default hr_api.g_varchar2
632: ,p_information3 in varchar2 default hr_api.g_varchar2
633: ,p_information4 in varchar2 default hr_api.g_varchar2
634: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 631: ,p_information2 in varchar2 default hr_api.g_varchar2

627: ,p_attribute30 in varchar2 default null
628: ,p_help_target in varchar2 default hr_api.g_varchar2
629: ,p_information_category in varchar2 default hr_api.g_varchar2
630: ,p_information1 in varchar2 default hr_api.g_varchar2
631: ,p_information2 in varchar2 default hr_api.g_varchar2
632: ,p_information3 in varchar2 default hr_api.g_varchar2
633: ,p_information4 in varchar2 default hr_api.g_varchar2
634: ,p_information5 in varchar2 default hr_api.g_varchar2
635: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 632: ,p_information3 in varchar2 default hr_api.g_varchar2

628: ,p_help_target in varchar2 default hr_api.g_varchar2
629: ,p_information_category in varchar2 default hr_api.g_varchar2
630: ,p_information1 in varchar2 default hr_api.g_varchar2
631: ,p_information2 in varchar2 default hr_api.g_varchar2
632: ,p_information3 in varchar2 default hr_api.g_varchar2
633: ,p_information4 in varchar2 default hr_api.g_varchar2
634: ,p_information5 in varchar2 default hr_api.g_varchar2
635: ,p_information6 in varchar2 default hr_api.g_varchar2
636: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 633: ,p_information4 in varchar2 default hr_api.g_varchar2

629: ,p_information_category in varchar2 default hr_api.g_varchar2
630: ,p_information1 in varchar2 default hr_api.g_varchar2
631: ,p_information2 in varchar2 default hr_api.g_varchar2
632: ,p_information3 in varchar2 default hr_api.g_varchar2
633: ,p_information4 in varchar2 default hr_api.g_varchar2
634: ,p_information5 in varchar2 default hr_api.g_varchar2
635: ,p_information6 in varchar2 default hr_api.g_varchar2
636: ,p_information7 in varchar2 default hr_api.g_varchar2
637: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 634: ,p_information5 in varchar2 default hr_api.g_varchar2

630: ,p_information1 in varchar2 default hr_api.g_varchar2
631: ,p_information2 in varchar2 default hr_api.g_varchar2
632: ,p_information3 in varchar2 default hr_api.g_varchar2
633: ,p_information4 in varchar2 default hr_api.g_varchar2
634: ,p_information5 in varchar2 default hr_api.g_varchar2
635: ,p_information6 in varchar2 default hr_api.g_varchar2
636: ,p_information7 in varchar2 default hr_api.g_varchar2
637: ,p_information8 in varchar2 default hr_api.g_varchar2
638: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 635: ,p_information6 in varchar2 default hr_api.g_varchar2

631: ,p_information2 in varchar2 default hr_api.g_varchar2
632: ,p_information3 in varchar2 default hr_api.g_varchar2
633: ,p_information4 in varchar2 default hr_api.g_varchar2
634: ,p_information5 in varchar2 default hr_api.g_varchar2
635: ,p_information6 in varchar2 default hr_api.g_varchar2
636: ,p_information7 in varchar2 default hr_api.g_varchar2
637: ,p_information8 in varchar2 default hr_api.g_varchar2
638: ,p_information9 in varchar2 default hr_api.g_varchar2
639: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 636: ,p_information7 in varchar2 default hr_api.g_varchar2

632: ,p_information3 in varchar2 default hr_api.g_varchar2
633: ,p_information4 in varchar2 default hr_api.g_varchar2
634: ,p_information5 in varchar2 default hr_api.g_varchar2
635: ,p_information6 in varchar2 default hr_api.g_varchar2
636: ,p_information7 in varchar2 default hr_api.g_varchar2
637: ,p_information8 in varchar2 default hr_api.g_varchar2
638: ,p_information9 in varchar2 default hr_api.g_varchar2
639: ,p_information10 in varchar2 default hr_api.g_varchar2
640: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 637: ,p_information8 in varchar2 default hr_api.g_varchar2

633: ,p_information4 in varchar2 default hr_api.g_varchar2
634: ,p_information5 in varchar2 default hr_api.g_varchar2
635: ,p_information6 in varchar2 default hr_api.g_varchar2
636: ,p_information7 in varchar2 default hr_api.g_varchar2
637: ,p_information8 in varchar2 default hr_api.g_varchar2
638: ,p_information9 in varchar2 default hr_api.g_varchar2
639: ,p_information10 in varchar2 default hr_api.g_varchar2
640: ,p_information11 in varchar2 default hr_api.g_varchar2
641: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 638: ,p_information9 in varchar2 default hr_api.g_varchar2

634: ,p_information5 in varchar2 default hr_api.g_varchar2
635: ,p_information6 in varchar2 default hr_api.g_varchar2
636: ,p_information7 in varchar2 default hr_api.g_varchar2
637: ,p_information8 in varchar2 default hr_api.g_varchar2
638: ,p_information9 in varchar2 default hr_api.g_varchar2
639: ,p_information10 in varchar2 default hr_api.g_varchar2
640: ,p_information11 in varchar2 default hr_api.g_varchar2
641: ,p_information12 in varchar2 default hr_api.g_varchar2
642: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 639: ,p_information10 in varchar2 default hr_api.g_varchar2

635: ,p_information6 in varchar2 default hr_api.g_varchar2
636: ,p_information7 in varchar2 default hr_api.g_varchar2
637: ,p_information8 in varchar2 default hr_api.g_varchar2
638: ,p_information9 in varchar2 default hr_api.g_varchar2
639: ,p_information10 in varchar2 default hr_api.g_varchar2
640: ,p_information11 in varchar2 default hr_api.g_varchar2
641: ,p_information12 in varchar2 default hr_api.g_varchar2
642: ,p_information13 in varchar2 default hr_api.g_varchar2
643: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 640: ,p_information11 in varchar2 default hr_api.g_varchar2

636: ,p_information7 in varchar2 default hr_api.g_varchar2
637: ,p_information8 in varchar2 default hr_api.g_varchar2
638: ,p_information9 in varchar2 default hr_api.g_varchar2
639: ,p_information10 in varchar2 default hr_api.g_varchar2
640: ,p_information11 in varchar2 default hr_api.g_varchar2
641: ,p_information12 in varchar2 default hr_api.g_varchar2
642: ,p_information13 in varchar2 default hr_api.g_varchar2
643: ,p_information14 in varchar2 default hr_api.g_varchar2
644: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 641: ,p_information12 in varchar2 default hr_api.g_varchar2

637: ,p_information8 in varchar2 default hr_api.g_varchar2
638: ,p_information9 in varchar2 default hr_api.g_varchar2
639: ,p_information10 in varchar2 default hr_api.g_varchar2
640: ,p_information11 in varchar2 default hr_api.g_varchar2
641: ,p_information12 in varchar2 default hr_api.g_varchar2
642: ,p_information13 in varchar2 default hr_api.g_varchar2
643: ,p_information14 in varchar2 default hr_api.g_varchar2
644: ,p_information15 in varchar2 default hr_api.g_varchar2
645: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 642: ,p_information13 in varchar2 default hr_api.g_varchar2

638: ,p_information9 in varchar2 default hr_api.g_varchar2
639: ,p_information10 in varchar2 default hr_api.g_varchar2
640: ,p_information11 in varchar2 default hr_api.g_varchar2
641: ,p_information12 in varchar2 default hr_api.g_varchar2
642: ,p_information13 in varchar2 default hr_api.g_varchar2
643: ,p_information14 in varchar2 default hr_api.g_varchar2
644: ,p_information15 in varchar2 default hr_api.g_varchar2
645: ,p_information16 in varchar2 default hr_api.g_varchar2
646: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 643: ,p_information14 in varchar2 default hr_api.g_varchar2

639: ,p_information10 in varchar2 default hr_api.g_varchar2
640: ,p_information11 in varchar2 default hr_api.g_varchar2
641: ,p_information12 in varchar2 default hr_api.g_varchar2
642: ,p_information13 in varchar2 default hr_api.g_varchar2
643: ,p_information14 in varchar2 default hr_api.g_varchar2
644: ,p_information15 in varchar2 default hr_api.g_varchar2
645: ,p_information16 in varchar2 default hr_api.g_varchar2
646: ,p_information17 in varchar2 default hr_api.g_varchar2
647: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 644: ,p_information15 in varchar2 default hr_api.g_varchar2

640: ,p_information11 in varchar2 default hr_api.g_varchar2
641: ,p_information12 in varchar2 default hr_api.g_varchar2
642: ,p_information13 in varchar2 default hr_api.g_varchar2
643: ,p_information14 in varchar2 default hr_api.g_varchar2
644: ,p_information15 in varchar2 default hr_api.g_varchar2
645: ,p_information16 in varchar2 default hr_api.g_varchar2
646: ,p_information17 in varchar2 default hr_api.g_varchar2
647: ,p_information18 in varchar2 default hr_api.g_varchar2
648: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 645: ,p_information16 in varchar2 default hr_api.g_varchar2

641: ,p_information12 in varchar2 default hr_api.g_varchar2
642: ,p_information13 in varchar2 default hr_api.g_varchar2
643: ,p_information14 in varchar2 default hr_api.g_varchar2
644: ,p_information15 in varchar2 default hr_api.g_varchar2
645: ,p_information16 in varchar2 default hr_api.g_varchar2
646: ,p_information17 in varchar2 default hr_api.g_varchar2
647: ,p_information18 in varchar2 default hr_api.g_varchar2
648: ,p_information19 in varchar2 default hr_api.g_varchar2
649: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 646: ,p_information17 in varchar2 default hr_api.g_varchar2

642: ,p_information13 in varchar2 default hr_api.g_varchar2
643: ,p_information14 in varchar2 default hr_api.g_varchar2
644: ,p_information15 in varchar2 default hr_api.g_varchar2
645: ,p_information16 in varchar2 default hr_api.g_varchar2
646: ,p_information17 in varchar2 default hr_api.g_varchar2
647: ,p_information18 in varchar2 default hr_api.g_varchar2
648: ,p_information19 in varchar2 default hr_api.g_varchar2
649: ,p_information20 in varchar2 default hr_api.g_varchar2
650: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 647: ,p_information18 in varchar2 default hr_api.g_varchar2

643: ,p_information14 in varchar2 default hr_api.g_varchar2
644: ,p_information15 in varchar2 default hr_api.g_varchar2
645: ,p_information16 in varchar2 default hr_api.g_varchar2
646: ,p_information17 in varchar2 default hr_api.g_varchar2
647: ,p_information18 in varchar2 default hr_api.g_varchar2
648: ,p_information19 in varchar2 default hr_api.g_varchar2
649: ,p_information20 in varchar2 default hr_api.g_varchar2
650: ,p_information21 in varchar2 default hr_api.g_varchar2
651: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 648: ,p_information19 in varchar2 default hr_api.g_varchar2

644: ,p_information15 in varchar2 default hr_api.g_varchar2
645: ,p_information16 in varchar2 default hr_api.g_varchar2
646: ,p_information17 in varchar2 default hr_api.g_varchar2
647: ,p_information18 in varchar2 default hr_api.g_varchar2
648: ,p_information19 in varchar2 default hr_api.g_varchar2
649: ,p_information20 in varchar2 default hr_api.g_varchar2
650: ,p_information21 in varchar2 default hr_api.g_varchar2
651: ,p_information22 in varchar2 default hr_api.g_varchar2
652: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 649: ,p_information20 in varchar2 default hr_api.g_varchar2

645: ,p_information16 in varchar2 default hr_api.g_varchar2
646: ,p_information17 in varchar2 default hr_api.g_varchar2
647: ,p_information18 in varchar2 default hr_api.g_varchar2
648: ,p_information19 in varchar2 default hr_api.g_varchar2
649: ,p_information20 in varchar2 default hr_api.g_varchar2
650: ,p_information21 in varchar2 default hr_api.g_varchar2
651: ,p_information22 in varchar2 default hr_api.g_varchar2
652: ,p_information23 in varchar2 default hr_api.g_varchar2
653: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 650: ,p_information21 in varchar2 default hr_api.g_varchar2

646: ,p_information17 in varchar2 default hr_api.g_varchar2
647: ,p_information18 in varchar2 default hr_api.g_varchar2
648: ,p_information19 in varchar2 default hr_api.g_varchar2
649: ,p_information20 in varchar2 default hr_api.g_varchar2
650: ,p_information21 in varchar2 default hr_api.g_varchar2
651: ,p_information22 in varchar2 default hr_api.g_varchar2
652: ,p_information23 in varchar2 default hr_api.g_varchar2
653: ,p_information24 in varchar2 default hr_api.g_varchar2
654: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 651: ,p_information22 in varchar2 default hr_api.g_varchar2

647: ,p_information18 in varchar2 default hr_api.g_varchar2
648: ,p_information19 in varchar2 default hr_api.g_varchar2
649: ,p_information20 in varchar2 default hr_api.g_varchar2
650: ,p_information21 in varchar2 default hr_api.g_varchar2
651: ,p_information22 in varchar2 default hr_api.g_varchar2
652: ,p_information23 in varchar2 default hr_api.g_varchar2
653: ,p_information24 in varchar2 default hr_api.g_varchar2
654: ,p_information25 in varchar2 default hr_api.g_varchar2
655: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 652: ,p_information23 in varchar2 default hr_api.g_varchar2

648: ,p_information19 in varchar2 default hr_api.g_varchar2
649: ,p_information20 in varchar2 default hr_api.g_varchar2
650: ,p_information21 in varchar2 default hr_api.g_varchar2
651: ,p_information22 in varchar2 default hr_api.g_varchar2
652: ,p_information23 in varchar2 default hr_api.g_varchar2
653: ,p_information24 in varchar2 default hr_api.g_varchar2
654: ,p_information25 in varchar2 default hr_api.g_varchar2
655: ,p_information26 in varchar2 default hr_api.g_varchar2
656: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 653: ,p_information24 in varchar2 default hr_api.g_varchar2

649: ,p_information20 in varchar2 default hr_api.g_varchar2
650: ,p_information21 in varchar2 default hr_api.g_varchar2
651: ,p_information22 in varchar2 default hr_api.g_varchar2
652: ,p_information23 in varchar2 default hr_api.g_varchar2
653: ,p_information24 in varchar2 default hr_api.g_varchar2
654: ,p_information25 in varchar2 default hr_api.g_varchar2
655: ,p_information26 in varchar2 default hr_api.g_varchar2
656: ,p_information27 in varchar2 default hr_api.g_varchar2
657: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 654: ,p_information25 in varchar2 default hr_api.g_varchar2

650: ,p_information21 in varchar2 default hr_api.g_varchar2
651: ,p_information22 in varchar2 default hr_api.g_varchar2
652: ,p_information23 in varchar2 default hr_api.g_varchar2
653: ,p_information24 in varchar2 default hr_api.g_varchar2
654: ,p_information25 in varchar2 default hr_api.g_varchar2
655: ,p_information26 in varchar2 default hr_api.g_varchar2
656: ,p_information27 in varchar2 default hr_api.g_varchar2
657: ,p_information28 in varchar2 default hr_api.g_varchar2
658: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 655: ,p_information26 in varchar2 default hr_api.g_varchar2

651: ,p_information22 in varchar2 default hr_api.g_varchar2
652: ,p_information23 in varchar2 default hr_api.g_varchar2
653: ,p_information24 in varchar2 default hr_api.g_varchar2
654: ,p_information25 in varchar2 default hr_api.g_varchar2
655: ,p_information26 in varchar2 default hr_api.g_varchar2
656: ,p_information27 in varchar2 default hr_api.g_varchar2
657: ,p_information28 in varchar2 default hr_api.g_varchar2
658: ,p_information29 in varchar2 default hr_api.g_varchar2
659: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 656: ,p_information27 in varchar2 default hr_api.g_varchar2

652: ,p_information23 in varchar2 default hr_api.g_varchar2
653: ,p_information24 in varchar2 default hr_api.g_varchar2
654: ,p_information25 in varchar2 default hr_api.g_varchar2
655: ,p_information26 in varchar2 default hr_api.g_varchar2
656: ,p_information27 in varchar2 default hr_api.g_varchar2
657: ,p_information28 in varchar2 default hr_api.g_varchar2
658: ,p_information29 in varchar2 default hr_api.g_varchar2
659: ,p_information30 in varchar2 default hr_api.g_varchar2
660: ,p_form_template_id out nocopy number

Line 657: ,p_information28 in varchar2 default hr_api.g_varchar2

653: ,p_information24 in varchar2 default hr_api.g_varchar2
654: ,p_information25 in varchar2 default hr_api.g_varchar2
655: ,p_information26 in varchar2 default hr_api.g_varchar2
656: ,p_information27 in varchar2 default hr_api.g_varchar2
657: ,p_information28 in varchar2 default hr_api.g_varchar2
658: ,p_information29 in varchar2 default hr_api.g_varchar2
659: ,p_information30 in varchar2 default hr_api.g_varchar2
660: ,p_form_template_id out nocopy number
661: ,p_object_version_number out nocopy number

Line 658: ,p_information29 in varchar2 default hr_api.g_varchar2

654: ,p_information25 in varchar2 default hr_api.g_varchar2
655: ,p_information26 in varchar2 default hr_api.g_varchar2
656: ,p_information27 in varchar2 default hr_api.g_varchar2
657: ,p_information28 in varchar2 default hr_api.g_varchar2
658: ,p_information29 in varchar2 default hr_api.g_varchar2
659: ,p_information30 in varchar2 default hr_api.g_varchar2
660: ,p_form_template_id out nocopy number
661: ,p_object_version_number out nocopy number
662: ) is

Line 659: ,p_information30 in varchar2 default hr_api.g_varchar2

655: ,p_information26 in varchar2 default hr_api.g_varchar2
656: ,p_information27 in varchar2 default hr_api.g_varchar2
657: ,p_information28 in varchar2 default hr_api.g_varchar2
658: ,p_information29 in varchar2 default hr_api.g_varchar2
659: ,p_information30 in varchar2 default hr_api.g_varchar2
660: ,p_form_template_id out nocopy number
661: ,p_object_version_number out nocopy number
662: ) is
663: --

Line 691: hr_api.validate_language_code(p_language_code => l_language_code);

687: -- instead of p_language_code from now on, to allow an IN OUT parameter to
688: -- be passed through.
689: --
690: l_language_code := p_language_code;
691: hr_api.validate_language_code(p_language_code => l_language_code);
692: --
693: hr_utility.set_location(l_proc, 20);
694: --
695: --

Line 773: when hr_api.cannot_find_prog_unit then

769: ,p_information28 => p_information28
770: ,p_information29 => p_information29
771: ,p_information30 => p_information30);
772: exception
773: when hr_api.cannot_find_prog_unit then
774: hr_api.cannot_find_prog_unit_error
775: (p_module_name => 'create_template'
776: ,p_hook_type => 'BP'
777: );

Line 774: hr_api.cannot_find_prog_unit_error

770: ,p_information29 => p_information29
771: ,p_information30 => p_information30);
772: exception
773: when hr_api.cannot_find_prog_unit then
774: hr_api.cannot_find_prog_unit_error
775: (p_module_name => 'create_template'
776: ,p_hook_type => 'BP'
777: );
778: end;

Line 966: when hr_api.cannot_find_prog_unit then

962: ,p_form_template_id => l_form_template_id
963: ,p_object_version_number => l_object_version_number);
964:
965: exception
966: when hr_api.cannot_find_prog_unit then
967: hr_api.cannot_find_prog_unit_error
968: (p_module_name => 'create_template'
969: ,p_hook_type => 'AP'
970: );

Line 967: hr_api.cannot_find_prog_unit_error

963: ,p_object_version_number => l_object_version_number);
964:
965: exception
966: when hr_api.cannot_find_prog_unit then
967: hr_api.cannot_find_prog_unit_error
968: (p_module_name => 'create_template'
969: ,p_hook_type => 'AP'
970: );
971: end;

Line 976: raise hr_api.validate_enabled;

972: --
973: -- When in validation only mode raise the Validate_Enabled exception
974: --
975: if p_validate then
976: raise hr_api.validate_enabled;
977: end if;
978: --
979: -- Set all output arguments
980: --

Line 986: when hr_api.validate_enabled then

982: p_object_version_number := l_object_version_number;
983: --
984: hr_utility.set_location(' Leaving:'||l_proc, 70);
985: exception
986: when hr_api.validate_enabled then
987: --
988: -- As the Validate_Enabled exception has been raised
989: -- we must rollback to the savepoint
990: --

Line 1078: when hr_api.cannot_find_prog_unit then

1074: ,p_object_version_number => p_object_version_number
1075: ,p_delete_children_flag => p_delete_children_flag
1076: );
1077: exception
1078: when hr_api.cannot_find_prog_unit then
1079: hr_api.cannot_find_prog_unit_error
1080: (p_module_name => 'delete_template'
1081: ,p_hook_type => 'BP'
1082: );

Line 1079: hr_api.cannot_find_prog_unit_error

1075: ,p_delete_children_flag => p_delete_children_flag
1076: );
1077: exception
1078: when hr_api.cannot_find_prog_unit then
1079: hr_api.cannot_find_prog_unit_error
1080: (p_module_name => 'delete_template'
1081: ,p_hook_type => 'BP'
1082: );
1083: end;

Line 1172: when hr_api.cannot_find_prog_unit then

1168: ,p_object_version_number => p_object_version_number
1169: ,p_delete_children_flag => p_delete_children_flag
1170: );
1171: exception
1172: when hr_api.cannot_find_prog_unit then
1173: hr_api.cannot_find_prog_unit_error
1174: (p_module_name => 'delete_template'
1175: ,p_hook_type => 'AP'
1176: );

Line 1173: hr_api.cannot_find_prog_unit_error

1169: ,p_delete_children_flag => p_delete_children_flag
1170: );
1171: exception
1172: when hr_api.cannot_find_prog_unit then
1173: hr_api.cannot_find_prog_unit_error
1174: (p_module_name => 'delete_template'
1175: ,p_hook_type => 'AP'
1176: );
1177: end;

Line 1184: raise hr_api.validate_enabled;

1180: --
1181: hr_utility.set_location('At:'|| l_proc, 85);
1182:
1183: if p_validate then
1184: raise hr_api.validate_enabled;
1185: end if;
1186: --
1187: hr_utility.set_location(' Leaving:'||l_proc, 90);
1188: exception

Line 1189: when hr_api.validate_enabled then

1185: end if;
1186: --
1187: hr_utility.set_location(' Leaving:'||l_proc, 90);
1188: exception
1189: when hr_api.validate_enabled then
1190: --
1191: -- As the Validate_Enabled exception has been raised
1192: -- we must rollback to the savepoint
1193: --

Line 1219: ,p_language_code in varchar2 default hr_api.userenv_lang

1215: (p_validate in boolean default false
1216: ,p_effective_date in date
1217: ,p_form_template_id in number
1218: ,p_object_version_number in out nocopy number
1219: ,p_language_code in varchar2 default hr_api.userenv_lang
1220: ,p_template_name in varchar2 default hr_api.g_varchar2
1221: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
1222: ,p_user_template_name in varchar2 default hr_api.g_varchar2
1223: ,p_description in varchar2 default hr_api.g_varchar2

Line 1220: ,p_template_name in varchar2 default hr_api.g_varchar2

1216: ,p_effective_date in date
1217: ,p_form_template_id in number
1218: ,p_object_version_number in out nocopy number
1219: ,p_language_code in varchar2 default hr_api.userenv_lang
1220: ,p_template_name in varchar2 default hr_api.g_varchar2
1221: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
1222: ,p_user_template_name in varchar2 default hr_api.g_varchar2
1223: ,p_description in varchar2 default hr_api.g_varchar2
1224: ,p_legislation_code in varchar2 default hr_api.g_varchar2

Line 1221: ,p_enabled_flag in varchar2 default hr_api.g_varchar2

1217: ,p_form_template_id in number
1218: ,p_object_version_number in out nocopy number
1219: ,p_language_code in varchar2 default hr_api.userenv_lang
1220: ,p_template_name in varchar2 default hr_api.g_varchar2
1221: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
1222: ,p_user_template_name in varchar2 default hr_api.g_varchar2
1223: ,p_description in varchar2 default hr_api.g_varchar2
1224: ,p_legislation_code in varchar2 default hr_api.g_varchar2
1225: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1222: ,p_user_template_name in varchar2 default hr_api.g_varchar2

1218: ,p_object_version_number in out nocopy number
1219: ,p_language_code in varchar2 default hr_api.userenv_lang
1220: ,p_template_name in varchar2 default hr_api.g_varchar2
1221: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
1222: ,p_user_template_name in varchar2 default hr_api.g_varchar2
1223: ,p_description in varchar2 default hr_api.g_varchar2
1224: ,p_legislation_code in varchar2 default hr_api.g_varchar2
1225: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1226: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1223: ,p_description in varchar2 default hr_api.g_varchar2

1219: ,p_language_code in varchar2 default hr_api.userenv_lang
1220: ,p_template_name in varchar2 default hr_api.g_varchar2
1221: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
1222: ,p_user_template_name in varchar2 default hr_api.g_varchar2
1223: ,p_description in varchar2 default hr_api.g_varchar2
1224: ,p_legislation_code in varchar2 default hr_api.g_varchar2
1225: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1226: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1227: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1224: ,p_legislation_code in varchar2 default hr_api.g_varchar2

1220: ,p_template_name in varchar2 default hr_api.g_varchar2
1221: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
1222: ,p_user_template_name in varchar2 default hr_api.g_varchar2
1223: ,p_description in varchar2 default hr_api.g_varchar2
1224: ,p_legislation_code in varchar2 default hr_api.g_varchar2
1225: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1226: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1227: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1228: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1225: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1221: ,p_enabled_flag in varchar2 default hr_api.g_varchar2
1222: ,p_user_template_name in varchar2 default hr_api.g_varchar2
1223: ,p_description in varchar2 default hr_api.g_varchar2
1224: ,p_legislation_code in varchar2 default hr_api.g_varchar2
1225: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1226: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1227: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1228: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1229: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1226: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1222: ,p_user_template_name in varchar2 default hr_api.g_varchar2
1223: ,p_description in varchar2 default hr_api.g_varchar2
1224: ,p_legislation_code in varchar2 default hr_api.g_varchar2
1225: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1226: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1227: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1228: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1229: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1230: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1227: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1223: ,p_description in varchar2 default hr_api.g_varchar2
1224: ,p_legislation_code in varchar2 default hr_api.g_varchar2
1225: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1226: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1227: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1228: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1229: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1230: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1231: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1228: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1224: ,p_legislation_code in varchar2 default hr_api.g_varchar2
1225: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1226: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1227: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1228: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1229: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1230: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1231: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1232: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1229: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1225: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1226: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1227: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1228: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1229: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1230: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1231: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1232: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1233: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1230: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1226: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1227: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1228: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1229: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1230: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1231: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1232: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1233: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1231: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1227: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1228: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1229: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1230: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1231: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1232: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1233: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1232: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1228: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1229: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1230: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1231: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1232: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1233: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1233: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1229: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1230: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1231: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1232: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1233: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1234: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1230: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1231: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1232: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1233: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1235: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1231: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1232: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1233: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1236: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1232: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1233: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1237: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1233: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1238: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1234: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1239: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1235: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1240: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1236: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1241: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1237: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1242: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1238: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1243: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1239: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1244: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1240: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1245: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1241: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1246: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1242: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1247: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1243: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1248: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1244: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1249: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1245: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1250: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1246: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1251: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1247: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1252: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1248: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1256: ,p_help_target in varchar2 default hr_api.g_varchar2

Line 1253: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1249: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1256: ,p_help_target in varchar2 default hr_api.g_varchar2
1257: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 1254: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1250: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1256: ,p_help_target in varchar2 default hr_api.g_varchar2
1257: ,p_information_category in varchar2 default hr_api.g_varchar2
1258: ,p_information1 in varchar2 default hr_api.g_varchar2

Line 1255: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1251: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1256: ,p_help_target in varchar2 default hr_api.g_varchar2
1257: ,p_information_category in varchar2 default hr_api.g_varchar2
1258: ,p_information1 in varchar2 default hr_api.g_varchar2
1259: ,p_information2 in varchar2 default hr_api.g_varchar2

Line 1256: ,p_help_target in varchar2 default hr_api.g_varchar2

1252: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1256: ,p_help_target in varchar2 default hr_api.g_varchar2
1257: ,p_information_category in varchar2 default hr_api.g_varchar2
1258: ,p_information1 in varchar2 default hr_api.g_varchar2
1259: ,p_information2 in varchar2 default hr_api.g_varchar2
1260: ,p_information3 in varchar2 default hr_api.g_varchar2

Line 1257: ,p_information_category in varchar2 default hr_api.g_varchar2

1253: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1256: ,p_help_target in varchar2 default hr_api.g_varchar2
1257: ,p_information_category in varchar2 default hr_api.g_varchar2
1258: ,p_information1 in varchar2 default hr_api.g_varchar2
1259: ,p_information2 in varchar2 default hr_api.g_varchar2
1260: ,p_information3 in varchar2 default hr_api.g_varchar2
1261: ,p_information4 in varchar2 default hr_api.g_varchar2

Line 1258: ,p_information1 in varchar2 default hr_api.g_varchar2

1254: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1256: ,p_help_target in varchar2 default hr_api.g_varchar2
1257: ,p_information_category in varchar2 default hr_api.g_varchar2
1258: ,p_information1 in varchar2 default hr_api.g_varchar2
1259: ,p_information2 in varchar2 default hr_api.g_varchar2
1260: ,p_information3 in varchar2 default hr_api.g_varchar2
1261: ,p_information4 in varchar2 default hr_api.g_varchar2
1262: ,p_information5 in varchar2 default hr_api.g_varchar2

Line 1259: ,p_information2 in varchar2 default hr_api.g_varchar2

1255: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1256: ,p_help_target in varchar2 default hr_api.g_varchar2
1257: ,p_information_category in varchar2 default hr_api.g_varchar2
1258: ,p_information1 in varchar2 default hr_api.g_varchar2
1259: ,p_information2 in varchar2 default hr_api.g_varchar2
1260: ,p_information3 in varchar2 default hr_api.g_varchar2
1261: ,p_information4 in varchar2 default hr_api.g_varchar2
1262: ,p_information5 in varchar2 default hr_api.g_varchar2
1263: ,p_information6 in varchar2 default hr_api.g_varchar2

Line 1260: ,p_information3 in varchar2 default hr_api.g_varchar2

1256: ,p_help_target in varchar2 default hr_api.g_varchar2
1257: ,p_information_category in varchar2 default hr_api.g_varchar2
1258: ,p_information1 in varchar2 default hr_api.g_varchar2
1259: ,p_information2 in varchar2 default hr_api.g_varchar2
1260: ,p_information3 in varchar2 default hr_api.g_varchar2
1261: ,p_information4 in varchar2 default hr_api.g_varchar2
1262: ,p_information5 in varchar2 default hr_api.g_varchar2
1263: ,p_information6 in varchar2 default hr_api.g_varchar2
1264: ,p_information7 in varchar2 default hr_api.g_varchar2

Line 1261: ,p_information4 in varchar2 default hr_api.g_varchar2

1257: ,p_information_category in varchar2 default hr_api.g_varchar2
1258: ,p_information1 in varchar2 default hr_api.g_varchar2
1259: ,p_information2 in varchar2 default hr_api.g_varchar2
1260: ,p_information3 in varchar2 default hr_api.g_varchar2
1261: ,p_information4 in varchar2 default hr_api.g_varchar2
1262: ,p_information5 in varchar2 default hr_api.g_varchar2
1263: ,p_information6 in varchar2 default hr_api.g_varchar2
1264: ,p_information7 in varchar2 default hr_api.g_varchar2
1265: ,p_information8 in varchar2 default hr_api.g_varchar2

Line 1262: ,p_information5 in varchar2 default hr_api.g_varchar2

1258: ,p_information1 in varchar2 default hr_api.g_varchar2
1259: ,p_information2 in varchar2 default hr_api.g_varchar2
1260: ,p_information3 in varchar2 default hr_api.g_varchar2
1261: ,p_information4 in varchar2 default hr_api.g_varchar2
1262: ,p_information5 in varchar2 default hr_api.g_varchar2
1263: ,p_information6 in varchar2 default hr_api.g_varchar2
1264: ,p_information7 in varchar2 default hr_api.g_varchar2
1265: ,p_information8 in varchar2 default hr_api.g_varchar2
1266: ,p_information9 in varchar2 default hr_api.g_varchar2

Line 1263: ,p_information6 in varchar2 default hr_api.g_varchar2

1259: ,p_information2 in varchar2 default hr_api.g_varchar2
1260: ,p_information3 in varchar2 default hr_api.g_varchar2
1261: ,p_information4 in varchar2 default hr_api.g_varchar2
1262: ,p_information5 in varchar2 default hr_api.g_varchar2
1263: ,p_information6 in varchar2 default hr_api.g_varchar2
1264: ,p_information7 in varchar2 default hr_api.g_varchar2
1265: ,p_information8 in varchar2 default hr_api.g_varchar2
1266: ,p_information9 in varchar2 default hr_api.g_varchar2
1267: ,p_information10 in varchar2 default hr_api.g_varchar2

Line 1264: ,p_information7 in varchar2 default hr_api.g_varchar2

1260: ,p_information3 in varchar2 default hr_api.g_varchar2
1261: ,p_information4 in varchar2 default hr_api.g_varchar2
1262: ,p_information5 in varchar2 default hr_api.g_varchar2
1263: ,p_information6 in varchar2 default hr_api.g_varchar2
1264: ,p_information7 in varchar2 default hr_api.g_varchar2
1265: ,p_information8 in varchar2 default hr_api.g_varchar2
1266: ,p_information9 in varchar2 default hr_api.g_varchar2
1267: ,p_information10 in varchar2 default hr_api.g_varchar2
1268: ,p_information11 in varchar2 default hr_api.g_varchar2

Line 1265: ,p_information8 in varchar2 default hr_api.g_varchar2

1261: ,p_information4 in varchar2 default hr_api.g_varchar2
1262: ,p_information5 in varchar2 default hr_api.g_varchar2
1263: ,p_information6 in varchar2 default hr_api.g_varchar2
1264: ,p_information7 in varchar2 default hr_api.g_varchar2
1265: ,p_information8 in varchar2 default hr_api.g_varchar2
1266: ,p_information9 in varchar2 default hr_api.g_varchar2
1267: ,p_information10 in varchar2 default hr_api.g_varchar2
1268: ,p_information11 in varchar2 default hr_api.g_varchar2
1269: ,p_information12 in varchar2 default hr_api.g_varchar2

Line 1266: ,p_information9 in varchar2 default hr_api.g_varchar2

1262: ,p_information5 in varchar2 default hr_api.g_varchar2
1263: ,p_information6 in varchar2 default hr_api.g_varchar2
1264: ,p_information7 in varchar2 default hr_api.g_varchar2
1265: ,p_information8 in varchar2 default hr_api.g_varchar2
1266: ,p_information9 in varchar2 default hr_api.g_varchar2
1267: ,p_information10 in varchar2 default hr_api.g_varchar2
1268: ,p_information11 in varchar2 default hr_api.g_varchar2
1269: ,p_information12 in varchar2 default hr_api.g_varchar2
1270: ,p_information13 in varchar2 default hr_api.g_varchar2

Line 1267: ,p_information10 in varchar2 default hr_api.g_varchar2

1263: ,p_information6 in varchar2 default hr_api.g_varchar2
1264: ,p_information7 in varchar2 default hr_api.g_varchar2
1265: ,p_information8 in varchar2 default hr_api.g_varchar2
1266: ,p_information9 in varchar2 default hr_api.g_varchar2
1267: ,p_information10 in varchar2 default hr_api.g_varchar2
1268: ,p_information11 in varchar2 default hr_api.g_varchar2
1269: ,p_information12 in varchar2 default hr_api.g_varchar2
1270: ,p_information13 in varchar2 default hr_api.g_varchar2
1271: ,p_information14 in varchar2 default hr_api.g_varchar2

Line 1268: ,p_information11 in varchar2 default hr_api.g_varchar2

1264: ,p_information7 in varchar2 default hr_api.g_varchar2
1265: ,p_information8 in varchar2 default hr_api.g_varchar2
1266: ,p_information9 in varchar2 default hr_api.g_varchar2
1267: ,p_information10 in varchar2 default hr_api.g_varchar2
1268: ,p_information11 in varchar2 default hr_api.g_varchar2
1269: ,p_information12 in varchar2 default hr_api.g_varchar2
1270: ,p_information13 in varchar2 default hr_api.g_varchar2
1271: ,p_information14 in varchar2 default hr_api.g_varchar2
1272: ,p_information15 in varchar2 default hr_api.g_varchar2

Line 1269: ,p_information12 in varchar2 default hr_api.g_varchar2

1265: ,p_information8 in varchar2 default hr_api.g_varchar2
1266: ,p_information9 in varchar2 default hr_api.g_varchar2
1267: ,p_information10 in varchar2 default hr_api.g_varchar2
1268: ,p_information11 in varchar2 default hr_api.g_varchar2
1269: ,p_information12 in varchar2 default hr_api.g_varchar2
1270: ,p_information13 in varchar2 default hr_api.g_varchar2
1271: ,p_information14 in varchar2 default hr_api.g_varchar2
1272: ,p_information15 in varchar2 default hr_api.g_varchar2
1273: ,p_information16 in varchar2 default hr_api.g_varchar2

Line 1270: ,p_information13 in varchar2 default hr_api.g_varchar2

1266: ,p_information9 in varchar2 default hr_api.g_varchar2
1267: ,p_information10 in varchar2 default hr_api.g_varchar2
1268: ,p_information11 in varchar2 default hr_api.g_varchar2
1269: ,p_information12 in varchar2 default hr_api.g_varchar2
1270: ,p_information13 in varchar2 default hr_api.g_varchar2
1271: ,p_information14 in varchar2 default hr_api.g_varchar2
1272: ,p_information15 in varchar2 default hr_api.g_varchar2
1273: ,p_information16 in varchar2 default hr_api.g_varchar2
1274: ,p_information17 in varchar2 default hr_api.g_varchar2

Line 1271: ,p_information14 in varchar2 default hr_api.g_varchar2

1267: ,p_information10 in varchar2 default hr_api.g_varchar2
1268: ,p_information11 in varchar2 default hr_api.g_varchar2
1269: ,p_information12 in varchar2 default hr_api.g_varchar2
1270: ,p_information13 in varchar2 default hr_api.g_varchar2
1271: ,p_information14 in varchar2 default hr_api.g_varchar2
1272: ,p_information15 in varchar2 default hr_api.g_varchar2
1273: ,p_information16 in varchar2 default hr_api.g_varchar2
1274: ,p_information17 in varchar2 default hr_api.g_varchar2
1275: ,p_information18 in varchar2 default hr_api.g_varchar2

Line 1272: ,p_information15 in varchar2 default hr_api.g_varchar2

1268: ,p_information11 in varchar2 default hr_api.g_varchar2
1269: ,p_information12 in varchar2 default hr_api.g_varchar2
1270: ,p_information13 in varchar2 default hr_api.g_varchar2
1271: ,p_information14 in varchar2 default hr_api.g_varchar2
1272: ,p_information15 in varchar2 default hr_api.g_varchar2
1273: ,p_information16 in varchar2 default hr_api.g_varchar2
1274: ,p_information17 in varchar2 default hr_api.g_varchar2
1275: ,p_information18 in varchar2 default hr_api.g_varchar2
1276: ,p_information19 in varchar2 default hr_api.g_varchar2

Line 1273: ,p_information16 in varchar2 default hr_api.g_varchar2

1269: ,p_information12 in varchar2 default hr_api.g_varchar2
1270: ,p_information13 in varchar2 default hr_api.g_varchar2
1271: ,p_information14 in varchar2 default hr_api.g_varchar2
1272: ,p_information15 in varchar2 default hr_api.g_varchar2
1273: ,p_information16 in varchar2 default hr_api.g_varchar2
1274: ,p_information17 in varchar2 default hr_api.g_varchar2
1275: ,p_information18 in varchar2 default hr_api.g_varchar2
1276: ,p_information19 in varchar2 default hr_api.g_varchar2
1277: ,p_information20 in varchar2 default hr_api.g_varchar2

Line 1274: ,p_information17 in varchar2 default hr_api.g_varchar2

1270: ,p_information13 in varchar2 default hr_api.g_varchar2
1271: ,p_information14 in varchar2 default hr_api.g_varchar2
1272: ,p_information15 in varchar2 default hr_api.g_varchar2
1273: ,p_information16 in varchar2 default hr_api.g_varchar2
1274: ,p_information17 in varchar2 default hr_api.g_varchar2
1275: ,p_information18 in varchar2 default hr_api.g_varchar2
1276: ,p_information19 in varchar2 default hr_api.g_varchar2
1277: ,p_information20 in varchar2 default hr_api.g_varchar2
1278: ,p_information21 in varchar2 default hr_api.g_varchar2

Line 1275: ,p_information18 in varchar2 default hr_api.g_varchar2

1271: ,p_information14 in varchar2 default hr_api.g_varchar2
1272: ,p_information15 in varchar2 default hr_api.g_varchar2
1273: ,p_information16 in varchar2 default hr_api.g_varchar2
1274: ,p_information17 in varchar2 default hr_api.g_varchar2
1275: ,p_information18 in varchar2 default hr_api.g_varchar2
1276: ,p_information19 in varchar2 default hr_api.g_varchar2
1277: ,p_information20 in varchar2 default hr_api.g_varchar2
1278: ,p_information21 in varchar2 default hr_api.g_varchar2
1279: ,p_information22 in varchar2 default hr_api.g_varchar2

Line 1276: ,p_information19 in varchar2 default hr_api.g_varchar2

1272: ,p_information15 in varchar2 default hr_api.g_varchar2
1273: ,p_information16 in varchar2 default hr_api.g_varchar2
1274: ,p_information17 in varchar2 default hr_api.g_varchar2
1275: ,p_information18 in varchar2 default hr_api.g_varchar2
1276: ,p_information19 in varchar2 default hr_api.g_varchar2
1277: ,p_information20 in varchar2 default hr_api.g_varchar2
1278: ,p_information21 in varchar2 default hr_api.g_varchar2
1279: ,p_information22 in varchar2 default hr_api.g_varchar2
1280: ,p_information23 in varchar2 default hr_api.g_varchar2

Line 1277: ,p_information20 in varchar2 default hr_api.g_varchar2

1273: ,p_information16 in varchar2 default hr_api.g_varchar2
1274: ,p_information17 in varchar2 default hr_api.g_varchar2
1275: ,p_information18 in varchar2 default hr_api.g_varchar2
1276: ,p_information19 in varchar2 default hr_api.g_varchar2
1277: ,p_information20 in varchar2 default hr_api.g_varchar2
1278: ,p_information21 in varchar2 default hr_api.g_varchar2
1279: ,p_information22 in varchar2 default hr_api.g_varchar2
1280: ,p_information23 in varchar2 default hr_api.g_varchar2
1281: ,p_information24 in varchar2 default hr_api.g_varchar2

Line 1278: ,p_information21 in varchar2 default hr_api.g_varchar2

1274: ,p_information17 in varchar2 default hr_api.g_varchar2
1275: ,p_information18 in varchar2 default hr_api.g_varchar2
1276: ,p_information19 in varchar2 default hr_api.g_varchar2
1277: ,p_information20 in varchar2 default hr_api.g_varchar2
1278: ,p_information21 in varchar2 default hr_api.g_varchar2
1279: ,p_information22 in varchar2 default hr_api.g_varchar2
1280: ,p_information23 in varchar2 default hr_api.g_varchar2
1281: ,p_information24 in varchar2 default hr_api.g_varchar2
1282: ,p_information25 in varchar2 default hr_api.g_varchar2

Line 1279: ,p_information22 in varchar2 default hr_api.g_varchar2

1275: ,p_information18 in varchar2 default hr_api.g_varchar2
1276: ,p_information19 in varchar2 default hr_api.g_varchar2
1277: ,p_information20 in varchar2 default hr_api.g_varchar2
1278: ,p_information21 in varchar2 default hr_api.g_varchar2
1279: ,p_information22 in varchar2 default hr_api.g_varchar2
1280: ,p_information23 in varchar2 default hr_api.g_varchar2
1281: ,p_information24 in varchar2 default hr_api.g_varchar2
1282: ,p_information25 in varchar2 default hr_api.g_varchar2
1283: ,p_information26 in varchar2 default hr_api.g_varchar2

Line 1280: ,p_information23 in varchar2 default hr_api.g_varchar2

1276: ,p_information19 in varchar2 default hr_api.g_varchar2
1277: ,p_information20 in varchar2 default hr_api.g_varchar2
1278: ,p_information21 in varchar2 default hr_api.g_varchar2
1279: ,p_information22 in varchar2 default hr_api.g_varchar2
1280: ,p_information23 in varchar2 default hr_api.g_varchar2
1281: ,p_information24 in varchar2 default hr_api.g_varchar2
1282: ,p_information25 in varchar2 default hr_api.g_varchar2
1283: ,p_information26 in varchar2 default hr_api.g_varchar2
1284: ,p_information27 in varchar2 default hr_api.g_varchar2

Line 1281: ,p_information24 in varchar2 default hr_api.g_varchar2

1277: ,p_information20 in varchar2 default hr_api.g_varchar2
1278: ,p_information21 in varchar2 default hr_api.g_varchar2
1279: ,p_information22 in varchar2 default hr_api.g_varchar2
1280: ,p_information23 in varchar2 default hr_api.g_varchar2
1281: ,p_information24 in varchar2 default hr_api.g_varchar2
1282: ,p_information25 in varchar2 default hr_api.g_varchar2
1283: ,p_information26 in varchar2 default hr_api.g_varchar2
1284: ,p_information27 in varchar2 default hr_api.g_varchar2
1285: ,p_information28 in varchar2 default hr_api.g_varchar2

Line 1282: ,p_information25 in varchar2 default hr_api.g_varchar2

1278: ,p_information21 in varchar2 default hr_api.g_varchar2
1279: ,p_information22 in varchar2 default hr_api.g_varchar2
1280: ,p_information23 in varchar2 default hr_api.g_varchar2
1281: ,p_information24 in varchar2 default hr_api.g_varchar2
1282: ,p_information25 in varchar2 default hr_api.g_varchar2
1283: ,p_information26 in varchar2 default hr_api.g_varchar2
1284: ,p_information27 in varchar2 default hr_api.g_varchar2
1285: ,p_information28 in varchar2 default hr_api.g_varchar2
1286: ,p_information29 in varchar2 default hr_api.g_varchar2

Line 1283: ,p_information26 in varchar2 default hr_api.g_varchar2

1279: ,p_information22 in varchar2 default hr_api.g_varchar2
1280: ,p_information23 in varchar2 default hr_api.g_varchar2
1281: ,p_information24 in varchar2 default hr_api.g_varchar2
1282: ,p_information25 in varchar2 default hr_api.g_varchar2
1283: ,p_information26 in varchar2 default hr_api.g_varchar2
1284: ,p_information27 in varchar2 default hr_api.g_varchar2
1285: ,p_information28 in varchar2 default hr_api.g_varchar2
1286: ,p_information29 in varchar2 default hr_api.g_varchar2
1287: ,p_information30 in varchar2 default hr_api.g_varchar2

Line 1284: ,p_information27 in varchar2 default hr_api.g_varchar2

1280: ,p_information23 in varchar2 default hr_api.g_varchar2
1281: ,p_information24 in varchar2 default hr_api.g_varchar2
1282: ,p_information25 in varchar2 default hr_api.g_varchar2
1283: ,p_information26 in varchar2 default hr_api.g_varchar2
1284: ,p_information27 in varchar2 default hr_api.g_varchar2
1285: ,p_information28 in varchar2 default hr_api.g_varchar2
1286: ,p_information29 in varchar2 default hr_api.g_varchar2
1287: ,p_information30 in varchar2 default hr_api.g_varchar2
1288: ) is

Line 1285: ,p_information28 in varchar2 default hr_api.g_varchar2

1281: ,p_information24 in varchar2 default hr_api.g_varchar2
1282: ,p_information25 in varchar2 default hr_api.g_varchar2
1283: ,p_information26 in varchar2 default hr_api.g_varchar2
1284: ,p_information27 in varchar2 default hr_api.g_varchar2
1285: ,p_information28 in varchar2 default hr_api.g_varchar2
1286: ,p_information29 in varchar2 default hr_api.g_varchar2
1287: ,p_information30 in varchar2 default hr_api.g_varchar2
1288: ) is
1289: --

Line 1286: ,p_information29 in varchar2 default hr_api.g_varchar2

1282: ,p_information25 in varchar2 default hr_api.g_varchar2
1283: ,p_information26 in varchar2 default hr_api.g_varchar2
1284: ,p_information27 in varchar2 default hr_api.g_varchar2
1285: ,p_information28 in varchar2 default hr_api.g_varchar2
1286: ,p_information29 in varchar2 default hr_api.g_varchar2
1287: ,p_information30 in varchar2 default hr_api.g_varchar2
1288: ) is
1289: --
1290: -- Declare cursors and local variables

Line 1287: ,p_information30 in varchar2 default hr_api.g_varchar2

1283: ,p_information26 in varchar2 default hr_api.g_varchar2
1284: ,p_information27 in varchar2 default hr_api.g_varchar2
1285: ,p_information28 in varchar2 default hr_api.g_varchar2
1286: ,p_information29 in varchar2 default hr_api.g_varchar2
1287: ,p_information30 in varchar2 default hr_api.g_varchar2
1288: ) is
1289: --
1290: -- Declare cursors and local variables
1291: --

Line 1322: hr_api.validate_language_code(p_language_code => l_language_code);

1318: -- instead of p_language_code from now on, to allow an IN OUT parameter to
1319: -- be passed through.
1320: --
1321: l_language_code := p_language_code;
1322: hr_api.validate_language_code(p_language_code => l_language_code);
1323: --
1324: hr_utility.set_location(l_proc, 20);
1325: --
1326: --

Line 1404: when hr_api.cannot_find_prog_unit then

1400: ,p_information28 => p_information28
1401: ,p_information29 => p_information29
1402: ,p_information30 => p_information30);
1403: exception
1404: when hr_api.cannot_find_prog_unit then
1405: hr_api.cannot_find_prog_unit_error
1406: (p_module_name => 'update_template'
1407: ,p_hook_type => 'BP'
1408: );

Line 1405: hr_api.cannot_find_prog_unit_error

1401: ,p_information29 => p_information29
1402: ,p_information30 => p_information30);
1403: exception
1404: when hr_api.cannot_find_prog_unit then
1405: hr_api.cannot_find_prog_unit_error
1406: (p_module_name => 'update_template'
1407: ,p_hook_type => 'BP'
1408: );
1409: end;

Line 1595: when hr_api.cannot_find_prog_unit then

1591: ,p_information28 => p_information28
1592: ,p_information29 => p_information29
1593: ,p_information30 => p_information30);
1594: exception
1595: when hr_api.cannot_find_prog_unit then
1596: hr_api.cannot_find_prog_unit_error
1597: (p_module_name => 'update_template'
1598: ,p_hook_type => 'AP'
1599: );

Line 1596: hr_api.cannot_find_prog_unit_error

1592: ,p_information29 => p_information29
1593: ,p_information30 => p_information30);
1594: exception
1595: when hr_api.cannot_find_prog_unit then
1596: hr_api.cannot_find_prog_unit_error
1597: (p_module_name => 'update_template'
1598: ,p_hook_type => 'AP'
1599: );
1600: end;

Line 1605: raise hr_api.validate_enabled;

1601: --
1602: -- When in validation only mode raise the Validate_Enabled exception
1603: --
1604: if p_validate then
1605: raise hr_api.validate_enabled;
1606: end if;
1607: --
1608: -- Set all output arguments
1609: --

Line 1614: when hr_api.validate_enabled then

1610: p_object_version_number := l_object_version_number;
1611: --
1612: hr_utility.set_location(' Leaving:'||l_proc, 70);
1613: exception
1614: when hr_api.validate_enabled then
1615: --
1616: -- As the Validate_Enabled exception has been raised
1617: -- we must rollback to the savepoint
1618: --