DBA Data[Home] [Help]

PACKAGE: APPS.OTA_MLS_MIGRATION

Source


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;