DBA Data[Home] [Help]

APPS.CSI_COUNTER_PVT dependencies on CSI_COUNTERS_B_S

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 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;