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.

APPS.PA_BUDGET_LINES_V_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 26: -- 1) Modidified the pa_resource_assignments insert to populte

22: -- xx-xxx-xxxx who? - Created
23: --
24: -- 16-AUG-02 jwhite As per the FP model conversion effort, did the following:
25: --
26: -- 1) Modidified the pa_resource_assignments insert to populte
27: -- resource_assignment_type as 'USER_ENTERED'.
28: --
29: -- 2) Added a call to PA_BUDGET_UTILS.Get_Project_Currency_Info
30: -- to populate the following new currency columns:

Line 167: -- pa_resource_assignments (removed previous

163: close get_budget_type_code;
164:
165: -- 23-APR-98, jwhite ------------------------------------------------------
166: -- Added Begin/End block to capture duplicate rows for
167: -- pa_resource_assignments (removed previous
168: -- where-NOT-Exists code)
169: --
170: /* The following code is modified as first check for the resource_Assignment_id,
171: If not exists then insert the record, by having the code like this the sequence

Line 172: pa_resource_assignments_s will not get incremented unnecessarily 23-MAR-2001 */

168: -- where-NOT-Exists code)
169: --
170: /* The following code is modified as first check for the resource_Assignment_id,
171: If not exists then insert the record, by having the code like this the sequence
172: pa_resource_assignments_s will not get incremented unnecessarily 23-MAR-2001 */
173:
174: BEGIN
175:
176: select resource_assignment_id

Line 178: from pa_resource_assignments a

174: BEGIN
175:
176: select resource_assignment_id
177: into x_resource_assignment_id
178: from pa_resource_assignments a
179: where a.budget_version_id = x_budget_version_id
180: and a.project_id = x_project_id
181: and nvl(a.task_id,0) = nvl(x_task_id,0)
182: and a.resource_list_member_id = x_resource_list_member_id

Line 189: SELECT pa_resource_assignments_s.nextval

185: l_rows_inserted := 0;
186: EXCEPTION
187: WHEN NO_DATA_FOUND THEN
188:
189: SELECT pa_resource_assignments_s.nextval
190: INTO X_Resource_Assignment_Id
191: FROM sys.dual;
192:
193: -- insert into pa_resource_assignments if necessary

Line 193: -- insert into pa_resource_assignments if necessary

189: SELECT pa_resource_assignments_s.nextval
190: INTO X_Resource_Assignment_Id
191: FROM sys.dual;
192:
193: -- insert into pa_resource_assignments if necessary
194: insert into pa_resource_assignments(
195: resource_assignment_id,
196: budget_version_id,
197: project_id,

Line 194: insert into pa_resource_assignments(

190: INTO X_Resource_Assignment_Id
191: FROM sys.dual;
192:
193: -- insert into pa_resource_assignments if necessary
194: insert into pa_resource_assignments(
195: resource_assignment_id,
196: budget_version_id,
197: project_id,
198: task_id,

Line 253: from pa_resource_assignments a

249: /* IF (l_rows_inserted = 0)
250: THEN
251: select resource_assignment_id
252: into x_resource_assignment_id
253: from pa_resource_assignments a
254: where a.budget_version_id = x_budget_version_id
255: and a.project_id = x_project_id
256: and nvl(a.task_id,0) = nvl(x_task_id,0)
257: and a.resource_list_member_id = x_resource_list_member_id

Line 603: FROM pa_resource_assignments a,

599: a.task_id,
600: a.resource_list_member_id,
601: a.unit_of_measure,
602: a.track_as_labor_flag
603: FROM pa_resource_assignments a,
604: pa_budget_lines l
605: WHERE l.rowid = X_Rowid
606: AND l.resource_assignment_id = a.resource_assignment_id
607: FOR UPDATE NOWAIT;

Line 1130: from pa_resource_assignments a,

1126: x_revenue,
1127: x_quantity,
1128: x_resource_assignment_id,
1129: x_track_as_labor_flag
1130: from pa_resource_assignments a,
1131: pa_budget_lines l
1132: where l.rowid = X_Rowid
1133: and l.resource_assignment_id = a.resource_assignment_id;
1134:

Line 1145: from pa_resource_assignments

1141: x_last_update_login := fnd_global.login_id;
1142:
1143: select budget_version_id
1144: into x_budget_version_id
1145: from pa_resource_assignments
1146: where resource_assignment_id = x_resource_assignment_id;
1147:
1148: -- clean up pa_resource_assignments if necessary
1149: delete pa_resource_assignments

Line 1148: -- clean up pa_resource_assignments if necessary

1144: into x_budget_version_id
1145: from pa_resource_assignments
1146: where resource_assignment_id = x_resource_assignment_id;
1147:
1148: -- clean up pa_resource_assignments if necessary
1149: delete pa_resource_assignments
1150: where resource_assignment_id = x_resource_assignment_id
1151: and not exists
1152: (select 1

Line 1149: delete pa_resource_assignments

1145: from pa_resource_assignments
1146: where resource_assignment_id = x_resource_assignment_id;
1147:
1148: -- clean up pa_resource_assignments if necessary
1149: delete pa_resource_assignments
1150: where resource_assignment_id = x_resource_assignment_id
1151: and not exists
1152: (select 1
1153: from pa_budget_lines

Line 1217: v_res_assignment_id PA_RESOURCE_ASSIGNMENTS.resource_assignment_id%TYPE; -- Added for bug 3777706

1213: x_resource_name IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1214: x_err_code IN OUT NOCOPY NUMBER) is --File.Sql.39 bug 4440895
1215:
1216: v_temp varchar2(1);
1217: v_res_assignment_id PA_RESOURCE_ASSIGNMENTS.resource_assignment_id%TYPE; -- Added for bug 3777706
1218: cursor c is
1219: /* commented for bug 3777706 and included modified query.
1220: Modified the query to be based on pa_budget_lines table to
1221: instead of pa_budget_lines_v, as pa_budget_lines_v is based

Line 1268: PA_RESOURCE_ASSIGNMENTS ra

1264: -- start of bug 3777706
1265: select SUBSTRB(pa_resources_pkg.get_resource_name(M1.RESOURCE_ID, M1.RESOURCE_TYPE_ID),1,30) resource_name
1266: into x_resource_name
1267: from PA_RESOURCE_LIST_MEMBERS M1,
1268: PA_RESOURCE_ASSIGNMENTS ra
1269: where
1270: ra.resource_assignment_id = v_res_assignment_id and
1271: ra.resource_list_member_id = M1.resource_list_member_id;
1272: -- end of bug 3777706