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,
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),
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: );
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 */
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,
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),
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: );
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 */
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,
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,
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: );
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 */
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,
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 :=
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,
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: );
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*/
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,
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,
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 );
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(
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 ,
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,
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,
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:
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:
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(