APPS.PA_FP_COPY_FROM_PKG dependencies on PA_FP_CPY_PERIODS_TMP

Line 7236: DELETE FROM pa_fp_cpy_periods_tmp;

7232: l_end_date DATE;
7233:
7234: BEGIN
7235:
7236: DELETE FROM pa_fp_cpy_periods_tmp;
7237:
7238: FOR i IN bl_periods LOOP
7239:
7240: l_period_name := NULL;

Line 7268: INSERT INTO pa_fp_cpy_periods_tmp

7264: p_msg_name => l_err_stage);
7265: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7266: END IF;
7267:
7268: INSERT INTO pa_fp_cpy_periods_tmp
7269: (PA_PERIOD_NAME
7270: ,GL_PERIOD_NAME
7271: ,PERIOD_NAME
7272: ,START_DATE

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

7808: ELSE
7809:
7810: /* Start of code fix for bug# 2634726 */
7811:
7812: -- Call a private api to populate pa_fp_cpy_periods_tmp table
7813: populate_cpy_periods_tmp(p_budget_version_id => p_source_plan_version_id,
7814: p_period_type => l_target_time_phased_code,
7815: p_shift_periods => l_periods);
7816:

Line 7820: -- pa_fp_cpy_periods_tmp

7816:
7817: -- Shift the pa_periods by l_periods
7818: -- Bug# 2634726- The two individual inserts which read pa_periods or gl_period_statuses based
7819: -- on the l_target_time_phased_code condition have been merged into one insert which reads
7820: -- pa_fp_cpy_periods_tmp
7821:
7822: INSERT INTO PA_BUDGET_LINES(
7823: budget_line_id /* FPB2 */
7824: ,budget_version_id /* FPB2 */

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

8055: ,NULL -- pc_cur_conv_rejection_code
8056: ,NULL -- pfc_cur_conv_rejection_code
8057: FROM PA_BUDGET_LINES pbl
8058: ,pa_resource_assignments pra
8059: ,PA_FP_CPY_PERIODS_TMP pptmp /* Bug# 2634726 */
8060: WHERE pra.parent_assignment_id = pbl.resource_assignment_id
8061: AND decode(l_target_time_phased_code,
8062: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P, pptmp.pa_period_name,
8063: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G, pptmp.gl_period_name) = pbl.period_name