[Home] [Help]
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:
5129: /* for period1 */
5157: where resource_assignment_id = l_ra_id_pl
5158: and start_date = l_start_date;
5159: --Bug 4947912
5160: IF l_budget_line_id IS NOT NULL THEN
5161: pa_fp_budget_lines_pkg.
5162: Update_Row(p_budget_line_id =>l_budget_line_id,
5163: p_revenue_adj => l_period_amount,
5164: x_return_status =>l_return_status);
5165: End if;
5174: where resource_assignment_id = l_ra_id_pl
5175: and start_date = l_start_date;
5176: --Bug 4947912
5177: IF l_budget_line_id IS NOT NULL THEN
5178: pa_fp_budget_lines_pkg.
5179: Update_Row(p_budget_line_id =>l_budget_line_id,
5180: p_cost_adj => l_period_amount,
5181: x_return_status =>l_return_status);
5182: End if;
5190: where resource_assignment_id = l_ra_id_pl
5191: and start_date = l_start_date;
5192: --Bug 4947912
5193: IF l_budget_line_id IS NOT NULL THEN
5194: pa_fp_budget_lines_pkg.
5195: Update_Row(p_budget_line_id =>l_budget_line_id,
5196: p_head_count_adj => l_period_amount,
5197: x_return_status =>l_return_status);
5198: End if;
5206: where resource_assignment_id = l_ra_id_pl
5207: and start_date = l_start_date;
5208: --Bug 4947912
5209: IF l_budget_line_id IS NOT NULL THEN
5210: pa_fp_budget_lines_pkg.
5211: Update_Row(p_budget_line_id =>l_budget_line_id,
5212: p_utilization_adj => l_period_amount,
5213: x_return_status =>l_return_status);
5214: End if;
5252: where resource_assignment_id = l_ra_id_pl
5253: and start_date = l_start_date;
5254:
5255: If l_budget_line_id is not null then
5256: pa_fp_budget_lines_pkg.
5257: Update_Row(p_budget_line_id =>l_budget_line_id,
5258: p_revenue_adj => l_period_amount,
5259: x_return_status =>l_return_status);
5260: End if;
5270: and start_date = l_start_date;
5271:
5272: --Bug 4947912
5273: If l_budget_line_id is not null then
5274: pa_fp_budget_lines_pkg.
5275: Update_Row(p_budget_line_id =>l_budget_line_id,
5276: p_cost_adj => l_period_amount,
5277: x_return_status =>l_return_status);
5278: End if;
5288:
5289:
5290: --Bug 4947912
5291: If l_budget_line_id is not null then
5292: pa_fp_budget_lines_pkg.
5293: Update_Row(p_budget_line_id =>l_budget_line_id,
5294: p_head_count_adj => l_period_amount,
5295: x_return_status =>l_return_status);
5296: End if;
5307:
5308:
5309: --Bug 4947912
5310: If l_budget_line_id is not null then
5311: pa_fp_budget_lines_pkg.
5312: Update_Row(p_budget_line_id =>l_budget_line_id,
5313: p_utilization_adj => l_period_amount,
5314: x_return_status =>l_return_status);
5315: End if;
5350: and start_date = l_start_date;
5351:
5352: --Bug 4947912
5353: If l_budget_line_id is not null then
5354: pa_fp_budget_lines_pkg.
5355: Update_Row(p_budget_line_id =>l_budget_line_id,
5356: p_revenue_adj => l_period_amount,
5357: x_return_status =>l_return_status);
5358: End if;
5368: and start_date = l_start_date;
5369:
5370: --Bug 4947912
5371: If l_budget_line_id is not null then
5372: pa_fp_budget_lines_pkg.
5373: Update_Row(p_budget_line_id =>l_budget_line_id,
5374: p_cost_adj => l_period_amount,
5375: x_return_status =>l_return_status);
5376: End if;
5385: and start_date = l_start_date;
5386:
5387: --Bug 4947912
5388: If l_budget_line_id is not null then
5389: pa_fp_budget_lines_pkg.
5390: Update_Row(p_budget_line_id =>l_budget_line_id,
5391: p_head_count_adj => l_period_amount,
5392: x_return_status =>l_return_status);
5393: End if;
5403: and start_date = l_start_date;
5404:
5405: --Bug 4947912
5406: If l_budget_line_id is not null then
5407: pa_fp_budget_lines_pkg.
5408: Update_Row(p_budget_line_id =>l_budget_line_id,
5409: p_utilization_adj => l_period_amount,
5410: x_return_status =>l_return_status);
5411: End if;
5447: and start_date = l_start_date;
5448:
5449: --Bug 4947912
5450: If l_budget_line_id is not null then
5451: pa_fp_budget_lines_pkg.
5452: Update_Row(p_budget_line_id =>l_budget_line_id,
5453: p_revenue_adj => l_period_amount,
5454: x_return_status =>l_return_status);
5455: End if;
5465: and start_date = l_start_date;
5466:
5467: --Bug 4947912
5468: If l_budget_line_id is not null then
5469: pa_fp_budget_lines_pkg.
5470: Update_Row(p_budget_line_id =>l_budget_line_id,
5471: p_cost_adj => l_period_amount,
5472: x_return_status =>l_return_status);
5473: End if;
5483: and start_date = l_start_date;
5484:
5485: --Bug 4947912
5486: If l_budget_line_id is not null then
5487: pa_fp_budget_lines_pkg.
5488: Update_Row(p_budget_line_id =>l_budget_line_id,
5489: p_head_count_adj => l_period_amount,
5490: x_return_status =>l_return_status);
5491: End if;
5501: and start_date = l_start_date;
5502:
5503: --Bug 4947912
5504: If l_budget_line_id is not null then
5505: pa_fp_budget_lines_pkg.
5506: Update_Row(p_budget_line_id =>l_budget_line_id,
5507: p_utilization_adj => l_period_amount,
5508: x_return_status =>l_return_status);
5509: End if;
5548: and start_date = l_start_date;
5549:
5550: --Bug 4947912
5551: If l_budget_line_id is not null then
5552: pa_fp_budget_lines_pkg.
5553: Update_Row(p_budget_line_id =>l_budget_line_id,
5554: p_revenue_adj => l_period_amount,
5555: x_return_status =>l_return_status);
5556: End If;
5566: and start_date = l_start_date;
5567:
5568: --Bug 4947912
5569: If l_budget_line_id is not null then
5570: pa_fp_budget_lines_pkg.
5571: Update_Row(p_budget_line_id =>l_budget_line_id,
5572: p_cost_adj => l_period_amount,
5573: x_return_status =>l_return_status);
5574: End If;
5584: and start_date = l_start_date;
5585:
5586: --Bug 4947912
5587: If l_budget_line_id is not null then
5588: pa_fp_budget_lines_pkg.
5589: Update_Row(p_budget_line_id =>l_budget_line_id,
5590: p_head_count_adj => l_period_amount,
5591: x_return_status =>l_return_status);
5592: End if;
5602: and start_date = l_start_date;
5603:
5604: --Bug 4947912
5605: If l_budget_line_id is not null then
5606: pa_fp_budget_lines_pkg.
5607: Update_Row(p_budget_line_id =>l_budget_line_id,
5608: p_utilization_adj => l_period_amount,
5609: x_return_status =>l_return_status);
5610: End if;
5647: and start_date = l_start_date;
5648:
5649: --Bug 4947912
5650: If l_budget_line_id is not null then
5651: pa_fp_budget_lines_pkg.
5652: Update_Row(p_budget_line_id =>l_budget_line_id,
5653: p_revenue_adj => l_period_amount,
5654: x_return_status =>l_return_status);
5655: End if;
5665: and start_date = l_start_date;
5666:
5667: --Bug 4947912
5668: If l_budget_line_id is not null then
5669: pa_fp_budget_lines_pkg.
5670: Update_Row(p_budget_line_id =>l_budget_line_id,
5671: p_cost_adj => l_period_amount,
5672: x_return_status =>l_return_status);
5673: End if;
5682: and start_date = l_start_date;
5683:
5684: --Bug 4947912
5685: If l_budget_line_id is not null then
5686: pa_fp_budget_lines_pkg.
5687: Update_Row(p_budget_line_id =>l_budget_line_id,
5688: p_head_count_adj => l_period_amount,
5689: x_return_status =>l_return_status);
5690: End if;
5700: and start_date = l_start_date;
5701:
5702: --Bug 4947912
5703: If l_budget_line_id is not null then
5704: pa_fp_budget_lines_pkg.
5705: Update_Row(p_budget_line_id =>l_budget_line_id,
5706: p_utilization_adj => l_period_amount,
5707: x_return_status =>l_return_status);
5708: End if;
5745: and start_date = l_start_date;
5746:
5747: --Bug 4947912
5748: If l_budget_line_id is not null then
5749: pa_fp_budget_lines_pkg.
5750: Update_Row(p_budget_line_id =>l_budget_line_id,
5751: p_revenue_adj => l_period_amount,
5752: x_return_status =>l_return_status);
5753: End if;
5762: where resource_assignment_id = l_ra_id_pl
5763: and start_date = l_start_date;
5764: --Bug 4947912
5765: If l_budget_line_id is not null then
5766: pa_fp_budget_lines_pkg.
5767: Update_Row(p_budget_line_id =>l_budget_line_id,
5768: p_cost_adj => l_period_amount,
5769: x_return_status =>l_return_status);
5770: End if;
5778: where resource_assignment_id = l_ra_id_pl
5779: and start_date = l_start_date;
5780: --Bug 4947912
5781: If l_budget_line_id is not null then
5782: pa_fp_budget_lines_pkg.
5783: Update_Row(p_budget_line_id =>l_budget_line_id,
5784: p_head_count_adj => l_period_amount,
5785: x_return_status =>l_return_status);
5786: End if;
5794: where resource_assignment_id = l_ra_id_pl
5795: and start_date = l_start_date;
5796: --Bug 4947912
5797: If l_budget_line_id is not null then
5798: pa_fp_budget_lines_pkg.
5799: Update_Row(p_budget_line_id =>l_budget_line_id,
5800: p_utilization_adj => l_period_amount,
5801: x_return_status =>l_return_status);
5802: End if;
5840: and start_date = l_start_date;
5841:
5842: --Bug 4947912
5843: If l_budget_line_id is not null then
5844: pa_fp_budget_lines_pkg.
5845: Update_Row(p_budget_line_id =>l_budget_line_id,
5846: p_revenue_adj => l_period_amount,
5847: x_return_status =>l_return_status);
5848: End if;
5858: and start_date = l_start_date;
5859:
5860: --Bug 4947912
5861: If l_budget_line_id is not null then
5862: pa_fp_budget_lines_pkg.
5863: Update_Row(p_budget_line_id =>l_budget_line_id,
5864: p_cost_adj => l_period_amount,
5865: x_return_status =>l_return_status);
5866: End if;
5875: and start_date = l_start_date;
5876:
5877: --Bug 4947912
5878: If l_budget_line_id is not null then
5879: pa_fp_budget_lines_pkg.
5880: Update_Row(p_budget_line_id =>l_budget_line_id,
5881: p_head_count_adj => l_period_amount,
5882: x_return_status =>l_return_status);
5883: End if;
5892: and start_date = l_start_date;
5893:
5894: --Bug 4947912
5895: If l_budget_line_id is not null then
5896: pa_fp_budget_lines_pkg.
5897: Update_Row(p_budget_line_id =>l_budget_line_id,
5898: p_utilization_adj => l_period_amount,
5899: x_return_status =>l_return_status);
5900: End if;
5933: and start_date = l_start_date;
5934:
5935: --Bug 4947912
5936: If l_budget_line_id is not null then
5937: pa_fp_budget_lines_pkg.
5938: Update_Row(p_budget_line_id =>l_budget_line_id,
5939: p_revenue_adj => l_period_amount,
5940: x_return_status =>l_return_status);
5941: End if;
5951: and start_date = l_start_date;
5952:
5953: --Bug 4947912
5954: If l_budget_line_id is not null then
5955: pa_fp_budget_lines_pkg.
5956: Update_Row(p_budget_line_id =>l_budget_line_id,
5957: p_cost_adj => l_period_amount,
5958: x_return_status =>l_return_status);
5959: End if;
5968: and start_date = l_start_date;
5969:
5970: --Bug 4947912
5971: If l_budget_line_id is not null then
5972: pa_fp_budget_lines_pkg.
5973: Update_Row(p_budget_line_id =>l_budget_line_id,
5974: p_head_count_adj => l_period_amount,
5975: x_return_status =>l_return_status);
5976: End if;
5985: and start_date = l_start_date;
5986:
5987: --Bug 4947912
5988: If l_budget_line_id is not null then
5989: pa_fp_budget_lines_pkg.
5990: Update_Row(p_budget_line_id =>l_budget_line_id,
5991: p_utilization_adj => l_period_amount,
5992: x_return_status =>l_return_status);
5993: End if;
6028: and start_date = l_start_date;
6029:
6030: --Bug 4947912
6031: If l_budget_line_id is not null then
6032: pa_fp_budget_lines_pkg.
6033: Update_Row(p_budget_line_id =>l_budget_line_id,
6034: p_revenue_adj => l_period_amount,
6035: x_return_status =>l_return_status);
6036: End if;
6046: and start_date = l_start_date;
6047:
6048: --Bug 4947912
6049: If l_budget_line_id is not null then
6050: pa_fp_budget_lines_pkg.
6051: Update_Row(p_budget_line_id =>l_budget_line_id,
6052: p_cost_adj => l_period_amount,
6053: x_return_status =>l_return_status);
6054: End if;
6063: and start_date = l_start_date;
6064:
6065: --Bug 4947912
6066: If l_budget_line_id is not null then
6067: pa_fp_budget_lines_pkg.
6068: Update_Row(p_budget_line_id =>l_budget_line_id,
6069: p_head_count_adj => l_period_amount,
6070: x_return_status =>l_return_status);
6071: End if;
6080: and start_date = l_start_date;
6081:
6082: --Bug 4947912
6083: If l_budget_line_id is not null then
6084: pa_fp_budget_lines_pkg.
6085: Update_Row(p_budget_line_id =>l_budget_line_id,
6086: p_utilization_adj => l_period_amount,
6087: x_return_status =>l_return_status);
6088: End if;
6125: where resource_assignment_id = l_ra_id_pl
6126: and start_date = l_start_date;
6127: --Bug 4947912
6128: If l_budget_line_id is not null then
6129: pa_fp_budget_lines_pkg.
6130: Update_Row(p_budget_line_id =>l_budget_line_id,
6131: p_revenue_adj => l_period_amount,
6132: x_return_status =>l_return_status);
6133: End if;
6143: and start_date = l_start_date;
6144:
6145: --Bug 4947912
6146: If l_budget_line_id is not null then
6147: pa_fp_budget_lines_pkg.
6148: Update_Row(p_budget_line_id =>l_budget_line_id,
6149: p_cost_adj => l_period_amount,
6150: x_return_status =>l_return_status);
6151: End if;
6160: and start_date = l_start_date;
6161:
6162: --Bug 4947912
6163: If l_budget_line_id is not null then
6164: pa_fp_budget_lines_pkg.
6165: Update_Row(p_budget_line_id =>l_budget_line_id,
6166: p_head_count_adj => l_period_amount,
6167: x_return_status =>l_return_status);
6168: End if;
6177: and start_date = l_start_date;
6178:
6179: --Bug 4947912
6180: If l_budget_line_id is not null then
6181: pa_fp_budget_lines_pkg.
6182: Update_Row(p_budget_line_id =>l_budget_line_id,
6183: p_utilization_adj => l_period_amount,
6184: x_return_status =>l_return_status);
6185: End if;
6222: and start_date = l_start_date;
6223:
6224: --Bug 4947912
6225: If l_budget_line_id is not null then
6226: pa_fp_budget_lines_pkg.
6227: Update_Row(p_budget_line_id =>l_budget_line_id,
6228: p_revenue_adj => l_period_amount,
6229: x_return_status =>l_return_status);
6230: End if;
6240: and start_date = l_start_date;
6241:
6242: --Bug 4947912
6243: If l_budget_line_id is not null then
6244: pa_fp_budget_lines_pkg.
6245: Update_Row(p_budget_line_id =>l_budget_line_id,
6246: p_cost_adj => l_period_amount,
6247: x_return_status =>l_return_status);
6248: End if;
6257: and start_date = l_start_date;
6258:
6259: --Bug 4947912
6260: If l_budget_line_id is not null then
6261: pa_fp_budget_lines_pkg.
6262: Update_Row(p_budget_line_id =>l_budget_line_id,
6263: p_head_count_adj => l_period_amount,
6264: x_return_status =>l_return_status);
6265: End if;
6274: and start_date = l_start_date;
6275:
6276: --Bug 4947912
6277: If l_budget_line_id is not null then
6278: pa_fp_budget_lines_pkg.
6279: Update_Row(p_budget_line_id =>l_budget_line_id,
6280: p_utilization_adj => l_period_amount,
6281: x_return_status =>l_return_status);
6282: End if;
6318: and start_date = l_start_date;
6319:
6320: --Bug 4947912
6321: If l_budget_line_id is not null then
6322: pa_fp_budget_lines_pkg.
6323: Update_Row(p_budget_line_id =>l_budget_line_id,
6324: p_revenue_adj => l_period_amount,
6325: x_return_status =>l_return_status);
6326: End if;
6336: and start_date = l_start_date;
6337:
6338: --Bug 4947912
6339: If l_budget_line_id is not null then
6340: pa_fp_budget_lines_pkg.
6341: Update_Row(p_budget_line_id =>l_budget_line_id,
6342: p_cost_adj => l_period_amount,
6343: x_return_status =>l_return_status);
6344: End if;
6353: and start_date = l_start_date;
6354:
6355: --Bug 4947912
6356: If l_budget_line_id is not null then
6357: pa_fp_budget_lines_pkg.
6358: Update_Row(p_budget_line_id =>l_budget_line_id,
6359: p_head_count_adj => l_period_amount,
6360: x_return_status =>l_return_status);
6361: End if;
6370: and start_date = l_start_date;
6371:
6372: --Bug 4947912
6373: If l_budget_line_id is not null then
6374: pa_fp_budget_lines_pkg.
6375: Update_Row(p_budget_line_id =>l_budget_line_id,
6376: p_utilization_adj => l_period_amount,
6377: x_return_status =>l_return_status);
6378: End if;
6420: where resource_assignment_id = l_ra_id_tl
6421: and start_date = l_start_date;
6422: --Bug 4947912
6423: If l_budget_line_id is not null then
6424: pa_fp_budget_lines_pkg.
6425: Update_Row(p_budget_line_id =>l_budget_line_id,
6426: p_revenue_adj => l_period_amount,
6427: x_return_status =>l_return_status);
6428: End if;
6437: where resource_assignment_id = l_ra_id_tl
6438: and start_date = l_start_date;
6439: --Bug 4947912
6440: If l_budget_line_id is not null then
6441: pa_fp_budget_lines_pkg.
6442: Update_Row(p_budget_line_id =>l_budget_line_id,
6443: p_cost_adj => l_period_amount,
6444: x_return_status =>l_return_status);
6445: End if;
6453: where resource_assignment_id = l_ra_id_tl
6454: and start_date = l_start_date;
6455: --Bug 4947912
6456: If l_budget_line_id is not null then
6457: pa_fp_budget_lines_pkg.
6458: Update_Row(p_budget_line_id =>l_budget_line_id,
6459: p_head_count_adj => l_period_amount,
6460: x_return_status =>l_return_status);
6461: End if;
6469: where resource_assignment_id = l_ra_id_tl
6470: and start_date = l_start_date;
6471: --Bug 4947912
6472: If l_budget_line_id is not null then
6473: pa_fp_budget_lines_pkg.
6474: Update_Row(p_budget_line_id =>l_budget_line_id,
6475: p_utilization_adj => l_period_amount,
6476: x_return_status =>l_return_status);
6477: End if;
6512: where resource_assignment_id = l_ra_id_tl
6513: and start_date = l_start_date;
6514: --Bug 4947912
6515: If l_budget_line_id is not null then
6516: pa_fp_budget_lines_pkg.
6517: Update_Row(p_budget_line_id =>l_budget_line_id,
6518: p_revenue_adj => l_period_amount,
6519: x_return_status =>l_return_status);
6520: End if;
6529: where resource_assignment_id = l_ra_id_tl
6530: and start_date = l_start_date;
6531: --Bug 4947912
6532: If l_budget_line_id is not null then
6533: pa_fp_budget_lines_pkg.
6534: Update_Row(p_budget_line_id =>l_budget_line_id,
6535: p_cost_adj => l_period_amount,
6536: x_return_status =>l_return_status);
6537: End if;
6545: where resource_assignment_id = l_ra_id_tl
6546: and start_date = l_start_date;
6547: --Bug 4947912
6548: If l_budget_line_id is not null then
6549: pa_fp_budget_lines_pkg.
6550: Update_Row(p_budget_line_id =>l_budget_line_id,
6551: p_head_count_adj => l_period_amount,
6552: x_return_status =>l_return_status);
6553: End if;
6561: where resource_assignment_id = l_ra_id_tl
6562: and start_date = l_start_date;
6563: --Bug 4947912
6564: If l_budget_line_id is not null then
6565: pa_fp_budget_lines_pkg.
6566: Update_Row(p_budget_line_id =>l_budget_line_id,
6567: p_utilization_adj => l_period_amount,
6568: x_return_status =>l_return_status);
6569: End if;
6601: where resource_assignment_id = l_ra_id_tl
6602: and start_date = l_start_date;
6603: --Bug 4947912
6604: If l_budget_line_id is not null then
6605: pa_fp_budget_lines_pkg.
6606: Update_Row(p_budget_line_id =>l_budget_line_id,
6607: p_revenue_adj => l_period_amount,
6608: x_return_status =>l_return_status);
6609: End if;
6618: where resource_assignment_id = l_ra_id_tl
6619: and start_date = l_start_date;
6620: --Bug 4947912
6621: If l_budget_line_id is not null then
6622: pa_fp_budget_lines_pkg.
6623: Update_Row(p_budget_line_id =>l_budget_line_id,
6624: p_cost_adj => l_period_amount,
6625: x_return_status =>l_return_status);
6626: End if;
6634: where resource_assignment_id = l_ra_id_tl
6635: and start_date = l_start_date;
6636: --Bug 4947912
6637: If l_budget_line_id is not null then
6638: pa_fp_budget_lines_pkg.
6639: Update_Row(p_budget_line_id =>l_budget_line_id,
6640: p_head_count_adj => l_period_amount,
6641: x_return_status =>l_return_status);
6642: End if;
6650: where resource_assignment_id = l_ra_id_tl
6651: and start_date = l_start_date;
6652: --Bug 4947912
6653: If l_budget_line_id is not null then
6654: pa_fp_budget_lines_pkg.
6655: Update_Row(p_budget_line_id =>l_budget_line_id,
6656: p_utilization_adj => l_period_amount,
6657: x_return_status =>l_return_status);
6658: End if;
6691: where resource_assignment_id = l_ra_id_tl
6692: and start_date = l_start_date;
6693: --Bug 4947912
6694: If l_budget_line_id is not null then
6695: pa_fp_budget_lines_pkg.
6696: Update_Row(p_budget_line_id =>l_budget_line_id,
6697: p_revenue_adj => l_period_amount,
6698: x_return_status =>l_return_status);
6699: End if;
6708: where resource_assignment_id = l_ra_id_tl
6709: and start_date = l_start_date;
6710: --Bug 4947912
6711: If l_budget_line_id is not null then
6712: pa_fp_budget_lines_pkg.
6713: Update_Row(p_budget_line_id =>l_budget_line_id,
6714: p_cost_adj => l_period_amount,
6715: x_return_status =>l_return_status);
6716: End if;
6724: where resource_assignment_id = l_ra_id_tl
6725: and start_date = l_start_date;
6726: --Bug 4947912
6727: If l_budget_line_id is not null then
6728: pa_fp_budget_lines_pkg.
6729: Update_Row(p_budget_line_id =>l_budget_line_id,
6730: p_head_count_adj => l_period_amount,
6731: x_return_status =>l_return_status);
6732: End if;
6740: where resource_assignment_id = l_ra_id_tl
6741: and start_date = l_start_date;
6742: --Bug 4947912
6743: If l_budget_line_id is not null then
6744: pa_fp_budget_lines_pkg.
6745: Update_Row(p_budget_line_id =>l_budget_line_id,
6746: p_utilization_adj => l_period_amount,
6747: x_return_status =>l_return_status);
6748: End if;
6783: where resource_assignment_id = l_ra_id_tl
6784: and start_date = l_start_date;
6785: --Bug 4947912
6786: If l_budget_line_id is not null then
6787: pa_fp_budget_lines_pkg.
6788: Update_Row(p_budget_line_id =>l_budget_line_id,
6789: p_revenue_adj => l_period_amount,
6790: x_return_status =>l_return_status);
6791: End if;
6800: where resource_assignment_id = l_ra_id_tl
6801: and start_date = l_start_date;
6802: --Bug 4947912
6803: If l_budget_line_id is not null then
6804: pa_fp_budget_lines_pkg.
6805: Update_Row(p_budget_line_id =>l_budget_line_id,
6806: p_cost_adj => l_period_amount,
6807: x_return_status =>l_return_status);
6808: End if;
6816: where resource_assignment_id = l_ra_id_tl
6817: and start_date = l_start_date;
6818: --Bug 4947912
6819: If l_budget_line_id is not null then
6820: pa_fp_budget_lines_pkg.
6821: Update_Row(p_budget_line_id =>l_budget_line_id,
6822: p_head_count_adj => l_period_amount,
6823: x_return_status =>l_return_status);
6824: End if;
6832: where resource_assignment_id = l_ra_id_tl
6833: and start_date = l_start_date;
6834: --Bug 4947912
6835: If l_budget_line_id is not null then
6836: pa_fp_budget_lines_pkg.
6837: Update_Row(p_budget_line_id =>l_budget_line_id,
6838: p_utilization_adj => l_period_amount,
6839: x_return_status =>l_return_status);
6840: End if;
6875: where resource_assignment_id = l_ra_id_tl
6876: and start_date = l_start_date;
6877: --Bug 4947912
6878: If l_budget_line_id is not null then
6879: pa_fp_budget_lines_pkg.
6880: Update_Row(p_budget_line_id =>l_budget_line_id,
6881: p_revenue_adj => l_period_amount,
6882: x_return_status =>l_return_status);
6883: End if;
6892: where resource_assignment_id = l_ra_id_tl
6893: and start_date = l_start_date;
6894: --Bug 4947912
6895: If l_budget_line_id is not null then
6896: pa_fp_budget_lines_pkg.
6897: Update_Row(p_budget_line_id =>l_budget_line_id,
6898: p_cost_adj => l_period_amount,
6899: x_return_status =>l_return_status);
6900: End if;
6908: where resource_assignment_id = l_ra_id_tl
6909: and start_date = l_start_date;
6910: --Bug 4947912
6911: If l_budget_line_id is not null then
6912: pa_fp_budget_lines_pkg.
6913: Update_Row(p_budget_line_id =>l_budget_line_id,
6914: p_head_count_adj => l_period_amount,
6915: x_return_status =>l_return_status);
6916: End if;
6924: where resource_assignment_id = l_ra_id_tl
6925: and start_date = l_start_date;
6926: --Bug 4947912
6927: If l_budget_line_id is not null then
6928: pa_fp_budget_lines_pkg.
6929: Update_Row(p_budget_line_id =>l_budget_line_id,
6930: p_utilization_adj => l_period_amount,
6931: x_return_status =>l_return_status);
6932: End if;
6967: where resource_assignment_id = l_ra_id_tl
6968: and start_date = l_start_date;
6969: --Bug 4947912
6970: If l_budget_line_id is not null then
6971: pa_fp_budget_lines_pkg.
6972: Update_Row(p_budget_line_id =>l_budget_line_id,
6973: p_revenue_adj => l_period_amount,
6974: x_return_status =>l_return_status);
6975: End if;
6984: where resource_assignment_id = l_ra_id_tl
6985: and start_date = l_start_date;
6986: --Bug 4947912
6987: If l_budget_line_id is not null then
6988: pa_fp_budget_lines_pkg.
6989: Update_Row(p_budget_line_id =>l_budget_line_id,
6990: p_cost_adj => l_period_amount,
6991: x_return_status =>l_return_status);
6992: End if;
7000: where resource_assignment_id = l_ra_id_tl
7001: and start_date = l_start_date;
7002: --Bug 4947912
7003: If l_budget_line_id is not null then
7004: pa_fp_budget_lines_pkg.
7005: Update_Row(p_budget_line_id =>l_budget_line_id,
7006: p_head_count_adj => l_period_amount,
7007: x_return_status =>l_return_status);
7008: End if;
7016: where resource_assignment_id = l_ra_id_tl
7017: and start_date = l_start_date;
7018: --Bug 4947912
7019: If l_budget_line_id is not null then
7020: pa_fp_budget_lines_pkg.
7021: Update_Row(p_budget_line_id =>l_budget_line_id,
7022: p_utilization_adj => l_period_amount,
7023: x_return_status =>l_return_status);
7024: End if;
7059: where resource_assignment_id = l_ra_id_tl
7060: and start_date = l_start_date;
7061: --Bug 4947912
7062: If l_budget_line_id is not null then
7063: pa_fp_budget_lines_pkg.
7064: Update_Row(p_budget_line_id =>l_budget_line_id,
7065: p_revenue_adj => l_period_amount,
7066: x_return_status =>l_return_status);
7067: End if;
7076: where resource_assignment_id = l_ra_id_tl
7077: and start_date = l_start_date;
7078: --Bug 4947912
7079: If l_budget_line_id is not null then
7080: pa_fp_budget_lines_pkg.
7081: Update_Row(p_budget_line_id =>l_budget_line_id,
7082: p_cost_adj => l_period_amount,
7083: x_return_status =>l_return_status);
7084: End if;
7092: where resource_assignment_id = l_ra_id_tl
7093: and start_date = l_start_date;
7094: --Bug 4947912
7095: If l_budget_line_id is not null then
7096: pa_fp_budget_lines_pkg.
7097: Update_Row(p_budget_line_id =>l_budget_line_id,
7098: p_head_count_adj => l_period_amount,
7099: x_return_status =>l_return_status);
7100: End if;
7108: where resource_assignment_id = l_ra_id_tl
7109: and start_date = l_start_date;
7110: --Bug 4947912
7111: If l_budget_line_id is not null then
7112: pa_fp_budget_lines_pkg.
7113: Update_Row(p_budget_line_id =>l_budget_line_id,
7114: p_utilization_adj => l_period_amount,
7115: x_return_status =>l_return_status);
7116: End if;
7148: where resource_assignment_id = l_ra_id_tl
7149: and start_date = l_start_date;
7150: --Bug 4947912
7151: If l_budget_line_id is not null then
7152: pa_fp_budget_lines_pkg.
7153: Update_Row(p_budget_line_id =>l_budget_line_id,
7154: p_revenue_adj => l_period_amount,
7155: x_return_status =>l_return_status);
7156: End if;
7165: where resource_assignment_id = l_ra_id_tl
7166: and start_date = l_start_date;
7167: --Bug 4947912
7168: If l_budget_line_id is not null then
7169: pa_fp_budget_lines_pkg.
7170: Update_Row(p_budget_line_id =>l_budget_line_id,
7171: p_cost_adj => l_period_amount,
7172: x_return_status =>l_return_status);
7173: End if;
7181: where resource_assignment_id = l_ra_id_tl
7182: and start_date = l_start_date;
7183: --Bug 4947912
7184: If l_budget_line_id is not null then
7185: pa_fp_budget_lines_pkg.
7186: Update_Row(p_budget_line_id =>l_budget_line_id,
7187: p_head_count_adj => l_period_amount,
7188: x_return_status =>l_return_status);
7189: End if;
7197: where resource_assignment_id = l_ra_id_tl
7198: and start_date = l_start_date;
7199: --Bug 4947912
7200: If l_budget_line_id is not null then
7201: pa_fp_budget_lines_pkg.
7202: Update_Row(p_budget_line_id =>l_budget_line_id,
7203: p_utilization_adj => l_period_amount,
7204: x_return_status =>l_return_status);
7205: End if;
7238: where resource_assignment_id = l_ra_id_tl
7239: and start_date = l_start_date;
7240: --Bug 4947912
7241: If l_budget_line_id is not null then
7242: pa_fp_budget_lines_pkg.
7243: Update_Row(p_budget_line_id =>l_budget_line_id,
7244: p_revenue_adj => l_period_amount,
7245: x_return_status =>l_return_status);
7246: End if;
7255: where resource_assignment_id = l_ra_id_tl
7256: and start_date = l_start_date;
7257: --Bug 4947912
7258: If l_budget_line_id is not null then
7259: pa_fp_budget_lines_pkg.
7260: Update_Row(p_budget_line_id =>l_budget_line_id,
7261: p_cost_adj => l_period_amount,
7262: x_return_status =>l_return_status);
7263: End if;
7271: where resource_assignment_id = l_ra_id_tl
7272: and start_date = l_start_date;
7273: --Bug 4947912
7274: If l_budget_line_id is not null then
7275: pa_fp_budget_lines_pkg.
7276: Update_Row(p_budget_line_id =>l_budget_line_id,
7277: p_head_count_adj => l_period_amount,
7278: x_return_status =>l_return_status);
7279: End if;
7287: where resource_assignment_id = l_ra_id_tl
7288: and start_date = l_start_date;
7289: --Bug 4947912
7290: If l_budget_line_id is not null then
7291: pa_fp_budget_lines_pkg.
7292: Update_Row(p_budget_line_id =>l_budget_line_id,
7293: p_utilization_adj => l_period_amount,
7294: x_return_status =>l_return_status);
7295: End if;
7330: where resource_assignment_id = l_ra_id_tl
7331: and start_date = l_start_date;
7332: --Bug 4947912
7333: If l_budget_line_id is not null then
7334: pa_fp_budget_lines_pkg.
7335: Update_Row(p_budget_line_id =>l_budget_line_id,
7336: p_revenue_adj => l_period_amount,
7337: x_return_status =>l_return_status);
7338: End if;
7348: where resource_assignment_id = l_ra_id_tl
7349: and start_date = l_start_date;
7350: --Bug 4947912
7351: If l_budget_line_id is not null then
7352: pa_fp_budget_lines_pkg.
7353: Update_Row(p_budget_line_id =>l_budget_line_id,
7354: p_cost_adj => l_period_amount,
7355: x_return_status =>l_return_status);
7356: End if;
7364: where resource_assignment_id = l_ra_id_tl
7365: and start_date = l_start_date;
7366: --Bug 4947912
7367: If l_budget_line_id is not null then
7368: pa_fp_budget_lines_pkg.
7369: Update_Row(p_budget_line_id =>l_budget_line_id,
7370: p_head_count_adj => l_period_amount,
7371: x_return_status =>l_return_status);
7372: End if;
7380: where resource_assignment_id = l_ra_id_tl
7381: and start_date = l_start_date;
7382: --Bug 4947912
7383: If l_budget_line_id is not null then
7384: pa_fp_budget_lines_pkg.
7385: Update_Row(p_budget_line_id =>l_budget_line_id,
7386: p_utilization_adj => l_period_amount,
7387: x_return_status =>l_return_status);
7388: End if;
7423: where resource_assignment_id = l_ra_id_tl
7424: and start_date = l_start_date;
7425: --Bug 4947912
7426: If l_budget_line_id is not null then
7427: pa_fp_budget_lines_pkg.
7428: Update_Row(p_budget_line_id =>l_budget_line_id,
7429: p_revenue_adj => l_period_amount,
7430: x_return_status =>l_return_status);
7431: End if;
7440: where resource_assignment_id = l_ra_id_tl
7441: and start_date = l_start_date;
7442: --Bug 4947912
7443: If l_budget_line_id is not null then
7444: pa_fp_budget_lines_pkg.
7445: Update_Row(p_budget_line_id =>l_budget_line_id,
7446: p_cost_adj => l_period_amount,
7447: x_return_status =>l_return_status);
7448: End if;
7456: where resource_assignment_id = l_ra_id_tl
7457: and start_date = l_start_date;
7458: --Bug 4947912
7459: If l_budget_line_id is not null then
7460: pa_fp_budget_lines_pkg.
7461: Update_Row(p_budget_line_id =>l_budget_line_id,
7462: p_head_count_adj => l_period_amount,
7463: x_return_status =>l_return_status);
7464: End if;
7472: where resource_assignment_id = l_ra_id_tl
7473: and start_date = l_start_date;
7474: --Bug 4947912
7475: If l_budget_line_id is not null then
7476: pa_fp_budget_lines_pkg.
7477: Update_Row(p_budget_line_id =>l_budget_line_id,
7478: p_utilization_adj => l_period_amount,
7479: x_return_status =>l_return_status);
7480: End if;
7515: where resource_assignment_id = l_ra_id_tl
7516: and start_date = l_start_date;
7517: --Bug 4947912
7518: If l_budget_line_id is not null then
7519: pa_fp_budget_lines_pkg.
7520: Update_Row(p_budget_line_id =>l_budget_line_id,
7521: p_revenue_adj => l_period_amount,
7522: x_return_status =>l_return_status);
7523: End if;
7532: where resource_assignment_id = l_ra_id_tl
7533: and start_date = l_start_date;
7534: --Bug 4947912
7535: If l_budget_line_id is not null then
7536: pa_fp_budget_lines_pkg.
7537: Update_Row(p_budget_line_id =>l_budget_line_id,
7538: p_cost_adj => l_period_amount,
7539: x_return_status =>l_return_status);
7540: End if;
7548: where resource_assignment_id = l_ra_id_tl
7549: and start_date = l_start_date;
7550: --Bug 4947912
7551: If l_budget_line_id is not null then
7552: pa_fp_budget_lines_pkg.
7553: Update_Row(p_budget_line_id =>l_budget_line_id,
7554: p_head_count_adj => l_period_amount,
7555: x_return_status =>l_return_status);
7556: End if;
7564: where resource_assignment_id = l_ra_id_tl
7565: and start_date = l_start_date;
7566: --Bug 4947912
7567: If l_budget_line_id is not null then
7568: pa_fp_budget_lines_pkg.
7569: Update_Row(p_budget_line_id =>l_budget_line_id,
7570: p_utilization_adj => l_period_amount,
7571: x_return_status =>l_return_status);
7572: End if;