APPS.CSI_ITEM_INSTANCE_VUHK SQL Statements

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

Line: 120

PROCEDURE update_item_instance_pre
 (
     p_api_version           IN     NUMBER
    ,p_commit                IN     VARCHAR2 := fnd_api.g_false
    ,p_init_msg_list         IN     VARCHAR2 := fnd_api.g_false
    ,p_validation_level      IN     NUMBER   := fnd_api.g_valid_level_full
    ,p_instance_rec          IN     csi_datastructures_pub.instance_rec
    ,p_ext_attrib_values_tbl IN     csi_datastructures_pub.extend_attrib_values_tbl
    ,p_party_tbl             IN     csi_datastructures_pub.party_tbl
    ,p_account_tbl           IN     csi_datastructures_pub.party_account_tbl
    ,p_pricing_attrib_tbl    IN     csi_datastructures_pub.pricing_attribs_tbl
    ,p_org_assignments_tbl   IN     csi_datastructures_pub.organization_units_tbl
    ,p_asset_assignment_tbl  IN     csi_datastructures_pub.instance_asset_tbl
    ,p_txn_rec               IN     csi_datastructures_pub.transaction_rec
    ,x_instance_id_lst       OUT    NOCOPY csi_datastructures_pub.id_tbl
    ,x_return_status         OUT    NOCOPY VARCHAR2
    ,x_msg_count             OUT    NOCOPY NUMBER
    ,x_msg_data              OUT    NOCOPY VARCHAR2
 )
IS
  l_JTM_enable_prof_value varchar2(255);

Line: 147

           ' ''UPDATE_ITEM_INSTANCE_PRE'', ' ||
           ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_PRE''); ' ||

Line: 161

           ' ''UPDATE_ITEM_INSTANCE_PRE'', ' ||
           ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_PRE''); ' ||

Line: 179

     ' begin ' || 'JTM_ITEM_INSTANCE_VUHK' || '.' || 'UPDATE_ITEM_INSTANCE_PRE' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||

Line: 215

PROCEDURE update_item_instance_post
 (
     p_api_version           IN     NUMBER
    ,p_commit                IN     VARCHAR2 := fnd_api.g_false
    ,p_init_msg_list         IN     VARCHAR2 := fnd_api.g_false
    ,p_validation_level      IN     NUMBER   := fnd_api.g_valid_level_full
    ,p_instance_rec          IN     csi_datastructures_pub.instance_rec
    ,p_ext_attrib_values_tbl IN     csi_datastructures_pub.extend_attrib_values_tbl
    ,p_party_tbl             IN     csi_datastructures_pub.party_tbl
    ,p_account_tbl           IN     csi_datastructures_pub.party_account_tbl
    ,p_pricing_attrib_tbl    IN     csi_datastructures_pub.pricing_attribs_tbl
    ,p_org_assignments_tbl   IN     csi_datastructures_pub.organization_units_tbl
    ,p_asset_assignment_tbl  IN     csi_datastructures_pub.instance_asset_tbl
    ,p_txn_rec               IN     csi_datastructures_pub.transaction_rec
    ,x_instance_id_lst       OUT    NOCOPY csi_datastructures_pub.id_tbl
    ,x_return_status         OUT    NOCOPY VARCHAR2
    ,x_msg_count             OUT    NOCOPY  NUMBER
    ,x_msg_data              OUT    NOCOPY  VARCHAR2
 ) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 241

           ' ''UPDATE_ITEM_INSTANCE_POST'', ' ||
           ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_POST''); ' ||

Line: 256

           ' ''UPDATE_ITEM_INSTANCE_POST'', ' ||
           ' ''CSI_ITEM_INSTANCE_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''JTM.CSI_ITEM_INSTANCE_VUHK.UPDATE_ITEM_INSTANCE_POST''); ' ||

Line: 273

     ' begin ' || 'JTM_ITEM_INSTANCE_VUHK' || '.' || 'UPDATE_ITEM_INSTANCE_POST' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8); ' ||