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_WP_GEN_BUDGET_AMT_PUB dependencies on PA_PROJECTS_ALL

Line 55: l_stru_sharing_code pa_projects_all.STRUCTURE_SHARING_CODE%TYPE;

51: l_msg_data VARCHAR2(2000);
52: l_data VARCHAR2(2000);
53: l_msg_index_out NUMBER;
54:
55: l_stru_sharing_code pa_projects_all.STRUCTURE_SHARING_CODE%TYPE;
56:
57: /* Flag parameters for calling Calculate API */
58: l_calculate_api_code VARCHAR2(30);
59: l_refresh_rates_flag VARCHAR2(1);

Line 116: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE ,

112: when multi currency is enabled, then take transaction currency and amts,
113: when target is approved budget version, then take projfunc currency and amts.
114: Don't pick up amounts for budget lines with non-null rejection codes. */
115: CURSOR budget_line_src_to_cal
116: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE ,
117: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
118:
119: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
120: ra.resource_assignment_id,

Line 117: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS

113: when target is approved budget version, then take projfunc currency and amts.
114: Don't pick up amounts for budget lines with non-null rejection codes. */
115: CURSOR budget_line_src_to_cal
116: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE ,
117: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
118:
119: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
120: ra.resource_assignment_id,
121: ra.rate_based_flag,

Line 218: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE

214:
215: /* Added for bug #4938603 */
216: CURSOR fcst_bdgt_line_actual_qty
217: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
218: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
219: ) IS
220: SELECT sum(nvl(init_quantity,0))
221: FROM pa_budget_lines
222: WHERE resource_assignment_id = c_res_asgn_id

Line 251: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

247: * mirorred here. See comments above the other cursor for more info.
248: * This cursor differs from the other one in that it only picks up source
249: * data with starting date after the forecast's actuals through period. */
250: CURSOR fcst_budget_line_src_to_cal
251: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
252: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
253: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
254: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
255: ra.resource_assignment_id,

Line 252: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

248: * This cursor differs from the other one in that it only picks up source
249: * data with starting date after the forecast's actuals through period. */
250: CURSOR fcst_budget_line_src_to_cal
251: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
252: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
253: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
254: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
255: ra.resource_assignment_id,
256: ra.rate_based_flag,

Line 322: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

318: -- Source time phasing is None. When Source time phasing is PA or GL,
319: -- use the fcst_budget_line_src_to_cal cursor. For more comments/details,
320: -- please see the other cursor.
321: CURSOR fcst_bdgt_line_src_to_cal_none
322: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
323: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
324: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
325: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
326: ra.resource_assignment_id,

Line 323: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

319: -- use the fcst_budget_line_src_to_cal cursor. For more comments/details,
320: -- please see the other cursor.
321: CURSOR fcst_bdgt_line_src_to_cal_none
322: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
323: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
324: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
325: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
326: ra.resource_assignment_id,
327: ra.rate_based_flag,

Line 2805: CURSOR budget_line_src_tgt(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

2801: /*when multi currency is not enabled, then take project currency and amts,
2802: when multi currency is enabled, then take transaction currency and amts,
2803: when target is approved budget version, then take projfunc currency and amts.
2804: Don't pick up amounts for budget lines with non-null rejection codes. */
2805: CURSOR budget_line_src_tgt(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2806: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
2807: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2808: ra.resource_assignment_id,
2809: ra.rate_based_flag,

Line 2806: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS

2802: when multi currency is enabled, then take transaction currency and amts,
2803: when target is approved budget version, then take projfunc currency and amts.
2804: Don't pick up amounts for budget lines with non-null rejection codes. */
2805: CURSOR budget_line_src_tgt(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2806: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
2807: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2808: ra.resource_assignment_id,
2809: ra.rate_based_flag,
2810: sbl.start_date,

Line 2930: CURSOR budget_line_src_tgt_none(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

2926: NVL(ta.billable_flag,'Y'); /* Added for ER 4376722 */
2927:
2928: --Start Changes Bug 6411406
2929: -- Created this cursor for non time phased scenario while generation of budget line.
2930: CURSOR budget_line_src_tgt_none(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2931: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
2932: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2933: ra.resource_assignment_id,
2934: ra.rate_based_flag,

Line 2931: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS

2927:
2928: --Start Changes Bug 6411406
2929: -- Created this cursor for non time phased scenario while generation of budget line.
2930: CURSOR budget_line_src_tgt_none(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2931: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
2932: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2933: ra.resource_assignment_id,
2934: ra.rate_based_flag,
2935: ra.planning_start_date,

Line 3025: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3021: * mirorred here. See comments above the other cursor for more info.
3022: * This cursor differs from the other one in that it only picks up source
3023: * data with starting date after the forecast's actuals through period. */
3024: CURSOR fcst_budget_line_src_tgt
3025: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3026: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3027: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
3028: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
3029: ra.resource_assignment_id,

Line 3026: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3022: * This cursor differs from the other one in that it only picks up source
3023: * data with starting date after the forecast's actuals through period. */
3024: CURSOR fcst_budget_line_src_tgt
3025: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3026: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3027: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
3028: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
3029: ra.resource_assignment_id,
3030: ra.rate_based_flag,

Line 3122: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3118: -- use the fcst_budget_line_src_tgt cursor. For more comments/details,
3119: -- please see the other cursor.
3120:
3121: CURSOR fcst_budget_line_src_tgt_none
3122: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3123: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3124: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
3125: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
3126: ra.resource_assignment_id,

Line 3123: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3119: -- please see the other cursor.
3120:
3121: CURSOR fcst_budget_line_src_tgt_none
3122: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3123: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3124: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
3125: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
3126: ra.resource_assignment_id,
3127: ra.rate_based_flag,

Line 3215: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE

3211:
3212: /* Added for bug #4938603 */
3213: CURSOR fcst_bdgt_line_actual_qty
3214: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
3215: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
3216: ) IS
3217: SELECT sum(nvl(init_quantity,0))
3218: FROM pa_budget_lines
3219: WHERE resource_assignment_id = c_res_asgn_id

Line 5663: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,

5659: * Lastly, this description should be updated any time the layout of
5660: * x_calculate_api_code is modified.
5661: */
5662: PROCEDURE GET_CALC_API_FLAG_PARAMS
5663: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
5664: P_FP_COLS_REC_SOURCE IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5665: P_FP_COLS_REC_TARGET IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5666: P_CALLING_CONTEXT IN VARCHAR2,
5667: X_CALCULATE_API_CODE OUT NOCOPY VARCHAR2,