1 PACKAGE PSB_ALLOCRULE_PERCENTS_PVT AS
2 /* $Header: PSBVARPS.pls 120.3 2005/07/13 11:23:22 shtripat ship $ */
3
4
5 PROCEDURE Insert_Row
6 ( p_api_version IN NUMBER,
7 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
8 p_commit IN VARCHAR2 := FND_API.G_FALSE,
9 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
10 p_return_status OUT NOCOPY VARCHAR2,
11 p_msg_count OUT NOCOPY NUMBER,
12 p_msg_data OUT NOCOPY VARCHAR2,
13 P_ALLOCATION_RULE_PERCENT_ID IN OUT NOCOPY NUMBER,
14 P_ALLOCATION_RULE_ID IN NUMBER,
15 P_PERIOD_NUM IN NUMBER,
16 P_MONTHLY IN NUMBER,
17 P_QUARTERLY IN NUMBER,
18 P_SEMI_ANNUAL IN NUMBER,
19 P_ATTRIBUTE1 IN VARCHAR2,
20 P_ATTRIBUTE2 IN VARCHAR2,
21 P_ATTRIBUTE3 IN VARCHAR2,
22 P_ATTRIBUTE4 IN VARCHAR2,
23 P_ATTRIBUTE5 IN VARCHAR2,
24 P_CONTEXT IN VARCHAR2,
25 P_LAST_UPDATE_DATE IN DATE,
26 P_LAST_UPDATED_BY IN NUMBER,
27 P_LAST_UPDATE_LOGIN IN NUMBER,
28 P_CREATED_BY IN NUMBER,
29 P_CREATION_DATE IN DATE
30 );
31
32 PROCEDURE Update_Row
33 ( p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
35 p_commit IN VARCHAR2 := FND_API.G_FALSE,
36 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
37 p_return_status OUT NOCOPY VARCHAR2,
38 p_msg_count OUT NOCOPY NUMBER,
39 p_msg_data OUT NOCOPY VARCHAR2,
40 P_ALLOCATION_RULE_ID IN NUMBER,
41 P_PERIOD_NUM IN NUMBER,
42 P_MONTHLY IN NUMBER,
43 P_QUARTERLY IN NUMBER,
44 P_SEMI_ANNUAL IN NUMBER,
45 P_ATTRIBUTE1 IN VARCHAR2,
46 P_ATTRIBUTE2 IN VARCHAR2,
47 P_ATTRIBUTE3 IN VARCHAR2,
48 P_ATTRIBUTE4 IN VARCHAR2,
49 P_ATTRIBUTE5 IN VARCHAR2,
50 P_CONTEXT IN VARCHAR2,
51 P_LAST_UPDATE_DATE IN DATE,
52 P_LAST_UPDATED_BY IN NUMBER,
53 P_LAST_UPDATE_LOGIN IN NUMBER
54 );
55
56
57 PROCEDURE Delete_Row
58 ( p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
60 p_commit IN VARCHAR2 := FND_API.G_FALSE,
61 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
62 p_return_status OUT NOCOPY VARCHAR2,
63 p_msg_count OUT NOCOPY NUMBER,
64 p_msg_data OUT NOCOPY VARCHAR2,
65 P_ALLOCATION_RULE_ID IN NUMBER,
66 P_PERIOD_NUM IN NUMBER
67 );
68
69 PROCEDURE Lock_Row
70 ( p_api_version IN NUMBER,
71 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
72 p_commit IN VARCHAR2 := FND_API.G_FALSE,
73 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
74 p_return_status OUT NOCOPY VARCHAR2,
75 p_msg_count OUT NOCOPY NUMBER,
76 p_msg_data OUT NOCOPY VARCHAR2,
77 p_lock_row OUT NOCOPY VARCHAR2,
78 P_ALLOCATION_RULE_ID IN NUMBER,
79 P_PERIOD_NUM IN NUMBER,
80 P_MONTHLY IN NUMBER,
81 P_QUARTERLY IN NUMBER,
82 P_SEMI_ANNUAL IN NUMBER
83 );
84
85 FUNCTION get_debug RETURN VARCHAR2;
86
87 END PSB_ALLOCRULE_PERCENTS_PVT;