APPS.ECX_XREF_HDR_PKG dependencies on ECX_XREF_HDR_B

Line 94: from ECX_XREF_HDR_B

90:
91: begin
92: select XREF_CATEGORY_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE
93: into l_hdr_id, l_db_luby, l_db_ludate
94: from ECX_XREF_HDR_B
95: where XREF_CATEGORY_CODE = x_xref_category_code;
96:
97: -- Update record, honoring customization mode.
98: -- Record should be updated only if:

Line 147: cursor C is select ROWID from ECX_XREF_HDR_B

143: X_LAST_UPDATE_DATE in DATE,
144: X_LAST_UPDATED_BY in NUMBER,
145: X_LAST_UPDATE_LOGIN in NUMBER
146: ) is
147: cursor C is select ROWID from ECX_XREF_HDR_B
148: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID
149: ;
150: begin
151: insert into ECX_XREF_HDR_B (

Line 151: insert into ECX_XREF_HDR_B (

147: cursor C is select ROWID from ECX_XREF_HDR_B
148: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID
149: ;
150: begin
151: insert into ECX_XREF_HDR_B (
152: XREF_CATEGORY_ID,
153: XREF_CATEGORY_CODE,
154: CREATION_DATE,
155: CREATED_BY,

Line 214: from ECX_XREF_HDR_B

210: X_DESCRIPTION in VARCHAR2
211: ) is
212: cursor c is select
213: XREF_CATEGORY_CODE
214: from ECX_XREF_HDR_B
215: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID
216: for update of XREF_CATEGORY_ID nowait;
217: recinfo c%rowtype;
218:

Line 267: update ECX_XREF_HDR_B set

263: X_LAST_UPDATED_BY in NUMBER,
264: X_LAST_UPDATE_LOGIN in NUMBER
265: ) is
266: begin
267: update ECX_XREF_HDR_B set
268: XREF_CATEGORY_CODE = X_XREF_CATEGORY_CODE,
269: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
270: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
271: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 303: delete from ECX_XREF_HDR_B

299: if (sql%notfound) then
300: raise no_data_found;
301: end if;
302:
303: delete from ECX_XREF_HDR_B
304: where XREF_CATEGORY_ID = X_XREF_CATEGORY_ID;
305:
306: if (sql%notfound) then
307: raise no_data_found;

Line 317: from ECX_XREF_HDR_B B

313: begin
314: delete from ECX_XREF_HDR_TL T
315: where not exists
316: (select NULL
317: from ECX_XREF_HDR_B B
318: where B.XREF_CATEGORY_ID = T.XREF_CATEGORY_ID
319: );
320:
321: update ECX_XREF_HDR_TL T set (