DBA Data[Home] [Help]

APPS.FND_OAM_DSCRAM dependencies on FND_PRIVACY_ATTRIBUTES_TL

Line 615: delete from FND_PRIVACY_ATTRIBUTES_TL where privacy_attribute_code = attribute_code;

611:
612: begin
613:
614: delete from FND_PRIVACY_ATTRIBUTES_B where privacy_attribute_code = attribute_code;
615: delete from FND_PRIVACY_ATTRIBUTES_TL where privacy_attribute_code = attribute_code;
616: delete from FND_OAM_DS_POLICY_ELMNTS where privacy_attribute_code = attribute_code;
617: delete from FND_COL_PRIV_ATTRIBUTES_B where privacy_attribute_code = attribute_code;
618: delete from FND_OAM_DS_PII_EXTENSIONS where privacy_attribute_code = attribute_code;
619: commit;

Line 753: insert into FND_PRIVACY_ATTRIBUTES_TL (PRIVACY_ATTRIBUTE_CODE,

749: l_last_updated_by,
750: sysdate,
751: l_last_update_login);
752:
753: insert into FND_PRIVACY_ATTRIBUTES_TL (PRIVACY_ATTRIBUTE_CODE,
754: PRIVACY_ATTRIBUTE_NAME,
755: DESCRIPTION,
756: CREATED_BY,
757: CREATION_DATE,

Line 779: from FND_PRIVACY_ATTRIBUTES_TL T

775: from FND_LANGUAGES L
776: where L.INSTALLED_FLAG in ('I', 'B')
777: and not exists
778: (select NULL
779: from FND_PRIVACY_ATTRIBUTES_TL T
780: where T.PRIVACY_ATTRIBUTE_CODE = attribute_code
781: and T.LANGUAGE = L.LANGUAGE_CODE);
782:
783: commit;

Line 854: insert into FND_PRIVACY_ATTRIBUTES_TL (PRIVACY_ATTRIBUTE_CODE,

850: l_last_updated_by,
851: sysdate,
852: l_last_update_login); */
853:
854: insert into FND_PRIVACY_ATTRIBUTES_TL (PRIVACY_ATTRIBUTE_CODE,
855: PRIVACY_ATTRIBUTE_NAME,
856: DESCRIPTION,
857: CREATED_BY,
858: CREATION_DATE,

Line 880: from FND_PRIVACY_ATTRIBUTES_TL T

876: from FND_LANGUAGES L
877: where L.INSTALLED_FLAG in ('I', 'B')
878: and not exists
879: (select NULL
880: from FND_PRIVACY_ATTRIBUTES_TL T
881: where T.PRIVACY_ATTRIBUTE_CODE = attribute_code
882: and T.LANGUAGE = L.LANGUAGE_CODE);
883:
884: commit;

Line 905: delete from FND_PRIVACY_ATTRIBUTES_TL where privacy_attribute_code = attribute_code;

901:
902: begin
903:
904: --delete from FND_PRIVACY_ATTRIBUTES_B where privacy_attribute_code = attribute_code;
905: delete from FND_PRIVACY_ATTRIBUTES_TL where privacy_attribute_code = attribute_code;
906: delete from FND_COL_PRIV_ATTRIBUTES_B where privacy_attribute_code = attribute_code;
907: delete from FND_OAM_DS_PII_EXTENSIONS where privacy_attribute_code = attribute_code;
908: EXCEPTION
909: when others then