DBA Data[Home] [Help]

APPS.JG_GLOBE_FLEX_VAL_SHARED dependencies on AP_INTERFACE_REJECTIONS

Line 10: -- invalid data and insert them to AP_INTERFACE_REJECTIONS table.

6: --
7: ---------------------------------------------------------------------------
8: -- INSERT_REJECTIONS():
9: -- AP Invoice Gateway Import Process uses this procedure to reject
10: -- invalid data and insert them to AP_INTERFACE_REJECTIONS table.
11: -- The table stores both header and line level invoice information.
12: -- The column PARENT_TABLE indicates the table from which the invoice
13: -- fetched is being rejected - AP_INVOICES_INTERFACE or
14: -- AP_INVOICE_LINES_INTERFACE. If the source of PARENT_TABLE is

Line 34: l_debug_info := 'Insert rejection information to ap_interface_rejections';

30: l_debug_info VARCHAR2(100);
31: BEGIN
32: -------------------------- DEBUG INFORMATION ------------------------------
33: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
34: l_debug_info := 'Insert rejection information to ap_interface_rejections';
35: ---------------------------------------------------------------------------
36: --
37: -- Insert into AP_INTERFACE_REJECTIONS
38: --

Line 37: -- Insert into AP_INTERFACE_REJECTIONS

33: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
34: l_debug_info := 'Insert rejection information to ap_interface_rejections';
35: ---------------------------------------------------------------------------
36: --
37: -- Insert into AP_INTERFACE_REJECTIONS
38: --
39: INSERT INTO ap_interface_rejections(
40: parent_table,
41: parent_id,

Line 39: INSERT INTO ap_interface_rejections(

35: ---------------------------------------------------------------------------
36: --
37: -- Insert into AP_INTERFACE_REJECTIONS
38: --
39: INSERT INTO ap_interface_rejections(
40: parent_table,
41: parent_id,
42: reject_lookup_code,
43: last_updated_by,