[Home] [Help]
PACKAGE: APPS.PSB_WS_DISTRIBUTIONS_PVT
Source
1 PACKAGE PSB_WS_Distributions_PVT AS
2 /* $Header: PSBVWDTS.pls 120.2 2005/07/13 11:31:08 shtripat ship $ */
3
4
5 PROCEDURE Insert_Row
6 (
7 p_api_version IN NUMBER,
8 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
9 p_commit IN VARCHAR2 := FND_API.G_FALSE,
10 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
11 p_return_status OUT NOCOPY VARCHAR2,
12 p_msg_count OUT NOCOPY NUMBER,
13 p_msg_data OUT NOCOPY VARCHAR2,
14 --
15 p_Row_Id IN OUT NOCOPY VARCHAR2,
16 p_Distribution_Id IN OUT NOCOPY NUMBER,
17 p_Distribution_Rule_Id IN NUMBER,
18 p_Worksheet_Id IN NUMBER,
19 p_Distribution_Date IN DATE,
20 p_Distributed_Flag IN VARCHAR2,
21 p_Last_Update_Date IN DATE,
22 p_Last_Updated_By IN NUMBER,
23 p_Last_Update_Login IN NUMBER,
24 p_Created_By IN NUMBER,
25 p_Creation_Date IN DATE
26 );
27
28
29 PROCEDURE Lock_Row
30 (
31 p_api_version IN NUMBER,
32 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
33 p_commit IN VARCHAR2 := FND_API.G_FALSE,
34 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35 p_return_status OUT NOCOPY VARCHAR2,
36 p_msg_count OUT NOCOPY NUMBER,
37 p_msg_data OUT NOCOPY VARCHAR2,
38 --
39 p_Row_Id IN VARCHAR2,
40 p_Distribution_Id IN NUMBER,
41 p_Distribution_Rule_Id IN NUMBER,
42 p_Worksheet_Id IN NUMBER,
43 p_Distribution_Date IN DATE,
44 p_Distributed_Flag IN VARCHAR2,
45 --
46 p_row_locked OUT NOCOPY VARCHAR2
47 );
48
49
50 PROCEDURE Update_Row
51 (
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
54 p_commit IN VARCHAR2 := FND_API.G_FALSE,
55 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56 p_return_status OUT NOCOPY VARCHAR2,
57 p_msg_count OUT NOCOPY NUMBER,
58 p_msg_data OUT NOCOPY VARCHAR2,
59 --
60 p_Row_Id IN VARCHAR2,
61 p_Distribution_Id IN NUMBER,
62 p_Distribution_Rule_Id IN NUMBER,
63 p_Worksheet_Id IN NUMBER,
64 p_Distribution_Date IN DATE,
65 p_Distributed_Flag IN VARCHAR2,
66 p_Last_Update_Date IN DATE,
67 p_Last_Updated_By IN NUMBER,
68 p_Last_Update_Login IN NUMBER
69 );
70
71
72 PROCEDURE Delete_Row
73 (
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 p_return_status OUT NOCOPY VARCHAR2,
79 p_msg_count OUT NOCOPY NUMBER,
80 p_msg_data OUT NOCOPY VARCHAR2,
81 --
82 p_Row_Id IN VARCHAR2
83 );
84
85 END PSB_WS_Distributions_PVT ;