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_TBD_API dependencies on OTA_BOOKING_DEALS

Line 83: If (p_constraint_name = 'OTA_BOOKING_DEALS_FK1') Then

79: hr_utility.set_location('Entering:'||l_proc, 5);
80: --
81: -- Foreign keys
82: --
83: If (p_constraint_name = 'OTA_BOOKING_DEALS_FK1') Then
84: -- Business Group ID
85: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
86: FND_MESSAGE.SET_TOKEN ('STEP', '1');
87: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK2') Then

Line 87: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK2') Then

83: If (p_constraint_name = 'OTA_BOOKING_DEALS_FK1') Then
84: -- Business Group ID
85: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
86: FND_MESSAGE.SET_TOKEN ('STEP', '1');
87: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK2') Then
88: -- Price List
89: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
90: FND_MESSAGE.SET_TOKEN ('STEP', '2');
91: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK3') Then

Line 91: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK3') Then

87: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK2') Then
88: -- Price List
89: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
90: FND_MESSAGE.SET_TOKEN ('STEP', '2');
91: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK3') Then
92: -- Activity
93: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
94: FND_MESSAGE.SET_TOKEN ('STEP', '3');
95: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK4') Then

Line 95: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK4') Then

91: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK3') Then
92: -- Activity
93: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
94: FND_MESSAGE.SET_TOKEN ('STEP', '3');
95: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_FK4') Then
96: -- Event
97: FND_MESSAGE.SET_NAME ('OTA', 'OTA_13467_TBD_INVALID_KEY');
98: FND_MESSAGE.SET_TOKEN ('STEP', '4');
99: --

Line 102: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_PK') Then

98: FND_MESSAGE.SET_TOKEN ('STEP', '4');
99: --
100: -- Primary key
101: --
102: ElsIf (p_constraint_name = 'OTA_BOOKING_DEALS_PK') Then
103: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
104: hr_utility.set_message_token('PROCEDURE', l_proc);
105: hr_utility.set_message_token('STEP','25');
106: hr_utility.raise_error;

Line 245: from ota_booking_deals

241: tbd_information17,
242: tbd_information18,
243: tbd_information19,
244: tbd_information20
245: from ota_booking_deals
246: where booking_deal_id = p_booking_deal_id;
247: --
248: l_proc varchar2(72) := g_package||'g_old_rec_current';
249: l_fct_ret boolean;

Line 511: from OTA_BOOKING_DEALS TBD

507: W_UNIQUE boolean;
508: --
509: cursor C1 is
510: select 1
511: from OTA_BOOKING_DEALS TBD
512: where TBD.BUSINESS_GROUP_ID+0 = P_BUSINESS_GROUP_ID
513: and upper (TBD.NAME) = upper (P_NAME)
514: and (p_customer_id is not null and
515: (customer_id is null or

Line 699: CONSTRAINT_ERROR ('OTA_BOOKING_DEALS_FK3');

695: W_TPL_START_DATE,
696: W_TPL_END_DATE;
697: if (C1%notfound) then
698: close C1;
699: CONSTRAINT_ERROR ('OTA_BOOKING_DEALS_FK3');
700: end if;
701: close C1;
702: --
703: if (W_BUSINESS_GROUP_ID <> P_BUSINESS_GROUP_ID) then

Line 774: CONSTRAINT_ERROR ('OTA_BOOKING_DEALS_FK5');

770: W_MAX_ATTENDEES,
771: W_PRICE_BASIS;
772: if (C1%notfound) then
773: close C1;
774: CONSTRAINT_ERROR ('OTA_BOOKING_DEALS_FK5');
775: end if;
776: close C1;
777: --
778: -- Business group

Line 851: CONSTRAINT_ERROR ('OTA_BOOKING_DEALS_FK4');

847: into W_TAV_START_DATE,
848: W_TAV_END_DATE;
849: if (C1%notfound) then
850: close C1;
851: CONSTRAINT_ERROR ('OTA_BOOKING_DEALS_FK4');
852: end if;
853: close C1;
854: --
855: if ( (P_START_DATE not between W_TAV_START_DATE

Line 1113: -- Insert the row into: ota_booking_deals

1109: p_rec.object_version_number := 1; -- Initialise the object version
1110: --
1111: g_api_dml := true; -- Set the api dml status
1112: --
1113: -- Insert the row into: ota_booking_deals
1114: --
1115: insert into ota_booking_deals
1116: ( booking_deal_id,
1117: customer_id,

Line 1115: insert into ota_booking_deals

1111: g_api_dml := true; -- Set the api dml status
1112: --
1113: -- Insert the row into: ota_booking_deals
1114: --
1115: insert into ota_booking_deals
1116: ( booking_deal_id,
1117: customer_id,
1118: approved_by_person_id,
1119: business_group_id,

Line 1278: -- Update the ota_booking_deals Row

1274: p_rec.object_version_number := p_rec.object_version_number + 1;
1275: --
1276: g_api_dml := true; -- Set the api dml status
1277: --
1278: -- Update the ota_booking_deals Row
1279: --
1280: update ota_booking_deals
1281: set
1282: booking_deal_id = p_rec.booking_deal_id,

Line 1280: update ota_booking_deals

1276: g_api_dml := true; -- Set the api dml status
1277: --
1278: -- Update the ota_booking_deals Row
1279: --
1280: update ota_booking_deals
1281: set
1282: booking_deal_id = p_rec.booking_deal_id,
1283: customer_id = p_rec.customer_id,
1284: approved_by_person_id = p_rec.approved_by_person_id,

Line 1396: -- Delete the ota_booking_deals row.

1392: hr_utility.set_location('Entering:'||l_proc, 5);
1393: --
1394: g_api_dml := true; -- Set the api dml status
1395: --
1396: -- Delete the ota_booking_deals row.
1397: --
1398: delete from ota_booking_deals
1399: where booking_deal_id = p_rec.booking_deal_id;
1400: --

Line 1398: delete from ota_booking_deals

1394: g_api_dml := true; -- Set the api dml status
1395: --
1396: -- Delete the ota_booking_deals row.
1397: --
1398: delete from ota_booking_deals
1399: where booking_deal_id = p_rec.booking_deal_id;
1400: --
1401: g_api_dml := false; -- Unset the api dml status
1402: --

Line 1454: Cursor C_Sel1 is select ota_booking_deals_s.nextval from sys.dual;

1450: Procedure pre_insert(p_rec in out nocopy g_rec_type) is
1451: --
1452: l_proc varchar2(72) := g_package||'pre_insert';
1453: --
1454: Cursor C_Sel1 is select ota_booking_deals_s.nextval from sys.dual;
1455: --
1456: Begin
1457: hr_utility.set_location('Entering:'||l_proc, 5);
1458: --

Line 1716: from ota_booking_deals

1712: tbd_information17,
1713: tbd_information18,
1714: tbd_information19,
1715: tbd_information20
1716: from ota_booking_deals
1717: where booking_deal_id = p_booking_deal_id
1718: for update nowait;
1719: --
1720: l_proc varchar2(72) := g_package||'lck';

Line 1759: hr_utility.set_message_token('TABLE_NAME', 'ota_booking_deals');

1755: -- The object is locked therefore we need to supply a meaningful
1756: -- error message.
1757: --
1758: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
1759: hr_utility.set_message_token('TABLE_NAME', 'ota_booking_deals');
1760: hr_utility.raise_error;
1761: End lck;
1762: --
1763: -- ----------------------------------------------------------------------------