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_API dependencies on ECX_XREF_DTL

Line 90: ecx_xref_dtl exd

86: where xref_category_id = p_xref_category_id;
87:
88: cursor get_refrences is
89: select count(*) from ecx_xref_standards exs,
90: ecx_xref_dtl exd
91: where exs.xref_category_id = p_xref_category_id
92: and exd.xref_category_id = p_xref_category_id;
93:
94: begin

Line 257: ECX_XREF_DTL exd,

253: exd.xref_ext_value
254: into x_xref_dtl_id,
255: x_xref_ext_value
256: from ECX_XREF_HDR exh,
257: ECX_XREF_DTL exd,
258: ECX_STANDARDS es
259: where exh.xref_category_code = p_xref_category_code
260: and exh.xref_category_id = exd.xref_category_id
261: and exd.direction = 'OUT'

Line 270: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_INT_TOO_MANY_ROWS',

266: and es.standard_type = nvl(p_standard_type, 'XML');
267: exception
268: when too_many_rows then
269: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
270: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_INT_TOO_MANY_ROWS',
271: 'p_standard_code', p_standard,
272: 'p_xref_category_code', p_xref_category_code,
273: 'p_tp_header_id', p_tp_header_id,
274: 'p_xref_int_value', p_xref_int_value);

Line 277: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_INT_ID_NOT_FOUND',

273: 'p_tp_header_id', p_tp_header_id,
274: 'p_xref_int_value', p_xref_int_value);
275: when no_data_found then
276: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
277: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_INT_ID_NOT_FOUND',
278: 'p_standard_code', p_standard,
279: 'p_xref_category_code', p_xref_category_code,
280: 'p_tp_header_id', p_tp_header_id,
281: 'p_xref_int_value', p_xref_int_value);

Line 329: ECX_XREF_DTL exd,

325: exd.xref_int_value
326: into x_xref_dtl_id,
327: x_xref_int_value
328: from ECX_XREF_HDR exh,
329: ECX_XREF_DTL exd,
330: ECX_STANDARDS es
331: where exh.xref_category_code = p_xref_category_code
332: and exh.xref_category_id = exd.xref_category_id
333: and exd.direction = 'IN'

Line 342: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_EXT_TOO_MANY_ROWS',

338: and es.standard_type = nvl(p_standard_type, 'XML');
339: exception
340: when too_many_rows then
341: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
342: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_EXT_TOO_MANY_ROWS',
343: 'p_standard_code', p_standard,
344: 'p_xref_category_code', p_xref_category_code,
345: 'p_tp_header_id', p_tp_header_id,
346: 'p_xref_ext_value', p_xref_ext_value);

Line 349: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_EXT_ID_NOT_FOUND',

345: 'p_tp_header_id', p_tp_header_id,
346: 'p_xref_ext_value', p_xref_ext_value);
347: when no_data_found then
348: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
349: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_EXT_ID_NOT_FOUND',
350: 'p_standard_code', p_standard,
351: 'p_xref_category_code', p_xref_category_code,
352: 'p_tp_header_id', p_tp_header_id,
353: 'p_xref_ext_value', p_xref_ext_value);

Line 387: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ID_NOT_NULL');

383:
384:
385: if (p_xref_dtl_id is null) then
386: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
387: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ID_NOT_NULL');
388: return;
389: end if;
390:
391: select

Line 422: ECX_XREF_DTL_VL exd,

418: x_last_updated_by,
419: x_creation_date,
420: x_created_by
421: from ECX_XREF_HDR_VL exh,
422: ECX_XREF_DTL_VL exd,
423: ECX_STANDARDS es
424: where exh.xref_category_id = exd.xref_category_id
425: and exd.xref_dtl_id = p_xref_dtl_id
426: and es.standard_id = exd.standard_id;

Line 431: 'p_table', 'ECX_XREF_DTL',

427: exception
428: when too_many_rows then
429: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
430: x_msg := ecx_debug.getTranslatedMessage('ECX_TOO_MANY_ROWS',
431: 'p_table', 'ECX_XREF_DTL',
432: 'p_key', p_xref_dtl_id);
433:
434: when no_data_found then
435: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

Line 437: 'p_table', 'ECX_XREF_DTL',

433:
434: when no_data_found then
435: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
436: x_msg := ecx_debug.getTranslatedMessage('ECX_NOT_FOUND',
437: 'p_table', 'ECX_XREF_DTL',
438: 'p_key', p_xref_dtl_id);
439: when others then
440: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
441: x_msg := SQLERRM;

Line 525: ECX_XREF_DTL_VL exd,

521: x_last_updated_by,
522: x_creation_date,
523: x_created_by
524: from ECX_XREF_HDR_VL exh,
525: ECX_XREF_DTL_VL exd,
526: ECX_STANDARDS es
527: where exh.xref_category_code = p_xref_category_code
528: and exh.xref_category_id = exd.xref_category_id
529: and exd.direction = p_direction

Line 538: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_NOT_FOUND',

534: and es.standard_type = nvl(p_standard_type, 'XML');
535: exception
536: when no_data_found then
537: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
538: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_NOT_FOUND',
539: 'p_standard_code', p_standard,
540: 'p_xref_category_code', p_xref_category_code,
541: 'p_direction' , p_direction,
542: 'p_xref_ext_value', p_xref_ext_value,

Line 638: select ecx_xref_dtl_s.nextval into x_xref_dtl_id from dual;

634: from ecx_standards
635: where standard_code = p_standard
636: and standard_type = nvl(p_standard_type, 'XML');
637:
638: select ecx_xref_dtl_s.nextval into x_xref_dtl_id from dual;
639:
640: ECX_XREF_DTL_PKG. insert_row (
641: X_ROWID => i_rowid,
642: X_XREF_DTL_ID => x_xref_dtl_id,

Line 640: ECX_XREF_DTL_PKG. insert_row (

636: and standard_type = nvl(p_standard_type, 'XML');
637:
638: select ecx_xref_dtl_s.nextval into x_xref_dtl_id from dual;
639:
640: ECX_XREF_DTL_PKG. insert_row (
641: X_ROWID => i_rowid,
642: X_XREF_DTL_ID => x_xref_dtl_id,
643: X_XREF_CATEGORY_ID => x_xref_category_id,
644: X_STANDARD_ID => i_standard_id,

Line 669: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ROW_EXISTS',

665: when dup_val_on_index then
666: x_xref_dtl_id := -1;
667: x_xref_category_id := -1;
668: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
669: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ROW_EXISTS',
670: 'p_xref_category_code', p_xref_category_code,
671: 'p_standard_code', p_standard,
672: 'p_xref_ext_value',p_xref_ext_value,
673: 'p_xref_int_value', p_xref_int_value,

Line 696: l_tp_header_id ecx_xref_dtl.tp_header_id%type;

692: ) is
693:
694: l_xref_cat_id ecx_xref_hdr.xref_category_id%type;
695: l_standard_id ecx_xref_standards.standard_id%type;
696: l_tp_header_id ecx_xref_dtl.tp_header_id%type;
697: l_xref_int_value ecx_xref_dtl.xref_int_value%type;
698: l_xref_ext_value ecx_xref_dtl.xref_ext_value%type;
699: l_direction ecx_xref_dtl.direction%type;
700:

Line 697: l_xref_int_value ecx_xref_dtl.xref_int_value%type;

693:
694: l_xref_cat_id ecx_xref_hdr.xref_category_id%type;
695: l_standard_id ecx_xref_standards.standard_id%type;
696: l_tp_header_id ecx_xref_dtl.tp_header_id%type;
697: l_xref_int_value ecx_xref_dtl.xref_int_value%type;
698: l_xref_ext_value ecx_xref_dtl.xref_ext_value%type;
699: l_direction ecx_xref_dtl.direction%type;
700:
701: cursor get_xref_dtl_data is

Line 698: l_xref_ext_value ecx_xref_dtl.xref_ext_value%type;

694: l_xref_cat_id ecx_xref_hdr.xref_category_id%type;
695: l_standard_id ecx_xref_standards.standard_id%type;
696: l_tp_header_id ecx_xref_dtl.tp_header_id%type;
697: l_xref_int_value ecx_xref_dtl.xref_int_value%type;
698: l_xref_ext_value ecx_xref_dtl.xref_ext_value%type;
699: l_direction ecx_xref_dtl.direction%type;
700:
701: cursor get_xref_dtl_data is
702: select xref_category_id,

Line 699: l_direction ecx_xref_dtl.direction%type;

695: l_standard_id ecx_xref_standards.standard_id%type;
696: l_tp_header_id ecx_xref_dtl.tp_header_id%type;
697: l_xref_int_value ecx_xref_dtl.xref_int_value%type;
698: l_xref_ext_value ecx_xref_dtl.xref_ext_value%type;
699: l_direction ecx_xref_dtl.direction%type;
700:
701: cursor get_xref_dtl_data is
702: select xref_category_id,
703: standard_id,

Line 708: from ecx_xref_dtl

704: tp_header_id,
705: xref_int_value,
706: xref_ext_value,
707: direction
708: from ecx_xref_dtl
709: where xref_dtl_id = p_xref_dtl_id;
710:
711: begin
712: x_return_status := ECX_UTIL_API.G_NO_ERROR;

Line 717: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ID_NOT_NULL');

713: x_msg := null;
714:
715: if (p_xref_dtl_id is null) then
716: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
717: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ID_NOT_NULL');
718: return;
719: elsif (p_xref_ext_value is null) then
720: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
721: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_EXT_VAL_NOT_NULL');

Line 762: update ECX_XREF_DTL set

758: l_xref_ext_value,
759: l_direction;
760: close get_xref_dtl_data;
761:
762: update ECX_XREF_DTL set
763: XREF_EXT_VALUE = p_xref_ext_value,
764: XREF_INT_VALUE = p_xref_int_value,
765: TP_HEADER_ID = p_tp_header_id,
766: DIRECTION = p_direction,

Line 774: 'p_table', 'ecx_xref_dtl',

770:
771: if (sql%rowcount = 0) then
772: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
773: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
774: 'p_table', 'ecx_xref_dtl',
775: 'p_param_name', 'Xref detail ID',
776: 'p_param_id', p_xref_dtl_id);
777: return;
778: end if;

Line 781: update ECX_XREF_DTL_TL set

777: return;
778: end if;
779:
780: -- update description for only the current language
781: update ECX_XREF_DTL_TL set
782: DESCRIPTION = p_description,
783: SOURCE_LANG = userenv('LANG')
784: where XREF_DTL_ID = p_xref_dtl_id
785: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 790: 'p_table', 'ecx_xref_dtl',

786:
787: if (sql%rowcount = 0) then
788: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
789: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
790: 'p_table', 'ecx_xref_dtl',
791: 'p_param_name', 'Xref detail ID',
792: 'p_param_id', p_xref_dtl_id);
793: return;
794: end if;

Line 803: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ID_ROW_EXISTS',

799: CLOSE get_xref_dtl_data;
800: end if;
801:
802: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
803: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ID_ROW_EXISTS',
804: 'p_tp_header_id', p_tp_header_id,
805: 'p_xref_ext_value', p_xref_ext_value,
806: 'p_xref_int_value', p_xref_int_value,
807: 'p_direction', p_direction);

Line 831: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ID_NOT_NULL');

827: x_msg := null;
828:
829: if (p_xref_dtl_id is null) then
830: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
831: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ID_NOT_NULL');
832: return;
833: end if;
834:
835: ECX_XREF_DTL_PKG.delete_row (

Line 835: ECX_XREF_DTL_PKG.delete_row (

831: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_DTL_ID_NOT_NULL');
832: return;
833: end if;
834:
835: ECX_XREF_DTL_PKG.delete_row (
836: X_XREF_DTL_ID => p_xref_dtl_id
837: );
838: exception
839: when no_data_found then

Line 842: 'p_table', 'ecx_xref_dtl',

838: exception
839: when no_data_found then
840: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
841: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
842: 'p_table', 'ecx_xref_dtl',
843: 'p_param_name', 'Xref detail ID',
844: 'p_param_id', p_xref_dtl_id);
845: when others then
846: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;