APPS.CS_INSTALLEDBASE_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 260

PROCEDURE Update_Revision
(
        p_api_version                   IN      NUMBER,
        p_init_msg_list         IN      VARCHAR2        DEFAULT FND_API.G_FALSE,
        p_commit                                IN      VARCHAR2        DEFAULT FND_API.G_FALSE,
        p_validation_level              IN      VARCHAR2        DEFAULT FND_API.G_VALID_LEVEL_FULL,
        x_return_status         OUT     VARCHAR2,
        x_msg_count                     OUT     NUMBER,
        x_msg_data                      OUT     VARCHAR2,
        p_cp_rev_id                     IN      NUMBER,
        p_object_version_number IN      NUMBER,
        p_start_date_active             IN      DATE            DEFAULT FND_API.G_MISS_DATE,
        p_end_date_active               IN      DATE            DEFAULT FND_API.G_MISS_DATE,
        p_desc_flex                     IN      CS_InstalledBase_PUB.DFF_Rec_Type,
        x_object_version_number OUT     NUMBER
) IS

BEGIN
  null;

Line: 279

END Update_Revision;

Line: 327

PROCEDURE Update_Product
(
        p_api_version                                   IN      NUMBER,
        p_init_msg_list                         IN      VARCHAR2        DEFAULT FND_API.G_FALSE,
        p_commit                                                IN      VARCHAR2        DEFAULT FND_API.G_FALSE,
        p_validation_level                              IN      VARCHAR2        DEFAULT FND_API.G_VALID_LEVEL_FULL,
        x_return_status                         OUT     VARCHAR2,
        x_msg_count                                     OUT     NUMBER,
        x_msg_data                                      OUT     VARCHAR2,
        p_cp_id                                         IN      NUMBER,
        p_as_of_date                                    IN      DATE    DEFAULT sysdate,
        p_cp_rec                                                IN      CS_InstalledBase_PUB.CP_Prod_Rec_Type,
        p_ship_rec                                      IN      CS_InstalledBase_PUB.CP_Ship_Rec_Type,
        p_comments                                      IN      VARCHAR2 DEFAULT NULL,
        p_split_cp_id                                   IN      NUMBER   DEFAULT NULL,
        p_split_reason_code                             IN      VARCHAR2 DEFAULT NULL,
        p_update_by_customer_flag               IN      VARCHAR2 DEFAULT FND_API.G_FALSE,
        p_abort_on_warn_flag                    IN      CS_InstalledBase_PUB.Abort_Upd_On_Warn_Rec_Type,
        p_cascade_updates_flag                  IN      CS_InstalledBase_PUB.Cascade_Upd_Flag_Rec_Type,
        p_cascade_inst_date_change_war  IN      VARCHAR2        DEFAULT FND_API.G_TRUE,
    p_org_id                IN NUMBER DEFAULT FND_API.G_MISS_NUM,
        p_savepoint_rec_lvl                             IN      NUMBER  DEFAULT 1
) IS
BEGIN

  null;

Line: 354

END Update_Product;

Line: 375

PROCEDURE Update_CP_Status(ERRBUF OUT VARCHAR2, RETCODE OUT NUMBER) IS

BEGIN
  null;

Line: 379

END Update_CP_Status;