APPS.CSI_COUNTER_PVT dependencies on CSI_COUNTERS_B

Line 1017: select CSI_COUNTERS_B_S.nextval

1013: );
1014:
1015: -- Check and Generate Counter_value_id
1016: IF l_counter_id IS NULL OR l_counter_id = FND_API.G_MISS_NUM THEN
1017: select CSI_COUNTERS_B_S.nextval
1018: into l_counter_id from dual;
1019: END IF;
1020: -- counter name suffix counter id is created from template or if duplicate exist.
1021: if l_created_from_counter_tmpl_id is not null then

Line 1450: from csi_counters_b

1446: --Validate Counter Id
1447: begin
1448: select 'x'
1449: into l_dummy
1450: from csi_counters_b
1451: where counter_id = l_counter_id;
1452: exception when no_data_found then
1453: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');
1454: end;

Line 1814: from csi_counters_b

1810: --Validate Counter Id
1811: begin
1812: select 'x'
1813: into l_dummy
1814: from csi_counters_b
1815: where counter_id = l_counter_id;
1816: exception when no_data_found then
1817: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');
1818: end;

Line 2138: from csi_counters_b

2134: --Validate Counter Id
2135: begin
2136: select 'x'
2137: into l_dummy
2138: from csi_counters_b
2139: where counter_id = l_counter_id;
2140: exception when no_data_found then
2141: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');
2142: end;

Line 2371: from csi_counters_b

2367: --Validate Counter Id
2368: begin
2369: select 'x'
2370: into l_dummy
2371: from csi_counters_b
2372: where counter_id = l_counter_id;
2373: exception when no_data_found then
2374: csi_ctr_gen_utility_pvt.ExitWithErrMsg('CSI_API_CTR_INVALID');
2375: end;

Line 4166: FROM csi_counters_b

4162: END IF;
4163:
4164: SELECT ctr_val_max_seq_no, object_version_number
4165: INTO l_old_ctr_val_max_seq_no, l_old_object_version_number
4166: FROM csi_counters_b
4167: WHERE counter_id = p_counter_id;
4168:
4169: IF (csi_ctr_gen_utility_pvt.g_debug_level > 1) THEN
4170: csi_ctr_gen_utility_pvt.put_line('l_old_ctr_val_max_seq_no : ' || l_old_ctr_val_max_seq_no);

Line 4253: UPDATE CSI_COUNTERS_B SET CTR_VAL_MAX_SEQ_NO = px_ctr_val_max_seq_no,

4249:
4250: -- Bug 9283089
4251: IF NVL(px_ctr_val_max_seq_no, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM THEN
4252:
4253: UPDATE CSI_COUNTERS_B SET CTR_VAL_MAX_SEQ_NO = px_ctr_val_max_seq_no,
4254: OBJECT_VERSION_NUMBER = l_old_object_version_number + 1,
4255: LAST_UPDATE_DATE = sysdate, LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
4256: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
4257: WHERE COUNTER_ID = p_counter_id;