[Home] [Help]
PACKAGE: APPS.IGC_CC_PERIODS_PKG
Source
1 PACKAGE IGC_CC_PERIODS_PKG AS
2 /* $Header: IGCCCCPS.pls 120.3.12000000.1 2007/08/20 12:11:32 mbremkum ship $ */
3
4 PROCEDURE Insert_Row
5 (
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
14 p_row_id IN OUT NOCOPY VARCHAR2,
15 p_org_id NUMBER,
16 p_period_set_name VARCHAR2,
17 p_period_name VARCHAR2,
18 p_cc_period_status VARCHAR2,
19 p_last_update_date DATE,
20 p_last_updated_by NUMBER,
21 p_last_update_login NUMBER,
22 p_created_by NUMBER,
23 p_creation_date DATE
24 );
25
26 PROCEDURE Lock_Row
27 (
28 p_api_version IN NUMBER,
29 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
30 p_commit IN VARCHAR2 := FND_API.G_FALSE,
31 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
32 p_return_status OUT NOCOPY VARCHAR2,
33 p_msg_count OUT NOCOPY NUMBER,
34 p_msg_data OUT NOCOPY VARCHAR2,
35
36 p_row_id IN OUT NOCOPY VARCHAR2,
37 p_org_id NUMBER,
38 p_period_set_name VARCHAR2,
39 p_period_name VARCHAR2,
40 p_cc_period_status VARCHAR2,
41
42 p_row_locked OUT NOCOPY VARCHAR2
43 );
44
45 PROCEDURE Update_Row
46 (
47 p_api_version IN NUMBER,
48 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
49 p_commit IN VARCHAR2 := FND_API.G_FALSE,
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51 p_return_status OUT NOCOPY VARCHAR2,
52 p_msg_count OUT NOCOPY NUMBER,
53 p_msg_data OUT NOCOPY VARCHAR2,
54
55 p_row_id IN OUT NOCOPY VARCHAR2,
56 p_org_id NUMBER,
57 p_period_set_name VARCHAR2,
58 p_period_name VARCHAR2,
59 p_cc_period_status VARCHAR2,
60 p_last_update_date DATE,
61 p_last_updated_by NUMBER,
62 p_last_update_login NUMBER
63 );
64
65 PROCEDURE Delete_Row
66 (
67 p_api_version IN NUMBER,
68 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
69 p_commit IN VARCHAR2 := FND_API.G_FALSE,
70 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
71 p_return_status OUT NOCOPY VARCHAR2,
72 p_msg_count OUT NOCOPY NUMBER,
73 p_msg_data OUT NOCOPY VARCHAR2,
74
75 p_row_id IN VARCHAR2
76 );
77
78 PROCEDURE Check_Unique
79 (
80
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
83 p_commit IN VARCHAR2 := FND_API.G_FALSE,
84 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
85 p_return_status OUT NOCOPY VARCHAR2,
86 p_msg_count OUT NOCOPY NUMBER,
87 p_msg_data OUT NOCOPY VARCHAR2,
88
89 p_row_id IN OUT NOCOPY VARCHAR2,
90 p_org_id NUMBER,
91 p_period_set_name VARCHAR2,
92 p_period_name VARCHAR2,
93
94 p_return_value IN OUT NOCOPY VARCHAR2
95 );
96
97 END IGC_CC_PERIODS_PKG;