PACKAGE BODY: APPS.OXTA_UTIL_PKG

Source

1 package body OXTA_UTIL_PKG as
2 /* $Header: ECXOXUTB.pls 115.2 2001/12/11 10:12:47 pkm ship        $ */
3 
4 procedure oxta_insertlog
5 (
6     p_sender_message_id   in  varchar2,
7     p_direction           in  varchar2,
8     p_status              in  varchar2,
9     p_begin_date          in  date,
10     p_request_type        in  varchar2,
11     p_content_length      in  number,
12     p_transaction_type    in  varchar2,
13     p_username            in  varchar2,
14     p_ip_address          in  varchar2,
15     p_protocol_type       in  varchar2,
16     p_protocol_address    in  varchar2,
17     p_result_code         in  varchar2,
18     p_result_text         in  varchar2,
19     p_receipt_message_id  in  varchar2,
20     p_completed_date      in  date,
21     p_exception_text      in  varchar2
22 ) is
23 pragma AUTONOMOUS_TRANSACTION;
24 begin
25 INSERT INTO ECX_OXTA_LOGMSG
26   (SENDER_MESSAGE_ID,
27     DIRECTION,
28     STATUS,
29     BEGIN_DATE,
30     REQUEST_TYPE,
31     CONTENT_LENGTH,
32     TRANSACTION_TYPE,
33     USERNAME,
34     IP_ADDRESS,
35     PROTOCOL_TYPE,
36     PROTOCOL_ADDRESS,
37     RESULT_CODE,
38     RESULT_TEXT,
39     RECEIPT_MESSAGE_ID,
40     COMPLETED_DATE,
41     EXCEPTION_TEXT)
42   VALUES
43   (p_sender_message_id,
44     p_direction,
45     p_status,
46     p_begin_date,
47     p_request_type,
48     p_content_length,
49     p_transaction_type,
50     p_username,
51     p_ip_address,
52     p_protocol_type,
53     p_protocol_address,
54     p_result_code,
55     p_result_text,
56     p_receipt_message_id,
57     p_completed_date,
58     p_exception_text);
59 commit;
60 end oxta_insertlog;
61 
62 end OXTA_UTIL_PKG;