[Home] [Help]
PACKAGE: APPS.JTF_REQUEST_HISTORY_PVT
Source
1 PACKAGE JTF_Request_History_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfgrqhs.pls 115.3 2003/09/05 19:41:14 sxkrishn ship $ */
3
4 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
5 --===================================================================
6 -- Start of Comments
7 -- -------------------------------------------------------
8 -- Record name
9 -- request_history_rec_type
10 -- -------------------------------------------------------
11 -- Parameters:
12 -- outcome_code
13 -- source_code_id
14 -- source_code
15 -- object_type
16 -- object_id
17 -- order_id
18 -- resubmit_count
19 -- outcome_desc
20 -- request
21 -- submit_dt_tm
22 -- server_id
23 -- template_id
24 -- app_info
25 -- group_id
26 -- hist_req_id
27 -- user_id
28 -- priority
29 -- processed_dt_tm
30 -- message_id
31 -- last_update_date
32 -- last_updated_by
33 -- creation_date
34 -- created_by
35 -- last_update_login
36 -- org_id
37 -- f_deletedflag
38 -- object_version_number
39 -- security_group_id
40 --
41 -- Required
42 --
43 -- Defaults
44 --
45 -- Note: This is automatic generated record definition, it includes all columns
46 -- defined in the table, developer must manually add or delete some of the attributes.
47 --
48 -- End of Comments
49
50 --===================================================================
51 TYPE request_history_rec_type IS RECORD
52 (
53 outcome_code VARCHAR2(50) ,
54 source_code_id NUMBER,
55 source_code VARCHAR2(30),
56 object_type VARCHAR2(30),
57 object_id NUMBER ,
58 order_id NUMBER,
59 resubmit_count NUMBER ,
60 outcome_desc VARCHAR2(2000),
61 request CLOB,
62 submit_dt_tm DATE,
63 server_id NUMBER,
64 template_id NUMBER,
65 app_info VARCHAR2(30),
66 group_id NUMBER,
67 hist_req_id NUMBER,
68 user_id NUMBER,
69 priority NUMBER,
70 processed_dt_tm DATE,
71 message_id RAW(16),
72 last_update_date DATE,
73 last_updated_by NUMBER,
74 creation_date DATE,
75 created_by NUMBER,
76 last_update_login NUMBER,
77 org_id NUMBER,
78 f_deletedflag VARCHAR2(1),
79 object_version_number NUMBER,
80 security_group_id NUMBER
81 );
82
83 g_miss_request_history_rec request_history_rec_type;
84 TYPE request_history_tbl_type IS TABLE OF request_history_rec_type INDEX BY BINARY_INTEGER;
85 g_miss_request_history_tbl request_history_tbl_type;
86
87 -- ==============================================================================
88 -- Start of Comments
89 -- ==============================================================================
90 -- API Name
91 -- Create_Request_History
92 -- Type
93 -- Private
94 -- Pre-Req
95 --
96 -- Parameters
97 --
98 -- IN
99 -- p_api_version_number IN NUMBER Required
100 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
101 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
102 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
103 -- p_request_history_rec IN request_history_rec_type Required
104 --
105 -- OUT
106 -- x_return_status OUT VARCHAR2
107 -- x_msg_count OUT NUMBER
108 -- x_msg_data OUT VARCHAR2
109 -- Version : Current version 1.0
110 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
111 -- and basic operation, developer must manually add parameters and business logic as necessary.
112 --
113 -- End of Comments
114 -- ==============================================================================
115 --
116
117 PROCEDURE Create_Request_History(
118 p_api_version_number IN NUMBER,
119 p_init_msg_list IN VARCHAR2 ,
120 p_commit IN VARCHAR2,
121 p_validation_level IN NUMBER ,
122
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126
127 p_request_history_rec IN request_history_rec_type,
128 x_request_history_id OUT NOCOPY NUMBER
129 );
130
131
132 END JTF_Request_History_PVT;
133