[Home] [Help]
PACKAGE: APPS.PSB_POS_SET_LINE_VALUES_PVT
Source
1 PACKAGE PSB_Pos_Set_Line_Values_Pvt AS
2 /* $Header: PSBVSLVS.pls 120.2 2005/07/13 11:29:49 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_Value_Sequence_Id IN OUT NOCOPY NUMBER,
17 p_Line_Sequence_Id IN NUMBER,
18 p_Attribute_Value_Id IN NUMBER,
19 p_Attribute_Value IN VARCHAR2,
20 p_Last_Update_Date IN DATE,
21 p_Last_Updated_By IN NUMBER,
22 p_Last_Update_Login IN NUMBER,
23 p_Created_By IN NUMBER,
24 p_Creation_Date IN DATE
25 );
26
27
28 PROCEDURE Lock_Row
29 (
30 p_api_version IN NUMBER,
31 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
32 p_commit IN VARCHAR2 := FND_API.G_FALSE,
33 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
34 p_return_status OUT NOCOPY VARCHAR2,
35 p_msg_count OUT NOCOPY NUMBER,
36 p_msg_data OUT NOCOPY VARCHAR2,
37 --
38 p_Row_Id IN VARCHAR2,
39 p_Value_Sequence_Id IN NUMBER,
40 p_Line_Sequence_Id IN NUMBER,
41 p_Attribute_Value_Id IN NUMBER,
42 p_Attribute_Value IN VARCHAR2,
43 --
44 p_row_locked OUT NOCOPY VARCHAR2
45 );
46
47
48 PROCEDURE Update_Row
49 (
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
52 p_commit IN VARCHAR2 := FND_API.G_FALSE,
53 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54 p_return_status OUT NOCOPY VARCHAR2,
55 p_msg_count OUT NOCOPY NUMBER,
56 p_msg_data OUT NOCOPY VARCHAR2,
57 --
58 p_Row_Id IN VARCHAR2,
59 p_Value_Sequence_Id IN NUMBER,
60 p_Line_Sequence_Id IN NUMBER,
61 p_Attribute_Value_Id IN NUMBER,
62 p_Attribute_Value IN VARCHAR2,
63 p_Last_Update_Date IN DATE,
64 p_Last_Updated_By IN NUMBER,
65 p_Last_Update_Login IN NUMBER
66 ) ;
67
68
69 PROCEDURE Delete_Row
70 (
71 p_api_version IN NUMBER,
72 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
73 p_commit IN VARCHAR2 := FND_API.G_FALSE,
74 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
75 p_return_status OUT NOCOPY VARCHAR2,
76 p_msg_count OUT NOCOPY NUMBER,
77 p_msg_data OUT NOCOPY VARCHAR2,
78 --
79 p_Row_Id IN VARCHAR2
80 );
81
82
83 PROCEDURE Check_Unique
84 (
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
87 p_commit IN VARCHAR2 := FND_API.G_FALSE,
88 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
89 p_return_status OUT NOCOPY VARCHAR2,
90 p_msg_count OUT NOCOPY NUMBER,
91 p_msg_data OUT NOCOPY VARCHAR2,
92 --
93 p_Row_Id IN VARCHAR2,
94 p_Line_Sequence_id IN NUMBER,
95 p_Attribute_Value_Id IN NUMBER,
96 p_Attribute_Value IN VARCHAR2,
97 p_Return_Value IN OUT NOCOPY VARCHAR2
98 );
99
100 PROCEDURE Check_References
101 (
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104 p_commit IN VARCHAR2 := FND_API.G_FALSE,
105 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106 p_return_status OUT NOCOPY VARCHAR2,
107 p_msg_count OUT NOCOPY NUMBER,
108 p_msg_data OUT NOCOPY VARCHAR2,
109 --
110 p_Account_Position_Set_Id IN NUMBER,
111 p_Return_Value IN OUT NOCOPY VARCHAR2
112 );
113
114
115 END PSB_Pos_Set_Line_Values_Pvt;