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 1006: P_TASK_ID IN PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE,

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

Line 1026: FROM pa_resource_assignments ra

1022: ra.cbs_element_id, --bug#16791711
1023: ra.planning_start_date,
1024: ra.planning_end_date,
1025: p_task_id
1026: FROM pa_resource_assignments ra
1027: WHERE c_task_id_flag = 'Y' AND
1028: ra.budget_version_id = P_BUDGET_VERSION_ID
1029: AND ra.task_id = P_TASK_ID
1030: UNION ALL

Line 1037: FROM pa_resource_assignments ra

1033: ra.cbs_element_id, --bug#16791711
1034: ra.planning_start_date,
1035: ra.planning_end_date,
1036: ra.task_id
1037: FROM pa_resource_assignments ra
1038: WHERE c_task_id_flag = 'N' AND
1039: ra.budget_version_id = P_BUDGET_VERSION_ID;
1040:
1041: -- Bug 4040832, 3970800: Modified project-level cursor to get

Line 1052: pa_resource_assignments ra

1048: ra.planning_start_date,
1049: ra.planning_end_date,
1050: tmp.project_element_id
1051: FROM PA_FP_FCST_GEN_TMP1 tmp,
1052: pa_resource_assignments ra
1053: WHERE tmp.project_element_id = p_task_id AND
1054: ra.budget_version_id = P_BUDGET_VERSION_ID AND
1055: NVL(ra.task_id,0) = 0 AND
1056: ra.resource_list_member_id = tmp.res_list_member_id AND

Line 1070: FROM pa_resource_assignments ra

1066: ra.cbs_element_id, --bug#16791711
1067: ra.planning_start_date,
1068: ra.planning_end_date,
1069: p_task_id
1070: FROM pa_resource_assignments ra
1071: WHERE c_task_id_flag = 'Y' AND
1072: ra.budget_version_id = P_BUDGET_VERSION_ID
1073: AND ra.task_id = P_TASK_ID
1074: AND ( ra.transaction_source_code IS NOT NULL

Line 1089: FROM pa_resource_assignments ra

1085: ra.cbs_element_id, --bug#16791711
1086: ra.planning_start_date,
1087: ra.planning_end_date,
1088: ra.task_id
1089: FROM pa_resource_assignments ra
1090: WHERE c_task_id_flag = 'N' AND
1091: ra.budget_version_id = P_BUDGET_VERSION_ID
1092: AND ( ra.transaction_source_code IS NOT NULL
1093: OR ( ra.transaction_source_code IS NULL

Line 1108: FROM pa_resource_assignments ra

1104: ra.cbs_element_id, --bug#16791711
1105: ra.planning_start_date,
1106: ra.planning_end_date,
1107: p_task_id
1108: FROM pa_resource_assignments ra
1109: WHERE c_task_id_flag = 'Y' AND
1110: ra.budget_version_id = P_BUDGET_VERSION_ID
1111: AND ra.task_id = P_TASK_ID
1112: AND ( ra.transaction_source_code IS NOT NULL

Line 1127: FROM pa_resource_assignments ra

1123: ra.cbs_element_id, --bug#16791711
1124: ra.planning_start_date,
1125: ra.planning_end_date,
1126: ra.task_id
1127: FROM pa_resource_assignments ra
1128: WHERE c_task_id_flag = 'N' AND
1129: ra.budget_version_id = P_BUDGET_VERSION_ID
1130: AND ( ra.transaction_source_code IS NOT NULL
1131: OR ( ra.transaction_source_code IS NULL

Line 1148: pa_resource_assignments ra

1144: ra.planning_start_date,
1145: ra.planning_end_date,
1146: tmp.project_element_id
1147: FROM PA_FP_FCST_GEN_TMP1 tmp,
1148: pa_resource_assignments ra
1149: WHERE tmp.project_element_id = p_task_id AND
1150: ra.budget_version_id = P_BUDGET_VERSION_ID AND
1151: NVL(ra.task_id,0) = 0 AND
1152: ra.resource_list_member_id = tmp.res_list_member_id

Line 1172: pa_resource_assignments ra

1168: ra.planning_start_date,
1169: ra.planning_end_date,
1170: tmp.project_element_id
1171: FROM PA_FP_FCST_GEN_TMP1 tmp,
1172: pa_resource_assignments ra
1173: WHERE tmp.project_element_id = p_task_id AND
1174: ra.budget_version_id = P_BUDGET_VERSION_ID AND
1175: NVL(ra.task_id,0) = 0 AND
1176: ra.resource_list_member_id = tmp.res_list_member_id

Line 1424: UPDATE pa_resource_assignments

1420:
1421: -- Bug 4165701: Since the generation source is Average of Actuals, we
1422: -- need to NULL out the spread curves of the generated resources.
1423: FORALL i IN 1..l_res_asg_id_tab.count
1424: UPDATE pa_resource_assignments
1425: SET spread_curve_id = NULL,
1426: sp_fixed_date = NULL,
1427: transaction_source_code = 'AVERAGE_ACTUALS' -- bug 4232619
1428: WHERE resource_assignment_id = l_res_asg_id_tab(i);

Line 3708: FROM pa_resource_assignments ra

3704:
3705: INSERT INTO pa_resource_asgn_curr_tmp
3706: ( resource_assignment_id )
3707: SELECT ra.resource_assignment_id
3708: FROM pa_resource_assignments ra
3709: WHERE ra.budget_version_id = p_budget_version_id
3710: AND ra.transaction_source_code IS NOT NULL;
3711:
3712: IF p_pa_debug_mode = 'Y' THEN

Line 3752: FROM pa_resource_assignments ra,

3748: bl.txn_currency_code,
3749: rbc.txn_raw_cost_rate_override,
3750: rbc.txn_burden_cost_rate_override,
3751: rbc.txn_bill_rate_override
3752: FROM pa_resource_assignments ra,
3753: pa_budget_lines bl,
3754: pa_resource_asgn_curr rbc
3755: WHERE ra.budget_version_id = p_budget_version_id
3756: AND ra.project_id = p_project_id

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

3858: END IF;
3859:
3860: END IF; -- IPM logic
3861:
3862: -- IPM: Delete records from PA_RESOURCE_ASSIGNMENTS that:
3863: -- 1. Do not have budget lines.
3864: -- 2. Have a non-null transaction_source_code.
3865: -- 3. Do not have a record in the PA_RESOURCE_ASGN_CURR table.
3866: -- In this way, we can ensure that all records in the resource

Line 3870: DELETE FROM pa_resource_assignments ra

3866: -- In this way, we can ensure that all records in the resource
3867: -- assignments table have a corresponding records in the new
3868: -- pa_resource_asgn_curr entity.
3869:
3870: DELETE FROM pa_resource_assignments ra
3871: WHERE ra.budget_version_id = p_budget_version_id
3872: AND ra.transaction_source_code IS NOT NULL
3873: AND NOT EXISTS (SELECT null
3874: FROM pa_budget_lines bl

Line 4189: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,

4185:
4186: PROCEDURE GET_WP_ACTUALS_FOR_RA
4187: (P_FP_COLS_SRC_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4188: P_FP_COLS_TGT_REC IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
4189: P_SRC_RES_ASG_ID IN PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
4190: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE,
4191: P_RES_LIST_MEM_ID IN PA_RESOURCE_LIST_MEMBERS.RESOURCE_LIST_MEMBER_ID%TYPE,
4192: P_ACTUALS_THRU_DATE IN DATE,
4193: X_ACT_QUANTITY OUT NOCOPY NUMBER,

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

4478:
4479: TYPE del_bud_line_tbl IS TABLE OF del_bud_line_rec;
4480: l_del_bud_line_tbl del_bud_line_tbl := del_bud_line_tbl();
4481:
4482: --Record created for updating rate_based_flag in pa_resource_assignments.
4483: TYPE update_rbf_rec IS RECORD( ra_id pa_resource_assignments.resource_assignment_id%TYPE,
4484: rate_based_flag pa_resource_assignments.rate_based_flag%TYPE);
4485: --pl/sql table created for updating rate_based_flag in pa_resource_assignments.
4486: TYPE update_rbf_tbl IS TABLE OF update_rbf_rec;

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

4479: TYPE del_bud_line_tbl IS TABLE OF del_bud_line_rec;
4480: l_del_bud_line_tbl del_bud_line_tbl := del_bud_line_tbl();
4481:
4482: --Record created for updating rate_based_flag in pa_resource_assignments.
4483: TYPE update_rbf_rec IS RECORD( ra_id pa_resource_assignments.resource_assignment_id%TYPE,
4484: rate_based_flag pa_resource_assignments.rate_based_flag%TYPE);
4485: --pl/sql table created for updating rate_based_flag in pa_resource_assignments.
4486: TYPE update_rbf_tbl IS TABLE OF update_rbf_rec;
4487: l_upd_rbf_tbl update_rbf_tbl;

Line 4484: rate_based_flag pa_resource_assignments.rate_based_flag%TYPE);

4480: l_del_bud_line_tbl del_bud_line_tbl := del_bud_line_tbl();
4481:
4482: --Record created for updating rate_based_flag in pa_resource_assignments.
4483: TYPE update_rbf_rec IS RECORD( ra_id pa_resource_assignments.resource_assignment_id%TYPE,
4484: rate_based_flag pa_resource_assignments.rate_based_flag%TYPE);
4485: --pl/sql table created for updating rate_based_flag in pa_resource_assignments.
4486: TYPE update_rbf_tbl IS TABLE OF update_rbf_rec;
4487: l_upd_rbf_tbl update_rbf_tbl;
4488:

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

4481:
4482: --Record created for updating rate_based_flag in pa_resource_assignments.
4483: TYPE update_rbf_rec IS RECORD( ra_id pa_resource_assignments.resource_assignment_id%TYPE,
4484: rate_based_flag pa_resource_assignments.rate_based_flag%TYPE);
4485: --pl/sql table created for updating rate_based_flag in pa_resource_assignments.
4486: TYPE update_rbf_tbl IS TABLE OF update_rbf_rec;
4487: l_upd_rbf_tbl update_rbf_tbl;
4488:
4489: TYPE description_tbl IS TABLE OF VARCHAR2(30) INDEX BY VARCHAR2(30);

Line 4817: pa_resource_assignments pra

4813: ,l_txn_src_code_tbl
4814: ,l_planning_end_date_tbl_1
4815: ,l_etc_source_tbl
4816: FROM pa_resource_asgn_curr prac,
4817: pa_resource_assignments pra
4818: WHERE prac.budget_version_id = p_budget_version_id
4819: AND pra.budget_version_id = p_budget_version_id
4820: AND prac.resource_assignment_id = pra.resource_assignment_id;
4821:

Line 5677: --Update the rate_based_flag in pa_resource_assignments.

5673: AND period_name = NVL(l_del_bud_line_tbl(i).period_name , period_name);
5674: END LOOP;
5675: END IF;
5676:
5677: --Update the rate_based_flag in pa_resource_assignments.
5678: IF l_upd_rbf_tbl.COUNT > 0 THEN
5679:
5680: FOR upd IN l_upd_rbf_tbl.FIRST..l_upd_rbf_tbl.LAST LOOP
5681: UPDATE pa_resource_assignments

Line 5681: UPDATE pa_resource_assignments

5677: --Update the rate_based_flag in pa_resource_assignments.
5678: IF l_upd_rbf_tbl.COUNT > 0 THEN
5679:
5680: FOR upd IN l_upd_rbf_tbl.FIRST..l_upd_rbf_tbl.LAST LOOP
5681: UPDATE pa_resource_assignments
5682: SET rate_based_flag = 'Y'
5683: WHERE resource_assignment_id = l_upd_rbf_tbl(upd).ra_id;
5684: END LOOP;
5685: END IF;

Line 5701: UPDATE pa_resource_assignments

5697:
5698: IF l_upd_rbf_tbl_1.count > 0 THEN
5699:
5700: FORALL upd IN 1..l_upd_rbf_tbl_1.COUNT
5701: UPDATE pa_resource_assignments
5702: SET rate_based_flag = 'Y'
5703: WHERE resource_assignment_id = l_upd_rbf_tbl_1(upd);
5704: END IF;
5705: