APPS.CS_PARTY_ROLES_PKG dependencies on CS_PARTY_ROLES_TL

Line 46: insert into CS_PARTY_ROLES_TL (

42: P_LAST_UPDATED_BY,
43: P_LAST_UPDATE_LOGIN
44: );
45:
46: insert into CS_PARTY_ROLES_TL (
47: CREATION_DATE,
48: CREATED_BY,
49: LAST_UPDATE_DATE,
50: LAST_UPDATED_BY,

Line 72: from CS_PARTY_ROLES_TL T

68: from FND_LANGUAGES L
69: where L.INSTALLED_FLAG in ('I', 'B')
70: and not exists
71: (select NULL
72: from CS_PARTY_ROLES_TL T
73: where T.PARTY_ROLE_CODE = PX_PARTY_ROLE_CODE
74: and T.LANGUAGE = L.LANGUAGE_CODE);
75:
76: x_object_version_number := l_object_version_number;

Line 112: update CS_PARTY_ROLES_TL set

108: if (sql%notfound) then
109: raise no_data_found;
110: end if;
111:
112: update CS_PARTY_ROLES_TL set
113: NAME = P_NAME,
114: DESCRIPTION = P_DESCRIPTION,
115: LAST_UPDATE_DATE = P_LAST_UPDATE_DATE,
116: LAST_UPDATED_BY = P_LAST_UPDATED_BY,

Line 131: delete from CS_PARTY_ROLES_TL

127: procedure DELETE_ROW (
128: P_PARTY_ROLE_CODE in VARCHAR2
129: ) is
130: begin
131: delete from CS_PARTY_ROLES_TL
132: where PARTY_ROLE_CODE = P_PARTY_ROLE_CODE;
133:
134: if (sql%notfound) then
135: raise no_data_found;

Line 149: delete from CS_PARTY_ROLES_TL T

145:
146: procedure ADD_LANGUAGE
147: is
148: begin
149: delete from CS_PARTY_ROLES_TL T
150: where not exists
151: (select NULL
152: from CS_PARTY_ROLES_B B
153: where B.PARTY_ROLE_CODE = T.PARTY_ROLE_CODE

Line 156: update CS_PARTY_ROLES_TL T set (

152: from CS_PARTY_ROLES_B B
153: where B.PARTY_ROLE_CODE = T.PARTY_ROLE_CODE
154: );
155:
156: update CS_PARTY_ROLES_TL T set (
157: NAME,
158: DESCRIPTION
159: ) = (select
160: B.NAME,

Line 162: from CS_PARTY_ROLES_TL B

158: DESCRIPTION
159: ) = (select
160: B.NAME,
161: B.DESCRIPTION
162: from CS_PARTY_ROLES_TL B
163: where B.PARTY_ROLE_CODE = T.PARTY_ROLE_CODE
164: and B.LANGUAGE = T.SOURCE_LANG)
165: where (
166: T.PARTY_ROLE_CODE,

Line 171: from CS_PARTY_ROLES_TL SUBB, CS_PARTY_ROLES_TL SUBT

167: T.LANGUAGE
168: ) in (select
169: SUBT.PARTY_ROLE_CODE,
170: SUBT.LANGUAGE
171: from CS_PARTY_ROLES_TL SUBB, CS_PARTY_ROLES_TL SUBT
172: where SUBB.PARTY_ROLE_CODE = SUBT.PARTY_ROLE_CODE
173: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
174: and (SUBB.NAME <> SUBT.NAME
175: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 180: insert into CS_PARTY_ROLES_TL (

176: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
177: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
178: ));
179:
180: insert into CS_PARTY_ROLES_TL (
181: CREATION_DATE,
182: CREATED_BY,
183: LAST_UPDATE_DATE,
184: LAST_UPDATED_BY,

Line 202: from CS_PARTY_ROLES_TL B, FND_LANGUAGES L

198: B.NAME,
199: B.DESCRIPTION,
200: L.LANGUAGE_CODE,
201: B.SOURCE_LANG
202: from CS_PARTY_ROLES_TL B, FND_LANGUAGES L
203: where L.INSTALLED_FLAG in ('I', 'B')
204: and B.LANGUAGE = userenv('LANG')
205: and not exists
206: (select NULL

Line 207: from CS_PARTY_ROLES_TL T

203: where L.INSTALLED_FLAG in ('I', 'B')
204: and B.LANGUAGE = userenv('LANG')
205: and not exists
206: (select NULL
207: from CS_PARTY_ROLES_TL T
208: where T.PARTY_ROLE_CODE = B.PARTY_ROLE_CODE
209: and T.LANGUAGE = L.LANGUAGE_CODE);
210: end ADD_LANGUAGE;
211:

Line 301: update CS_PARTY_ROLES_TL set

297: else
298: l_user_id := 0;
299: end if;
300:
301: update CS_PARTY_ROLES_TL set
302: name = nvl(x_name,name),
303: description = nvl(x_description,name),
304: last_update_date = nvl(x_last_update_date,sysdate),
305: last_updated_by = l_user_id,