eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECX_XREF_DTL_PKG dependencies on STANDARD

Line 6: X_STANDARD_ID IN NUMBER,

2: /* $Header: ECXXRFDB.pls 115.5 2003/11/14 17:44:59 mtai ship $ */
3:
4: procedure TRANSLATE_ROW (
5: X_XREF_CATEGORY_ID IN NUMBER,
6: X_STANDARD_ID IN NUMBER,
7: X_TP_HEADER_ID IN NUMBER,
8: X_XREF_EXT_VALUE IN VARCHAR2,
9: X_XREF_INT_VALUE IN VARCHAR2,
10: X_DIRECTION IN VARCHAR2,

Line 37: and standard_id = X_STANDARD_ID

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
40: and xref_ext_value = X_XREF_EXT_VALUE
41: and direction = X_DIRECTION;

Line 75: X_STANDARD_CODE IN VARCHAR2,

71: end TRANSLATE_ROW;
72:
73: procedure LOAD_ROW (
74: X_XREF_CATEGORY_CODE IN VARCHAR2,
75: X_STANDARD_CODE IN VARCHAR2,
76: X_TP_HEADER_ID IN NUMBER,
77: X_XREF_EXT_VALUE IN VARCHAR2,
78: X_XREF_INT_VALUE IN VARCHAR2,
79: X_DIRECTION IN VARCHAR2,

Line 83: X_STANDARD_TYPE IN VARCHAR2)

79: X_DIRECTION IN VARCHAR2,
80: X_DESCRIPTION IN VARCHAR2,
81: X_OWNER IN VARCHAR2,
82: X_CUSTOM_MODE IN VARCHAR2,
83: X_STANDARD_TYPE IN VARCHAR2)
84: is
85: l_luby number; -- entity owner in file
86: l_ludate date; -- entity update date in file
87: l_db_luby number; -- entity owner in db

Line 93: l_standard_id number :=0;

89: l_ret_code pls_integer :=0;
90: l_errmsg varchar2(2000) := null;
91: l_dtl_id number := 0;
92: l_hdr_id number :=0;
93: l_standard_id number :=0;
94: begin
95: -- Translate owner to file_last_updated_by
96: if (x_owner = 'SEED') then
97: l_luby := 1;

Line 111: select STANDARD_ID

107: into l_hdr_id
108: from ecx_xref_hdr_b
109: where XREF_CATEGORY_CODE = X_XREF_CATEGORY_CODE;
110:
111: select STANDARD_ID
112: into l_standard_id
113: from ecx_standards_b
114: where STANDARD_CODE = X_STANDARD_CODE
115: and STANDARD_TYPE = nvl(X_STANDARD_TYPE, 'XML');

Line 112: into l_standard_id

108: from ecx_xref_hdr_b
109: where XREF_CATEGORY_CODE = X_XREF_CATEGORY_CODE;
110:
111: select STANDARD_ID
112: into l_standard_id
113: from ecx_standards_b
114: where STANDARD_CODE = X_STANDARD_CODE
115: and STANDARD_TYPE = nvl(X_STANDARD_TYPE, 'XML');
116:

Line 113: from ecx_standards_b

109: where XREF_CATEGORY_CODE = X_XREF_CATEGORY_CODE;
110:
111: select STANDARD_ID
112: into l_standard_id
113: from ecx_standards_b
114: where STANDARD_CODE = X_STANDARD_CODE
115: and STANDARD_TYPE = nvl(X_STANDARD_TYPE, 'XML');
116:
117: select XREF_DTL_ID

Line 114: where STANDARD_CODE = X_STANDARD_CODE

110:
111: select STANDARD_ID
112: into l_standard_id
113: from ecx_standards_b
114: where STANDARD_CODE = X_STANDARD_CODE
115: and STANDARD_TYPE = nvl(X_STANDARD_TYPE, 'XML');
116:
117: select XREF_DTL_ID
118: into l_dtl_id

Line 115: and STANDARD_TYPE = nvl(X_STANDARD_TYPE, 'XML');

111: select STANDARD_ID
112: into l_standard_id
113: from ecx_standards_b
114: where STANDARD_CODE = X_STANDARD_CODE
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

Line 121: and standard_id = l_standard_id

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
124: and xref_ext_value = X_XREF_EXT_VALUE
125: and direction = X_DIRECTION;

Line 160: p_standard => X_STANDARD_CODE,

156: x_msg => l_errmsg,
157: x_xref_dtl_id => l_dtl_id,
158: x_xref_category_id => l_hdr_id,
159: p_xref_category_code => X_XREF_CATEGORY_CODE,
160: p_standard => X_STANDARD_CODE,
161: p_tp_header_id => X_TP_HEADER_ID,
162: p_xref_ext_value => X_XREF_EXT_VALUE,
163: p_xref_int_value => X_XREF_INT_VALUE,
164: p_description => X_DESCRIPTION,

Line 166: p_standard_type => X_STANDARD_TYPE

162: p_xref_ext_value => X_XREF_EXT_VALUE,
163: p_xref_int_value => X_XREF_INT_VALUE,
164: p_description => X_DESCRIPTION,
165: p_direction => X_DIRECTION,
166: p_standard_type => X_STANDARD_TYPE
167: );
168: if NOT(l_ret_code = ECX_UTIL_API.G_NO_ERROR) then
169: raise_application_error(-20000, l_errmsg);
170: end if;

Line 180: X_STANDARD_ID in NUMBER,

176: procedure INSERT_ROW (
177: X_ROWID in out NOCOPY VARCHAR2,
178: X_XREF_DTL_ID in NUMBER,
179: X_XREF_CATEGORY_ID in NUMBER,
180: X_STANDARD_ID in NUMBER,
181: X_XREF_STANDARD_CODE in VARCHAR2,
182: X_TP_HEADER_ID in NUMBER,
183: X_XREF_EXT_VALUE in VARCHAR2,
184: X_XREF_INT_VALUE in VARCHAR2,

Line 181: X_XREF_STANDARD_CODE in VARCHAR2,

177: X_ROWID in out NOCOPY VARCHAR2,
178: X_XREF_DTL_ID in NUMBER,
179: X_XREF_CATEGORY_ID in NUMBER,
180: X_STANDARD_ID in NUMBER,
181: X_XREF_STANDARD_CODE in VARCHAR2,
182: X_TP_HEADER_ID in NUMBER,
183: X_XREF_EXT_VALUE in VARCHAR2,
184: X_XREF_INT_VALUE in VARCHAR2,
185: X_DIRECTION in VARCHAR2,

Line 200: STANDARD_ID,

196: begin
197: insert into ECX_XREF_DTL_B (
198: XREF_DTL_ID,
199: XREF_CATEGORY_ID,
200: STANDARD_ID,
201: XREF_STANDARD_CODE,
202: TP_HEADER_ID,
203: XREF_EXT_VALUE,
204: XREF_INT_VALUE,

Line 201: XREF_STANDARD_CODE,

197: insert into ECX_XREF_DTL_B (
198: XREF_DTL_ID,
199: XREF_CATEGORY_ID,
200: STANDARD_ID,
201: XREF_STANDARD_CODE,
202: TP_HEADER_ID,
203: XREF_EXT_VALUE,
204: XREF_INT_VALUE,
205: DIRECTION,

Line 214: X_STANDARD_ID,

210: LAST_UPDATE_LOGIN
211: ) values (
212: X_XREF_DTL_ID,
213: X_XREF_CATEGORY_ID,
214: X_STANDARD_ID,
215: X_XREF_STANDARD_CODE,
216: X_TP_HEADER_ID,
217: X_XREF_EXT_VALUE,
218: X_XREF_INT_VALUE,

Line 215: X_XREF_STANDARD_CODE,

211: ) values (
212: X_XREF_DTL_ID,
213: X_XREF_CATEGORY_ID,
214: X_STANDARD_ID,
215: X_XREF_STANDARD_CODE,
216: X_TP_HEADER_ID,
217: X_XREF_EXT_VALUE,
218: X_XREF_INT_VALUE,
219: X_DIRECTION,

Line 268: X_STANDARD_ID in NUMBER,

264:
265: procedure LOCK_ROW (
266: X_XREF_DTL_ID in NUMBER,
267: X_XREF_CATEGORY_ID in NUMBER,
268: X_STANDARD_ID in NUMBER,
269: X_XREF_STANDARD_CODE in VARCHAR2,
270: X_TP_HEADER_ID in NUMBER,
271: X_XREF_EXT_VALUE in VARCHAR2,
272: X_XREF_INT_VALUE in VARCHAR2,

Line 269: X_XREF_STANDARD_CODE in VARCHAR2,

265: procedure LOCK_ROW (
266: X_XREF_DTL_ID in NUMBER,
267: X_XREF_CATEGORY_ID in NUMBER,
268: X_STANDARD_ID in NUMBER,
269: X_XREF_STANDARD_CODE in VARCHAR2,
270: X_TP_HEADER_ID in NUMBER,
271: X_XREF_EXT_VALUE in VARCHAR2,
272: X_XREF_INT_VALUE in VARCHAR2,
273: X_DIRECTION in VARCHAR2,

Line 278: STANDARD_ID,

274: X_DESCRIPTION in VARCHAR2
275: ) is
276: cursor c is select
277: XREF_CATEGORY_ID,
278: STANDARD_ID,
279: XREF_STANDARD_CODE,
280: TP_HEADER_ID,
281: XREF_EXT_VALUE,
282: XREF_INT_VALUE,

Line 279: XREF_STANDARD_CODE,

275: ) is
276: cursor c is select
277: XREF_CATEGORY_ID,
278: STANDARD_ID,
279: XREF_STANDARD_CODE,
280: TP_HEADER_ID,
281: XREF_EXT_VALUE,
282: XREF_INT_VALUE,
283: DIRECTION

Line 306: AND (recinfo.STANDARD_ID = X_STANDARD_ID)

302: app_exception.raise_exception;
303: end if;
304: close c;
305: if ( (recinfo.XREF_CATEGORY_ID = X_XREF_CATEGORY_ID)
306: AND (recinfo.STANDARD_ID = X_STANDARD_ID)
307: AND ((recinfo.XREF_STANDARD_CODE = X_XREF_STANDARD_CODE)
308: OR ((recinfo.XREF_STANDARD_CODE is null) AND (X_XREF_STANDARD_CODE is null)))
309: AND (recinfo.TP_HEADER_ID = X_TP_HEADER_ID)
310: AND (recinfo.XREF_EXT_VALUE = X_XREF_EXT_VALUE)

Line 307: AND ((recinfo.XREF_STANDARD_CODE = X_XREF_STANDARD_CODE)

303: end if;
304: close c;
305: if ( (recinfo.XREF_CATEGORY_ID = X_XREF_CATEGORY_ID)
306: AND (recinfo.STANDARD_ID = X_STANDARD_ID)
307: AND ((recinfo.XREF_STANDARD_CODE = X_XREF_STANDARD_CODE)
308: OR ((recinfo.XREF_STANDARD_CODE is null) AND (X_XREF_STANDARD_CODE is null)))
309: AND (recinfo.TP_HEADER_ID = X_TP_HEADER_ID)
310: AND (recinfo.XREF_EXT_VALUE = X_XREF_EXT_VALUE)
311: AND (recinfo.XREF_INT_VALUE = X_XREF_INT_VALUE)

Line 308: OR ((recinfo.XREF_STANDARD_CODE is null) AND (X_XREF_STANDARD_CODE is null)))

304: close c;
305: if ( (recinfo.XREF_CATEGORY_ID = X_XREF_CATEGORY_ID)
306: AND (recinfo.STANDARD_ID = X_STANDARD_ID)
307: AND ((recinfo.XREF_STANDARD_CODE = X_XREF_STANDARD_CODE)
308: OR ((recinfo.XREF_STANDARD_CODE is null) AND (X_XREF_STANDARD_CODE is null)))
309: AND (recinfo.TP_HEADER_ID = X_TP_HEADER_ID)
310: AND (recinfo.XREF_EXT_VALUE = X_XREF_EXT_VALUE)
311: AND (recinfo.XREF_INT_VALUE = X_XREF_INT_VALUE)
312: AND (recinfo.DIRECTION = X_DIRECTION)

Line 338: X_STANDARD_ID in NUMBER,

334:
335: procedure UPDATE_ROW (
336: X_XREF_DTL_ID in NUMBER,
337: X_XREF_CATEGORY_ID in NUMBER,
338: X_STANDARD_ID in NUMBER,
339: X_XREF_STANDARD_CODE in VARCHAR2,
340: X_TP_HEADER_ID in NUMBER,
341: X_XREF_EXT_VALUE in VARCHAR2,
342: X_XREF_INT_VALUE in VARCHAR2,

Line 339: X_XREF_STANDARD_CODE in VARCHAR2,

335: procedure UPDATE_ROW (
336: X_XREF_DTL_ID in NUMBER,
337: X_XREF_CATEGORY_ID in NUMBER,
338: X_STANDARD_ID in NUMBER,
339: X_XREF_STANDARD_CODE in VARCHAR2,
340: X_TP_HEADER_ID in NUMBER,
341: X_XREF_EXT_VALUE in VARCHAR2,
342: X_XREF_INT_VALUE in VARCHAR2,
343: X_DIRECTION in VARCHAR2,

Line 352: STANDARD_ID = X_STANDARD_ID,

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,
355: XREF_EXT_VALUE = X_XREF_EXT_VALUE,
356: XREF_INT_VALUE = X_XREF_INT_VALUE,

Line 353: XREF_STANDARD_CODE = X_XREF_STANDARD_CODE,

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,
355: XREF_EXT_VALUE = X_XREF_EXT_VALUE,
356: XREF_INT_VALUE = X_XREF_INT_VALUE,
357: DIRECTION = X_DIRECTION,