DBA Data[Home] [Help]

APPS.XTR_AUDIT dependencies on XTR_AUDIT_COLUMNS

Line 68: v_table_column xtr_audit_columns_v.table_column%TYPE;

64:
65: native constant integer := 1;
66: V_MAX_COL constant integer := 60;
67: v_counter binary_integer;
68: v_table_column xtr_audit_columns_v.table_column%TYPE;
69: v_select varchar2(4000);
70: v_num_col integer;
71: v_sql varchar2(4000);
72: v_rec_num binary_integer := 1;

Line 124: from XTR_AUDIT_COLUMNS

120: upper(nvl(p_key_yn,'N')),
121: upper(column_type)
122: --* Bug#3121210, rravunny
123: --*decode(event,'INTERGROUP TRANSFERS',decode(nvl(P_KEY_YN, 'N'),'Y',decode(table_column,'DEAL_NUMBER',1,'TRANSACTION_NUMBER',1,0),0),0)
124: from XTR_AUDIT_COLUMNS
125: where event = pc_event
126: and ( nvl(audit_yn, 'N') = 'Y' or
127: nvl(P_KEY_YN, 'N') = 'Y' )
128: --* Bug#3121210, rravunny