DBA Data[Home] [Help]

APPS.AP_DBI_PKG dependencies on AP_DBI_LOG

Line 56: INSERT INTO AP_DBI_LOG(Table_Name,

52: p_key_value_list(uniq_values);
53: END IF;
54:
55: l_debug_info := 'inserting record from list';
56: INSERT INTO AP_DBI_LOG(Table_Name,
57: Operation_Flag,
58: Key_Value1,
59: Key_Value2,
60: Exp_Processed_Flag,

Line 83: INSERT INTO AP_DBI_LOG(Table_Name,

79: );
80: ELSIF p_table_name = 'AP_INVOICES'
81: OR p_table_name = 'AP_HOLDS' THEN
82: l_debug_info := 'inserting record from list';
83: INSERT INTO AP_DBI_LOG(Table_Name,
84: Operation_Flag,
85: Key_Value1,
86: Key_Value2,
87: Exp_Processed_Flag,

Line 111: INSERT INTO AP_DBI_LOG(Table_Name,

107: ELSIF p_table_name = 'AP_PAYMENT_SCHEDULES' THEN
108:
109: IF p_key_value1 IS NULL THEN
110: /*Have a list of invoices whose payment_nums change*/
111: INSERT INTO AP_DBI_LOG(Table_Name,
112: Operation_Flag,
113: Key_Value1,
114: Key_Value2,
115: Exp_Processed_Flag,

Line 137: INSERT INTO AP_DBI_LOG(Table_Name,

133: mod(to_number(to_char(trunc(sysdate), 'J')), 32)
134: FROM AP_PAYMENT_SCHEDULES
135: WHERE invoice_id =p_key_value_list(uniq_values);
136: ELSE /*we have a list of payment_nums for one inv_id*/
137: INSERT INTO AP_DBI_LOG(Table_Name,
138: Operation_Flag,
139: Key_Value1,
140: Key_Value2,
141: Exp_Processed_Flag,

Line 173: INSERT INTO AP_DBI_LOG(Table_Name,

169: ELSIF p_table_name = 'AP_PAYMENT_SCHEDULES' and
170: p_key_value2 is null THEN
171:
172:
173: INSERT INTO AP_DBI_LOG(Table_Name,
174: Operation_Flag,
175: Key_Value1,
176: Key_Value2,
177: Exp_Processed_Flag,

Line 212: INSERT INTO AP_DBI_LOG(Table_Name,

208: END IF;
209: END IF;
210:
211: l_debug_info := 'inserting normal record';
212: INSERT INTO AP_DBI_LOG(Table_Name,
213: Operation_Flag,
214: Key_Value1,
215: Key_Value2,
216: Exp_Processed_Flag,