APPS.PA_FP_COPY_FROM_PKG dependencies on PA_FP_CPY_PERIODS_TMP

Line 7253: DELETE FROM pa_fp_cpy_periods_tmp;

7249: l_end_date DATE;
7250:
7251: BEGIN
7252:
7253: DELETE FROM pa_fp_cpy_periods_tmp;
7254:
7255: FOR i IN bl_periods LOOP
7256:
7257: l_period_name := NULL;

Line 7286: INSERT INTO pa_fp_cpy_periods_tmp

7282: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7283: END IF;
7284:
7285: If (l_period_name IS NOT NULL) then -- Added if condition for Bug 7556248 --Bug 9062715
7286: INSERT INTO pa_fp_cpy_periods_tmp
7287: (PA_PERIOD_NAME
7288: ,GL_PERIOD_NAME
7289: ,PERIOD_NAME
7290: ,START_DATE

Line 7839: -- Call a private api to populate pa_fp_cpy_periods_tmp table

7835: ELSE
7836:
7837: /* Start of code fix for bug# 2634726 */
7838:
7839: -- Call a private api to populate pa_fp_cpy_periods_tmp table
7840: populate_cpy_periods_tmp(p_budget_version_id => p_source_plan_version_id,
7841: p_period_type => l_target_time_phased_code,
7842: p_shift_periods => l_periods);
7843:

Line 7847: -- pa_fp_cpy_periods_tmp

7843:
7844: -- Shift the pa_periods by l_periods
7845: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based
7846: -- on the l_target_time_phased_code condition have been merged into one insert which reads
7847: -- pa_fp_cpy_periods_tmp
7848:
7849: INSERT INTO PA_BUDGET_LINES(
7850: budget_line_id /* FPB2 */
7851: ,budget_version_id /* FPB2 */

Line 8086: ,PA_FP_CPY_PERIODS_TMP pptmp /* Bug# 2634726 */

8082: ,NULL -- pc_cur_conv_rejection_code
8083: ,NULL -- pfc_cur_conv_rejection_code
8084: FROM PA_BUDGET_LINES pbl
8085: ,pa_resource_assignments pra
8086: ,PA_FP_CPY_PERIODS_TMP pptmp /* Bug# 2634726 */
8087: WHERE pra.parent_assignment_id = pbl.resource_assignment_id
8088: AND decode(l_target_time_phased_code,
8089: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P, pptmp.pa_period_name,
8090: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G, pptmp.gl_period_name) = pbl.period_name