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 --commented these conditions of rejection codes for Bug #14177908
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 4601: FROM pa_budget_lines bl

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

Line 4680: FROM pa_budget_lines

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

Line 4748: pa_budget_lines a,

4744: ,l_res_class_code_tbl
4745: ,l_rate_based_flag_tbl
4746: ,l_cbs_element_id_tbl --bug#16911079
4747: From
4748: pa_budget_lines a,
4749: pa_resource_assignments b
4750: Where a.resource_assignment_id = b.resource_assignment_id
4751: and b.budget_version_id = p_budget_version_id
4752: and b.resource_assignment_id = p_resource_assignment_id

Line 4808: from the tables PA_BUDGET_LINES */

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

Line 4810: DELETE FROM pa_budget_lines

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

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

4874: END IF;
4875:
4876: ELSE
4877:
4878: /* Deleting records from pa_budget_lines (for resource_assignment_id
4879: and txn_currency_code) and pa_proj_periods_denorm (for 'TRANSACTION'
4880: currency type. */
4881:
4882: DELETE FROM pa_budget_lines

Line 4882: DELETE FROM pa_budget_lines

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

Line 4959: FROM pa_budget_lines bl

4955: INTO l_rec_exists /* PK: use exists */
4956: FROM dual
4957: WHERE exists
4958: (SELECT 1
4959: FROM pa_budget_lines bl
4960: WHERE resource_assignment_id = p_resource_assignment_id
4961: AND ROWNUM = 1);
4962:
4963: EXCEPTION