DBA Data[Home] [Help]

PACKAGE: APPS.PSB_POSITION_CONTROL_PVT

Source


1 PACKAGE PSB_POSITION_CONTROL_PVT AS
2 /* $Header: PSBVWPCS.pls 120.3 2005/07/13 11:31:20 shtripat ship $ */
3 
4 /* ----------------------------------------------------------------------- */
5 g_checkpoint_save    CONSTANT NUMBER := 100;
6 g_limit_bulk_numrows CONSTANT NUMBER := 100;
7 
8 PROCEDURE Convert_Organization_Attr_CP
9 ( errbuf               OUT  NOCOPY  VARCHAR2,
10   retcode              OUT  NOCOPY  VARCHAR2,
11   p_business_group_id  IN   NUMBER,
12   p_attribute_id       IN   NUMBER
13 );
14 
15 /* ----------------------------------------------------------------------- */
16 
17 PROCEDURE Upload_Worksheet_CP
18 ( errbuf                 OUT  NOCOPY  VARCHAR2,
19   retcode                OUT  NOCOPY  VARCHAR2,
20   p_worksheet_id         IN   NUMBER,
21   p_hr_budget_id         IN   NUMBER,
22   p_from_budget_year_id  IN   NUMBER,
23   p_to_budget_year_id    IN   NUMBER,
24   p_run_mode             IN   VARCHAR2
25 );
26 
27 /* ----------------------------------------------------------------------- */
28 
29 PROCEDURE Upload_Budget_HRMS
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   p_event_type           IN   VARCHAR2,
38   p_source_id            IN   NUMBER,
39   p_hr_budget_id         IN   NUMBER,
40   p_from_budget_year_id  IN   NUMBER,
41   p_to_budget_year_id    IN   NUMBER
42 );
43 
44 /* ----------------------------------------------------------------------- */
45 
46 PROCEDURE Modify_Position_Accounts
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_NONE,
51   p_return_status         OUT  NOCOPY  VARCHAR2,
52   p_msg_count             OUT  NOCOPY  NUMBER,
53   p_msg_data              OUT  NOCOPY  VARCHAR2,
54   p_position_id           IN   NUMBER,
55   p_hr_budget_id          IN   NUMBER,
56   p_budget_revision_id    IN   NUMBER,
57   p_budget_group_id       IN   NUMBER,
58   p_base_line_version     IN   VARCHAR2,
59   p_start_date            IN   DATE,
60   p_end_date              IN   DATE,
61   p_code_combination_id   IN   NUMBER,
62   p_currency_code         IN   VARCHAR2,
63   p_amount                IN   NUMBER
64 );
65 
66 /* ----------------------------------------------------------------------- */
67 
68 PROCEDURE Modify_Position_Costs
69 ( p_api_version           IN   NUMBER,
70   p_init_msg_list         IN   VARCHAR2 := FND_API.G_FALSE,
71   p_commit                IN   VARCHAR2 := FND_API.G_FALSE,
72   p_validation_level      IN   NUMBER := FND_API.G_VALID_LEVEL_NONE,
73   p_return_status         OUT  NOCOPY  VARCHAR2,
74   p_msg_count             OUT  NOCOPY  NUMBER,
75   p_msg_data              OUT  NOCOPY  VARCHAR2,
76   p_position_id           IN   NUMBER,
77   p_hr_budget_id          IN   NUMBER,
78   p_pay_element_id        IN   NUMBER,
79   p_budget_revision_id    IN   NUMBER,
80   p_base_line_version     IN   VARCHAR2,
81   p_start_date            IN   DATE,
82   p_end_date              IN   DATE,
83   p_currency_code         IN   VARCHAR2,
84   p_element_cost          IN   NUMBER
85 );
86 
87 /* ----------------------------------------------------------------------- */
88 
89 PROCEDURE Modify_Position_FTE
90 ( p_api_version           IN   NUMBER,
91   p_init_msg_list         IN   VARCHAR2 := FND_API.G_FALSE,
92   p_commit                IN   VARCHAR2 := FND_API.G_FALSE,
93   p_validation_level      IN   NUMBER := FND_API.G_VALID_LEVEL_NONE,
94   p_return_status         OUT  NOCOPY  VARCHAR2,
95   p_msg_count             OUT  NOCOPY  NUMBER,
96   p_msg_data              OUT  NOCOPY  VARCHAR2,
97   p_position_id           IN   NUMBER,
98   p_hr_budget_id          IN   NUMBER,
99   p_budget_revision_id    IN   NUMBER,
100   p_base_line_version     IN   VARCHAR2,
101   p_start_date            IN   DATE,
102   p_end_date              IN   DATE,
103   p_fte                   IN   NUMBER
104 );
105 
106 /* ----------------------------------------------------------------------- */
107 
108 PROCEDURE Validate_Position_Budget
109 ( p_return_status  OUT  NOCOPY  VARCHAR2,
110   --p_msg_count      OUT  NOCOPY  NUMBER,
111   --p_msg_data       OUT  NOCOPY  VARCHAR2,
112   p_event_type     IN   VARCHAR2,
113   p_source_id      IN   NUMBER);
114 
115 /* ----------------------------------------------------------------------- */
116 
117 PROCEDURE Upload_Element
118 ( p_return_status           OUT  NOCOPY  VARCHAR2,
119   p_source_data_extract_id  IN   NUMBER,
120   p_target_data_extract_id  IN   NUMBER,
121   p_pay_element_id          IN   NUMBER
122 );
123 
124 /* ----------------------------------------------------------------------- */
125 /* Bug No 2579818 Start */
126 
127 PROCEDURE Upload_Attribute_Values
128 ( p_return_status               OUT  NOCOPY  VARCHAR2,
129   p_source_data_extract_id      IN   NUMBER,
130   p_source_business_group_id    IN   NUMBER,
131   p_target_data_extract_id      IN   NUMBER
132 );
133 
134 /* Bug No 2579818 End */
135 /* ----------------------------------------------------------------------- */
136 
137 END PSB_POSITION_CONTROL_PVT;