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_FP_GEN_FCST_AMT_PUB1 dependencies on PA_RESOURCE_ASSIGNMENTS

Line 53: FROM pa_resource_assignments ra,

49:
50: CURSOR rev_only_nrb_txns_csr IS
51: SELECT bl.resource_assignment_id,
52: bl.txn_currency_code
53: FROM pa_resource_assignments ra,
54: pa_budget_lines bl
55: WHERE ra.budget_version_id = p_budget_version_id
56: AND ra.project_id = p_project_id
57: AND ra.rate_based_flag = 'N'

Line 88: FROM pa_resource_assignments ra,

84:
85: CURSOR nrb_txns_without_bl_csr IS
86: SELECT rbc.resource_assignment_id,
87: rbc.txn_currency_code
88: FROM pa_resource_assignments ra,
89: pa_resource_asgn_curr rbc
90: WHERE ra.budget_version_id = p_budget_version_id
91: AND ra.project_id = p_project_id
92: AND ra.rate_based_flag = 'N'

Line 616: * in the pa_resource_assignments table to be non rate-based with UOM equal to

612:
613: /**
614: * This procedure checks for rate-based target txns that have source txns in
615: * different units of measurement mapped to them. Such target txns are updated
616: * in the pa_resource_assignments table to be non rate-based with UOM equal to
617: * currency.
618: *
619: * Currently the P_FP_COLS_REC parameter is unused. This, however, will likely
620: * change with future modifications.

Line 635: pa_resource_assignments ra

631: CURSOR get_res_asg_cur IS
632: SELECT /*+ INDEX(tmp,PA_FP_CALC_AMT_TMP1_N1)*/
633: DISTINCT(tmp.target_res_asg_id)
634: FROM pa_fp_calc_amt_tmp1 tmp,
635: pa_resource_assignments ra
636: WHERE ra.resource_assignment_id = tmp.target_res_asg_id
637: and ra.budget_version_id = p_budget_version_id
638: and ra.rate_based_flag = 'Y'
639: GROUP BY tmp.target_res_asg_id

Line 644: l_currency_code CONSTANT PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE := 'DOLLARS';

640: HAVING COUNT(DISTINCT(tmp.unit_of_measure)) > 1;
641:
642: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
643:
644: l_currency_code CONSTANT PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE := 'DOLLARS';
645: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
646: l_last_update_login NUMBER := FND_GLOBAL.login_id;
647:
648: l_count NUMBER;

Line 676: UPDATE pa_resource_assignments

672: RETURN;
673: END IF;
674:
675: FORALL i IN 1..l_res_asg_id_tab.count
676: UPDATE pa_resource_assignments
677: SET rate_based_flag = 'N',
678: unit_of_measure = l_currency_code,
679: last_update_date = SYSDATE,
680: last_updated_by = l_last_updated_by,

Line 1004: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,

1000: END CALL_SUMM_POP_TMPS;
1001:
1002: PROCEDURE GEN_AVERAGE_OF_ACTUALS_WRP
1003: (P_BUDGET_VERSION_ID IN PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
1004: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,
1005: P_ACTUALS_THRU_DATE IN DATE,
1006: P_FP_COLS_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
1007: P_ACTUALS_FROM_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,
1008: P_ACTUALS_TO_PERIOD IN PA_PERIODS_ALL.PERIOD_NAME%TYPE,

Line 1023: FROM pa_resource_assignments ra

1019: ra.resource_list_member_id,
1020: ra.planning_start_date,
1021: ra.planning_end_date,
1022: p_task_id
1023: FROM pa_resource_assignments ra
1024: WHERE c_task_id_flag = 'Y' AND
1025: ra.budget_version_id = P_BUDGET_VERSION_ID
1026: AND ra.task_id = P_TASK_ID
1027: UNION ALL

Line 1033: FROM pa_resource_assignments ra

1029: ra.resource_list_member_id,
1030: ra.planning_start_date,
1031: ra.planning_end_date,
1032: ra.task_id
1033: FROM pa_resource_assignments ra
1034: WHERE c_task_id_flag = 'N' AND
1035: ra.budget_version_id = P_BUDGET_VERSION_ID;
1036:
1037: -- Bug 4040832, 3970800: Modified project-level cursor to get

Line 1047: pa_resource_assignments ra

1043: ra.planning_start_date,
1044: ra.planning_end_date,
1045: tmp.project_element_id
1046: FROM PA_FP_FCST_GEN_TMP1 tmp,
1047: pa_resource_assignments ra
1048: WHERE tmp.project_element_id = p_task_id AND
1049: ra.budget_version_id = P_BUDGET_VERSION_ID AND
1050: NVL(ra.task_id,0) = 0 AND
1051: ra.resource_list_member_id = tmp.res_list_member_id;

Line 1062: FROM pa_resource_assignments ra

1058: ra.resource_list_member_id,
1059: ra.planning_start_date,
1060: ra.planning_end_date,
1061: p_task_id
1062: FROM pa_resource_assignments ra
1063: WHERE c_task_id_flag = 'Y' AND
1064: ra.budget_version_id = P_BUDGET_VERSION_ID
1065: AND ra.task_id = P_TASK_ID
1066: AND ( ra.transaction_source_code IS NOT NULL

Line 1080: FROM pa_resource_assignments ra

1076: ra.resource_list_member_id,
1077: ra.planning_start_date,
1078: ra.planning_end_date,
1079: ra.task_id
1080: FROM pa_resource_assignments ra
1081: WHERE c_task_id_flag = 'N' AND
1082: ra.budget_version_id = P_BUDGET_VERSION_ID
1083: AND ( ra.transaction_source_code IS NOT NULL
1084: OR ( ra.transaction_source_code IS NULL

Line 1098: FROM pa_resource_assignments ra

1094: ra.resource_list_member_id,
1095: ra.planning_start_date,
1096: ra.planning_end_date,
1097: p_task_id
1098: FROM pa_resource_assignments ra
1099: WHERE c_task_id_flag = 'Y' AND
1100: ra.budget_version_id = P_BUDGET_VERSION_ID
1101: AND ra.task_id = P_TASK_ID
1102: AND ( ra.transaction_source_code IS NOT NULL

Line 1116: FROM pa_resource_assignments ra

1112: ra.resource_list_member_id,
1113: ra.planning_start_date,
1114: ra.planning_end_date,
1115: ra.task_id
1116: FROM pa_resource_assignments ra
1117: WHERE c_task_id_flag = 'N' AND
1118: ra.budget_version_id = P_BUDGET_VERSION_ID
1119: AND ( ra.transaction_source_code IS NOT NULL
1120: OR ( ra.transaction_source_code IS NULL

Line 1136: pa_resource_assignments ra

1132: ra.planning_start_date,
1133: ra.planning_end_date,
1134: tmp.project_element_id
1135: FROM PA_FP_FCST_GEN_TMP1 tmp,
1136: pa_resource_assignments ra
1137: WHERE tmp.project_element_id = p_task_id AND
1138: ra.budget_version_id = P_BUDGET_VERSION_ID AND
1139: NVL(ra.task_id,0) = 0 AND
1140: ra.resource_list_member_id = tmp.res_list_member_id

Line 1158: pa_resource_assignments ra

1154: ra.planning_start_date,
1155: ra.planning_end_date,
1156: tmp.project_element_id
1157: FROM PA_FP_FCST_GEN_TMP1 tmp,
1158: pa_resource_assignments ra
1159: WHERE tmp.project_element_id = p_task_id AND
1160: ra.budget_version_id = P_BUDGET_VERSION_ID AND
1161: NVL(ra.task_id,0) = 0 AND
1162: ra.resource_list_member_id = tmp.res_list_member_id

Line 1401: UPDATE pa_resource_assignments

1397:
1398: -- Bug 4165701: Since the generation source is Average of Actuals, we
1399: -- need to NULL out the spread curves of the generated resources.
1400: FORALL i IN 1..l_res_asg_id_tab.count
1401: UPDATE pa_resource_assignments
1402: SET spread_curve_id = NULL,
1403: sp_fixed_date = NULL,
1404: transaction_source_code = 'AVERAGE_ACTUALS' -- bug 4232619
1405: WHERE resource_assignment_id = l_res_asg_id_tab(i);

Line 3684: FROM pa_resource_assignments ra

3680:
3681: INSERT INTO pa_resource_asgn_curr_tmp
3682: ( resource_assignment_id )
3683: SELECT ra.resource_assignment_id
3684: FROM pa_resource_assignments ra
3685: WHERE ra.budget_version_id = p_budget_version_id
3686: AND ra.transaction_source_code IS NOT NULL;
3687:
3688: IF p_pa_debug_mode = 'Y' THEN

Line 3728: FROM pa_resource_assignments ra,

3724: bl.txn_currency_code,
3725: rbc.txn_raw_cost_rate_override,
3726: rbc.txn_burden_cost_rate_override,
3727: rbc.txn_bill_rate_override
3728: FROM pa_resource_assignments ra,
3729: pa_budget_lines bl,
3730: pa_resource_asgn_curr rbc
3731: WHERE ra.budget_version_id = p_budget_version_id
3732: AND ra.project_id = p_project_id

Line 3838: -- IPM: Delete records from PA_RESOURCE_ASSIGNMENTS that:

3834: END IF;
3835:
3836: END IF; -- IPM logic
3837:
3838: -- IPM: Delete records from PA_RESOURCE_ASSIGNMENTS that:
3839: -- 1. Do not have budget lines.
3840: -- 2. Have a non-null transaction_source_code.
3841: -- 3. Do not have a record in the PA_RESOURCE_ASGN_CURR table.
3842: -- In this way, we can ensure that all records in the resource

Line 3846: DELETE FROM pa_resource_assignments ra

3842: -- In this way, we can ensure that all records in the resource
3843: -- assignments table have a corresponding records in the new
3844: -- pa_resource_asgn_curr entity.
3845:
3846: DELETE FROM pa_resource_assignments ra
3847: WHERE ra.budget_version_id = p_budget_version_id
3848: AND ra.transaction_source_code IS NOT NULL
3849: AND NOT EXISTS (SELECT null
3850: FROM pa_budget_lines bl

Line 4165: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

4161:
4162: PROCEDURE GET_WP_ACTUALS_FOR_RA
4163: (P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4164: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4165: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
4166: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
4167: P_RES_LIST_MEM_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
4168: P_ACTUALS_THRU_DATE IN DATE,
4169: X_ACT_QUANTITY OUT NOCOPY NUMBER,

Line 4458: --Record created for updating rate_based_flag in pa_resource_assignments.

4454:
4455: TYPE del_bud_line_tbl IS TABLE OF del_bud_line_rec;
4456: l_del_bud_line_tbl del_bud_line_tbl := del_bud_line_tbl();
4457:
4458: --Record created for updating rate_based_flag in pa_resource_assignments.
4459: TYPE update_rbf_rec IS RECORD( ra_id pa_resource_assignments.resource_assignment_id%TYPE,
4460: rate_based_flag pa_resource_assignments.rate_based_flag%TYPE);
4461: --pl/sql table created for updating rate_based_flag in pa_resource_assignments.
4462: TYPE update_rbf_tbl IS TABLE OF update_rbf_rec;

Line 4459: TYPE update_rbf_rec IS RECORD( ra_id pa_resource_assignments.resource_assignment_id%TYPE,

4455: TYPE del_bud_line_tbl IS TABLE OF del_bud_line_rec;
4456: l_del_bud_line_tbl del_bud_line_tbl := del_bud_line_tbl();
4457:
4458: --Record created for updating rate_based_flag in pa_resource_assignments.
4459: TYPE update_rbf_rec IS RECORD( ra_id pa_resource_assignments.resource_assignment_id%TYPE,
4460: rate_based_flag pa_resource_assignments.rate_based_flag%TYPE);
4461: --pl/sql table created for updating rate_based_flag in pa_resource_assignments.
4462: TYPE update_rbf_tbl IS TABLE OF update_rbf_rec;
4463: l_upd_rbf_tbl update_rbf_tbl;

Line 4460: rate_based_flag pa_resource_assignments.rate_based_flag%TYPE);

4456: l_del_bud_line_tbl del_bud_line_tbl := del_bud_line_tbl();
4457:
4458: --Record created for updating rate_based_flag in pa_resource_assignments.
4459: TYPE update_rbf_rec IS RECORD( ra_id pa_resource_assignments.resource_assignment_id%TYPE,
4460: rate_based_flag pa_resource_assignments.rate_based_flag%TYPE);
4461: --pl/sql table created for updating rate_based_flag in pa_resource_assignments.
4462: TYPE update_rbf_tbl IS TABLE OF update_rbf_rec;
4463: l_upd_rbf_tbl update_rbf_tbl;
4464:

Line 4461: --pl/sql table created for updating rate_based_flag in pa_resource_assignments.

4457:
4458: --Record created for updating rate_based_flag in pa_resource_assignments.
4459: TYPE update_rbf_rec IS RECORD( ra_id pa_resource_assignments.resource_assignment_id%TYPE,
4460: rate_based_flag pa_resource_assignments.rate_based_flag%TYPE);
4461: --pl/sql table created for updating rate_based_flag in pa_resource_assignments.
4462: TYPE update_rbf_tbl IS TABLE OF update_rbf_rec;
4463: l_upd_rbf_tbl update_rbf_tbl;
4464:
4465: TYPE description_tbl IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(30);

Line 4793: pa_resource_assignments pra

4789: ,l_txn_src_code_tbl
4790: ,l_planning_end_date_tbl_1
4791: ,l_etc_source_tbl
4792: FROM pa_resource_asgn_curr prac,
4793: pa_resource_assignments pra
4794: WHERE prac.budget_version_id = p_budget_version_id
4795: AND pra.budget_version_id = p_budget_version_id
4796: AND prac.resource_assignment_id = pra.resource_assignment_id;
4797:

Line 5573: --Update the rate_based_flag in pa_resource_assignments.

5569: AND period_name = NVL(l_del_bud_line_tbl(i).period_name , period_name);
5570: END LOOP;
5571: END IF;
5572:
5573: --Update the rate_based_flag in pa_resource_assignments.
5574: IF l_upd_rbf_tbl.COUNT > 0 THEN
5575:
5576: FOR upd IN l_upd_rbf_tbl.FIRST..l_upd_rbf_tbl.LAST LOOP
5577: UPDATE pa_resource_assignments

Line 5577: UPDATE pa_resource_assignments

5573: --Update the rate_based_flag in pa_resource_assignments.
5574: IF l_upd_rbf_tbl.COUNT > 0 THEN
5575:
5576: FOR upd IN l_upd_rbf_tbl.FIRST..l_upd_rbf_tbl.LAST LOOP
5577: UPDATE pa_resource_assignments
5578: SET rate_based_flag = 'Y'
5579: WHERE resource_assignment_id = l_upd_rbf_tbl(upd).ra_id;
5580: END LOOP;
5581: END IF;

Line 5597: UPDATE pa_resource_assignments

5593:
5594: IF l_upd_rbf_tbl_1.count > 0 THEN
5595:
5596: FORALL upd IN 1..l_upd_rbf_tbl_1.COUNT
5597: UPDATE pa_resource_assignments
5598: SET rate_based_flag = 'Y'
5599: WHERE resource_assignment_id = l_upd_rbf_tbl_1(upd);
5600: END IF;
5601: