[Home] [Help]
5116:
5117:
5118:
5119: /********************************************************************************************/
5120: /* update pa_budget_lines */
5121: /********************************************************************************************/
5122:
5123: ---->Bug 4947912. In the code below that updates pa_budget_lines did the following changes
5124: ---->Handled the no_data_found exception on the Selects on pa_budget_lines
5119: /********************************************************************************************/
5120: /* update pa_budget_lines */
5121: /********************************************************************************************/
5122:
5123: ---->Bug 4947912. In the code below that updates pa_budget_lines did the following changes
5124: ---->Handled the no_data_found exception on the Selects on pa_budget_lines
5125: ---->Call to pa_fp_budget_lines_pkg.Update_Row is made only if the budget line exists.
5126:
5127:
5120: /* update pa_budget_lines */
5121: /********************************************************************************************/
5122:
5123: ---->Bug 4947912. In the code below that updates pa_budget_lines did the following changes
5124: ---->Handled the no_data_found exception on the Selects on pa_budget_lines
5125: ---->Call to pa_fp_budget_lines_pkg.Update_Row is made only if the budget line exists.
5126:
5127:
5128:
5137: --Bug 4947912
5138: Begin
5139: select budget_line_id
5140: into l_budget_line_id
5141: from pa_budget_lines
5142: where resource_assignment_id = l_ra_id_pl
5143: and start_date = l_start_date
5144: and txn_currency_code = p_currency_code;
5145: Exception
5232: --Bug 4947912
5233: Begin
5234: select budget_line_id
5235: into l_budget_line_id
5236: from pa_budget_lines
5237: where resource_assignment_id = l_ra_id_pl
5238: and start_date = l_start_date
5239: and txn_currency_code = p_currency_code;
5240: Exception
5329: --Bug 4947912
5330: Begin
5331: select budget_line_id
5332: into l_budget_line_id
5333: from pa_budget_lines
5334: where resource_assignment_id = l_ra_id_pl
5335: and start_date = l_start_date
5336: and txn_currency_code = p_currency_code;
5337: Exception
5425: --Bug 4947912
5426: Begin
5427: select budget_line_id
5428: into l_budget_line_id
5429: from pa_budget_lines
5430: where resource_assignment_id = l_ra_id_pl
5431: and start_date = l_start_date
5432: and txn_currency_code = p_currency_code;
5433: Exception
5526: --Bug 4947912
5527: Begin
5528: select budget_line_id
5529: into l_budget_line_id
5530: from pa_budget_lines
5531: where resource_assignment_id = l_ra_id_pl
5532: and start_date = l_start_date
5533: and txn_currency_code = p_currency_code;
5534: Exception
5625: --Bug 4947912
5626: Begin
5627: select budget_line_id
5628: into l_budget_line_id
5629: from pa_budget_lines
5630: where resource_assignment_id = l_ra_id_pl
5631: and start_date = l_start_date
5632: and txn_currency_code = p_currency_code;
5633: Exception
5724: --Bug 4947912
5725: Begin
5726: select budget_line_id
5727: into l_budget_line_id
5728: from pa_budget_lines
5729: where resource_assignment_id = l_ra_id_pl
5730: and start_date = l_start_date
5731: and txn_currency_code = p_currency_code;
5732: Exception
5818: --Bug 4947912
5819: Begin
5820: select budget_line_id
5821: into l_budget_line_id
5822: from pa_budget_lines
5823: where resource_assignment_id = l_ra_id_pl
5824: and start_date = l_start_date
5825: and txn_currency_code = p_currency_code;
5826: Exception
5912: --Bug 4947912
5913: Begin
5914: select budget_line_id
5915: into l_budget_line_id
5916: from pa_budget_lines
5917: where resource_assignment_id = l_ra_id_pl
5918: and start_date = l_start_date
5919: and txn_currency_code = p_currency_code;
5920: Exception
6006: --Bug 4947912
6007: Begin
6008: select budget_line_id
6009: into l_budget_line_id
6010: from pa_budget_lines
6011: where resource_assignment_id = l_ra_id_pl
6012: and start_date = l_start_date
6013: and txn_currency_code = p_currency_code;
6014: Exception
6104: --Bug 4947912
6105: Begin
6106: select budget_line_id
6107: into l_budget_line_id
6108: from pa_budget_lines
6109: where resource_assignment_id = l_ra_id_pl
6110: and start_date = l_start_date
6111: and txn_currency_code = p_currency_code;
6112: Exception
6200: --Bug 4947912
6201: Begin
6202: select budget_line_id
6203: into l_budget_line_id
6204: from pa_budget_lines
6205: where resource_assignment_id = l_ra_id_pl
6206: and start_date = l_start_date
6207: and txn_currency_code = p_currency_code;
6208: Exception
6296: --Bug 4947912
6297: Begin
6298: select budget_line_id
6299: into l_budget_line_id
6300: from pa_budget_lines
6301: where resource_assignment_id = l_ra_id_pl
6302: and start_date = l_start_date
6303: and txn_currency_code = p_currency_code;
6304: Exception
6399: --Bug 4947912
6400: Begin
6401: select budget_line_id
6402: into l_budget_line_id
6403: from pa_budget_lines
6404: where resource_assignment_id = l_ra_id_tl
6405: and start_date = l_start_date
6406: and txn_currency_code = p_currency_code;
6407: Exception
6491: --Bug 4947912
6492: Begin
6493: select budget_line_id
6494: into l_budget_line_id
6495: from pa_budget_lines
6496: where resource_assignment_id = l_ra_id_tl
6497: and start_date = l_start_date
6498: and txn_currency_code = p_currency_code;
6499: Exception
6581: --Bug 4947912
6582: Begin
6583: select budget_line_id
6584: into l_budget_line_id
6585: from pa_budget_lines
6586: where resource_assignment_id = l_ra_id_tl
6587: and start_date = l_start_date
6588: and txn_currency_code = p_currency_code;
6589: Exception
6670: --Bug 4947912
6671: Begin
6672: select budget_line_id
6673: into l_budget_line_id
6674: from pa_budget_lines
6675: where resource_assignment_id = l_ra_id_tl
6676: and start_date = l_start_date
6677: and txn_currency_code = p_currency_code;
6678: Exception
6763: --Bug 4947912
6764: Begin
6765: select budget_line_id
6766: into l_budget_line_id
6767: from pa_budget_lines
6768: where resource_assignment_id = l_ra_id_tl
6769: and start_date = l_start_date
6770: and txn_currency_code = p_currency_code;
6771: Exception
6854: --Bug 4947912
6855: Begin
6856: select budget_line_id
6857: into l_budget_line_id
6858: from pa_budget_lines
6859: where resource_assignment_id = l_ra_id_tl
6860: and start_date = l_start_date
6861: and txn_currency_code = p_currency_code;
6862: Exception
6946: --Bug 4947912
6947: Begin
6948: select budget_line_id
6949: into l_budget_line_id
6950: from pa_budget_lines
6951: where resource_assignment_id = l_ra_id_tl
6952: and start_date = l_start_date
6953: and txn_currency_code = p_currency_code;
6954: Exception
7038: --Bug 4947912
7039: Begin
7040: select budget_line_id
7041: into l_budget_line_id
7042: from pa_budget_lines
7043: where resource_assignment_id = l_ra_id_tl
7044: and start_date = l_start_date
7045: and txn_currency_code = p_currency_code;
7046: Exception
7128: --Bug 4947912
7129: Begin
7130: select budget_line_id
7131: into l_budget_line_id
7132: from pa_budget_lines
7133: where resource_assignment_id = l_ra_id_tl
7134: and start_date = l_start_date
7135: and txn_currency_code = p_currency_code;
7136: Exception
7217: --Bug 4947912
7218: Begin
7219: select budget_line_id
7220: into l_budget_line_id
7221: from pa_budget_lines
7222: where resource_assignment_id = l_ra_id_tl
7223: and start_date = l_start_date
7224: and txn_currency_code = p_currency_code;
7225: Exception
7309: --Bug 4947912
7310: Begin
7311: select budget_line_id
7312: into l_budget_line_id
7313: from pa_budget_lines
7314: where resource_assignment_id = l_ra_id_tl
7315: and start_date = l_start_date
7316: and txn_currency_code = p_currency_code;
7317: Exception
7402: --Bug 4947912
7403: Begin
7404: select budget_line_id
7405: into l_budget_line_id
7406: from pa_budget_lines
7407: where resource_assignment_id = l_ra_id_tl
7408: and start_date = l_start_date
7409: and txn_currency_code = p_currency_code;
7410: Exception
7494: --Bug 4947912
7495: Begin
7496: select budget_line_id
7497: into l_budget_line_id
7498: from pa_budget_lines
7499: where resource_assignment_id = l_ra_id_tl
7500: and start_date = l_start_date
7501: and txn_currency_code = p_currency_code;
7502: Exception
7579:
7580:
7581:
7582: /****************************************************************************************/
7583: /*End of update pa_budget_lines*/
7584: /***************************************************************************************/
7585:
7586:
7587:
7602: sum(nvl(UTILIZATION_ADJ,0)),
7603: round(sum(nvl(HEAD_COUNT_ADJ,0)),0)
7604: into l_adj_rev_amount,l_adj_cost_amount,
7605: l_adj_util_amount,l_adj_hc_amount
7606: from pa_budget_lines
7607: where resource_assignment_id = l_ra_id_tl;
7608:
7609:
7610: PA_FP_RESOURCE_ASSIGNMENTS_PKG.
7623: sum(nvl(UTILIZATION_ADJ,0)),
7624: round(sum(nvl(HEAD_COUNT_ADJ,0)),0)
7625: into l_adj_rev_amount,l_adj_cost_amount,
7626: l_adj_util_amount,l_adj_hc_amount
7627: from pa_budget_lines
7628: where resource_assignment_id = l_ra_id_pl;
7629:
7630:
7631: PA_FP_RESOURCE_ASSIGNMENTS_PKG.
7674: sum(nvl(UTILIZATION_ADJ,0))/l_number_of_periods,
7675: round(sum(nvl(HEAD_COUNT_ADJ,0))/l_number_of_periods,0)
7676: into l_adj_rev_amount,l_adj_cost_amount,
7677: l_adj_util_amount,l_adj_hc_amount
7678: from pa_budget_lines
7679: where resource_assignment_id = l_ra_id_pl;
7680:
7681:
7682: PA_FP_BUDGET_VERSIONS_PKG.