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_STANDARDS

Line 89: select count(*) from ecx_xref_standards exs,

85: select 1 from ecx_object_attributes
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:

Line 695: l_standard_id ecx_xref_standards.standard_id%type;

691: p_direction IN VARCHAR2
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;

Line 916: ECX_XREF_STANDARDS_vl exs,

912: x_last_updated_by,
913: x_creation_date,
914: x_created_by
915: from ECX_XREF_HDR_vl exh,
916: ECX_XREF_STANDARDS_vl exs,
917: ECX_STANDARDS es
918: where exh.xref_category_code = p_xref_category_code
919: and exh.xref_category_id = exs.xref_category_id
920: and exs.xref_std_value = p_xref_std_value

Line 1057: select ecx_xref_standards_s.nextval

1053: 'p_owner', p_owner);
1054: return;
1055: end if;
1056:
1057: select ecx_xref_standards_s.nextval
1058: into x_xref_std_id from dual;
1059:
1060: ECX_XREF_STANDARDS_PKG.insert_row (
1061: X_ROWID => i_rowid,

Line 1060: ECX_XREF_STANDARDS_PKG.insert_row (

1056:
1057: select ecx_xref_standards_s.nextval
1058: into x_xref_std_id from dual;
1059:
1060: ECX_XREF_STANDARDS_PKG.insert_row (
1061: X_ROWID => i_rowid,
1062: X_XREF_STANDARD_ID => x_xref_std_id,
1063: X_XREF_CATEGORY_ID => x_xref_category_id,
1064: X_STANDARD_ID => i_standard_id,

Line 1105: l_standard_id ecx_xref_standards.standard_id%type;

1101: p_owner IN VARCHAR2
1102: ) is
1103: i_u_by pls_integer := 0;
1104: l_xref_cat_id ecx_xref_hdr.xref_category_id%type;
1105: l_standard_id ecx_xref_standards.standard_id%type;
1106: l_xref_std_value ecx_xref_standards.xref_std_value%type;
1107: l_xref_int_value ecx_xref_standards.xref_int_value%type;
1108:
1109: begin

Line 1106: l_xref_std_value ecx_xref_standards.xref_std_value%type;

1102: ) is
1103: i_u_by pls_integer := 0;
1104: l_xref_cat_id ecx_xref_hdr.xref_category_id%type;
1105: l_standard_id ecx_xref_standards.standard_id%type;
1106: l_xref_std_value ecx_xref_standards.xref_std_value%type;
1107: l_xref_int_value ecx_xref_standards.xref_int_value%type;
1108:
1109: begin
1110: x_return_status := ECX_UTIL_API.G_NO_ERROR;

Line 1107: l_xref_int_value ecx_xref_standards.xref_int_value%type;

1103: i_u_by pls_integer := 0;
1104: l_xref_cat_id ecx_xref_hdr.xref_category_id%type;
1105: l_standard_id ecx_xref_standards.standard_id%type;
1106: l_xref_std_value ecx_xref_standards.xref_std_value%type;
1107: l_xref_int_value ecx_xref_standards.xref_int_value%type;
1108:
1109: begin
1110: x_return_status := ECX_UTIL_API.G_NO_ERROR;
1111: x_msg := null;

Line 1133: update ECX_XREF_STANDARDS set

1129: else
1130: i_u_by := 0;
1131: end if;
1132:
1133: update ECX_XREF_STANDARDS set
1134: XREF_STD_VALUE = p_xref_std_value,
1135: XREF_INT_VALUE = p_xref_int_value,
1136: LAST_UPDATE_DATE = sysdate,
1137: LAST_UPDATED_BY = i_u_by,

Line 1144: 'p_table', 'ecx_xref_standards',

1140:
1141: if (sql%rowcount = 0) then
1142: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
1143: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
1144: 'p_table', 'ecx_xref_standards',
1145: 'p_param_name', 'Xref standard ID',
1146: 'p_param_id', p_xref_standard_id);
1147: return;
1148: end if;

Line 1151: update ECX_XREF_STANDARDS_TL set

1147: return;
1148: end if;
1149:
1150: -- update description for the current language
1151: update ECX_XREF_STANDARDS_TL set
1152: DESCRIPTION = p_description,
1153: SOURCE_LANG = userenv('LANG')
1154: where XREF_STANDARD_ID = p_xref_standard_id
1155: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line 1160: 'p_table', 'ecx_xref_standards',

1156:
1157: if (sql%rowcount = 0) then
1158: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
1159: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
1160: 'p_table', 'ecx_xref_standards',
1161: 'p_param_name', 'Xref standard ID',
1162: 'p_param_id', p_xref_standard_id);
1163: return;
1164: end if;

Line 1194: ECX_XREF_STANDARDS_PKG.delete_row (

1190: x_msg := ecx_debug.getTranslatedMessage('ECX_XREF_STANDARD_ID_NOT_NULL');
1191: return;
1192: end if;
1193:
1194: ECX_XREF_STANDARDS_PKG.delete_row (
1195: X_XREF_STANDARD_ID => p_xref_standard_id
1196: );
1197:
1198: exception

Line 1202: 'p_table', 'ecx_xref_standards',

1198: exception
1199: when no_data_found then
1200: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
1201: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
1202: 'p_table', 'ecx_xref_standards',
1203: 'p_param_name', 'Xref standard ID',
1204: 'p_param_id', p_xref_standard_id);
1205: when others then
1206: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;