APPS.PA_FP_ROLLUP_PKG dependencies on PA_BUDGET_LINES

Line 352: a) pa_budget_lines to pa_resource_assignments

348: a lot of it.
349:
350:
351: - Replaced pre-M rollup logic with two-level rollup:
352: a) pa_budget_lines to pa_resource_assignments
353: b) pa_resource_assignments to pa_budget_versions
354:
355: - For p_entire_version = 'N', gutted all logic for
356: this condition. All logic was obsolete.

Line 558: FROM pa_budget_lines pbl

554: ,sum(nvl(raw_cost,0))
555: ,sum(nvl(burdened_cost,0))
556: ,sum(nvl(revenue,0))
557: ,sum(nvl(quantity,0))
558: FROM pa_budget_lines pbl
559: WHERE pbl.resource_assignment_id = pra.resource_assignment_id
560: and pbl.cost_rejection_code IS NULL
561: and pbl.revenue_rejection_code IS NULL
562: and pbl.burden_rejection_code IS NULL

Line 773: from pa_budget_lines on all user_entered records. Insert parents for all the records with amounts.

769:
770: /*===================================================================================================
771: REFRESH_RESOURCE_ASSIGNMENTS: This API refreshes the complete resource assignments table.
772: It does following deletes all rolled up records from pa_resource_assignments.Update amounts
773: from pa_budget_lines on all user_entered records. Insert parents for all the records with amounts.
774: Stamps the parent_assignment_id on all the records.
775: This procedure returns without any action in case there are no records in PA_RESOURCE_ASSIGNMENTS.
776: ===================================================================================================*/
777:

Line 933: FROM pa_budget_lines

929: CURSOR c_budget_lines_exist(p_budget_version_id IN NUMBER) IS
930: SELECT 1
931: FROM DUAL
932: WHERE EXISTS (SELECT resource_assignment_id
933: FROM pa_budget_lines
934: WHERE budget_version_id = p_budget_version_id);
935:
936: l_budget_line_exists NUMBER;
937:

Line 1079: FROM pa_budget_lines pbl

1075: ,sum(nvl(raw_cost,0))
1076: ,sum(nvl(burdened_cost,0))
1077: ,sum(nvl(revenue,0))
1078: ,sum(nvl(quantity,0))
1079: FROM pa_budget_lines pbl
1080: WHERE pbl.resource_assignment_id = pra.resource_assignment_id)
1081: WHERE budget_version_id = p_budget_version_id
1082: AND resource_assignment_type = PA_FP_CONSTANTS_PKG.G_USER_ENTERED;
1083:

Line 4600: FROM pa_budget_lines bl

4596: ,null quantity
4597: ,'Y' delete_flag
4598: ,l_project_currency_code --Bug # 2615807
4599: ,l_projFunc_currency_code --Bug # 2615807
4600: FROM pa_budget_lines bl
4601: ,pa_resource_assignments pra
4602: WHERE bl.resource_assignment_id = p_resource_assignment_id
4603: AND pra.resource_assignment_id = bl.resource_assignment_id
4604: /* FPB2: Removed grouped by and null handling in select columns as

Line 4679: FROM pa_budget_lines

4675: ,decode(txn_currency_code,p_txn_currency_code,0,revenue)
4676: ,decode(txn_currency_code,p_txn_currency_code,0,quantity)
4677: ,l_project_currency_code --Bug#2615807
4678: ,l_projFunc_currency_code --Bug#2615807
4679: FROM pa_budget_lines
4680: WHERE resource_assignment_id = p_resource_assignment_id
4681: /* FPB2: Removed grouped by and null handling in select columns as
4682: budget_line_id needs to be included
4683: GROUP BY resource_assignment_id, txn_currency_code */ ;

Line 4745: pa_budget_lines a,

4741: ,l_task_id_tbl
4742: ,l_res_class_code_tbl
4743: ,l_rate_based_flag_tbl
4744: From
4745: pa_budget_lines a,
4746: pa_resource_assignments b
4747: Where a.resource_assignment_id = b.resource_assignment_id
4748: and b.budget_version_id = p_budget_version_id
4749: and b.resource_assignment_id = p_resource_assignment_id

Line 4804: from the tables PA_BUDGET_LINES */

4800:
4801: IF (p_txn_currency_code IS NULL) THEN
4802:
4803: /* Transaction Currency Code is NULL and hence we can delete records
4804: from the tables PA_BUDGET_LINES */
4805:
4806: DELETE FROM pa_budget_lines
4807: WHERE resource_assignment_id = p_resource_assignment_id;
4808:

Line 4806: DELETE FROM pa_budget_lines

4802:
4803: /* Transaction Currency Code is NULL and hence we can delete records
4804: from the tables PA_BUDGET_LINES */
4805:
4806: DELETE FROM pa_budget_lines
4807: WHERE resource_assignment_id = p_resource_assignment_id;
4808:
4809: l_records_deleted := sql%rowcount;
4810:

Line 4874: /* Deleting records from pa_budget_lines (for resource_assignment_id

4870: END IF;
4871:
4872: ELSE
4873:
4874: /* Deleting records from pa_budget_lines (for resource_assignment_id
4875: and txn_currency_code) and pa_proj_periods_denorm (for 'TRANSACTION'
4876: currency type. */
4877:
4878: DELETE FROM pa_budget_lines

Line 4878: DELETE FROM pa_budget_lines

4874: /* Deleting records from pa_budget_lines (for resource_assignment_id
4875: and txn_currency_code) and pa_proj_periods_denorm (for 'TRANSACTION'
4876: currency type. */
4877:
4878: DELETE FROM pa_budget_lines
4879: WHERE resource_assignment_id = p_resource_assignment_id
4880: AND txn_currency_code = p_txn_currency_code;
4881:
4882: l_records_deleted := sql%rowcount;

Line 4955: FROM pa_budget_lines bl

4951: INTO l_rec_exists /* PK: use exists */
4952: FROM dual
4953: WHERE exists
4954: (SELECT 1
4955: FROM pa_budget_lines bl
4956: WHERE resource_assignment_id = p_resource_assignment_id
4957: AND ROWNUM = 1);
4958:
4959: EXCEPTION