DBA Data[Home] [Help]

PACKAGE BODY: APPS.PSB_PAY_ELEMENTS_L_PVT

Source


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