APPS.ASG_HELPER dependencies on ASG_SEQUENCE_PARTITIONS

Line 270: DELETE FROM asg_sequence_partitions

266:
267: BEGIN
268: -- Delete the row before inserting
269: -- #$% Can remove delete after debug/qa
270: DELETE FROM asg_sequence_partitions
271: WHERE clientid = p_user_name AND name = p_seq_name;
272:
273: OPEN C_MULTI_PLATFORM(p_user_name);
274: FETCH C_MULTI_PLATFORM into l_multi_platform;

Line 278: select ASG_SEQUENCE_PARTITIONS_S.nextval into l_access_id from dual;

274: FETCH C_MULTI_PLATFORM into l_multi_platform;
275: CLOSE C_MULTI_PLATFORM;
276:
277: IF l_multi_platform = 'Y' THEN
278: select ASG_SEQUENCE_PARTITIONS_S.nextval into l_access_id from dual;
279: END IF;
280:
281: INSERT INTO asg_sequence_partitions (
282: CLIENTID,

Line 281: INSERT INTO asg_sequence_partitions (

277: IF l_multi_platform = 'Y' THEN
278: select ASG_SEQUENCE_PARTITIONS_S.nextval into l_access_id from dual;
279: END IF;
280:
281: INSERT INTO asg_sequence_partitions (
282: CLIENTID,
283: NAME,
284: CURR_VAL,
285: INCR,

Line 319: DELETE FROM asg_sequence_partitions

315: p_seq_name IN VARCHAR2)
316: IS
317: BEGIN
318:
319: DELETE FROM asg_sequence_partitions
320: WHERE clientid = p_user_name AND name = p_seq_name;
321:
322: COMMIT;
323: IF(check_is_log_enabled(g_stmt_level))

Line 524: DELETE FROM asg_sequence_partitions

520:
521: DELETE FROM asg_complete_refresh
522: WHERE user_name = l_user_name;
523:
524: DELETE FROM asg_sequence_partitions
525: WHERE clientid = p_user_name;
526:
527: DELETE FROM ASG_USER
528: WHERE user_name = l_user_name;

Line 1494: l_sql_string := 'GRANT SELECT ON ASG_SEQUENCE_PARTITIONS_V TO '||

1490: l_sql_string := 'GRANT SELECT ON ASG_DELETE_QUEUE TO '||
1491: l_olite_schema;
1492: grant_db_privilege(l_sql_string);
1493:
1494: l_sql_string := 'GRANT SELECT ON ASG_SEQUENCE_PARTITIONS_V TO '||
1495: l_olite_schema;
1496: grant_db_privilege(l_sql_string);
1497:
1498: l_sql_string := 'GRANT SELECT ON ASG_TEMP_LOB TO '||