[Home] [Help]
PACKAGE: APPS.PSB_RULE_TRANSACTION_TYPE_PVT
Source
1 package PSB_RULE_TRANSACTION_TYPE_PVT as
2 /* $Header: PSBVTTPS.pls 120.2 2005/07/13 11:30:18 shtripat noship $ */
3
4 procedure INSERT_ROW (
5 p_api_version IN NUMBER,
6 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
7 p_commit IN VARCHAR2 := FND_API.G_FALSE,
8 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
9 p_return_status OUT NOCOPY VARCHAR2,
10 p_msg_count OUT NOCOPY NUMBER,
11 p_msg_data OUT NOCOPY VARCHAR2,
12 --
13 P_ROWID IN OUT NOCOPY VARCHAR2,
14 P_RULE_ID IN NUMBER,
15 P_TRANSACTION_TYPE IN VARCHAR2,
16 --Following 1 parameter added for Bug # 2123930.
17 P_ENABLE_FLAG IN VARCHAR2,
18 p_Last_Update_Date DATE,
19 p_Last_Updated_By NUMBER,
20 p_Last_Update_Login NUMBER,
21 p_Created_By NUMBER,
22 p_Creation_Date DATE
23 );
24
25 procedure LOCK_ROW (
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 p_return_status OUT NOCOPY VARCHAR2,
31 p_msg_count OUT NOCOPY NUMBER,
32 p_msg_data OUT NOCOPY VARCHAR2,
33 p_lock_row OUT NOCOPY VARCHAR2,
34 --
35 P_RULE_ID IN NUMBER,
36 P_TRANSACTION_TYPE IN VARCHAR2,
37 --Following 1 parameter added for Bug # 2123930.
38 P_ENABLE_FLAG IN VARCHAR2
39 );
40
41 procedure UPDATE_ROW (
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44 p_commit IN VARCHAR2 := FND_API.G_FALSE,
45 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46 p_return_status OUT NOCOPY VARCHAR2,
47 p_msg_count OUT NOCOPY NUMBER,
48 p_msg_data OUT NOCOPY VARCHAR2,
49 --
50 P_RULE_ID IN NUMBER,
51 P_TRANSACTION_TYPE IN VARCHAR2,
52 --Following 1 parameter added for Bug # 2123930.
53 P_ENABLE_FLAG IN VARCHAR2,
54 p_Last_Update_Date DATE,
55 p_Last_Updated_By NUMBER,
56 p_Last_Update_Login NUMBER
57 );
58
59 procedure DELETE_ROW (
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 p_return_status OUT NOCOPY VARCHAR2,
65 p_msg_count OUT NOCOPY NUMBER,
66 p_msg_data OUT NOCOPY VARCHAR2,
67 --
68 P_RULE_ID IN NUMBER,
69 P_TRANSACTION_TYPE IN VARCHAR2,
70 --Following 1 parameter added for Bug # 2123930.
71 P_ENABLE_FLAG IN VARCHAR2
72 );
73
74
75 end PSB_RULE_TRANSACTION_TYPE_PVT;