APPS.PA_FP_MAINTAIN_ACTUAL_PUB dependencies on PA_PROG_ACT_BY_PERIOD_TEMP

Line 6: /**MAINTAIN_ACTUAL_AMT_WRP will get value from PA_PROG_ACT_BY_PERIOD_TEMP view*

2: /* $Header: PAFPMAPB.pls 120.16 2007/04/13 16:17:29 rthumma noship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5:
6: /**MAINTAIN_ACTUAL_AMT_WRP will get value from PA_PROG_ACT_BY_PERIOD_TEMP view*
7: *Populate init columns in PA_BUDGET_LINES. *
8: *Valid values for parameter P_CALLING_CONTEXT are:*
9: * WP_PROGRESS -- Work plan progress *
10: * WP_SUMMARIZED_ACTUAL -- Work plan summarized actual transactions *

Line 46: FROM PA_PROG_ACT_BY_PERIOD_TEMP vw,

42: bv.budget_version_id,
43: vw.STRUCTURE_VERSION_ID,
44: vw.RESOURCE_ASSIGNMENT_ID,
45: vw.TXN_CURRENCY_CODE
46: FROM PA_PROG_ACT_BY_PERIOD_TEMP vw,
47: PA_BUDGET_VERSIONS bv,
48: PA_RESOURCE_ASSIGNMENTS ra
49: WHERE bv.project_structure_version_id = vw.structure_version_id
50: AND nvl(bv.wp_version_flag,'N') = 'Y' AND

Line 62: FROM PA_PROG_ACT_BY_PERIOD_TEMP vw,

58: bv.budget_version_id,
59: vw.STRUCTURE_VERSION_ID,
60: vw.HIDDEN_RES_ASSGN_ID,
61: vw.TXN_CURRENCY_CODE
62: FROM PA_PROG_ACT_BY_PERIOD_TEMP vw,
63: PA_BUDGET_VERSIONS bv,
64: PA_RESOURCE_ASSIGNMENTS ra
65: WHERE bv.project_structure_version_id = vw.structure_version_id
66: AND nvl(bv.wp_version_flag,'N') = 'Y' AND

Line 88: FROM PA_PROG_ACT_BY_PERIOD_TEMP

84: actual_rawcost_pc,
85: actual_rawcost_fc,
86: start_date,
87: finish_date
88: FROM PA_PROG_ACT_BY_PERIOD_TEMP
89: WHERE structure_version_id = p_struct_ver_id
90: AND nvl(resource_assignment_id,HIDDEN_RES_ASSGN_ID) = p_res_asg_id
91: AND txn_currency_code = p_txn_currency_code;
92:

Line 255: FROM PA_PROG_ACT_BY_PERIOD_TEMP

251:
252: SELECT DISTINCT NVL(resource_assignment_id, hidden_res_assgn_id)
253: BULK COLLECT
254: INTO l_ra_id_upd_reprt_tab
255: FROM PA_PROG_ACT_BY_PERIOD_TEMP
256: WHERE project_id = P_PROJECT_ID_TAB(ss1)
257: AND structure_version_id = P_WP_STR_VERSION_ID_TAB(ss1)
258: AND NVL(resource_assignment_id, hidden_res_assgn_id) IS NOT NULL;
259:

Line 635: delete from PA_PROG_ACT_BY_PERIOD_TEMP where project_id = P_PROJECT_ID_TAB(ss1) and structure_version_id = P_WP_STR_VERSION_ID_TAB(ss1);

631: END LOOP;
632:
633: -- 5294838 : Added beloe code to delete temp table
634: FOR ss1 IN 1 .. P_PROJECT_ID_TAB.COUNT LOOP
635: delete from PA_PROG_ACT_BY_PERIOD_TEMP where project_id = P_PROJECT_ID_TAB(ss1) and structure_version_id = P_WP_STR_VERSION_ID_TAB(ss1);
636: end loop;
637:
638: IF p_pa_debug_mode = 'Y' AND p_init_msg_flag = 'Y' THEN
639: PA_DEBUG.reset_err_stack;

Line 2657: PA_PROG_ACT_BY_PERIOD_TEMP t

2653: ra.planning_end_date,
2654: min(t.start_date),
2655: max(t.finish_date)
2656: FROM pa_resource_assignments ra,
2657: PA_PROG_ACT_BY_PERIOD_TEMP t
2658: WHERE ra.resource_assignment_id =
2659: nvl(t.resource_assignment_id,t.HIDDEN_RES_ASSGN_ID)
2660: AND ra.budget_version_id = p_budget_version_id
2661: GROUP BY ra.resource_assignment_id,