1 PACKAGE ota_mls_migration AUTHID CURRENT_USER AS
2 /* $Header: otmlsmig.pkh 115.0 2003/04/11 14:23:37 jbharath noship $ */
3
4 -- ---------------------------------------------------------------------------------------
5 -- |--------------------------< migrateActivityDefintionData >---------------------------|
6 -- ---------------------------------------------------------------------------------------
7 --
8 --
9 -- Description:
10 -- This procedure migrates a chunk of Activitydefintion records. For each ID in the
11 -- range the OTA_ACTIVITY_DEFINITIONS_TL table is populated for each installed language.
12 --
13 --
14 procedure migrateActivityDefinitionData(
15 p_process_ctrl IN varchar2,
16 p_start_pkid IN number,
17 p_end_pkid IN number,
18 p_rows_processed OUT nocopy number);
19
20 -- ---------------------------------------------------------------------------------
21 -- |-----------------------< migrateActivityVersionData >--------------------------|
22 -- ---------------------------------------------------------------------------------
23 --
24 --
25 -- Description:
26 -- This procedure migrates a chunk of Activity Version records. For each ID in the
27 -- range the OTA_ACTIVITY_VERSIONS_TL table is populated for each installed
28 -- language.
29 --
30 --
31 procedure migrateActivityVersionData(
32 p_process_ctrl IN varchar2,
33 p_start_pkid IN number,
34 p_end_pkid IN number,
35 p_rows_processed OUT nocopy number);
36 --
37 -- -----------------------------------------------------------------------
38 -- |-----------------------< migrateEventData >--------------------------|
39 -- -----------------------------------------------------------------------
40 --
41 --
42 -- Description:
43 -- This procedure migrates a chunk of Event records. For each ID in the
44 -- range the OTA_EVENTS_TL table is populated for each installed
45 -- language.
46 --
47 procedure migrateEventData(
48 p_process_ctrl IN varchar2,
49 p_start_pkid IN number,
50 p_end_pkid IN number,
51 p_rows_processed OUT nocopy number);
52
53 -- ----------------------------------------------------------------------------------
54 -- |-----------------------< migrateBookingStatusTypeData >--------------------------|
55 -- ----------------------------------------------------------------------------------
56 --
57 --
58 -- Description:
59 -- This procedure migrates a chunk of Booking Status Type records. For each ID in the
60 -- range the OTA_BOOKING_STATUS_TYPES_TL table is populated for each installed
61 -- language.
62 --
63 procedure migrateBookingStatusTypeData(
64 p_process_ctrl IN varchar2,
65 p_start_pkid IN number,
66 p_end_pkid IN number,
67 p_rows_processed OUT nocopy number);
68 --
69 -- --------------------------------------------------------------------------
70 -- |-----------------------< migrateResourceData >--------------------------|
71 -- --------------------------------------------------------------------------
72 --
73 --
74 -- Description:
75 -- This procedure migrates a chunk of Resource records. For each ID in the
76 -- range the OTA_SUPPLIABLE_RESOURCESS_TL table is populated for each installed
77 -- language.
78 --
79 procedure migrateResourceData(
80 p_process_ctrl IN varchar2,
81 p_start_pkid IN number,
82 p_end_pkid IN number,
83 p_rows_processed OUT nocopy number);
84
85
86 end ota_mls_migration;