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_EVT_SHD dependencies on OTA_EVENTS

Line 47: If (p_constraint_name = 'OTA_EVENTS_FK1') Then

43: hr_utility.set_location ('Constrint Name = '||p_constraint_name,5);
44: --
45: -- Key constraints
46: --
47: If (p_constraint_name = 'OTA_EVENTS_FK1') Then
48: FND_MESSAGE.SET_NAME('OTA','OTA_13429_EVT_NO_TAV');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'OTA_EVENTS_FK2') Then
51: FND_MESSAGE.SET_NAME('OTA','OTA_13430_EVT_NO_BUS');

Line 50: ElsIf (p_constraint_name = 'OTA_EVENTS_FK2') Then

46: --
47: If (p_constraint_name = 'OTA_EVENTS_FK1') Then
48: FND_MESSAGE.SET_NAME('OTA','OTA_13429_EVT_NO_TAV');
49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'OTA_EVENTS_FK2') Then
51: FND_MESSAGE.SET_NAME('OTA','OTA_13430_EVT_NO_BUS');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'OTA_EVENTS_FK3') Then
54: FND_MESSAGE.SET_NAME('OTA','OTA_13431_EVT_NO_BUD');

Line 53: ElsIf (p_constraint_name = 'OTA_EVENTS_FK3') Then

49: fnd_message.raise_error;
50: ElsIf (p_constraint_name = 'OTA_EVENTS_FK2') Then
51: FND_MESSAGE.SET_NAME('OTA','OTA_13430_EVT_NO_BUS');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'OTA_EVENTS_FK3') Then
54: FND_MESSAGE.SET_NAME('OTA','OTA_13431_EVT_NO_BUD');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_EVENTS_FK4') Then
57: FND_MESSAGE.SET_NAME('OTA','OTA_13432_EVT_NO_ORG');

Line 56: ElsIf (p_constraint_name = 'OTA_EVENTS_FK4') Then

52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'OTA_EVENTS_FK3') Then
54: FND_MESSAGE.SET_NAME('OTA','OTA_13431_EVT_NO_BUD');
55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_EVENTS_FK4') Then
57: FND_MESSAGE.SET_NAME('OTA','OTA_13432_EVT_NO_ORG');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_EVENTS_FK5') Then
60: FND_MESSAGE.SET_NAME('OTA','OTA_13433_EVT_NO_PAR');

Line 59: ElsIf (p_constraint_name = 'OTA_EVENTS_FK5') Then

55: fnd_message.raise_error;
56: ElsIf (p_constraint_name = 'OTA_EVENTS_FK4') Then
57: FND_MESSAGE.SET_NAME('OTA','OTA_13432_EVT_NO_ORG');
58: fnd_message.raise_error;
59: ElsIf (p_constraint_name = 'OTA_EVENTS_FK5') Then
60: FND_MESSAGE.SET_NAME('OTA','OTA_13433_EVT_NO_PAR');
61: fnd_message.raise_error;
62: /* 3803613 */
63: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then

Line 67: ElsIf (p_constraint_name = 'OTA_EVENTS_PK') Then

63: ElsIf (p_constraint_name = 'OTA_PROGRAM_MEMBERSHIPS_FK1') Then
64: FND_MESSAGE.SET_NAME('OTA','OTA_13681_EVT_PMM_EXISTS');
65: fnd_message.raise_error;
66: /* 3803613 */
67: ElsIf (p_constraint_name = 'OTA_EVENTS_PK') Then
68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', W_PROC);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;

Line 72: ElsIf (p_constraint_name = 'OTA_EVENTS_UK2') Then

68: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
69: hr_utility.set_message_token('PROCEDURE', W_PROC);
70: hr_utility.set_message_token('STEP','30');
71: hr_utility.raise_error;
72: ElsIf (p_constraint_name = 'OTA_EVENTS_UK2') Then
73: fnd_message.set_name('OTA','OTA_13471_SES_EXISTS');
74: fnd_message.raise_error;
75: ElsIf (p_constraint_name = 'OTA_EVENT_UK3') Then
76: fnd_message.set_name('OTA','OTA_13889_EVT_LINE_DUPLICATE');

Line 191: ElsIf (p_constraint_name = 'OTA_EVENTS_UK4') Then

187: fnd_message.raise_error;
188: ElsIf (p_constraint_name = 'OTA_EVT_VENDOR_NULL') Then
189: fnd_message.set_name('OTA','OTA_13453_EVT_VENDOR');
190: fnd_message.raise_error;
191: ElsIf (p_constraint_name = 'OTA_EVENTS_UK4') Then
192: fnd_message.set_name('OTA', 'OTA_EVT_DUPLICATE_OFFERING');
193: fnd_message.raise_error;
194: --
195: -- ?

Line 290: from ota_events

286: timezone,
287: parent_offering_id,
288: data_source,
289: event_availability
290: from ota_events
291: where event_id = p_event_id;
292: --
293: l_proc varchar2(72) := g_package||'api_updating';
294: l_fct_ret boolean;

Line 423: from ota_events

419: timezone,
420: parent_offering_id,
421: data_source,
422: event_availability
423: from ota_events
424: where event_id = p_event_id
425: for update nowait;
426: --
427: l_proc varchar2(72) := g_package||'lck';

Line 466: hr_utility.set_message_token('TABLE_NAME', 'ota_events');

462: -- The object is locked therefore we need to supply a meaningful
463: -- error message.
464: --
465: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
466: hr_utility.set_message_token('TABLE_NAME', 'ota_events');
467: hr_utility.raise_error;
468: End lck;
469: -- ----------------------------------------------------------------------------
470: -- |-----------------------------< convert_args >-----------------------------|

Line 715: from OTA_EVENTS_VL

711: , timezone
712: , parent_offering_id
713: , data_source
714: , event_availability
715: from OTA_EVENTS_VL
716: where EVENT_ID = P_EVENT_ID;
717: --
718: begin
719: --

Line 756: ota_events evt

752: --
753: cursor c1 is
754: select null
755: from ota_program_memberships mem,
756: ota_events evt
757: where mem.program_event_id = p_event_id
758: and mem.event_id = evt.event_id
759: and evt.event_status = 'P';
760: --

Line 855: -- Raises an error if the event ID used does not exist on OTA_EVENTS.

851: -- ----------------------------------------------------------------------------
852: -- -----------------------< CHECK_EVENT_IS_VALID >-----------------------------
853: -- ----------------------------------------------------------------------------
854: --
855: -- Raises an error if the event ID used does not exist on OTA_EVENTS.
856: --
857: procedure CHECK_EVENT_IS_VALID (
858: P_EVENT_ID in number
859: ) is

Line 985: from ota_events evt,

981:
982: cursor C2 is
983: select ol.unit_selling_price,
984: ol.line_id
985: from ota_events evt,
986: oe_order_lines_all ol
987: where evt.event_id = p_event_id and
988: ol.line_id = evt.line_id;
989:

Line 991: w_line_id ota_events.line_id%type;

987: where evt.event_id = p_event_id and
988: ol.line_id = evt.line_id;
989:
990: --
991: w_line_id ota_events.line_id%type;
992: W_TOTAL number;
993: --
994: begin
995: --