[Home] [Help]
PACKAGE: APPS.PSB_RULE_WITHIN_SEGMENT_PVT
Source
1 package PSB_RULE_WITHIN_SEGMENT_PVT as
2 /* $Header: PSBVWSPS.pls 120.2 2005/07/13 11:31:32 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_SEGMENT_NAME IN VARCHAR2,
16 P_APPLICATION_COLUMN_NAME IN VARCHAR2,
17 p_Last_Update_Date DATE,
18 p_Last_Updated_By NUMBER,
19 p_Last_Update_Login NUMBER,
20 p_Created_By NUMBER,
21 p_Creation_Date DATE
22 );
23
24 procedure LOCK_ROW (
25 p_api_version IN NUMBER,
26 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27 p_commit IN VARCHAR2 := FND_API.G_FALSE,
28 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29 p_return_status OUT NOCOPY VARCHAR2,
30 p_msg_count OUT NOCOPY NUMBER,
31 p_msg_data OUT NOCOPY VARCHAR2,
32 p_lock_row OUT NOCOPY VARCHAR2,
33 --
34 P_RULE_ID IN NUMBER,
35 P_SEGMENT_NAME IN VARCHAR2,
36 P_APPLICATION_COLUMN_NAME IN VARCHAR2
37 );
38
39 procedure UPDATE_ROW (
40 p_api_version IN NUMBER,
41 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE,
43 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
44 p_return_status OUT NOCOPY VARCHAR2,
45 p_msg_count OUT NOCOPY NUMBER,
46 p_msg_data OUT NOCOPY VARCHAR2,
47 --
48 P_RULE_ID IN NUMBER,
49 P_SEGMENT_NAME IN VARCHAR2,
50 P_APPLICATION_COLUMN_NAME IN VARCHAR2,
51 p_Last_Update_Date DATE,
52 p_Last_Updated_By NUMBER,
53 p_Last_Update_Login 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 --
66 P_RULE_ID IN NUMBER,
67 P_APPLICATION_COLUMN_NAME IN VARCHAR2
68 );
69
70 FUNCTION VALIDATE_ACCOUNT_SEGMENT (
71 p_str IN VARCHAR2,
72 p_sets IN VARCHAR2,
73 p_chart_of_accounts_id IN VARCHAR2,
74 p_app_column_name IN VARCHAR2
75 ) RETURN BOOLEAN;
76
77 end PSB_RULE_WITHIN_SEGMENT_PVT;