1 package body PSP_EXTERNAL_EFFORT_LINES_BK1 as
2 /* $Header: PSPEEAIB.pls 120.2 2006/02/28 05:27:39 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2008/11/06 01:40:03 (YYYY/MM/DD HH24:MI:SS)
5 procedure INSERT_EXTERNAL_EFFORT_LINE_A
6 (P_EXTERNAL_EFFORT_LINE_ID in NUMBER
7 ,P_BATCH_NAME in VARCHAR2
8 ,P_DISTRIBUTION_DATE in DATE
9 ,P_PERSON_ID in NUMBER
10 ,P_ASSIGNMENT_ID in NUMBER
11 ,P_CURRENCY_CODE in VARCHAR2
12 ,P_DISTRIBUTION_AMOUNT in NUMBER
13 ,P_BUSINESS_GROUP_ID in NUMBER
14 ,P_SET_OF_BOOKS_ID in NUMBER
15 ,P_GL_CODE_COMBINATION_ID in NUMBER
16 ,P_PROJECT_ID in NUMBER
17 ,P_TASK_ID in NUMBER
18 ,P_AWARD_ID in NUMBER
19 ,P_EXPENDITURE_ORGANIZATION_ID in NUMBER
20 ,P_EXPENDITURE_TYPE in VARCHAR2
21 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
22 ,P_ATTRIBUTE1 in VARCHAR2
23 ,P_ATTRIBUTE2 in VARCHAR2
24 ,P_ATTRIBUTE3 in VARCHAR2
25 ,P_ATTRIBUTE4 in VARCHAR2
26 ,P_ATTRIBUTE5 in VARCHAR2
27 ,P_ATTRIBUTE6 in VARCHAR2
28 ,P_ATTRIBUTE7 in VARCHAR2
29 ,P_ATTRIBUTE8 in VARCHAR2
30 ,P_ATTRIBUTE9 in VARCHAR2
31 ,P_ATTRIBUTE10 in VARCHAR2
32 ,P_ATTRIBUTE11 in VARCHAR2
33 ,P_ATTRIBUTE12 in VARCHAR2
34 ,P_ATTRIBUTE13 in VARCHAR2
35 ,P_ATTRIBUTE14 in VARCHAR2
36 ,P_ATTRIBUTE15 in VARCHAR2
37 ,P_OBJECT_VERSION_NUMBER in NUMBER
38 ,P_RETURN_STATUS in BOOLEAN
39 )is
40 begin
41 hr_utility.set_location('Entering: PSP_EXTERNAL_EFFORT_LINES_BK1.INSERT_EXTERNAL_EFFORT_LINE_A', 10);
42 hr_utility.set_location(' Leaving: PSP_EXTERNAL_EFFORT_LINES_BK1.INSERT_EXTERNAL_EFFORT_LINE_A', 20);
43 end INSERT_EXTERNAL_EFFORT_LINE_A;
44 procedure INSERT_EXTERNAL_EFFORT_LINE_B
45 (P_BATCH_NAME in VARCHAR2
46 ,P_DISTRIBUTION_DATE in DATE
47 ,P_PERSON_ID in NUMBER
48 ,P_ASSIGNMENT_ID in NUMBER
49 ,P_CURRENCY_CODE in VARCHAR2
50 ,P_DISTRIBUTION_AMOUNT in NUMBER
51 ,P_BUSINESS_GROUP_ID in NUMBER
52 ,P_SET_OF_BOOKS_ID in NUMBER
53 ,P_GL_CODE_COMBINATION_ID in NUMBER
54 ,P_PROJECT_ID in NUMBER
55 ,P_TASK_ID in NUMBER
56 ,P_AWARD_ID in NUMBER
57 ,P_EXPENDITURE_ORGANIZATION_ID in NUMBER
58 ,P_EXPENDITURE_TYPE in VARCHAR2
59 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
60 ,P_ATTRIBUTE1 in VARCHAR2
61 ,P_ATTRIBUTE2 in VARCHAR2
62 ,P_ATTRIBUTE3 in VARCHAR2
63 ,P_ATTRIBUTE4 in VARCHAR2
64 ,P_ATTRIBUTE5 in VARCHAR2
65 ,P_ATTRIBUTE6 in VARCHAR2
66 ,P_ATTRIBUTE7 in VARCHAR2
67 ,P_ATTRIBUTE8 in VARCHAR2
68 ,P_ATTRIBUTE9 in VARCHAR2
69 ,P_ATTRIBUTE10 in VARCHAR2
70 ,P_ATTRIBUTE11 in VARCHAR2
71 ,P_ATTRIBUTE12 in VARCHAR2
72 ,P_ATTRIBUTE13 in VARCHAR2
73 ,P_ATTRIBUTE14 in VARCHAR2
74 ,P_ATTRIBUTE15 in VARCHAR2
75 )is
76 l_commit_unit_number number;
77 l_legislation_code varchar2(30);
78 begin
79 hr_utility.set_location('Entering: PSP_EXTERNAL_EFFORT_LINES_BK1.INSERT_EXTERNAL_EFFORT_LINE_B', 10);
80 l_commit_unit_number := hr_api.return_commit_unit;
81 if hr_api.call_app_hooks then
82 PSP_PEE_EXT.INSERT_EXTERNAL_EFF_LINE_EXT
83 (P_BATCH_NAME => P_BATCH_NAME
84 ,P_DISTRIBUTION_DATE => P_DISTRIBUTION_DATE
85 ,P_PERSON_ID => P_PERSON_ID
86 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
87 ,P_CURRENCY_CODE => P_CURRENCY_CODE
88 ,P_DISTRIBUTION_AMOUNT => P_DISTRIBUTION_AMOUNT
89 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
90 ,P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
91 ,P_GL_CODE_COMBINATION_ID => P_GL_CODE_COMBINATION_ID
92 ,P_PROJECT_ID => P_PROJECT_ID
93 ,P_TASK_ID => P_TASK_ID
94 ,P_AWARD_ID => P_AWARD_ID
95 ,P_EXPENDITURE_ORGANIZATION_ID => P_EXPENDITURE_ORGANIZATION_ID
96 ,P_EXPENDITURE_TYPE => P_EXPENDITURE_TYPE
97 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
98 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
99 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
100 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
101 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
102 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
103 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
104 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
105 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
106 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
107 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
108 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
109 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
110 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
111 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
112 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
113 );
114 end if;
115 hr_api.validate_commit_unit(l_commit_unit_number, 'INSERT_EXTERNAL_EFFORT_LINE', 'BP');
116 hr_utility.set_location(' Leaving: PSP_EXTERNAL_EFFORT_LINES_BK1.INSERT_EXTERNAL_EFFORT_LINE_B', 20);
117 end INSERT_EXTERNAL_EFFORT_LINE_B;
118 end PSP_EXTERNAL_EFFORT_LINES_BK1;
[Home] [Help]