eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.PSP_EXTERNAL_EFFORT_LINES_BK2

Source


1 package body PSP_EXTERNAL_EFFORT_LINES_BK2 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:04 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_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_BK2.UPDATE_EXTERNAL_EFFORT_LINE_A', 10);
42 hr_utility.set_location(' Leaving: PSP_EXTERNAL_EFFORT_LINES_BK2.UPDATE_EXTERNAL_EFFORT_LINE_A', 20);
43 end UPDATE_EXTERNAL_EFFORT_LINE_A;
44 procedure UPDATE_EXTERNAL_EFFORT_LINE_B
45 (P_EXTERNAL_EFFORT_LINE_ID in NUMBER
46 ,P_BATCH_NAME in VARCHAR2
47 ,P_DISTRIBUTION_DATE in DATE
48 ,P_PERSON_ID in NUMBER
49 ,P_ASSIGNMENT_ID in NUMBER
50 ,P_CURRENCY_CODE in VARCHAR2
51 ,P_DISTRIBUTION_AMOUNT in NUMBER
52 ,P_BUSINESS_GROUP_ID in NUMBER
53 ,P_SET_OF_BOOKS_ID in NUMBER
54 ,P_GL_CODE_COMBINATION_ID in NUMBER
55 ,P_PROJECT_ID in NUMBER
56 ,P_TASK_ID in NUMBER
57 ,P_AWARD_ID in NUMBER
58 ,P_EXPENDITURE_ORGANIZATION_ID in NUMBER
59 ,P_EXPENDITURE_TYPE in VARCHAR2
60 ,P_ATTRIBUTE_CATEGORY in VARCHAR2
61 ,P_ATTRIBUTE1 in VARCHAR2
62 ,P_ATTRIBUTE2 in VARCHAR2
63 ,P_ATTRIBUTE3 in VARCHAR2
64 ,P_ATTRIBUTE4 in VARCHAR2
65 ,P_ATTRIBUTE5 in VARCHAR2
66 ,P_ATTRIBUTE6 in VARCHAR2
67 ,P_ATTRIBUTE7 in VARCHAR2
68 ,P_ATTRIBUTE8 in VARCHAR2
69 ,P_ATTRIBUTE9 in VARCHAR2
70 ,P_ATTRIBUTE10 in VARCHAR2
71 ,P_ATTRIBUTE11 in VARCHAR2
72 ,P_ATTRIBUTE12 in VARCHAR2
73 ,P_ATTRIBUTE13 in VARCHAR2
74 ,P_ATTRIBUTE14 in VARCHAR2
75 ,P_ATTRIBUTE15 in VARCHAR2
76 ,P_OBJECT_VERSION_NUMBER in NUMBER
77 )is
78 l_commit_unit_number number;
79 l_legislation_code   varchar2(30);
80 begin
81 hr_utility.set_location('Entering: PSP_EXTERNAL_EFFORT_LINES_BK2.UPDATE_EXTERNAL_EFFORT_LINE_B', 10);
82 l_commit_unit_number := hr_api.return_commit_unit;
83 if hr_api.call_app_hooks then
84 PSP_PEE_EXT.UPDATE_EXTERNAL_EFF_LINE_EXT
85 (P_EXTERNAL_EFFORT_LINE_ID => P_EXTERNAL_EFFORT_LINE_ID
86 ,P_BATCH_NAME => P_BATCH_NAME
87 ,P_DISTRIBUTION_DATE => P_DISTRIBUTION_DATE
88 ,P_PERSON_ID => P_PERSON_ID
89 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
90 ,P_CURRENCY_CODE => P_CURRENCY_CODE
91 ,P_DISTRIBUTION_AMOUNT => P_DISTRIBUTION_AMOUNT
92 ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
93 ,P_SET_OF_BOOKS_ID => P_SET_OF_BOOKS_ID
94 ,P_GL_CODE_COMBINATION_ID => P_GL_CODE_COMBINATION_ID
95 ,P_PROJECT_ID => P_PROJECT_ID
96 ,P_TASK_ID => P_TASK_ID
97 ,P_AWARD_ID => P_AWARD_ID
98 ,P_EXPENDITURE_ORGANIZATION_ID => P_EXPENDITURE_ORGANIZATION_ID
99 ,P_EXPENDITURE_TYPE => P_EXPENDITURE_TYPE
100 ,P_ATTRIBUTE_CATEGORY => P_ATTRIBUTE_CATEGORY
101 ,P_ATTRIBUTE1 => P_ATTRIBUTE1
102 ,P_ATTRIBUTE2 => P_ATTRIBUTE2
103 ,P_ATTRIBUTE3 => P_ATTRIBUTE3
104 ,P_ATTRIBUTE4 => P_ATTRIBUTE4
105 ,P_ATTRIBUTE5 => P_ATTRIBUTE5
106 ,P_ATTRIBUTE6 => P_ATTRIBUTE6
107 ,P_ATTRIBUTE7 => P_ATTRIBUTE7
108 ,P_ATTRIBUTE8 => P_ATTRIBUTE8
109 ,P_ATTRIBUTE9 => P_ATTRIBUTE9
110 ,P_ATTRIBUTE10 => P_ATTRIBUTE10
111 ,P_ATTRIBUTE11 => P_ATTRIBUTE11
112 ,P_ATTRIBUTE12 => P_ATTRIBUTE12
113 ,P_ATTRIBUTE13 => P_ATTRIBUTE13
114 ,P_ATTRIBUTE14 => P_ATTRIBUTE14
115 ,P_ATTRIBUTE15 => P_ATTRIBUTE15
116 ,P_OBJECT_VERSION_NUMBER => P_OBJECT_VERSION_NUMBER
117 );
118 end if;
119 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EXTERNAL_EFFORT_LINE', 'BP');
120 hr_utility.set_location(' Leaving: PSP_EXTERNAL_EFFORT_LINES_BK2.UPDATE_EXTERNAL_EFFORT_LINE_B', 20);
121 end UPDATE_EXTERNAL_EFFORT_LINE_B;
122 end PSP_EXTERNAL_EFFORT_LINES_BK2;