APPS.ECX_XREF_API dependencies on ECX_XREF_HDR

Line 17: is select ecx_xref_hdr_s.nextval

13: p_owner IN VARCHAR2
14: ) is
15:
16: cursor c_xref_hdr_id
17: is select ecx_xref_hdr_s.nextval
18: from dual;
19:
20: i_c_by pls_integer := 0;
21: i_rowid varchar2(240) := null;

Line 45: ECX_XREF_HDR_PKG.insert_row (

41: open c_xref_hdr_id;
42: fetch c_xref_hdr_id into x_xref_hdr_id;
43: close c_xref_hdr_id;
44:
45: ECX_XREF_HDR_PKG.insert_row (
46: X_ROWID => i_rowid,
47: X_XREF_CATEGORY_CODE => p_xref_category_code,
48: X_XREF_CATEGORY_ID => x_xref_hdr_id,
49: X_DESCRIPTION => p_description,

Line 130: ECX_XREF_HDR_PKG.delete_row (

126: 'p_category_id', p_xref_category_id);
127: return;
128: end if;
129:
130: ECX_XREF_HDR_PKG.delete_row (
131: X_XREF_CATEGORY_ID => p_xref_category_id
132: );
133:
134: exception

Line 138: 'p_table', 'ecx_xref_hdr',

134: exception
135: when no_data_found then
136: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
137: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
138: 'p_table', 'ecx_xref_hdr',
139: 'p_param_name', 'Category Code ID',
140: 'p_param_id', p_xref_category_id);
141: when others then
142: if get_refrences%ISOPEN then

Line 186: ECX_XREF_HDR_PKG.update_row (

182: else
183: i_u_by := 0;
184: end if;
185:
186: ECX_XREF_HDR_PKG.update_row (
187: X_XREF_CATEGORY_ID => p_xref_category_id,
188: X_XREF_CATEGORY_CODE => p_xref_category_code,
189: X_DESCRIPTION => p_description,
190: X_LAST_UPDATE_DATE => sysdate,

Line 199: 'p_table', 'ecx_xref_hdr_tl',

195: exception
196: when no_data_found then
197: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
198: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
199: 'p_table', 'ecx_xref_hdr_tl',
200: 'p_param_name', 'Cateogry Code ID',
201: 'p_param_id', p_xref_category_id);
202:
203: when dup_val_on_index then

Line 256: from ECX_XREF_HDR exh,

252: select xref_dtl_id,
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

Line 328: from ECX_XREF_HDR exh,

324: select xref_dtl_id,
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

Line 421: from ECX_XREF_HDR_VL exh,

417: x_last_update_date,
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

Line 524: from ECX_XREF_HDR_VL exh,

520: x_last_update_date,
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

Line 622: from ecx_xref_hdr

618:
619: begin
620: select xref_category_id
621: into x_xref_category_id
622: from ecx_xref_hdr
623: where xref_category_code = p_xref_category_code;
624: exception
625: when no_data_found then
626: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

Line 694: l_xref_cat_id ecx_xref_hdr.xref_category_id%type;

690: p_description IN VARCHAR2,
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;

Line 915: from ECX_XREF_HDR_vl exh,

911: x_last_update_date,
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

Line 998: from ecx_xref_hdr

994:
995: begin
996: select xref_category_id
997: into x_xref_category_id
998: from ecx_xref_hdr
999: where xref_category_code = p_xref_category_code;
1000:
1001: exception
1002: when no_data_found then

Line 1104: l_xref_cat_id ecx_xref_hdr.xref_category_id%type;

1100: p_description IN VARCHAR2,
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: