APPS.CSM_WF_PKG dependencies on CS_COUNTERS

Line 3141: -- p_counter_id cs_counters.counter_id%type

3137: X_Msg_Data OUT NOCOPY VARCHAR2,
3138: p_counter_id IN NUMBER,
3139: x_object_version_number OUT NOCOPY NUMBER
3140: -- p_user_id in number,
3141: -- p_counter_id cs_counters.counter_id%type
3142: )
3143: IS
3144: l_sqlerrno VARCHAR2(20);
3145: l_sqlerrmsg VARCHAR2(4000);

Line 3224: FROM CS_COUNTERS counters

3220: IS
3221: CURSOR l_counter_csr ( b_ctr_grp_id NUMBER)
3222: IS
3223: SELECT counters.COUNTER_ID
3224: FROM CS_COUNTERS counters
3225: , CS_COUNTER_GROUPS counter_groups
3226: WHERE counters.counter_group_id = counter_groups.counter_group_id
3227: AND counter_groups.counter_group_id = b_ctr_grp_id
3228: AND counters.TYPE = 'REGULAR';

Line 3282: -- p_counter_id cs_counters.counter_id%type

3278: X_Msg_Data ,
3279: l_counter_rec.COUNTER_ID , -- p_counter_id ,
3280: x_object_version_number
3281: -- p_user_id in number,
3282: -- p_counter_id cs_counters.counter_id%type
3283: );
3284: END LOOP;
3285:
3286: EXCEPTION

Line 3317: cs_counters counters,

3313: ,b_source_object_id NUMBER)
3314: IS
3315: SELECT counters.counter_id
3316: FROM CS_COUNTER_GROUPS counter_groups,
3317: cs_counters counters,
3318: csm_item_instances_acc acc
3319: WHERE counter_groups.source_object_code = b_source_object_cd
3320: AND counter_groups.source_object_id = b_source_object_id
3321: AND acc.instance_id = counter_groups.source_object_id

Line 3377: FROM CS_COUNTERS counters

3373:
3374: CURSOR l_counter_csr ( b_ctr_grp_id NUMBER)
3375: IS
3376: SELECT counters.counter_id
3377: FROM CS_COUNTERS counters
3378: , CS_COUNTER_GROUPS counter_groups
3379: , csm_item_instances_acc acc
3380: WHERE counter_groups.counter_group_id = b_ctr_grp_id
3381: AND counters.counter_group_id = counter_groups.counter_group_id

Line 3416: PROCEDURE CS_COUNTERS_INSTANTIATE_POST(

3412: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3413: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_COUNTER_GRP_Post_Upd',FND_LOG.LEVEL_EXCEPTION);
3414: END CS_COUNTER_GRP_Post_Upd;
3415:
3416: PROCEDURE CS_COUNTERS_INSTANTIATE_POST(
3417: P_Api_Version IN NUMBER,
3418: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3419: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3420: X_Return_Status OUT NOCOPY VARCHAR2,

Line 3450: END CS_COUNTERS_INSTANTIATE_POST;

3446: EXCEPTION
3447: --log the error
3448: WHEN OTHERS THEN
3449: csm_util_pkg.log('ERROR: COUNTER_GROUP_ID => ' || to_char(p_ctr_grp_id));
3450: END CS_COUNTERS_INSTANTIATE_POST;
3451:
3452:
3453:
3454: /*------------

Line 3470: -- p_cs_counters cs_counters%rowtype

3466: p_object_version_number IN NUMBER,
3467: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3468: x_object_version_number OUT NOCOPY NUMBER
3469: -- p_user_id in number,
3470: -- p_cs_counters cs_counters%rowtype
3471: )
3472: IS
3473:
3474: /* CURSOR l_acc_del_csr(b_counter_id NUMBER) IS

Line 3476: FROM CS_COUNTERS counters

3472: IS
3473:
3474: /* CURSOR l_acc_del_csr(b_counter_id NUMBER) IS
3475: SELECT acc.user_id
3476: FROM CS_COUNTERS counters
3477: , CS_COUNTER_GROUPS counter_groups
3478: , csm_item_instances_acc acc
3479: WHERE counters.counter_group_id = counter_groups.counter_group_id
3480: AND counter_groups.source_object_code = 'CP'

Line 3487: FROM CS_COUNTERS counters

3483: and counters.counter_id = b_counter_id;
3484:
3485: CURSOR l_acc_upd_csr(b_counter_id NUMBER) IS
3486: SELECT acc.user_id
3487: FROM CS_COUNTERS counters
3488: , CS_COUNTER_GROUPS counter_groups
3489: , csm_item_instances_acc acc
3490: WHERE counters.counter_group_id = counter_groups.counter_group_id
3491: AND counter_groups.source_object_code = 'CP'

Line 3531: FROM CS_COUNTERS counters

3527: l_return_status VARCHAR2(2000);
3528:
3529: CURSOR l_acc_csr(b_counter_id NUMBER) IS
3530: SELECT COUNT(1)
3531: FROM CS_COUNTERS counters
3532: , CS_COUNTER_GROUPS counter_groups
3533: , csm_item_instances_acc acc
3534: WHERE counters.counter_group_id = counter_groups.counter_group_id
3535: AND counter_groups.source_object_code = 'CP'