APPS.CSD_MIGRATE_FROM_12X_PKG7 dependencies on CSD_MIGRATE_FROM_12X_PKG7

Line 1: PACKAGE BODY CSD_MIGRATE_FROM_12X_PKG7 AS

1: PACKAGE BODY CSD_MIGRATE_FROM_12X_PKG7 AS
2: /* $Header: csdmig7b.pls 120.2 2008/04/25 09:53:32 subhat noship $ */
3:
4: /* Procedure Name: csd_isupport_ssearch_mig7 */
5: /* This procedure updates the existing csd_ro_savedsearches table to */

Line 24: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',

20:
21: begin
22: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
23: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
24: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',
25: 'Before fetching the party for user_id');
26: end if;
27:
28: -- make use of an implicit cursor to get the customer_id's for the user_ids

Line 54: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',

50: -- update all the null party_id's
51:
52: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
53: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
54: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',
55: 'Before bulk update of CSD_RO_SAVEDSEARCHES table');
56: end if;
57:
58: --forall i in 1 ..usr_party_tbl.COUNT

Line 66: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',

62: and party_id is null;
63:
64: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
65: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
66: 'CSD.PLSQL.CSD_Migrate_From_12X_PKG7.csd_isupport_ssearch_mig7',
67: 'After bulk update of CSD_RO_SAVEDSEARCHES table');
68: end if;
69:
70: commit work;

Line 74: end CSD_MIGRATE_FROM_12X_PKG7;

70: commit work;
71:
72: end CSD_ISUPPORT_SSEARCH_MIG7;
73:
74: end CSD_MIGRATE_FROM_12X_PKG7;