20: p_lookup_type IN VARCHAR2);
21:
22:
23: l_api_version number := 1.0;
24: l_init_msg_list_true varchar2(20) := FND_API.g_TRUE;
25: l_init_msg_list_false varchar2(20) := FND_API.g_FALSE;
26: l_init_commit_true varchar2(20) := FND_API.g_FALSE;
27: l_init_commit_false varchar2(20) := FND_API.g_FALSE;
28:
21:
22:
23: l_api_version number := 1.0;
24: l_init_msg_list_true varchar2(20) := FND_API.g_TRUE;
25: l_init_msg_list_false varchar2(20) := FND_API.g_FALSE;
26: l_init_commit_true varchar2(20) := FND_API.g_FALSE;
27: l_init_commit_false varchar2(20) := FND_API.g_FALSE;
28:
29: x_msg_count number;
22:
23: l_api_version number := 1.0;
24: l_init_msg_list_true varchar2(20) := FND_API.g_TRUE;
25: l_init_msg_list_false varchar2(20) := FND_API.g_FALSE;
26: l_init_commit_true varchar2(20) := FND_API.g_FALSE;
27: l_init_commit_false varchar2(20) := FND_API.g_FALSE;
28:
29: x_msg_count number;
30: x_msg_data varchar2(1000);
23: l_api_version number := 1.0;
24: l_init_msg_list_true varchar2(20) := FND_API.g_TRUE;
25: l_init_msg_list_false varchar2(20) := FND_API.g_FALSE;
26: l_init_commit_true varchar2(20) := FND_API.g_FALSE;
27: l_init_commit_false varchar2(20) := FND_API.g_FALSE;
28:
29: x_msg_count number;
30: x_msg_data varchar2(1000);
31: x_return_status varchar2(1000);