APPS.ECX_XREF_API dependencies on ECX_XREF_STANDARDS_S

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 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 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 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,