[Home] [Help]
PACKAGE: APPS.QP_LIMITS_PVT
Source
1 PACKAGE QP_Limits_PVT AS
2 /* $Header: QPXVLMTS.pls 120.1 2005/06/14 23:29:57 appldev $ */
3
4 -- Start of Comments
5 -- API name Process_Limits
6 -- Type Private
7 -- Function
8 --
9 -- Pre-reqs
10 --
11 -- Parameters
12 --
13 -- Version Current version = 1.0
14 -- Initial version = 1.0
15 --
16 -- Notes
17 --
18 -- End of Comments
19
20 PROCEDURE Process_Limits
21 ( p_api_version_number IN NUMBER
22 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
23 , p_commit IN VARCHAR2 := FND_API.G_FALSE
24 , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
25 , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
26 QP_GLOBALS.G_MISS_CONTROL_REC
27 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
28 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
29 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
30 , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
31 QP_Limits_PUB.G_MISS_LIMITS_REC
32 , p_old_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
33 QP_Limits_PUB.G_MISS_LIMITS_REC
34 , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
35 QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
36 , p_old_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
37 QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
38 , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
39 QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
40 , p_old_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
41 QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
42 , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
43 , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
44 , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
45 );
46
47 -- Start of Comments
48 -- API name Lock_Limits
49 -- Type Private
50 -- Function
51 --
52 -- Pre-reqs
53 --
54 -- Parameters
55 --
56 -- Version Current version = 1.0
57 -- Initial version = 1.0
58 --
59 -- Notes
60 --
61 -- End of Comments
62
63 PROCEDURE Lock_Limits
64 ( p_api_version_number IN NUMBER
65 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
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 , p_LIMITS_rec IN QP_Limits_PUB.Limits_Rec_Type :=
70 QP_Limits_PUB.G_MISS_LIMITS_REC
71 , p_LIMIT_ATTRS_tbl IN QP_Limits_PUB.Limit_Attrs_Tbl_Type :=
72 QP_Limits_PUB.G_MISS_LIMIT_ATTRS_TBL
73 , p_LIMIT_BALANCES_tbl IN QP_Limits_PUB.Limit_Balances_Tbl_Type :=
74 QP_Limits_PUB.G_MISS_LIMIT_BALANCES_TBL
75 , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
76 , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
77 , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
78 );
79
80 -- Start of Comments
81 -- API name Get_Limits
82 -- Type Private
83 -- Function
84 --
85 -- Pre-reqs
86 --
87 -- Parameters
88 --
89 -- Version Current version = 1.0
90 -- Initial version = 1.0
91 --
92 -- Notes
93 --
94 -- End of Comments
95
96 PROCEDURE Get_Limits
97 ( p_api_version_number IN NUMBER
98 , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
99 , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
100 , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
101 , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
102 , p_limit_id IN NUMBER
103 , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limits_Rec_Type
104 , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Attrs_Tbl_Type
105 , x_LIMIT_BALANCES_tbl OUT NOCOPY /* file.sql.39 change */ QP_Limits_PUB.Limit_Balances_Tbl_Type
106 );
107
108 END QP_Limits_PVT;