APPS.ECX_XREF_STANDARDS_PKG dependencies on ECX_XREF_STANDARDS_B

Line 35: from ecx_xref_standards_b

31:
32: begin
33: select xref_standard_id
34: into l_xref_standard_id
35: from ecx_xref_standards_b
36: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID
37: and STANDARD_ID = X_STANDARD_ID
38: and XREF_STD_VALUE = X_XREF_STD_VALUE
39: and XREF_INT_VALUE = X_XREF_INT_VALUE;

Line 118: from ECX_XREF_STANDARDS_B

114: and standard_type = nvl(X_STANDARD_TYPE, 'XML');
115:
116: select XREF_STANDARD_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
117: into l_xref_standard_id, l_db_luby, l_db_ludate
118: from ECX_XREF_STANDARDS_B
119: where XREF_CATEGORY_ID = l_hdr_id
120: and STANDARD_ID = l_standard_id
121: and XREF_STD_VALUE = X_XREF_STD_VALUE
122: and XREF_INT_VALUE = X_XREF_INT_VALUE;

Line 193: cursor C is select ROWID from ECX_XREF_STANDARDS_B

189: X_LAST_UPDATE_DATE in DATE,
190: X_LAST_UPDATED_BY in NUMBER,
191: X_LAST_UPDATE_LOGIN in NUMBER
192: ) is
193: cursor C is select ROWID from ECX_XREF_STANDARDS_B
194: where XREF_STANDARD_ID = X_XREF_STANDARD_ID
195: ;
196: begin
197: insert into ECX_XREF_STANDARDS_B (

Line 197: insert into ECX_XREF_STANDARDS_B (

193: cursor C is select ROWID from ECX_XREF_STANDARDS_B
194: where XREF_STANDARD_ID = X_XREF_STANDARD_ID
195: ;
196: begin
197: insert into ECX_XREF_STANDARDS_B (
198: XREF_STANDARD_ID,
199: XREF_CATEGORY_ID,
200: STANDARD_ID,
201: XREF_STANDARD_CODE,

Line 280: from ECX_XREF_STANDARDS_B

276: XREF_STANDARD_CODE,
277: XREF_STD_VALUE,
278: XREF_INT_VALUE,
279: DATA_SEEDED
280: from ECX_XREF_STANDARDS_B
281: where XREF_STANDARD_ID = X_XREF_STANDARD_ID
282: for update of XREF_STANDARD_ID nowait;
283: recinfo c%rowtype;
284:

Line 346: update ECX_XREF_STANDARDS_B set

342: X_LAST_UPDATED_BY in NUMBER,
343: X_LAST_UPDATE_LOGIN in NUMBER
344: ) is
345: begin
346: update ECX_XREF_STANDARDS_B set
347: XREF_CATEGORY_ID = X_XREF_CATEGORY_ID,
348: STANDARD_ID = X_STANDARD_ID,
349: XREF_STANDARD_CODE = X_XREF_STANDARD_CODE,
350: XREF_STD_VALUE = X_XREF_STD_VALUE,

Line 387: delete from ECX_XREF_STANDARDS_B

383: if (sql%notfound) then
384: raise no_data_found;
385: end if;
386:
387: delete from ECX_XREF_STANDARDS_B
388: where XREF_STANDARD_ID = X_XREF_STANDARD_ID;
389:
390: if (sql%notfound) then
391: raise no_data_found;

Line 401: from ECX_XREF_STANDARDS_B B

397: begin
398: delete from ECX_XREF_STANDARDS_TL T
399: where not exists
400: (select NULL
401: from ECX_XREF_STANDARDS_B B
402: where B.XREF_STANDARD_ID = T.XREF_STANDARD_ID
403: );
404:
405: update ECX_XREF_STANDARDS_TL T set (