eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_COUNTERS_VUHK SQL Statements

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

Line: 608


PROCEDURE UPDATE_CTR_GRP_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_grp_id                 IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_ctr_grp_rec                IN   CS_COUNTERS_PUB.CtrGrp_Rec_Type,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT NOCOPY NUMBER
    ) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 629


           ' ''UPDATE_CTR_GRP_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_PRE''); ' ||

Line: 642


           ' ''UPDATE_CTR_GRP_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_PRE''); ' ||

Line: 659


     ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_CTR_GRP_PRE' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||

Line: 697


PROCEDURE UPDATE_CTR_GRP_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_grp_id                 IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_ctr_grp_rec                IN   CS_COUNTERS_PUB.CtrGrp_Rec_Type,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT NOCOPY NUMBER
    ) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 718


           ' ''UPDATE_CTR_GRP_POST'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_POST''); ' ||

Line: 731


           ' ''UPDATE_CTR_GRP_POST'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_GRP_POST''); ' ||

Line: 748


     ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_CTR_GRP_POST' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||

Line: 786


PROCEDURE UPDATE_COUNTER_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_id                     IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_ctr_rec                    IN   CS_COUNTERS_PUB.Ctr_Rec_Type,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT NOCOPY NUMBER
    ) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 807


           ' ''UPDATE_COUNTER_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_PRE''); ' ||

Line: 820


           ' ''UPDATE_COUNTER_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_PRE''); ' ||

Line: 837


     ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_COUNTER_PRE' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||

Line: 875


PROCEDURE UPDATE_COUNTER_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_id                     IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_ctr_rec                    IN   CS_COUNTERS_PUB.Ctr_Rec_Type,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT NOCOPY NUMBER
    ) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 896


           ' ''UPDATE_COUNTER_POST'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_POST''); ' ||

Line: 909


           ' ''UPDATE_COUNTER_POST'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_COUNTER_POST''); ' ||

Line: 926


     ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_COUNTER_POST' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||

Line: 964


PROCEDURE UPDATE_CTR_PROP_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_prop_id                IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_ctr_prop_rec               IN   CS_COUNTERS_PUB.Ctr_Prop_Rec_Type,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT NOCOPY NUMBER
    ) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 985


           ' ''UPDATE_CTR_PROP_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_PRE''); ' ||

Line: 999


           ' ''UPDATE_CTR_PROP_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_PRE''); ' ||

Line: 1016


     ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_CTR_PROP_PRE' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||

Line: 1054


PROCEDURE UPDATE_CTR_PROP_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_prop_id                IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_ctr_prop_rec               IN   CS_COUNTERS_PUB.Ctr_Prop_Rec_Type,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT NOCOPY NUMBER
    ) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 1075


           ' ''UPDATE_CTR_PROP_POST'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_POST''); ' ||

Line: 1088


           ' ''UPDATE_CTR_PROP_POST'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''jtm:CS_COUNTERS_VUHK.UPDATE_CTR_PROP_POST''); ' ||

Line: 1105


     ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'UPDATE_CTR_PROP_POST' ||
            '(:1,:2,:3,:4,:5,:6,:7,:8,:9,:10); ' ||

Line: 1143


PROCEDURE UPDATE_FORMULA_REF_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_formula_bvar_id        IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_counter_id                 IN   NUMBER,
    p_bind_var_name              IN   VARCHAR2,
    p_mapped_item_id             IN   NUMBER,
    p_mapped_counter_id          IN   NUMBER,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT NOCOPY NUMBER,
    p_reading_type               IN   VARCHAR2
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1165


PROCEDURE UPDATE_FORMULA_REF_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_formula_bvar_id        IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_counter_id                 IN   NUMBER,
    p_bind_var_name              IN   VARCHAR2,
    p_mapped_item_id             IN   NUMBER,
    p_mapped_counter_id          IN   NUMBER,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT NOCOPY NUMBER,
    p_reading_type               IN   VARCHAR2
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1187


PROCEDURE UPDATE_GRPOP_FILTER_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_der_filter_id          IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_seq_no                     IN   NUMBER,
    p_counter_id                 IN   NUMBER,
    p_left_paren                 IN   VARCHAR2,
    p_ctr_prop_id                IN   NUMBER,
    p_rel_op                     IN   VARCHAR2,
    p_right_val                  IN   VARCHAR2,
    p_right_paren                IN   VARCHAR2,
    p_log_op                     IN   VARCHAR2,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT NOCOPY NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1212


PROCEDURE UPDATE_GRPOP_FILTER_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_der_filter_id          IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_seq_no                     IN   NUMBER,
    p_counter_id                 IN   NUMBER,
    p_left_paren                 IN   VARCHAR2,
    p_ctr_prop_id                IN   NUMBER,
    p_rel_op                     IN   VARCHAR2,
    p_right_val                  IN   VARCHAR2,
    p_right_paren                IN   VARCHAR2,
    p_log_op                     IN   VARCHAR2,
    p_cascade_upd_to_instances   IN   VARCHAR2,
    x_object_version_number      OUT NOCOPY NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1237


PROCEDURE UPDATE_CTR_ASSOCIATION_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_association_id         IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_ctr_grp_id                 IN   NUMBER,
    p_source_object_id           IN   NUMBER,
    x_object_version_number      OUT NOCOPY NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1255


PROCEDURE UPDATE_CTR_ASSOCIATION_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_association_id         IN   NUMBER,
    p_object_version_number      IN   NUMBER,
    p_ctr_grp_id                 IN   NUMBER,
    p_source_object_id           IN   NUMBER,
    x_object_version_number      OUT NOCOPY NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1273


PROCEDURE DELETE_COUNTER_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_id			 IN   NUMBER
    ) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 1290


           ' ''DELETE_COUNTER_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_PRE''); ' ||

Line: 1303


           ' ''DELETE_COUNTER_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_PRE''); ' ||

Line: 1320


     ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'DELETE_COUNTER_PRE' ||
            '(:1,:2,:3,:4,:5,:6,:7); ' ||

Line: 1355


PROCEDURE DELETE_COUNTER_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_id                     IN   NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1370


PROCEDURE DELETE_CTR_PROP_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_prop_id		 IN   NUMBER
    ) IS
  l_JTM_enable_prof_value varchar2(255);

Line: 1387


           ' ''DELETE_CTR_PROP_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''jtm:CS_COUNTERS_VUHK.DELETE_CTR_PROP_PRE''); ' ||

Line: 1400


           ' ''DELETE_CTR_PROP_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''jtm:CS_COUNTERS_VUHK.DELETE_CTR_PROP_PRE''); ' ||

Line: 1417


     ' begin ' || 'JTM_COUNTERS_VUHK' || '.' || 'DELETE_CTR_PROP_PRE' ||
            '(:1,:2,:3,:4,:5,:6,:7); ' ||

Line: 1452


PROCEDURE DELETE_CTR_PROP_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_prop_id                IN   NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1466


PROCEDURE DELETE_FORMULA_REF_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_formula_bvar_id        IN   NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1480


PROCEDURE DELETE_FORMULA_REF_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_formula_bvar_id        IN   NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1494


PROCEDURE DELETE_GRPOP_FILTER_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_der_filter_id          IN   NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1508


PROCEDURE DELETE_GRPOP_FILTER_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_der_filter_id          IN   NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1522


PROCEDURE DELETE_CTR_ASSOCIATION_PRE(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_association_id	 IN   NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1536


PROCEDURE DELETE_CTR_ASSOCIATION_POST(
    P_Api_Version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    X_Return_Status              OUT NOCOPY VARCHAR2,
    X_Msg_Count                  OUT NOCOPY NUMBER,
    X_Msg_Data                   OUT NOCOPY VARCHAR2,
    p_ctr_association_id         IN   NUMBER
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 1550


PROCEDURE DELETE_COUNTER_INSTANCE_PRE (
    p_api_version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_SOURCE_OBJECT_ID           IN   NUMBER,
    p_SOURCE_OBJECT_CODE         IN   VARCHAR2,
    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: 1568


           ' ''DELETE_COUNTER_INSTANCE_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''Error:'' || SQLERRM ' || ',' ||
           ' 1,' ||
           ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_INSTANCE_PRE''); ' ||

Line: 1581


           ' ''DELETE_COUNTER_INSTANCE_PRE'', ' ||
           ' ''CS_COUNTERS_VUHK'', ' ||
           ' ''The procedure is called.'', ' ||
           ' 4,' ||
           ' ''jtm:CS_COUNTERS_VUHK.DELETE_COUNTER_INSTANCE_PRE''); ' ||

Line: 1598


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

Line: 1634


PROCEDURE DELETE_COUNTER_INSTANCE_POST (
    p_api_version                IN   NUMBER,
    P_Init_Msg_List              IN   VARCHAR2,
    P_Commit                     IN   VARCHAR2,
    p_SOURCE_OBJECT_ID           IN   NUMBER,
    p_SOURCE_OBJECT_CODE         IN   VARCHAR2,
    x_Return_status              OUT NOCOPY VARCHAR2,
    x_Msg_Count                  OUT NOCOPY NUMBER,
    x_Msg_Data                   OUT NOCOPY VARCHAR2
    ) IS
BEGIN
   x_return_status := FND_API.G_RET_STS_SUCCESS;