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_EFF_REPORT_DETAILS_BK1

Source


1 package body PSP_EFF_REPORT_DETAILS_BK1 as
2 /* $Header: PSPEDAIB.pls 120.4 2006/01/30 22:33:34 generated noship $ */
3 -- Code generated by the Oracle HRMS API Hook Pre-processor
4 -- Created on 2007/01/03 23:26:21 (YYYY/MM/DD HH24:MI:SS)
5 procedure UPDATE_EFF_REPORT_DETAILS_A
6 (P_EFFORT_REPORT_DETAIL_ID in NUMBER
7 ,P_ASSIGNMENT_ID in VARCHAR2
8 ,P_GL_SEGMENT1 in VARCHAR2
9 ,P_GL_SEGMENT2 in VARCHAR2
10 ,P_GL_SEGMENT3 in VARCHAR2
11 ,P_GL_SEGMENT4 in VARCHAR2
12 ,P_GL_SEGMENT5 in VARCHAR2
13 ,P_GL_SEGMENT6 in VARCHAR2
14 ,P_GL_SEGMENT7 in VARCHAR2
15 ,P_GL_SEGMENT8 in VARCHAR2
16 ,P_GL_SEGMENT9 in VARCHAR2
17 ,P_GL_SEGMENT10 in VARCHAR2
18 ,P_GL_SEGMENT11 in VARCHAR2
19 ,P_GL_SEGMENT12 in VARCHAR2
20 ,P_GL_SEGMENT13 in VARCHAR2
21 ,P_GL_SEGMENT14 in VARCHAR2
22 ,P_GL_SEGMENT15 in VARCHAR2
23 ,P_GL_SEGMENT16 in VARCHAR2
24 ,P_GL_SEGMENT17 in VARCHAR2
25 ,P_GL_SEGMENT18 in VARCHAR2
26 ,P_GL_SEGMENT19 in VARCHAR2
27 ,P_GL_SEGMENT20 in VARCHAR2
28 ,P_GL_SEGMENT21 in VARCHAR2
29 ,P_GL_SEGMENT22 in VARCHAR2
30 ,P_GL_SEGMENT23 in VARCHAR2
31 ,P_GL_SEGMENT24 in VARCHAR2
32 ,P_GL_SEGMENT25 in VARCHAR2
33 ,P_GL_SEGMENT26 in VARCHAR2
34 ,P_GL_SEGMENT27 in VARCHAR2
35 ,P_GL_SEGMENT28 in VARCHAR2
36 ,P_GL_SEGMENT29 in VARCHAR2
37 ,P_GL_SEGMENT30 in VARCHAR2
38 ,P_PROJECT_ID in NUMBER
39 ,P_EXPENDITURE_ORG_ID in NUMBER
40 ,P_EXPENDITURE_TYPE in VARCHAR2
41 ,P_TASK_ID in NUMBER
42 ,P_AWARD_ID in NUMBER
43 ,P_COUNT_EFF_DETAIL_ID in NUMBER
44 ,P_EFFORT_START_DATE in DATE
45 ,P_EFFORT_END_DATE in DATE
46 ,P_INVESTIGATOR_PERSON_ID in NUMBER
47 ,P_INVESTIGATOR_NAME in VARCHAR2
48 ,P_INVESTIGATOR_ORG_NAME in VARCHAR2
49 ,P_INVESTIGATOR_PRIMARY_ORG_ID in NUMBER
50 )is
51 begin
52 hr_utility.set_location('Entering: PSP_EFF_REPORT_DETAILS_BK1.UPDATE_EFF_REPORT_DETAILS_A', 10);
53 hr_utility.set_location(' Leaving: PSP_EFF_REPORT_DETAILS_BK1.UPDATE_EFF_REPORT_DETAILS_A', 20);
54 end UPDATE_EFF_REPORT_DETAILS_A;
55 procedure UPDATE_EFF_REPORT_DETAILS_B
56 (P_EFFORT_REPORT_DETAIL_ID in NUMBER
57 ,P_ASSIGNMENT_ID in VARCHAR2
58 ,P_GL_SEGMENT1 in VARCHAR2
59 ,P_GL_SEGMENT2 in VARCHAR2
60 ,P_GL_SEGMENT3 in VARCHAR2
61 ,P_GL_SEGMENT4 in VARCHAR2
62 ,P_GL_SEGMENT5 in VARCHAR2
63 ,P_GL_SEGMENT6 in VARCHAR2
64 ,P_GL_SEGMENT7 in VARCHAR2
65 ,P_GL_SEGMENT8 in VARCHAR2
66 ,P_GL_SEGMENT9 in VARCHAR2
67 ,P_GL_SEGMENT10 in VARCHAR2
68 ,P_GL_SEGMENT11 in VARCHAR2
69 ,P_GL_SEGMENT12 in VARCHAR2
70 ,P_GL_SEGMENT13 in VARCHAR2
71 ,P_GL_SEGMENT14 in VARCHAR2
72 ,P_GL_SEGMENT15 in VARCHAR2
73 ,P_GL_SEGMENT16 in VARCHAR2
74 ,P_GL_SEGMENT17 in VARCHAR2
75 ,P_GL_SEGMENT18 in VARCHAR2
76 ,P_GL_SEGMENT19 in VARCHAR2
77 ,P_GL_SEGMENT20 in VARCHAR2
78 ,P_GL_SEGMENT21 in VARCHAR2
79 ,P_GL_SEGMENT22 in VARCHAR2
80 ,P_GL_SEGMENT23 in VARCHAR2
81 ,P_GL_SEGMENT24 in VARCHAR2
82 ,P_GL_SEGMENT25 in VARCHAR2
83 ,P_GL_SEGMENT26 in VARCHAR2
84 ,P_GL_SEGMENT27 in VARCHAR2
85 ,P_GL_SEGMENT28 in VARCHAR2
86 ,P_GL_SEGMENT29 in VARCHAR2
87 ,P_GL_SEGMENT30 in VARCHAR2
88 ,P_PROJECT_ID in NUMBER
89 ,P_EXPENDITURE_ORG_ID in NUMBER
90 ,P_EXPENDITURE_TYPE in VARCHAR2
91 ,P_TASK_ID in NUMBER
92 ,P_AWARD_ID in NUMBER
93 ,P_COUNT_EFF_DETAIL_ID in NUMBER
94 ,P_EFFORT_START_DATE in DATE
95 ,P_EFFORT_END_DATE in DATE
96 ,P_INVESTIGATOR_PERSON_ID in NUMBER
97 ,P_INVESTIGATOR_NAME in VARCHAR2
98 ,P_INVESTIGATOR_ORG_NAME in VARCHAR2
99 ,P_INVESTIGATOR_PRIMARY_ORG_ID in NUMBER
100 )is
101 l_commit_unit_number number;
102 l_legislation_code   varchar2(30);
103 begin
104 hr_utility.set_location('Entering: PSP_EFF_REPORT_DETAILS_BK1.UPDATE_EFF_REPORT_DETAILS_B', 10);
105 l_commit_unit_number := hr_api.return_commit_unit;
106 if hr_api.call_app_hooks then
107 PSP_ERD_EXT.UPDATE_EFF_REPORT_DETAILS_EXT
108 (P_EFFORT_REPORT_DETAIL_ID => P_EFFORT_REPORT_DETAIL_ID
109 ,P_ASSIGNMENT_ID => P_ASSIGNMENT_ID
110 ,P_GL_SEGMENT1 => P_GL_SEGMENT1
111 ,P_GL_SEGMENT2 => P_GL_SEGMENT2
112 ,P_GL_SEGMENT3 => P_GL_SEGMENT3
113 ,P_GL_SEGMENT4 => P_GL_SEGMENT4
114 ,P_GL_SEGMENT5 => P_GL_SEGMENT5
115 ,P_GL_SEGMENT6 => P_GL_SEGMENT6
116 ,P_GL_SEGMENT7 => P_GL_SEGMENT7
117 ,P_GL_SEGMENT8 => P_GL_SEGMENT8
118 ,P_GL_SEGMENT9 => P_GL_SEGMENT9
119 ,P_GL_SEGMENT10 => P_GL_SEGMENT10
120 ,P_GL_SEGMENT11 => P_GL_SEGMENT11
121 ,P_GL_SEGMENT12 => P_GL_SEGMENT12
122 ,P_GL_SEGMENT13 => P_GL_SEGMENT13
123 ,P_GL_SEGMENT14 => P_GL_SEGMENT14
124 ,P_GL_SEGMENT15 => P_GL_SEGMENT15
125 ,P_GL_SEGMENT16 => P_GL_SEGMENT16
126 ,P_GL_SEGMENT17 => P_GL_SEGMENT17
127 ,P_GL_SEGMENT18 => P_GL_SEGMENT18
128 ,P_GL_SEGMENT19 => P_GL_SEGMENT19
129 ,P_GL_SEGMENT20 => P_GL_SEGMENT20
130 ,P_GL_SEGMENT21 => P_GL_SEGMENT21
131 ,P_GL_SEGMENT22 => P_GL_SEGMENT22
132 ,P_GL_SEGMENT23 => P_GL_SEGMENT23
133 ,P_GL_SEGMENT24 => P_GL_SEGMENT24
134 ,P_GL_SEGMENT25 => P_GL_SEGMENT25
135 ,P_GL_SEGMENT26 => P_GL_SEGMENT26
136 ,P_GL_SEGMENT27 => P_GL_SEGMENT27
137 ,P_GL_SEGMENT28 => P_GL_SEGMENT28
138 ,P_GL_SEGMENT29 => P_GL_SEGMENT29
139 ,P_GL_SEGMENT30 => P_GL_SEGMENT30
140 ,P_PROJECT_ID => P_PROJECT_ID
141 ,P_EXPENDITURE_ORG_ID => P_EXPENDITURE_ORG_ID
142 ,P_EXPENDITURE_TYPE => P_EXPENDITURE_TYPE
143 ,P_TASK_ID => P_TASK_ID
144 ,P_AWARD_ID => P_AWARD_ID
145 ,P_COUNT_EFF_DETAIL_ID => P_COUNT_EFF_DETAIL_ID
146 ,P_EFFORT_START_DATE => P_EFFORT_START_DATE
147 ,P_EFFORT_END_DATE => P_EFFORT_END_DATE
148 ,P_INVESTIGATOR_PERSON_ID => P_INVESTIGATOR_PERSON_ID
149 ,P_INVESTIGATOR_NAME => P_INVESTIGATOR_NAME
150 ,P_INVESTIGATOR_ORG_NAME => P_INVESTIGATOR_ORG_NAME
151 ,P_INVESTIGATOR_PRIMARY_ORG_ID => P_INVESTIGATOR_PRIMARY_ORG_ID
152 );
153 end if;
154 hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_EFF_REPORT_DETAILS', 'BP');
155 hr_utility.set_location(' Leaving: PSP_EFF_REPORT_DETAILS_BK1.UPDATE_EFF_REPORT_DETAILS_B', 20);
156 end UPDATE_EFF_REPORT_DETAILS_B;
157 end PSP_EFF_REPORT_DETAILS_BK1;