APPS.FND_OAM_DSCRAM dependencies on FND_OAM_DS_POLICIES_TL

Line 49: insert into FND_OAM_DS_POLICIES_TL (

45: l_last_updated_by, sysdate, l_last_update_login);
46:
47: /*insert into the TL table*/
48:
49: insert into FND_OAM_DS_POLICIES_TL (
50: policy_id,
51: policy_name,
52: description,
53: CREATED_BY,

Line 69: from FND_OAM_DS_POLICIES_TL T

65: from FND_LANGUAGES L
66: where L.INSTALLED_FLAG in ('I', 'B')
67: and not exists
68: (select NULL
69: from FND_OAM_DS_POLICIES_TL T
70: where T.POLICY_ID = policyid
71: and T.LANGUAGE = L.LANGUAGE_CODE);
72:
73: commit;

Line 105: delete from FND_OAM_DS_POLICIES_TL

101: where policy_id = policyid;
102:
103:
104: /* Make sure no bad data in tl table */
105: delete from FND_OAM_DS_POLICIES_TL
106: where policy_id = policyid
107: and language in (select l.language_code
108: from fnd_languages l
109: where l.installed_flag in ('I', 'B'));

Line 112: insert into FND_OAM_DS_POLICIES_TL (

108: from fnd_languages l
109: where l.installed_flag in ('I', 'B'));
110:
111:
112: insert into FND_OAM_DS_POLICIES_TL (
113: policy_id,
114: policy_name,
115: description,
116: CREATED_BY,

Line 132: from FND_OAM_DS_POLICIES_TL T

128: from FND_LANGUAGES L
129: where L.INSTALLED_FLAG in ('I', 'B')
130: and not exists
131: (select NULL
132: from FND_OAM_DS_POLICIES_TL T
133: where T.POLICY_ID = policyid
134: and T.LANGUAGE = L.LANGUAGE_CODE);
135:
136: /* Delete all policy elements for this policy. */

Line 638: delete from FND_OAM_DS_POLICIES_TL where policy_id = p_policy_id;

634:
635: begin
636:
637: delete from FND_OAM_DS_POLICIES_B where policy_id = p_policy_id;
638: delete from FND_OAM_DS_POLICIES_TL where policy_id = p_policy_id;
639: delete from FND_OAM_DS_PSET_ELMNTS where policy_id = p_policy_id;
640: delete from FND_OAM_DS_POLICY_ELMNTS where policy_id = p_policy_id;
641:
642: commit;