DBA Data[Home] [Help]

APPS.XTR_MISC_P dependencies on XTR_AUDIT_COLUMNS

Line 42: v_table_column xtr_audit_columns_v.table_column%TYPE;

38: native constant integer := 1;
39: v7 constant integer := 2;
40: V_MAX_COL constant integer := 50; -- Maximum number of columns which can be audited.
41: v_counter binary_integer;
42: v_table_column xtr_audit_columns_v.table_column%TYPE;
43: v_select varchar2(1000);
44: v_num_col integer; -- The number of columns for this audit.
45: v_sql varchar2(2000);
46: v_rec_num binary_integer := 1;

Line 88: from XTR_AUDIT_COLUMNS

84: where event = pc_event;
85: --
86: cursor c_get_columns ( pc_event varchar2 )is
87: select table_column, column_title, upper(nvl(p_key_yn,'N')), upper(column_type)
88: from XTR_AUDIT_COLUMNS
89: where event = pc_event
90: and ( nvl(audit_yn, 'N') = 'Y' or
91: nvl(P_KEY_YN, 'N') = 'Y') ;
92: --