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_BST_API dependencies on OTA_BOOKING_STATUS_TYPES

Line 98: if (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_FK1') Then

94: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
95: --
96: -- Key constraints
97: --
98: if (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_FK1') Then
99: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13202_GEN_INVALID_KEY');
100: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME', 'ORGANIZATION_ID');
101: FND_MESSAGE.SET_TOKEN ('TABLE_NAME', 'HR_ORGANIZATION_UNITS');
102: -- elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_PK') Then

Line 102: -- elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_PK') Then

98: if (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_FK1') Then
99: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13202_GEN_INVALID_KEY');
100: FND_MESSAGE.SET_TOKEN ('COLUMN_NAME', 'ORGANIZATION_ID');
101: FND_MESSAGE.SET_TOKEN ('TABLE_NAME', 'HR_ORGANIZATION_UNITS');
102: -- elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_PK') Then
103: -- Unkn constraint will be raised giving constraint name.
104: -- FND_MESSAGE.SET_NAME ('OTA', 'HR_6153_ALW_PROCEDURE_FAIL');
105: -- FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
106: -- FND_MESSAGE.SET_TOKEN ('STEP','10');

Line 107: elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_UK2') Then

103: -- Unkn constraint will be raised giving constraint name.
104: -- FND_MESSAGE.SET_NAME ('OTA', 'HR_6153_ALW_PROCEDURE_FAIL');
105: -- FND_MESSAGE.SET_TOKEN ('PROCEDURE', W_PROC);
106: -- FND_MESSAGE.SET_TOKEN ('STEP','10');
107: elsif (P_CONSTRAINT_NAME = 'OTA_BOOKING_STATUS_TYPES_UK2') Then
108: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13209_GEN_NOT_UNIQUE');
109: FND_MESSAGE.SET_TOKEN ('FIELD', 'The status name');
110: FND_MESSAGE.SET_TOKEN ('MESSAGE_EXTENSION', 'Must be unique');
111: --

Line 170: from OTA_BOOKING_STATUS_TYPES_VL BST

166: W_BOOKING_STATUS_TYPE_ID number (9);
167: --
168: cursor C1 is
169: select BST.BOOKING_STATUS_TYPE_ID
170: from OTA_BOOKING_STATUS_TYPES_VL BST
171: where BST.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
172: and BST.NAME = P_NAME;
173: --
174: begin

Line 205: from OTA_BOOKING_STATUS_TYPES_TL BST

201: ) return varchar2 is
202: --
203: cursor C1 is
204: select BST.NAME
205: from OTA_BOOKING_STATUS_TYPES_TL BST
206: where BST.BOOKING_STATUS_TYPE_ID = P_BOOKING_STATUS_TYPE_ID
207: and BST.LANGUAGE = USERENV('LANG');
208: --
209: W_PROCEDURE varchar2 (72)

Line 252: from OTA_BOOKING_STATUS_TYPES_VL BST

248: --
249: cursor C_DEFAULT is
250: select BST.BOOKING_STATUS_TYPE_ID,
251: BST.NAME
252: from OTA_BOOKING_STATUS_TYPES_VL BST
253: where BST.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
254: and BST.DEFAULT_FLAG = 'Y'
255: and BST.TYPE <> 'C'
256: and ((P_EVENT_STATUS = 'F' AND -- Bug #1870097. For status 'F' use Waitlist as default, for status 'P' use either Waitlisted or Requested

Line 297: from OTA_BOOKING_STATUS_TYPES_VL BST

293: V_UNIQUE varchar (3);
294: --
295: cursor C_UNIQUE is
296: select 'NO'
297: from OTA_BOOKING_STATUS_TYPES_VL BST
298: where BST.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
299: and upper (BST.NAME) = upper (P_NAME)
300: and ( (P_BOOKING_STATUS_TYPE_ID
301: is null)

Line 319: CONSTRAINT_ERROR ('OTA_BOOKING_STATUS_TYPES_UK2');

315: close C_UNIQUE;
316: --
317:
318: if (V_UNIQUE <> 'YES') then
319: CONSTRAINT_ERROR ('OTA_BOOKING_STATUS_TYPES_UK2');
320: end if;
321: --
322: HR_UTILITY.SET_LOCATION (' Leaving: ' || W_PROCEDURE, 10);
323: --

Line 346: from OTA_BOOKING_STATUS_TYPES_VL BST

342:
343: --
344: cursor C_DEFAULT is
345: select BST.NAME
346: from OTA_BOOKING_STATUS_TYPES_VL BST
347: where BST.BUSINESS_GROUP_ID = P_BUSINESS_GROUP_ID
348: and BST.TYPE = P_TYPE
349: and BST.DEFAULT_FLAG = 'Y';
350: --

Line 611: from ota_booking_status_types_vl

607: bst_information17,
608: bst_information18,
609: bst_information19,
610: bst_information20
611: from ota_booking_status_types_vl
612: where booking_status_type_id = p_booking_status_type_id;
613: --
614: W_PROC varchar2(72) := G_PACKAGE||'g_old_rec_current';
615: l_fct_ret boolean;

Line 684: , ota_booking_status_types bst

680: cursor csr_sec_grp is
681: select pbg.security_group_id,
682: pbg.legislation_code
683: from per_business_groups_perf pbg
684: , ota_booking_status_types bst
685: where bst.booking_status_type_id = p_booking_status_type_id
686: and pbg.business_group_id = bst.business_group_id;
687: --
688: -- Declare local variables

Line 754: , ota_booking_status_types bst

750: --
751: cursor csr_leg_code is
752: select pbg.legislation_code
753: from per_business_groups_perf pbg
754: , ota_booking_status_types bst
755: where bst.booking_status_type_id = p_booking_status_type_id
756: and pbg.business_group_id = bst.business_group_id;
757: --
758: -- Declare local variables

Line 882: -- Insert the row into: ota_booking_status_types

878: p_rec.object_version_number := 1; -- Initialise the object version
879: --
880: g_api_dml := true; -- Set the api dml status
881: --
882: -- Insert the row into: ota_booking_status_types
883: --
884: insert into ota_booking_status_types
885: ( booking_status_type_id,
886: business_group_id,

Line 884: insert into ota_booking_status_types

880: g_api_dml := true; -- Set the api dml status
881: --
882: -- Insert the row into: ota_booking_status_types
883: --
884: insert into ota_booking_status_types
885: ( booking_status_type_id,
886: business_group_id,
887: active_flag,
888: default_flag,

Line 1027: -- Update the ota_booking_status_types Row

1023: p_rec.object_version_number := p_rec.object_version_number + 1;
1024: --
1025: g_api_dml := true; -- Set the api dml status
1026: --
1027: -- Update the ota_booking_status_types Row
1028: --
1029: update ota_booking_status_types
1030: set
1031: booking_status_type_id = p_rec.booking_status_type_id,

Line 1029: update ota_booking_status_types

1025: g_api_dml := true; -- Set the api dml status
1026: --
1027: -- Update the ota_booking_status_types Row
1028: --
1029: update ota_booking_status_types
1030: set
1031: booking_status_type_id = p_rec.booking_status_type_id,
1032: business_group_id = p_rec.business_group_id,
1033: active_flag = p_rec.active_flag,

Line 1135: -- Delete the ota_booking_status_types row.

1131: HR_UTILITY.SET_LOCATION('Entering:'||W_PROC, 5);
1132: --
1133: g_api_dml := true; -- Set the api dml status
1134: --
1135: -- Delete the ota_booking_status_types row.
1136: --
1137: delete from ota_booking_status_types
1138: where booking_status_type_id = p_rec.booking_status_type_id;
1139: --

Line 1137: delete from ota_booking_status_types

1133: g_api_dml := true; -- Set the api dml status
1134: --
1135: -- Delete the ota_booking_status_types row.
1136: --
1137: delete from ota_booking_status_types
1138: where booking_status_type_id = p_rec.booking_status_type_id;
1139: --
1140: g_api_dml := false; -- Unset the api dml status
1141: --

Line 1193: Cursor C_Sel1 is select ota_booking_status_types_s.nextval from sys.dual;

1189: Procedure pre_insert(p_rec in out nocopy g_rec_type) is
1190: --
1191: W_PROC varchar2(72) := G_PACKAGE||'pre_insert';
1192: --
1193: Cursor C_Sel1 is select ota_booking_status_types_s.nextval from sys.dual;
1194: --
1195: Begin
1196: HR_UTILITY.SET_LOCATION('Entering:'||W_PROC, 5);
1197: --

Line 1445: from ota_booking_status_types

1441: bst_information17,
1442: bst_information18,
1443: bst_information19,
1444: bst_information20
1445: from ota_booking_status_types
1446: where booking_status_type_id = p_booking_status_type_id
1447: for update nowait;
1448: --
1449: W_PROC varchar2(72) := G_PACKAGE||'lck';

Line 1488: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'ota_booking_status_types');

1484: -- The object is locked therefore we need to supply a meaningful
1485: -- error message.
1486: --
1487: FND_MESSAGE.SET_NAME('OTA', 'HR_7165_OBJECT_LOCKED');
1488: FND_MESSAGE.SET_TOKEN('TABLE_NAME', 'ota_booking_status_types');
1489: HR_UTILITY.raise_error;
1490: End lck;
1491: --
1492: -- ----------------------------------------------------------------------------