APPS.ECX_XREF_DTL_PKG dependencies on ECX_XREF_DTL_B

Line 35: from ECX_XREF_DTL_B

31:
32: begin
33: select xref_dtl_id
34: into l_dtl_id
35: from ECX_XREF_DTL_B
36: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID
37: and standard_id = X_STANDARD_ID
38: and tp_header_id = X_TP_HEADER_ID
39: and xref_int_value = X_XREF_INT_VALUE

Line 119: from ECX_XREF_DTL_B

115: and STANDARD_TYPE = nvl(X_STANDARD_TYPE, 'XML');
116:
117: select XREF_DTL_ID
118: into l_dtl_id
119: from ECX_XREF_DTL_B
120: where XREF_CATEGORY_ID = l_hdr_id
121: and standard_id = l_standard_id
122: and tp_header_id = X_TP_HEADER_ID
123: and xref_int_value = X_XREF_INT_VALUE

Line 193: cursor C is select ROWID from ECX_XREF_DTL_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_DTL_B
194: where XREF_DTL_ID = X_XREF_DTL_ID
195: ;
196: begin
197: insert into ECX_XREF_DTL_B (

Line 197: insert into ECX_XREF_DTL_B (

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

Line 284: from ECX_XREF_DTL_B

280: TP_HEADER_ID,
281: XREF_EXT_VALUE,
282: XREF_INT_VALUE,
283: DIRECTION
284: from ECX_XREF_DTL_B
285: where XREF_DTL_ID = X_XREF_DTL_ID
286: for update of XREF_DTL_ID nowait;
287: recinfo c%rowtype;
288:

Line 350: update ECX_XREF_DTL_B set

346: X_LAST_UPDATED_BY in NUMBER,
347: X_LAST_UPDATE_LOGIN in NUMBER
348: ) is
349: begin
350: update ECX_XREF_DTL_B set
351: XREF_CATEGORY_ID = X_XREF_CATEGORY_ID,
352: STANDARD_ID = X_STANDARD_ID,
353: XREF_STANDARD_CODE = X_XREF_STANDARD_CODE,
354: TP_HEADER_ID = X_TP_HEADER_ID,

Line 392: delete from ECX_XREF_DTL_B

388: if (sql%notfound) then
389: raise no_data_found;
390: end if;
391:
392: delete from ECX_XREF_DTL_B
393: where XREF_DTL_ID = X_XREF_DTL_ID;
394:
395: if (sql%notfound) then
396: raise no_data_found;

Line 406: from ECX_XREF_DTL_B B

402: begin
403: delete from ECX_XREF_DTL_TL T
404: where not exists
405: (select NULL
406: from ECX_XREF_DTL_B B
407: where B.XREF_DTL_ID = T.XREF_DTL_ID
408: );
409:
410: update ECX_XREF_DTL_TL T set (