APPS.ASG_HELPER dependencies on ASG_SEQUENCE_PARTITIONS

Line 262: DELETE FROM asg_sequence_partitions

258: IS
259: BEGIN
260: -- Delete the row before inserting
261: -- #$% Can remove delete after debug/qa
262: DELETE FROM asg_sequence_partitions
263: WHERE clientid = p_user_name AND name = p_seq_name;
264:
265: INSERT INTO asg_sequence_partitions (
266: CLIENTID,

Line 265: INSERT INTO asg_sequence_partitions (

261: -- #$% Can remove delete after debug/qa
262: DELETE FROM asg_sequence_partitions
263: WHERE clientid = p_user_name AND name = p_seq_name;
264:
265: INSERT INTO asg_sequence_partitions (
266: CLIENTID,
267: NAME,
268: CURR_VAL,
269: INCR,

Line 300: DELETE FROM asg_sequence_partitions

296: p_seq_name IN VARCHAR2)
297: IS
298: BEGIN
299:
300: DELETE FROM asg_sequence_partitions
301: WHERE clientid = p_user_name AND name = p_seq_name;
302:
303: COMMIT;
304: IF(check_is_log_enabled(g_stmt_level))

Line 505: DELETE FROM asg_sequence_partitions

501:
502: DELETE FROM asg_complete_refresh
503: WHERE user_name = l_user_name;
504:
505: DELETE FROM asg_sequence_partitions
506: WHERE clientid = p_user_name;
507:
508: DELETE FROM ASG_USER
509: WHERE user_name = l_user_name;

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

1427: l_sql_string := 'GRANT SELECT ON ASG_DELETE_QUEUE TO '||
1428: l_olite_schema;
1429: grant_db_privilege(l_sql_string);
1430:
1431: l_sql_string := 'GRANT SELECT ON ASG_SEQUENCE_PARTITIONS_V TO '||
1432: l_olite_schema;
1433: grant_db_privilege(l_sql_string);
1434:
1435: l_sql_string := 'GRANT SELECT ON ASG_TEMP_LOB TO '||