[Home] [Help]
PACKAGE: APPS.JTF_LOC_TYPES_PVT
Source
1 PACKAGE JTF_Loc_Types_PVT AUTHID CURRENT_USER AS
2 /* $Header: jtfvlots.pls 120.2 2005/08/18 22:55:48 stopiwal ship $ */
3
4 TYPE loc_type_rec_type IS RECORD
5 (
6 LOCATION_TYPE_ID NUMBER,
7 LAST_UPDATE_DATE DATE,
8 LAST_UPDATED_BY NUMBER,
9 CREATION_DATE DATE,
10 CREATED_BY NUMBER,
11 LAST_UPDATE_LOGIN NUMBER,
12 OBJECT_VERSION_NUMBER NUMBER,
13 LOCATION_TYPE_CODE VARCHAR2(30),
14 LOCATION_TYPE_NAME VARCHAR2(240),
15 DESCRIPTION VARCHAR2(4000)
16 );
17
18
19 /****************************************************************************/
20 -- Procedure
21 -- update_loc_type
22 -- Purpose
23 -- update a row in JTF_LOC_TYPES_B and JTF_LOC_TYPES_TL
24 -- Parameters
25 -- IN:
26 -- p_api_version IN NUMBER
27 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
28 -- p_commit IN VARCHAR2 := FND_API.g_false
29 -- p_validation_level IN NUMBER := FND_API.g_valid_level_full
30 --
31 -- p_loc_type_rec IN loc_type_rec_type
32 --
33 -- OUT:
34 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
35 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
36 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
37 ------------------------------------------------------------------------------
38 PROCEDURE update_loc_type
39 (
40 p_api_version IN NUMBER,
41 P_init_msg_list IN VARCHAR2 := FND_API.g_false,
42 p_commit IN VARCHAR2 := FND_API.g_false,
43 p_validation_level IN NUMBER := FND_API.g_valid_level_full,
44
45 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
46 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
47 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
48
49 p_loc_type_rec IN loc_type_rec_type
50 );
51
52 /****************************************************************************/
53 -- Procedure
54 -- lock_loc_type
55 -- Purpose
56 -- lock a row form JTF_Loc_Tyeps_B and JTF_Loc_Tyeps_TL
57 -- Parameters
58 -- IN:
59 -- p_api_version IN NUMBER
60 -- p_init_msg_list IN VARCHAR2 := FND_API.g_false
61 --
62 -- p_loc_type_id IN NUMBER
63 -- p_object_version IN NUMBER
64 --
65 -- OUT:
66 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67 -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
68 -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69 ------------------------------------------------------------------------------
70 PROCEDURE lock_loc_type
71 (
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 := FND_API.g_false,
74
75 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
76 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
77 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
78
79 p_loc_type_id IN NUMBER,
80 p_object_version IN NUMBER
81 );
82
83 /***************************************************************************/
84 -- Procedure
85 -- check_items
86 -- Purpose
87 -- item level checking
88 -- Parameters
89 -- IN:
90 -- p_validation_mode IN VARCHAR2
91 -- p_loc_type_rec IN loc_type_rec_type
92 --
93 -- OUT:
94 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95 ------------------------------------------------------------------------------
96 PROCEDURE check_items
97 (
98 p_validation_mode IN VARCHAR2,
99 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
100 p_loc_type_rec IN loc_type_rec_type
101 );
102
103 /****************************************************************************/
104 -- Procedure
105 -- check_loc_type_req_items
106 -- Purpose
107 -- check if required items are miss
108 -- Parameters
109 -- IN:
110 -- p_validation_mode IN VARCHAR2
111 -- p_loc_type_rec IN loc_type_rec_type
112 -- OUT:
113 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
114 ------------------------------------------------------------------------------
115 PROCEDURE check_loc_type_req_items
116 (
117 p_validation_mode IN VARCHAR2,
118 p_loc_type_rec IN loc_type_rec_type,
119 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
120 );
121
122 /****************************************************************************/
123 -- Procedure
124 -- check_loc_type_uk_items
125 -- Purpose
126 -- check unique keys
127 -- Parameters
128 -- IN:
129 -- p_validation_mode IN VARCHAR2
130 -- p_loc_type_rec IN loc_type_rec_type
131 -- OUT:
132 -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
133 ------------------------------------------------------------------------------
134 PROCEDURE check_loc_type_uk_items
135 (
136 p_validation_mode IN VARCHAR2,
137 p_loc_type_rec IN loc_type_rec_type,
138 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
139 );
140
141 END JTF_Loc_Types_PVT;