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_EDIT_LINE_PKG dependencies on PA_FP_CPY_PERIODS_TMP

Line 1139: So, bucketing period code can be derived by comparing the start date in pa_fp_cpy_periods_tmp

1135:
1136: IF l_period_profile_id IS NOT NULL THEN
1137:
1138: /* Bug 2672548 - We are deriving the PD / SD info even when budget lines doesnt exists.
1139: So, bucketing period code can be derived by comparing the start date in pa_fp_cpy_periods_tmp
1140: with the derived preceding / succeeding information. */
1141:
1142: INSERT INTO PA_FP_ROLLUP_TMP
1143: ( ROLLUP_ID

Line 1357: ,pa_fp_cpy_periods_tmp tmp

1353: ,pbl.REVENUE_SOURCE
1354: ,pbl.PM_PRODUCT_CODE
1355: FROM pa_resource_assignments pra
1356: ,pa_budget_lines pbl
1357: ,pa_fp_cpy_periods_tmp tmp
1358: WHERE pra.resource_assignment_id = p_resource_assignment_id
1359: AND pbl.resource_assignment_id(+) = p_resource_assignment_id
1360: AND pbl.start_date(+) = tmp.start_date
1361: AND pbl.txn_currency_code(+) = p_txn_currency_code);

Line 2996: delete from pa_fp_cpy_periods_tmp;

2992: IF P_PA_DEBUG_MODE = 'Y' THEN
2993: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2994: END IF;
2995:
2996: delete from pa_fp_cpy_periods_tmp;
2997:
2998: pa_debug.g_err_stage:='deleted '||sql%rowcount || ' records from tmp table' ;
2999: IF P_PA_DEBUG_MODE = 'Y' THEN
3000: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 3006: pa_debug.g_err_stage:='Populating pa_fp_cpy_periods_tmp in the case of pa_period time phasing';

3002:
3003:
3004: IF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN
3005:
3006: pa_debug.g_err_stage:='Populating pa_fp_cpy_periods_tmp in the case of pa_period time phasing';
3007: IF P_PA_DEBUG_MODE = 'Y' THEN
3008: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3009: END IF;
3010:

Line 3013: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for preceding period' ;

3009: END IF;
3010:
3011: IF p_preceding_prd_start_date IS NOT NULL THEN
3012:
3013: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for preceding period' ;
3014: IF P_PA_DEBUG_MODE = 'Y' THEN
3015: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3016: END IF;
3017:

Line 3018: INSERT INTO pa_fp_cpy_periods_tmp

3014: IF P_PA_DEBUG_MODE = 'Y' THEN
3015: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3016: END IF;
3017:
3018: INSERT INTO pa_fp_cpy_periods_tmp
3019: ( start_date
3020: ,end_date
3021: ,pa_period_name
3022: ,gl_period_name

Line 3034: INSERT INTO pa_fp_cpy_periods_tmp

3030: WHERE start_date = p_preceding_prd_start_date;
3031:
3032: END IF;
3033:
3034: INSERT INTO pa_fp_cpy_periods_tmp
3035: ( start_date
3036: ,end_date
3037: ,pa_period_name
3038: ,gl_period_name

Line 3055: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for succeeding period' ;

3051: END IF;
3052:
3053: IF p_succeeding_prd_start_date IS NOT NULL THEN
3054:
3055: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for succeeding period' ;
3056: IF P_PA_DEBUG_MODE = 'Y' THEN
3057: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3058: END IF;
3059:

Line 3060: INSERT INTO pa_fp_cpy_periods_tmp

3056: IF P_PA_DEBUG_MODE = 'Y' THEN
3057: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3058: END IF;
3059:
3060: INSERT INTO pa_fp_cpy_periods_tmp
3061: ( start_date
3062: ,end_date
3063: ,pa_period_name
3064: ,gl_period_name

Line 3078: pa_debug.g_err_stage:='Populating pa_fp_cpy_periods_tmp in the case of gl_period time phasing';

3074: END IF;
3075:
3076: ELSIF l_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G THEN
3077:
3078: pa_debug.g_err_stage:='Populating pa_fp_cpy_periods_tmp in the case of gl_period time phasing';
3079: IF P_PA_DEBUG_MODE = 'Y' THEN
3080: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,3);
3081: END IF;
3082:

Line 3086: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for preceding period' ;

3082:
3083:
3084: IF p_preceding_prd_start_date IS NOT NULL THEN
3085:
3086: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for preceding period' ;
3087: IF P_PA_DEBUG_MODE = 'Y' THEN
3088: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3089: END IF;
3090:

Line 3091: INSERT INTO pa_fp_cpy_periods_tmp

3087: IF P_PA_DEBUG_MODE = 'Y' THEN
3088: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3089: END IF;
3090:
3091: INSERT INTO pa_fp_cpy_periods_tmp
3092: ( start_date
3093: ,end_date
3094: ,pa_period_name
3095: ,gl_period_name

Line 3111: INSERT INTO pa_fp_cpy_periods_tmp(

3107: AND g.start_date = p_preceding_prd_start_date;
3108:
3109: END IF;
3110:
3111: INSERT INTO pa_fp_cpy_periods_tmp(
3112: start_date
3113: ,end_date
3114: ,pa_period_name
3115: ,gl_period_name

Line 3136: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for preceding period' ;

3132: END IF;
3133:
3134: IF p_succeeding_prd_start_date IS NOT NULL THEN
3135:
3136: pa_debug.g_err_stage:='inserting into pa_fp_cpy_periods_tmp for preceding period' ;
3137: IF P_PA_DEBUG_MODE = 'Y' THEN
3138: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3139: END IF;
3140:

Line 3141: INSERT INTO pa_fp_cpy_periods_tmp

3137: IF P_PA_DEBUG_MODE = 'Y' THEN
3138: pa_debug.write('POPULATE_ELIGIBLE_PERIODS: ' || l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
3139: END IF;
3140:
3141: INSERT INTO pa_fp_cpy_periods_tmp
3142: ( start_date
3143: ,end_date
3144: ,pa_period_name
3145: ,gl_period_name