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_BUDGET_PVT dependencies on DBMS_SQL

Line 5113: l_cursor_id := DBMS_SQL.open_cursor;

5109: --dbms_output.put_line('Statement: '||substr(l_statement,1,100));
5110: --dbms_output.put_line('Statement: '||substr(l_statement,101,100));
5111: --dbms_output.put_line('Statement: '||substr(l_statement,201,100));
5112:
5113: l_cursor_id := DBMS_SQL.open_cursor;
5114: DBMS_SQL.parse(l_cursor_id, l_statement, DBMS_SQL.native);
5115:
5116: IF p_description IS NOT NULL
5117: AND p_description <> nvl(l_budget_line_rec.description,FND_API.G_MISS_CHAR)

Line 5114: DBMS_SQL.parse(l_cursor_id, l_statement, DBMS_SQL.native);

5110: --dbms_output.put_line('Statement: '||substr(l_statement,101,100));
5111: --dbms_output.put_line('Statement: '||substr(l_statement,201,100));
5112:
5113: l_cursor_id := DBMS_SQL.open_cursor;
5114: DBMS_SQL.parse(l_cursor_id, l_statement, DBMS_SQL.native);
5115:
5116: IF p_description IS NOT NULL
5117: AND p_description <> nvl(l_budget_line_rec.description,FND_API.G_MISS_CHAR)
5118: THEN

Line 5120: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', TO_CHAR(NULL));

5116: IF p_description IS NOT NULL
5117: AND p_description <> nvl(l_budget_line_rec.description,FND_API.G_MISS_CHAR)
5118: THEN
5119: IF p_description = FND_API.G_MISS_CHAR THEN
5120: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', TO_CHAR(NULL));
5121: ELSE
5122: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', p_description);
5123: END IF;
5124: END IF;

Line 5122: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', p_description);

5118: THEN
5119: IF p_description = FND_API.G_MISS_CHAR THEN
5120: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', TO_CHAR(NULL));
5121: ELSE
5122: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', p_description);
5123: END IF;
5124: END IF;
5125:
5126: IF p_raw_cost IS NOT NULL

Line 5130: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCost', TO_NUMBER(NULL));

5126: IF p_raw_cost IS NOT NULL
5127: AND p_raw_cost <> nvl(l_budget_line_rec.raw_cost,FND_API.G_MISS_NUM)
5128: THEN
5129: IF p_raw_cost = FND_API.G_MISS_NUM THEN
5130: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCost', TO_NUMBER(NULL));
5131: ELSE
5132: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCost', p_raw_cost);
5133: END IF;
5134: END IF;

Line 5132: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCost', p_raw_cost);

5128: THEN
5129: IF p_raw_cost = FND_API.G_MISS_NUM THEN
5130: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCost', TO_NUMBER(NULL));
5131: ELSE
5132: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCost', p_raw_cost);
5133: END IF;
5134: END IF;
5135:
5136: IF l_burdened_cost_flag = 'N' -- added for burden_distributed_cost ='N'

Line 5143: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCostForB', TO_NUMBER(NULL));

5139: IF p_raw_cost IS NOT NULL
5140: AND p_raw_cost <> nvl(l_budget_line_rec.burdened_cost,FND_API.G_MISS_NUM)
5141: THEN
5142: IF p_raw_cost = FND_API.G_MISS_NUM THEN
5143: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCostForB', TO_NUMBER(NULL));
5144: ELSE
5145: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCostForB', p_raw_cost);
5146: END IF;
5147: END IF;

Line 5145: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCostForB', p_raw_cost);

5141: THEN
5142: IF p_raw_cost = FND_API.G_MISS_NUM THEN
5143: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCostForB', TO_NUMBER(NULL));
5144: ELSE
5145: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCostForB', p_raw_cost);
5146: END IF;
5147: END IF;
5148:
5149: ELSE

Line 5155: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBurdenedCost', TO_NUMBER(NULL));

5151: IF p_burdened_cost IS NOT NULL
5152: AND p_burdened_cost <> nvl(l_budget_line_rec.burdened_cost,FND_API.G_MISS_NUM)
5153: THEN
5154: IF p_burdened_cost = FND_API.G_MISS_NUM THEN
5155: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBurdenedCost', TO_NUMBER(NULL));
5156: ELSE
5157: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBurdenedCost', p_burdened_cost);
5158: END IF;
5159: END IF;

Line 5157: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBurdenedCost', p_burdened_cost);

5153: THEN
5154: IF p_burdened_cost = FND_API.G_MISS_NUM THEN
5155: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBurdenedCost', TO_NUMBER(NULL));
5156: ELSE
5157: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBurdenedCost', p_burdened_cost);
5158: END IF;
5159: END IF;
5160:
5161: END IF;--l_burdened_cost_flag = 'N'

Line 5167: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRevenue',TO_NUMBER(NULL));

5163: IF p_revenue IS NOT NULL
5164: AND p_revenue <> nvl(l_budget_line_rec.revenue,FND_API.G_MISS_NUM)
5165: THEN
5166: IF p_revenue = FND_API.G_MISS_NUM THEN
5167: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRevenue',TO_NUMBER(NULL));
5168: ELSE
5169: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRevenue',p_revenue);
5170: END IF;
5171: END IF;

Line 5169: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRevenue',p_revenue);

5165: THEN
5166: IF p_revenue = FND_API.G_MISS_NUM THEN
5167: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRevenue',TO_NUMBER(NULL));
5168: ELSE
5169: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRevenue',p_revenue);
5170: END IF;
5171: END IF;
5172:
5173: IF p_quantity IS NOT NULL

Line 5177: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xQuantity',TO_NUMBER(NULL));

5173: IF p_quantity IS NOT NULL
5174: AND p_quantity <> nvl(l_budget_line_rec.quantity,FND_API.G_MISS_NUM)
5175: THEN
5176: IF p_quantity = FND_API.G_MISS_NUM THEN
5177: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xQuantity',TO_NUMBER(NULL));
5178: ELSE
5179: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xQuantity',p_quantity);
5180: END IF;
5181: END IF;

Line 5179: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xQuantity',p_quantity);

5175: THEN
5176: IF p_quantity = FND_API.G_MISS_NUM THEN
5177: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xQuantity',TO_NUMBER(NULL));
5178: ELSE
5179: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xQuantity',p_quantity);
5180: END IF;
5181: END IF;
5182:
5183: IF p_change_reason_code IS NOT NULL

Line 5187: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', TO_CHAR(NULL));

5183: IF p_change_reason_code IS NOT NULL
5184: AND p_change_reason_code <> nvl(l_budget_line_rec.change_reason_code,FND_API.G_MISS_CHAR)
5185: THEN
5186: IF p_change_reason_code = FND_API.G_MISS_CHAR THEN
5187: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', TO_CHAR(NULL));
5188: ELSE
5189: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', p_change_reason_code);
5190: END IF;
5191: END IF;

Line 5189: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', p_change_reason_code);

5185: THEN
5186: IF p_change_reason_code = FND_API.G_MISS_CHAR THEN
5187: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', TO_CHAR(NULL));
5188: ELSE
5189: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', p_change_reason_code);
5190: END IF;
5191: END IF;
5192:
5193: IF p_attribute_category IS NOT NULL

Line 5197: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttributeCategory', TO_CHAR(NULL));

5193: IF p_attribute_category IS NOT NULL
5194: AND p_attribute_category <> nvl(l_budget_line_rec.attribute_category,FND_API.G_MISS_CHAR)
5195: THEN
5196: IF p_attribute_category = FND_API.G_MISS_CHAR THEN
5197: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttributeCategory', TO_CHAR(NULL));
5198: ELSE
5199: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttributeCategory', p_attribute_category);
5200: END IF;
5201: END IF;

Line 5199: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttributeCategory', p_attribute_category);

5195: THEN
5196: IF p_attribute_category = FND_API.G_MISS_CHAR THEN
5197: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttributeCategory', TO_CHAR(NULL));
5198: ELSE
5199: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttributeCategory', p_attribute_category);
5200: END IF;
5201: END IF;
5202:
5203: IF p_attribute1 IS NOT NULL

Line 5207: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute1', TO_CHAR(NULL));

5203: IF p_attribute1 IS NOT NULL
5204: AND p_attribute1 <> nvl(l_budget_line_rec.attribute1,FND_API.G_MISS_CHAR)
5205: THEN
5206: IF p_attribute1 = FND_API.G_MISS_CHAR THEN
5207: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute1', TO_CHAR(NULL));
5208: ELSE
5209: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute1', p_attribute1);
5210: END IF;
5211: END IF;

Line 5209: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute1', p_attribute1);

5205: THEN
5206: IF p_attribute1 = FND_API.G_MISS_CHAR THEN
5207: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute1', TO_CHAR(NULL));
5208: ELSE
5209: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute1', p_attribute1);
5210: END IF;
5211: END IF;
5212:
5213: IF p_attribute2 IS NOT NULL

Line 5217: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute2', TO_CHAR(NULL));

5213: IF p_attribute2 IS NOT NULL
5214: AND p_attribute2 <> nvl(l_budget_line_rec.attribute2,FND_API.G_MISS_CHAR)
5215: THEN
5216: IF p_attribute2 = FND_API.G_MISS_CHAR THEN
5217: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute2', TO_CHAR(NULL));
5218: ELSE
5219: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute2', p_attribute2);
5220: END IF;
5221: END IF;

Line 5219: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute2', p_attribute2);

5215: THEN
5216: IF p_attribute2 = FND_API.G_MISS_CHAR THEN
5217: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute2', TO_CHAR(NULL));
5218: ELSE
5219: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute2', p_attribute2);
5220: END IF;
5221: END IF;
5222:
5223: IF p_attribute3 IS NOT NULL

Line 5227: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute3', TO_CHAR(NULL));

5223: IF p_attribute3 IS NOT NULL
5224: AND p_attribute3 <> nvl(l_budget_line_rec.attribute3,FND_API.G_MISS_CHAR)
5225: THEN
5226: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
5227: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute3', TO_CHAR(NULL));
5228: ELSE
5229: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute3', p_attribute3);
5230: END IF;
5231: END IF;

Line 5229: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute3', p_attribute3);

5225: THEN
5226: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
5227: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute3', TO_CHAR(NULL));
5228: ELSE
5229: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute3', p_attribute3);
5230: END IF;
5231: END IF;
5232:
5233: IF p_attribute4 IS NOT NULL

Line 5237: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute4', TO_CHAR(NULL));

5233: IF p_attribute4 IS NOT NULL
5234: AND p_attribute4 <> nvl(l_budget_line_rec.attribute4,FND_API.G_MISS_CHAR)
5235: THEN
5236: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
5237: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute4', TO_CHAR(NULL));
5238: ELSE
5239: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute4', p_attribute4);
5240: END IF;
5241: END IF;

Line 5239: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute4', p_attribute4);

5235: THEN
5236: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
5237: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute4', TO_CHAR(NULL));
5238: ELSE
5239: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute4', p_attribute4);
5240: END IF;
5241: END IF;
5242:
5243: IF p_attribute5 IS NOT NULL

Line 5247: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute5', TO_CHAR(NULL));

5243: IF p_attribute5 IS NOT NULL
5244: AND p_attribute5 <> nvl(l_budget_line_rec.attribute5,FND_API.G_MISS_CHAR)
5245: THEN
5246: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
5247: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute5', TO_CHAR(NULL));
5248: ELSE
5249: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute5', p_attribute5);
5250: END IF;
5251: END IF;

Line 5249: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute5', p_attribute5);

5245: THEN
5246: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
5247: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute5', TO_CHAR(NULL));
5248: ELSE
5249: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute5', p_attribute5);
5250: END IF;
5251: END IF;
5252:
5253: IF p_attribute6 IS NOT NULL

Line 5257: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute6', TO_CHAR(NULL));

5253: IF p_attribute6 IS NOT NULL
5254: AND p_attribute6 <> nvl(l_budget_line_rec.attribute6,FND_API.G_MISS_CHAR)
5255: THEN
5256: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
5257: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute6', TO_CHAR(NULL));
5258: ELSE
5259: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute6', p_attribute6);
5260: END IF;
5261: END IF;

Line 5259: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute6', p_attribute6);

5255: THEN
5256: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
5257: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute6', TO_CHAR(NULL));
5258: ELSE
5259: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute6', p_attribute6);
5260: END IF;
5261: END IF;
5262:
5263: IF p_attribute7 IS NOT NULL

Line 5267: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute7', TO_CHAR(NULL));

5263: IF p_attribute7 IS NOT NULL
5264: AND p_attribute7 <> nvl(l_budget_line_rec.attribute7,FND_API.G_MISS_CHAR)
5265: THEN
5266: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
5267: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute7', TO_CHAR(NULL));
5268: ELSE
5269: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute7', p_attribute7);
5270: END IF;
5271: END IF;

Line 5269: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute7', p_attribute7);

5265: THEN
5266: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
5267: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute7', TO_CHAR(NULL));
5268: ELSE
5269: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute7', p_attribute7);
5270: END IF;
5271: END IF;
5272:
5273: IF p_attribute8 IS NOT NULL

Line 5277: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute8', TO_CHAR(NULL));

5273: IF p_attribute8 IS NOT NULL
5274: AND p_attribute8 <> nvl(l_budget_line_rec.attribute8,FND_API.G_MISS_CHAR)
5275: THEN
5276: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
5277: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute8', TO_CHAR(NULL));
5278: ELSE
5279: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute8', p_attribute8);
5280: END IF;
5281: END IF;

Line 5279: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute8', p_attribute8);

5275: THEN
5276: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
5277: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute8', TO_CHAR(NULL));
5278: ELSE
5279: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute8', p_attribute8);
5280: END IF;
5281: END IF;
5282:
5283: IF p_attribute9 IS NOT NULL

Line 5287: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute9', TO_CHAR(NULL));

5283: IF p_attribute9 IS NOT NULL
5284: AND p_attribute9 <> nvl(l_budget_line_rec.attribute9,FND_API.G_MISS_CHAR)
5285: THEN
5286: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
5287: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute9', TO_CHAR(NULL));
5288: ELSE
5289: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute9', p_attribute9);
5290: END IF;
5291: END IF;

Line 5289: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute9', p_attribute9);

5285: THEN
5286: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
5287: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute9', TO_CHAR(NULL));
5288: ELSE
5289: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute9', p_attribute9);
5290: END IF;
5291: END IF;
5292:
5293: IF p_attribute10 IS NOT NULL

Line 5297: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute10', TO_CHAR(NULL));

5293: IF p_attribute10 IS NOT NULL
5294: AND p_attribute10 <> nvl(l_budget_line_rec.attribute10,FND_API.G_MISS_CHAR)
5295: THEN
5296: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
5297: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute10', TO_CHAR(NULL));
5298: ELSE
5299: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute10', p_attribute10);
5300: END IF;
5301: END IF;

Line 5299: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute10', p_attribute10);

5295: THEN
5296: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
5297: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute10', TO_CHAR(NULL));
5298: ELSE
5299: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute10', p_attribute10);
5300: END IF;
5301: END IF;
5302:
5303: IF p_attribute11 IS NOT NULL

Line 5307: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute11', TO_CHAR(NULL));

5303: IF p_attribute11 IS NOT NULL
5304: AND p_attribute11 <> nvl(l_budget_line_rec.attribute11,FND_API.G_MISS_CHAR)
5305: THEN
5306: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
5307: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute11', TO_CHAR(NULL));
5308: ELSE
5309: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute11', p_attribute11);
5310: END IF;
5311: END IF;

Line 5309: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute11', p_attribute11);

5305: THEN
5306: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
5307: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute11', TO_CHAR(NULL));
5308: ELSE
5309: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute11', p_attribute11);
5310: END IF;
5311: END IF;
5312:
5313: IF p_attribute12 IS NOT NULL

Line 5317: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute12', TO_CHAR(NULL));

5313: IF p_attribute12 IS NOT NULL
5314: AND p_attribute12 <> nvl(l_budget_line_rec.attribute12,FND_API.G_MISS_CHAR)
5315: THEN
5316: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
5317: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute12', TO_CHAR(NULL));
5318: ELSE
5319: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute12', p_attribute12);
5320: END IF;
5321: END IF;

Line 5319: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute12', p_attribute12);

5315: THEN
5316: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
5317: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute12', TO_CHAR(NULL));
5318: ELSE
5319: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute12', p_attribute12);
5320: END IF;
5321: END IF;
5322:
5323: IF p_attribute13 IS NOT NULL

Line 5327: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute13', TO_CHAR(NULL));

5323: IF p_attribute13 IS NOT NULL
5324: AND p_attribute13 <> nvl(l_budget_line_rec.attribute13,FND_API.G_MISS_CHAR)
5325: THEN
5326: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
5327: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute13', TO_CHAR(NULL));
5328: ELSE
5329: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute13', p_attribute13);
5330: END IF;
5331: END IF;

Line 5329: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute13', p_attribute13);

5325: THEN
5326: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
5327: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute13', TO_CHAR(NULL));
5328: ELSE
5329: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute13', p_attribute13);
5330: END IF;
5331: END IF;
5332:
5333: IF p_attribute14 IS NOT NULL

Line 5337: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute14', TO_CHAR(NULL));

5333: IF p_attribute14 IS NOT NULL
5334: AND p_attribute14 <> nvl(l_budget_line_rec.attribute14,FND_API.G_MISS_CHAR)
5335: THEN
5336: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
5337: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute14', TO_CHAR(NULL));
5338: ELSE
5339: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute14', p_attribute14);
5340: END IF;
5341: END IF;

Line 5339: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute14', p_attribute14);

5335: THEN
5336: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
5337: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute14', TO_CHAR(NULL));
5338: ELSE
5339: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute14', p_attribute14);
5340: END IF;
5341: END IF;
5342:
5343: IF p_attribute15 IS NOT NULL

Line 5347: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute15', TO_CHAR(NULL));

5343: IF p_attribute15 IS NOT NULL
5344: AND p_attribute15 <> nvl(l_budget_line_rec.attribute15,FND_API.G_MISS_CHAR)
5345: THEN
5346: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
5347: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute15', TO_CHAR(NULL));
5348: ELSE
5349: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute15', p_attribute15);
5350: END IF;
5351: END IF;

Line 5349: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute15', p_attribute15);

5345: THEN
5346: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
5347: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute15', TO_CHAR(NULL));
5348: ELSE
5349: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute15', p_attribute15);
5350: END IF;
5351: END IF;
5352:
5353: --Dates should always be bound instead of concatenating them as strings to

Line 5355: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xLastUpdateDate', SYSDATE);

5351: END IF;
5352:
5353: --Dates should always be bound instead of concatenating them as strings to
5354: --avoid conversion problems.
5355: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xLastUpdateDate', SYSDATE);
5356: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xStartDate', p_start_date);
5357:
5358:
5359: l_rows := DBMS_SQL.execute(l_cursor_id);

Line 5356: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xStartDate', p_start_date);

5352:
5353: --Dates should always be bound instead of concatenating them as strings to
5354: --avoid conversion problems.
5355: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xLastUpdateDate', SYSDATE);
5356: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xStartDate', p_start_date);
5357:
5358:
5359: l_rows := DBMS_SQL.execute(l_cursor_id);
5360:

Line 5359: l_rows := DBMS_SQL.execute(l_cursor_id);

5355: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xLastUpdateDate', SYSDATE);
5356: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xStartDate', p_start_date);
5357:
5358:
5359: l_rows := DBMS_SQL.execute(l_cursor_id);
5360:
5361: --dbms_output.put_line('# rows processed: '||l_rows);
5362:
5363: IF DBMS_SQL.is_open (l_cursor_id)

Line 5363: IF DBMS_SQL.is_open (l_cursor_id)

5359: l_rows := DBMS_SQL.execute(l_cursor_id);
5360:
5361: --dbms_output.put_line('# rows processed: '||l_rows);
5362:
5363: IF DBMS_SQL.is_open (l_cursor_id)
5364: THEN
5365: DBMS_SQL.close_cursor (l_cursor_id);
5366: END IF;
5367:

Line 5365: DBMS_SQL.close_cursor (l_cursor_id);

5361: --dbms_output.put_line('# rows processed: '||l_rows);
5362:
5363: IF DBMS_SQL.is_open (l_cursor_id)
5364: THEN
5365: DBMS_SQL.close_cursor (l_cursor_id);
5366: END IF;
5367:
5368: /* FPB2: MRC */
5369: BEGIN