APPS.FND_OAM_DSCRAM dependencies on FND_OAM_DS_DELETES

Line 459: /* add a new delete entry into FND_OAM_DS_DELETES */

455:
456: end remove_pset_elements;
457:
458:
459: /* add a new delete entry into FND_OAM_DS_DELETES */
460:
461: procedure add_delete
462: (
463: l_table_name IN VARCHAR2,

Line 480: select FND_OAM_DS_DELETES_S.nextval

476:
477: begin
478:
479: /* Get new ID */
480: select FND_OAM_DS_DELETES_S.nextval
481: into deleteid
482: from sys.dual;
483:
484: --truncate flag, value can be "T" or "F". the default is "F"

Line 500: --before insert, check there is an existing row in fnd_oam_ds_deletes for

496: and t.application_id = pi.application_id
497: and pi.oracle_id = ou.oracle_id;
498: end if;
499:
500: --before insert, check there is an existing row in fnd_oam_ds_deletes for
501: -- (owner, table_name, where_cluase, use_truncate_flag)
502:
503: select count(*) into v_count from fnd_oam_ds_deletes
504: where owner = v_owner

Line 503: select count(*) into v_count from fnd_oam_ds_deletes

499:
500: --before insert, check there is an existing row in fnd_oam_ds_deletes for
501: -- (owner, table_name, where_cluase, use_truncate_flag)
502:
503: select count(*) into v_count from fnd_oam_ds_deletes
504: where owner = v_owner
505: and table_name = l_table_name
506: and where_clause = l_where_clause
507: and use_truncate_flag = v_use_truncate_flag;

Line 511: insert into FND_OAM_DS_DELETES(

507: and use_truncate_flag = v_use_truncate_flag;
508:
509: --insert when there is not an existing entry.
510: if v_count = 0 then
511: insert into FND_OAM_DS_DELETES(
512: delete_id,
513: table_name,
514: owner,
515: where_clause,

Line 538: /* add a new delete entry into FND_OAM_DS_DELETES */

534:
535:
536:
537:
538: /* add a new delete entry into FND_OAM_DS_DELETES */
539:
540: procedure update_delete
541: (
542: l_delete_id IN VARCHAR2,

Line 559: select count(*) into v_count from fnd_oam_ds_deletes

555:
556: --truncate flag, value can be "T" or "F". the default is "F"
557: v_use_truncate_flag := NVL(l_use_truncate_flag, 'F');
558:
559: select count(*) into v_count from fnd_oam_ds_deletes
560: where delete_id=l_delete_id;
561:
562: --insert when there is not an existing entry.
563: if v_count > 0 then

Line 564: update FND_OAM_DS_DELETES

560: where delete_id=l_delete_id;
561:
562: --insert when there is not an existing entry.
563: if v_count > 0 then
564: update FND_OAM_DS_DELETES
565: set where_clause=l_where_clause, use_truncate_flag = l_use_truncate_flag,
566: last_updated_by=l_last_updated_by ,last_update_date=sysdate
567: where delete_id=l_delete_id;
568: end if;

Line 583: /* remove a delete entry with deleteid from FND_OAM_DS_DELETES */

579:
580:
581:
582:
583: /* remove a delete entry with deleteid from FND_OAM_DS_DELETES */
584:
585: procedure remove_delete
586: (
587: deleteid in number

Line 593: delete from FND_OAM_DS_DELETES where delete_id = deleteid;

589:
590:
591: begin
592:
593: delete from FND_OAM_DS_DELETES where delete_id = deleteid;
594:
595: commit;
596: EXCEPTION
597: when others then

Line 682: delete from FND_OAM_DS_DELETES where delete_id = deleteid;

678: ) is
679:
680: begin
681:
682: delete from FND_OAM_DS_DELETES where delete_id = deleteid;
683: delete from FND_OAM_DS_POLICY_ELMNTS where delete_id = deleteid;
684: commit;
685: EXCEPTION
686: when others then

Line 1164: from fnd_oam_ds_deletes d, fnd_oam_ds_policy_elmnts pe

1160:
1161: --cursor to query deletes/truncates for a policy
1162: CURSOR policy_delete_c (v_policyid fnd_oam_ds_policies_b.policy_id%TYPE) IS
1163: select d.delete_id, d.owner, d.table_name, d.where_clause, d.use_truncate_flag
1164: from fnd_oam_ds_deletes d, fnd_oam_ds_policy_elmnts pe
1165: where pe.policy_id = v_policyid
1166: and upper(pe.element_type) = 'DML_DELETE'
1167: and d.delete_id = pe.delete_id;
1168: delete_rec policy_delete_c%ROWTYPE;