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 183: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE

179:
180: /* Added for bug #4938603 */
181: CURSOR fcst_bdgt_line_actual_qty
182: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
183: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
184: ) IS
185: SELECT sum(nvl(init_quantity,0))
186: FROM pa_budget_lines
187: WHERE resource_assignment_id = c_res_asgn_id

Line 216: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

212: * mirorred here. See comments above the other cursor for more info.
213: * This cursor differs from the other one in that it only picks up source
214: * data with starting date after the forecast's actuals through period. */
215: CURSOR fcst_budget_line_src_to_cal
216: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
217: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
218: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
219: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
220: ra.resource_assignment_id,

Line 217: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

213: * This cursor differs from the other one in that it only picks up source
214: * data with starting date after the forecast's actuals through period. */
215: CURSOR fcst_budget_line_src_to_cal
216: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
217: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
218: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
219: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
220: ra.resource_assignment_id,
221: ra.rate_based_flag,

Line 287: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

283: -- Source time phasing is None. When Source time phasing is PA or GL,
284: -- use the fcst_budget_line_src_to_cal cursor. For more comments/details,
285: -- please see the other cursor.
286: CURSOR fcst_bdgt_line_src_to_cal_none
287: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
288: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
289: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
290: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
291: ra.resource_assignment_id,

Line 288: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

284: -- use the fcst_budget_line_src_to_cal cursor. For more comments/details,
285: -- please see the other cursor.
286: CURSOR fcst_bdgt_line_src_to_cal_none
287: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
288: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
289: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
290: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
291: ra.resource_assignment_id,
292: ra.rate_based_flag,

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

2759: /*when multi currency is not enabled, then take project currency and amts,
2760: when multi currency is enabled, then take transaction currency and amts,
2761: when target is approved budget version, then take projfunc currency and amts.
2762: Don't pick up amounts for budget lines with non-null rejection codes. */
2763: CURSOR budget_line_src_tgt(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2764: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
2765: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2766: ra.resource_assignment_id,
2767: ra.rate_based_flag,

Line 2764: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS

2760: when multi currency is enabled, then take transaction currency and amts,
2761: when target is approved budget version, then take projfunc currency and amts.
2762: Don't pick up amounts for budget lines with non-null rejection codes. */
2763: CURSOR budget_line_src_tgt(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2764: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
2765: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2766: ra.resource_assignment_id,
2767: ra.rate_based_flag,
2768: sbl.start_date,

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

2849: NVL(ta.billable_flag,'Y'); /* Added for ER 4376722 */
2850:
2851: --Start Changes Bug 6411406
2852: -- Created this cursor for non time phased scenario while generation of budget line.
2853: CURSOR budget_line_src_tgt_none(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2854: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
2855: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2856: ra.resource_assignment_id,
2857: ra.rate_based_flag,

Line 2854: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS

2850:
2851: --Start Changes Bug 6411406
2852: -- Created this cursor for non time phased scenario while generation of budget line.
2853: CURSOR budget_line_src_tgt_none(c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2854: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE) IS
2855: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2856: ra.resource_assignment_id,
2857: ra.rate_based_flag,
2858: ra.planning_start_date,

Line 2947: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

2943: * mirorred here. See comments above the other cursor for more info.
2944: * This cursor differs from the other one in that it only picks up source
2945: * data with starting date after the forecast's actuals through period. */
2946: CURSOR fcst_budget_line_src_tgt
2947: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2948: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2949: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
2950: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2951: ra.resource_assignment_id,

Line 2948: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

2944: * This cursor differs from the other one in that it only picks up source
2945: * data with starting date after the forecast's actuals through period. */
2946: CURSOR fcst_budget_line_src_tgt
2947: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2948: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
2949: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
2950: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
2951: ra.resource_assignment_id,
2952: ra.rate_based_flag,

Line 3044: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3040: -- use the fcst_budget_line_src_tgt cursor. For more comments/details,
3041: -- please see the other cursor.
3042:
3043: CURSOR fcst_budget_line_src_tgt_none
3044: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3045: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3046: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
3047: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
3048: ra.resource_assignment_id,

Line 3045: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,

3041: -- please see the other cursor.
3042:
3043: CURSOR fcst_budget_line_src_tgt_none
3044: (c_proj_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3045: c_projfunc_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE,
3046: c_src_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE) IS
3047: SELECT /*+ INDEX(tmp4,PA_RES_LIST_MAP_TMP4_N2)*/
3048: ra.resource_assignment_id,
3049: ra.rate_based_flag,

Line 3137: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE

3133:
3134: /* Added for bug #4938603 */
3135: CURSOR fcst_bdgt_line_actual_qty
3136: (c_res_asgn_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE,
3137: c_txn_currency_code PA_PROJECTS_ALL.PROJECT_CURRENCY_CODE%TYPE
3138: ) IS
3139: SELECT sum(nvl(init_quantity,0))
3140: FROM pa_budget_lines
3141: WHERE resource_assignment_id = c_res_asgn_id

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

5580: * Lastly, this description should be updated any time the layout of
5581: * x_calculate_api_code is modified.
5582: */
5583: PROCEDURE GET_CALC_API_FLAG_PARAMS
5584: (P_PROJECT_ID IN PA_PROJECTS_ALL.PROJECT_ID%TYPE,
5585: P_FP_COLS_REC_SOURCE IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5586: P_FP_COLS_REC_TARGET IN PA_FP_GEN_AMOUNT_UTILS.FP_COLS,
5587: P_CALLING_CONTEXT IN VARCHAR2,
5588: X_CALCULATE_API_CODE OUT NOCOPY VARCHAR2,