[Home] [Help]
PACKAGE: APPS.JTF_USR_HKS
Source
1 package JTF_USR_HKS as
2 /* $Header: JTFUHKSS.pls 120.2 2005/11/15 14:05:06 jdang ship $ */
3
4 ----------------------------------------------------------------------------
5
6 G_PKJ_NAME CONSTANT VARCHAR2(25) := 'JTF_USR_HKS';
7
8
9 /* Data type declaration */
10 Type OAI_data_array_type is Varray(10) of Varchar2(50);
11
12
13 Function Ok_To_Execute( p_Pkg_name varchar2,
14 p_API_name varchar2,
15 p_Process_type varchar2,
16 p_User_hook_type varchar2
17 ) Return Boolean;
18
19
20 Procedure WrkflowLaunch( p_Wf_item_name varchar2,
21 p_Wf_item_process_name varchar2,
22 p_Wf_item_key varchar2,
23 p_Bind_data_id number,
24 x_return_code Out nocopy varchar2
25 );
26
27 Procedure GenMsgWrkflowLaunch(
28 p_Wf_item_name varchar2 := 'JTFMSGWF',
29 p_Wf_item_process_name varchar2 := 'JTFMSGWF_PROCESS1',
30 p_Wf_item_key varchar2,
31 p_prod_code varchar2,
32 p_bus_obj_code varchar2,
33 p_bus_obj_name varchar2 := FND_API.G_MISS_CHAR,
34 p_action_code varchar2,
35 p_correlation varchar2 := FND_API.G_MISS_CHAR,
36 p_bind_data_id Number,
37 p_OAI_param varchar2 := FND_API.G_MISS_CHAR,
38 p_OAI_array JTF_USR_HKS.OAI_data_array_type
39 := JTF_USR_HKS.OAI_data_array_type(FND_API.G_MISS_CHAR),
40 x_return_code Out varchar2
41 );
42
43 /* For publishing messages */
44 Procedure Generate_message(
45 p_prod_code varchar2,
46 p_bus_obj_code varchar2,
47 p_bus_obj_name varchar2 := FND_API.G_MISS_CHAR,
48 p_action_code varchar2,
49 p_correlation varchar2 := FND_API.G_MISS_CHAR,
50 p_bind_data_id number,
51 p_OAI_param varchar2 := FND_API.G_MISS_CHAR,
52 p_OAI_array JTF_USR_HKS.OAI_data_array_type :=
53 JTF_USR_HKS.OAI_data_array_type(FND_API.G_MISS_CHAR),
54 x_return_code Out varchar2
55 );
56
57 /* For sending reply */
58 Procedure Generate_message(
59 p_prod_code varchar2,
60 p_bus_obj_code varchar2,
61 p_bus_obj_name varchar2 := FND_API.G_MISS_CHAR,
62 p_action_code varchar2,
63 p_correlation varchar2 := FND_API.G_MISS_CHAR,
64 p_bind_data_id number,
65 p_ref_sender varchar2,
66 p_ref_msg_id number,
67 p_OAI_param varchar2 := FND_API.G_MISS_CHAR,
68 p_OAI_array JTF_USR_HKS.OAI_data_array_type :=
69 JTF_USR_HKS.OAI_data_array_type(FND_API.G_MISS_CHAR),
70 x_return_code Out varchar2
71 );
72
73 /* For Sync/Async Request/reply */
74 Procedure Generate_message(
75 p_prod_code varchar2,
76 p_bus_obj_code varchar2,
77 p_bus_obj_name varchar2 := FND_API.G_MISS_CHAR,
78 p_action_code varchar2,
79 p_correlation varchar2 := FND_API.G_MISS_CHAR,
80 p_bind_data_id number,
81 p_timeout number,
82 p_OAI_param varchar2 := FND_API.G_MISS_CHAR,
83 p_OAI_array JTF_USR_HKS.OAI_data_array_type :=
84 JTF_USR_HKS.OAI_data_array_type(FND_API.G_MISS_CHAR),
85 x_msg_id Out nocopy number,
86 x_reply_msg Out nocopy CLOB,
87 x_return_code Out nocopy varchar2
88 );
89
90 /* For sending pre-generate XML messages */
91 Procedure Generate_message(
92 p_prod_code varchar2,
93 p_bus_obj_code varchar2,
94 p_bus_obj_name varchar2 := FND_API.G_MISS_CHAR,
95 p_correlation varchar2 := FND_API.G_MISS_CHAR,
96 p_timeout number := 0, /* 0-Async, >0 Sync ,< 0 sync-infinite wait */
97 p_message CLOB,
98 p_msg_type varchar2 := 'P', /* P - Publish , R - Sync/Async Req/Reply*/
99 x_msg_id Out nocopy number,
100 x_reply_msg Out nocopy CLOB,
101 x_return_code Out nocopy varchar2
102 );
103
104 Function Get_Bind_Data_Id Return Number;
105
106 Procedure Load_Bind_Data(
107 p_bind_data_id Number,
108 p_bind_name varchar2,
109 p_bind_value varchar2,
110 p_bind_type varchar2,
111 p_data_type varchar2
112 );
113
114 Procedure Purge_Bind_Data( p_Bind_Data_Id Number,
115 p_bind_type Varchar2 );
116
117 Function Get_User_Hook_Id Return Number;
118
119 Function Get_Bus_Obj_Id Return Number;
120
121 procedure Generate_Hdrxml(
122 p_prodcode IN varchar2,
123 p_bo_code IN varchar2,
124 p_noun IN varchar2 := fnd_api.g_miss_char,
125 p_verb IN varchar2 := fnd_api.g_miss_char,
126 p_type IN varchar2 := 'PUBLISH',
127 p_sender IN varchar2 := fnd_api.g_miss_char,
128 p_msg_id IN varchar2 := fnd_api.g_miss_char,
129 x_hdrxml OUT nocopy varchar2 );
130
131 Procedure Publish_Message(
132 p_prod_code Varchar2 ,
133 p_bus_obj_code Varchar2 ,
134 p_bus_obj_name Varchar2 := fnd_api.g_miss_char,
135 p_action_code Varchar2 ,
136 p_correlation Varchar2 := fnd_api.g_miss_char ,
137 p_bind_data_id Number ,
138 p_msg_type Varchar2 := fnd_api.g_miss_char,
139 p_ref_sender Varchar2 := fnd_api.g_miss_char,
140 p_ref_msg_id Number := fnd_api.g_miss_num,
141 p_timeout Number := 0 );
142
143
144 Procedure Stage_Message(
145 p_prod_code Varchar2 ,
146 p_bus_obj_code Varchar2 ,
147 p_action_code Varchar2 ,
148 p_correlation Varchar2 ,
149 p_bind_data_id Number );
150
151 Procedure Handle_msg_Excep(
152 p_prod_code Varchar2 ,
153 p_bus_obj_code Varchar2 ,
154 p_action_code Varchar2 ,
155 p_correlation Varchar2 ,
156 p_bind_data_id Number ,
157 p_msg_type Varchar2 ,
158 p_err_msg Varchar2 );
159
160 END jtf_usr_hks;