APPS.CSM_WF_PKG dependencies on CS_COUNTERS

Line 3171: -- p_counter_id cs_counters.counter_id%type

3167: X_Msg_Data OUT NOCOPY VARCHAR2,
3168: p_counter_id IN NUMBER,
3169: x_object_version_number OUT NOCOPY NUMBER
3170: -- p_user_id in number,
3171: -- p_counter_id cs_counters.counter_id%type
3172: )
3173: IS
3174: l_sqlerrno VARCHAR2(20);
3175: l_sqlerrmsg VARCHAR2(4000);

Line 3254: FROM CS_COUNTERS counters

3250: IS
3251: CURSOR l_counter_csr ( b_ctr_grp_id NUMBER)
3252: IS
3253: SELECT counters.COUNTER_ID
3254: FROM CS_COUNTERS counters
3255: , CS_COUNTER_GROUPS counter_groups
3256: WHERE counters.counter_group_id = counter_groups.counter_group_id
3257: AND counter_groups.counter_group_id = b_ctr_grp_id
3258: AND counters.TYPE = 'REGULAR';

Line 3312: -- p_counter_id cs_counters.counter_id%type

3308: X_Msg_Data ,
3309: l_counter_rec.COUNTER_ID , -- p_counter_id ,
3310: x_object_version_number
3311: -- p_user_id in number,
3312: -- p_counter_id cs_counters.counter_id%type
3313: );
3314: END LOOP;
3315:
3316: EXCEPTION

Line 3347: cs_counters counters,

3343: ,b_source_object_id NUMBER)
3344: IS
3345: SELECT counters.counter_id
3346: FROM CS_COUNTER_GROUPS counter_groups,
3347: cs_counters counters,
3348: csm_item_instances_acc acc
3349: WHERE counter_groups.source_object_code = b_source_object_cd
3350: AND counter_groups.source_object_id = b_source_object_id
3351: AND acc.instance_id = counter_groups.source_object_id

Line 3407: FROM CS_COUNTERS counters

3403:
3404: CURSOR l_counter_csr ( b_ctr_grp_id NUMBER)
3405: IS
3406: SELECT counters.counter_id
3407: FROM CS_COUNTERS counters
3408: , CS_COUNTER_GROUPS counter_groups
3409: , csm_item_instances_acc acc
3410: WHERE counter_groups.counter_group_id = b_ctr_grp_id
3411: AND counters.counter_group_id = counter_groups.counter_group_id

Line 3446: PROCEDURE CS_COUNTERS_INSTANTIATE_POST(

3442: || ':' || l_sqlerrno || ':' || l_sqlerrmsg;
3443: CSM_UTIL_PKG.LOG(l_error_msg, 'CSM_WF_PKG.CS_COUNTER_GRP_Post_Upd',FND_LOG.LEVEL_EXCEPTION);
3444: END CS_COUNTER_GRP_Post_Upd;
3445:
3446: PROCEDURE CS_COUNTERS_INSTANTIATE_POST(
3447: P_Api_Version IN NUMBER,
3448: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
3449: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
3450: X_Return_Status OUT NOCOPY VARCHAR2,

Line 3480: END CS_COUNTERS_INSTANTIATE_POST;

3476: EXCEPTION
3477: --log the error
3478: WHEN OTHERS THEN
3479: csm_util_pkg.log('ERROR: COUNTER_GROUP_ID => ' || to_char(p_ctr_grp_id));
3480: END CS_COUNTERS_INSTANTIATE_POST;
3481:
3482:
3483:
3484: /*------------

Line 3500: -- p_cs_counters cs_counters%rowtype

3496: p_object_version_number IN NUMBER,
3497: p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
3498: x_object_version_number OUT NOCOPY NUMBER
3499: -- p_user_id in number,
3500: -- p_cs_counters cs_counters%rowtype
3501: )
3502: IS
3503:
3504: /* CURSOR l_acc_del_csr(b_counter_id NUMBER) IS

Line 3506: FROM CS_COUNTERS counters

3502: IS
3503:
3504: /* CURSOR l_acc_del_csr(b_counter_id NUMBER) IS
3505: SELECT acc.user_id
3506: FROM CS_COUNTERS counters
3507: , CS_COUNTER_GROUPS counter_groups
3508: , csm_item_instances_acc acc
3509: WHERE counters.counter_group_id = counter_groups.counter_group_id
3510: AND counter_groups.source_object_code = 'CP'

Line 3517: FROM CS_COUNTERS counters

3513: and counters.counter_id = b_counter_id;
3514:
3515: CURSOR l_acc_upd_csr(b_counter_id NUMBER) IS
3516: SELECT acc.user_id
3517: FROM CS_COUNTERS counters
3518: , CS_COUNTER_GROUPS counter_groups
3519: , csm_item_instances_acc acc
3520: WHERE counters.counter_group_id = counter_groups.counter_group_id
3521: AND counter_groups.source_object_code = 'CP'

Line 3561: FROM CS_COUNTERS counters

3557: l_return_status VARCHAR2(2000);
3558:
3559: CURSOR l_acc_csr(b_counter_id NUMBER) IS
3560: SELECT COUNT(1)
3561: FROM CS_COUNTERS counters
3562: , CS_COUNTER_GROUPS counter_groups
3563: , csm_item_instances_acc acc
3564: WHERE counters.counter_group_id = counter_groups.counter_group_id
3565: AND counter_groups.source_object_code = 'CP'