eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_TEA_INS dependencies on OTA_TEA_SHD

Line 53: Procedure insert_dml(p_rec in out nocopy ota_tea_shd.g_rec_type) is

49: -- Internal Development Use Only.
50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure insert_dml(p_rec in out nocopy ota_tea_shd.g_rec_type) is
54: --
55: l_proc varchar2(72) := g_package||'insert_dml';
56: --
57: Begin

Line 61: ota_tea_shd.g_api_dml := true; -- Set the api dml status

57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: --
61: ota_tea_shd.g_api_dml := true; -- Set the api dml status
62: --
63: -- Insert the row into: ota_event_associations
64: --
65: insert into ota_event_associations

Line 126: ota_tea_shd.g_api_dml := false; -- Unset the api dml status

122: p_rec.tea_information19,
123: p_rec.tea_information20
124: );
125: --
126: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: Exception
130: When hr_api.check_integrity_violated Then

Line 132: ota_tea_shd.g_api_dml := false; -- Unset the api dml status

128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
133: ota_tea_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated

Line 133: ota_tea_shd.constraint_error

129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
133: ota_tea_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ota_tea_shd.g_api_dml := false; -- Unset the api dml status

Line 137: ota_tea_shd.g_api_dml := false; -- Unset the api dml status

133: ota_tea_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
138: ota_tea_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated

Line 138: ota_tea_shd.constraint_error

134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.parent_integrity_violated Then
136: -- Parent integrity has been violated
137: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
138: ota_tea_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ota_tea_shd.g_api_dml := false; -- Unset the api dml status

Line 142: ota_tea_shd.g_api_dml := false; -- Unset the api dml status

138: ota_tea_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tea_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ota_tea_shd.g_api_dml := false; -- Unset the api dml status

Line 143: ota_tea_shd.constraint_error

139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When hr_api.unique_integrity_violated Then
141: -- Unique integrity has been violated
142: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tea_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;

Line 146: ota_tea_shd.g_api_dml := false; -- Unset the api dml status

142: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
143: ota_tea_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When Others Then
146: ota_tea_shd.g_api_dml := false; -- Unset the api dml status
147: Raise;
148: End insert_dml;
149: --
150: -- ----------------------------------------------------------------------------

Line 187: Procedure pre_insert(p_rec in out nocopy ota_tea_shd.g_rec_type) is

183: -- Internal Development Use Only.
184: --
185: -- {End Of Comments}
186: -- ----------------------------------------------------------------------------
187: Procedure pre_insert(p_rec in out nocopy ota_tea_shd.g_rec_type) is
188: --
189: l_proc varchar2(72) := g_package||'pre_insert';
190: --
191: Cursor C_Sel1 is select ota_event_associations_s.nextval from sys.dual;

Line 316: p_rec in out nocopy ota_tea_shd.g_rec_type,

312: -- |---------------------------------< ins >----------------------------------|
313: -- ----------------------------------------------------------------------------
314: Procedure ins
315: (
316: p_rec in out nocopy ota_tea_shd.g_rec_type,
317: p_validate in boolean
318: ,p_association_type in varchar2
319: ,p_business_group_id in number
320: ,p_price_basis in varchar2

Line 476: l_rec ota_tea_shd.g_rec_type;

472: ,p_finance_line_id in out nocopy number
473: ,p_delegate_contact_email in varchar2
474: ) is
475: --
476: l_rec ota_tea_shd.g_rec_type;
477: l_proc varchar2(72) := g_package||'ins';
478: --
479: Begin
480: hr_utility.set_location('Entering:'||l_proc, 5);

Line 486: ota_tea_shd.convert_args

482: -- Call conversion function to turn arguments into the
483: -- p_rec structure.
484: --
485: l_rec :=
486: ota_tea_shd.convert_args
487: (
488: null,
489: p_event_id,
490: p_customer_id,