DBA Data[Home] [Help]

PACKAGE BODY: APPS.PSB_PAY_ELEMENTS_I_PVT

Source


1 PACKAGE BODY PSB_PAY_ELEMENTS_I_PVT AS
2 /* $Header: PSBWELIB.pls 120.2 2005/07/13 11:33:39 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   --
14   P_ROW_ID                           in OUT  NOCOPY  VARCHAR2,
15   P_PAY_ELEMENT_ID                   in      NUMBER,
16   P_BUSINESS_GROUP_ID                in      NUMBER,
17   P_DATA_EXTRACT_ID                  in      NUMBER,
18   P_BUDGET_SET_ID                    in      NUMBER := FND_API.G_MISS_NUM,
19   P_NAME                             in      VARCHAR2,
20   P_DESCRIPTION                      in      VARCHAR2,
21   P_ELEMENT_VALUE_TYPE               in      VARCHAR2,
22   P_FORMULA_ID                       in      NUMBER,
23   P_OVERWRITE_FLAG                   in      VARCHAR2,
24   P_REQUIRED_FLAG                    in      VARCHAR2,
25   P_FOLLOW_SALARY                    in      VARCHAR2,
26   P_PAY_BASIS                        IN      VARCHAR2,
27   P_START_DATE                       in      DATE,
28   P_END_DATE                         in      DATE,
29   P_PROCESSING_TYPE                  in      VARCHAR2,
30   P_PERIOD_TYPE                      in      VARCHAR2,
31   P_PROCESS_PERIOD_TYPE              in      VARCHAR2,
32   P_MAX_ELEMENT_VALUE_TYPE           in      VARCHAR2,
33   P_MAX_ELEMENT_VALUE                in      NUMBER,
34   P_SALARY_FLAG                      in      VARCHAR2,
35   P_SALARY_TYPE                      in      VARCHAR2,
36   P_OPTION_FLAG                      in      VARCHAR2,
37   P_HR_ELEMENT_TYPE_ID               in      NUMBER,
38   P_ATTRIBUTE_CATEGORY               in      VARCHAR2,
39   P_ATTRIBUTE1                       in      VARCHAR2,
40   P_ATTRIBUTE2                       in      VARCHAR2,
41   P_ATTRIBUTE3                       in      VARCHAR2,
42   P_ATTRIBUTE4                       in      VARCHAR2,
43   P_ATTRIBUTE5                       in      VARCHAR2,
44   P_ATTRIBUTE6                       in      VARCHAR2,
45   P_ATTRIBUTE7                       in      VARCHAR2,
46   P_ATTRIBUTE8                       in      VARCHAR2,
47   P_ATTRIBUTE9                       in      VARCHAR2,
48   P_ATTRIBUTE10                      in      VARCHAR2,
49   P_LAST_UPDATE_DATE                 in      DATE,
50   P_LAST_UPDATED_BY                  in      NUMBER,
51   P_LAST_UPDATE_LOGIN                in      NUMBER,
52   P_CREATED_BY                       in      NUMBER,
53   P_CREATION_DATE                    in      DATE
54 ) IS
55 
56  BEGIN
57 
58  PSB_PAY_ELEMENTS_PVT.INSERT_ROW
59  ( p_api_version                 ,
60   p_init_msg_list               ,
61   p_commit                      ,
62   p_validation_level            ,
63   p_return_status               ,
64   p_msg_count                   ,
65   p_msg_data                    ,
66   --
67   P_ROW_ID                      ,
68   P_PAY_ELEMENT_ID              ,
69   P_BUSINESS_GROUP_ID           ,
70   P_DATA_EXTRACT_ID             ,
71   P_BUDGET_SET_ID               ,
72   P_NAME                        ,
73   P_DESCRIPTION                 ,
74   P_ELEMENT_VALUE_TYPE          ,
75   P_FORMULA_ID                  ,
76   P_OVERWRITE_FLAG              ,
77   P_REQUIRED_FLAG               ,
78   P_FOLLOW_SALARY               ,
79   P_PAY_BASIS                   ,
80   P_START_DATE                  ,
81   P_END_DATE                    ,
82   P_PROCESSING_TYPE             ,
83   P_PERIOD_TYPE                 ,
84   P_PROCESS_PERIOD_TYPE         ,
85   P_MAX_ELEMENT_VALUE_TYPE      ,
86   P_MAX_ELEMENT_VALUE           ,
87   P_SALARY_FLAG                 ,
88   P_SALARY_TYPE                 ,
89   P_OPTION_FLAG                 ,
90   P_HR_ELEMENT_TYPE_ID          ,
91   P_ATTRIBUTE_CATEGORY          ,
92   P_ATTRIBUTE1                  ,
93   P_ATTRIBUTE2                  ,
94   P_ATTRIBUTE3                  ,
95   P_ATTRIBUTE4                  ,
96   P_ATTRIBUTE5                  ,
97   P_ATTRIBUTE6                  ,
98   P_ATTRIBUTE7                  ,
99   P_ATTRIBUTE8                  ,
100   P_ATTRIBUTE9                  ,
101   P_ATTRIBUTE10                 ,
102   P_LAST_UPDATE_DATE            ,
103   P_LAST_UPDATED_BY             ,
104   P_LAST_UPDATE_LOGIN           ,
105   P_CREATED_BY                  ,
106   P_CREATION_DATE
107   );
108 
109 
110   END INSERT_ROW;
111 
112 
113 END PSB_PAY_ELEMENTS_I_PVT;