DBA Data[Home] [Help]

PACKAGE: APPS.JTF_LOG_TO_PHY_PVT

Source


1 PACKAGE JTF_LOG_TO_PHY_PVT AUTHID CURRENT_USER AS
2 /* $Header: JTFVDPOS.pls 120.2 2005/10/25 05:07:02 psanyal ship $ */
3 
4   G_API_VERSION CONSTANT NUMBER := 1.0;
5 
6   PROCEDURE get_obj_by_id(
7     p_api_version       IN   NUMBER,
8     p_init_msg_list     IN VARCHAR2 := FND_API.G_FALSE,
9     x_return_status     OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
10     x_msg_count         OUT NOCOPY /* file.sql.39 change */ NUMBER,
11     x_msg_data          OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
12     p_logicalid         IN jtf_dsp_obj_lgl_ctnt.item_id%TYPE,
13     p_siteid            IN jtf_dsp_lgl_phys_map.msite_id%TYPE,
14     p_langcode          IN jtf_dsp_lgl_phys_map.language_code%TYPE,
15     x_filename          OUT NOCOPY /* file.sql.39 change */ jtf_amv_attachments.file_name%TYPE,
16     x_description       OUT NOCOPY /* file.sql.39 change */ jtf_amv_items_vl.description%TYPE,
17     x_fileid            OUT NOCOPY /* file.sql.39 change */ jtf_amv_attachments.file_id%TYPE);
18 
19   PROCEDURE get_obj_by_name(
20     p_api_version       IN   NUMBER,
21     p_init_msg_list     IN VARCHAR2 := FND_API.G_FALSE,
22     x_return_status     OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
23     x_msg_count         OUT NOCOPY /* file.sql.39 change */ NUMBER,
24     x_msg_data          OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
25     p_access_name       IN jtf_amv_items_vl.access_name%TYPE,
26     p_siteid            IN jtf_dsp_lgl_phys_map.msite_id%TYPE,
27     p_langcode          IN jtf_dsp_lgl_phys_map.language_code%TYPE,
28     x_filename          OUT NOCOPY /* file.sql.39 change */ jtf_amv_attachments.file_name%TYPE,
29     x_description       OUT NOCOPY /* file.sql.39 change */ jtf_amv_items_vl.description%TYPE,
30     x_fileid            OUT NOCOPY /* file.sql.39 change */ jtf_amv_attachments.file_id%TYPE);
31 
32 END JTF_LOG_TO_PHY_PVT;