APPS.JTF_USR_HKS dependencies on JTF_USR_HKS

Line 1: package body JTF_USR_HKS as

1: package body JTF_USR_HKS as
2: /* $Header: JTFUHKSB.pls 120.4 2005/10/21 12:24:43 kjayapra ship $ */
3:
4: -------------------------------------------------------------------------
5: G_PKJ_NAME CONSTANT VARCHAR2(25) := 'JTF_USR_HKS';

Line 5: G_PKJ_NAME CONSTANT VARCHAR2(25) := 'JTF_USR_HKS';

1: package body JTF_USR_HKS as
2: /* $Header: JTFUHKSB.pls 120.4 2005/10/21 12:24:43 kjayapra ship $ */
3:
4: -------------------------------------------------------------------------
5: G_PKJ_NAME CONSTANT VARCHAR2(25) := 'JTF_USR_HKS';
6:
7: /* function to check for execution of pre/post logic */
8:
9: Function Ok_To_Execute( p_Pkg_name varchar2,

Line 146: JTF_USR_HKS.Purge_Bind_Data( p_bind_data_id => l_bind_data_id,

142: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
143: FND_MSG_PUB.Add;
144:
145: /* Purge Bind data table */
146: JTF_USR_HKS.Purge_Bind_Data( p_bind_data_id => l_bind_data_id,
147: p_bind_type => 'W'
148: );
149:
150: x_return_code := FND_API.G_RET_STS_SUCCESS;

Line 183: p_OAI_array JTF_USR_HKS.OAI_data_array_type,

179: p_action_code varchar2,
180: p_correlation varchar2,
181: p_bind_data_id Number,
182: p_OAI_param varchar2,
183: p_OAI_array JTF_USR_HKS.OAI_data_array_type,
184: x_return_code Out NOCOPY varchar2
185: ) is
186:
187: l_bind_data_id Number := p_bind_data_id;

Line 290: JTF_USR_HKS.Purge_Bind_Data( p_bind_data_id => l_bind_data_id,

286: FND_MESSAGE.SET_TOKEN('WF_KEY',p_wf_item_key);
287: FND_MSG_PUB.Add;
288:
289: -- Purge Bind data table
290: JTF_USR_HKS.Purge_Bind_Data( p_bind_data_id => l_bind_data_id,
291: p_bind_type => 'W'
292: );
293:
294: x_return_code := FND_API.G_RET_STS_SUCCESS;

Line 343: p_OAI_array JTF_USR_HKS.OAI_data_array_type,

339: p_action_code varchar2,
340: p_correlation varchar2,
341: p_bind_data_id number,
342: p_OAI_param varchar2,
343: p_OAI_array JTF_USR_HKS.OAI_data_array_type,
344: x_return_code Out NOCOPY varchar2
345: ) is
346: l_msg_SQL CLOB;
347: l_msg_mode number;

Line 429: p_OAI_array JTF_USR_HKS.OAI_data_array_type,

425: p_bind_data_id number,
426: p_ref_sender varchar2,
427: p_ref_msg_id number,
428: p_OAI_param varchar2,
429: p_OAI_array JTF_USR_HKS.OAI_data_array_type,
430: x_return_code Out NOCOPY varchar2
431: ) is
432: l_msg_SQL CLOB;
433: l_msg_mode number;

Line 496: p_OAI_array JTF_USR_HKS.OAI_data_array_type,

492: p_correlation varchar2,
493: p_bind_data_id number,
494: p_timeout number,
495: p_OAI_param varchar2,
496: p_OAI_array JTF_USR_HKS.OAI_data_array_type,
497: x_msg_id Out NOCOPY number,
498: x_reply_msg Out NOCOPY CLOB,
499: x_return_code Out NOCOPY varchar2
500: ) is

Line 701: l_db_id := JTF_USR_HKS.Get_Bus_Obj_Id;

697: Function Get_Bind_Data_Id Return Number is
698:
699: l_db_id Number;
700: Begin
701: l_db_id := JTF_USR_HKS.Get_Bus_Obj_Id;
702:
703: return(l_db_id);
704:
705: End Get_Bind_Data_Id;

Line 1005: JTF_USR_HKS.Purge_Bind_Data( p_bind_data_id => p_bind_data_id,

1001: end if;
1002: -- dbms_output.put_line(' after queue message');
1003:
1004: /* Purge Bind data table */
1005: JTF_USR_HKS.Purge_Bind_Data( p_bind_data_id => p_bind_data_id,
1006: p_bind_type => 'S'
1007: );
1008:
1009: End Publish_Message;

Line 1065: JTF_USR_HKS.Handle_msg_Excep(

1061: payload => l_stage_obj ,
1062: msgid => l_msg_id );
1063: Exception
1064: When OTHERS then
1065: JTF_USR_HKS.Handle_msg_Excep(
1066: p_prod_code => p_prod_code,
1067: p_bus_obj_code => p_bus_obj_code ,
1068: p_action_code => p_action_code ,
1069: p_correlation => p_correlation ,

Line 1120: END jtf_usr_hks;

1116:
1117: End Handle_msg_Excep;
1118:
1119:
1120: END jtf_usr_hks;