1 PACKAGE CSD_MIGRATE_FROM_12X_PKG7 AUTHID CURRENT_USER AS
2 /* $Header: csdmig7s.pls 120.3 2008/04/25 09:53:05 subhat noship $ */
3
4 /* This record type holds the party_id's corresponding to the user_id */
5
6 /*TYPE user_party_id_rec is record (
7 user_Id number(15),
8 party_Id number(15) );
9
10 -- table type corresponding to this record.
11
12 --type user_party_id_tbl is table of user_party_id_rec index by binary_integer; */
13
14 -- bug#6993441 subhat
15 -- Associative arrays are not allowed withing forall statement prior 11g
16 -- two different arrays to hold userid and partyid
17
18 TYPE user_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
19 TYPE party_id_tbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
20
21 -- end bug#6993441 subhat
22
23 /* Procedure Name: csd_isupport_ssearch_mig7 */
24 /* This procedure updates the existing csd_ro_savedsearches table to */
25 /* support the iSupport multiparty enhancement. The party_id for the */
26 /* existing records will be updated to default party_id corresponding to*/
27 /* user_id. */
28 /* @param. None */
29
30 PROCEDURE CSD_ISUPPORT_SSEARCH_MIG7;
31
32 END CSD_MIGRATE_FROM_12X_PKG7;