DBA Data[Home] [Help]

PACKAGE: APPS.IRC_MDS_MIGRATION

Source


1 PACKAGE irc_mds_migration AUTHID CURRENT_USER AS
2 /* $Header: irmdsmig.pkh 120.0 2005/07/26 15:14:52 mbocutt noship $ */
3 
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< migrateJobSearchData >------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 --
9 -- Description:
10 --   This procedure migrates a chunk of job search records. For each ID in the
11 --   range the IRC_SEARCH_CRITERIA table is udpated.
12 --
13 --
14 procedure migrateJobSearchData(
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 -- ----------------------------------------------------------------------------
22 -- |--------------------------< createworkPrefsData >------------------------|
23 -- ----------------------------------------------------------------------------
24 --
25 --
26 -- Description:
27 --   This procedure creates work preferences for existing candidates. For each
28 --   PERSONID in IRC_NOTIFICATION_PREFERENCES , a record is inserted into
29 --   IRC_SEARCH_CRITERIA.
30 --
31 procedure createworkPrefsData(
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 end irc_mds_migration;