DBA Data[Home] [Help]

APPS.GML_OPM_ROI_GRP dependencies on PO_INTERFACE_ERRORS

Line 36: l_error_message po_interface_errors.error_message%TYPE ;

32:
33: PRAGMA AUTONOMOUS_TRANSACTION;
34:
35: l_interface_type VARCHAR2(25) := 'RCV-856';
36: l_error_message po_interface_errors.error_message%TYPE ;
37: l_group_id NUMBER;
38: l_header_interface_id NUMBER;
39: BEGIN
40:

Line 76: INSERT INTO po_interface_errors(Interface_Type,

72: WHERE interface_transaction_id = p_rti_id ;
73:
74: END IF;
75:
76: INSERT INTO po_interface_errors(Interface_Type,
77: Interface_Transaction_Id,
78: column_name,
79: table_name,
80: error_message,

Line 98: po_interface_errors_s.NEXTVAL,

94: Program_Update_date,
95: BATCH_ID)
96: VALUES
97: (l_interface_type,
98: po_interface_errors_s.NEXTVAL,
99: p_column_name,
100: p_table_name,
101: l_error_message,
102: p_Error_Message_name,