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 5130: l_cursor_id := DBMS_SQL.open_cursor;

5126: --dbms_output.put_line('Statement: '||substr(l_statement,1,100));
5127: --dbms_output.put_line('Statement: '||substr(l_statement,101,100));
5128: --dbms_output.put_line('Statement: '||substr(l_statement,201,100));
5129:
5130: l_cursor_id := DBMS_SQL.open_cursor;
5131: DBMS_SQL.parse(l_cursor_id, l_statement, DBMS_SQL.native);
5132:
5133: IF p_description IS NOT NULL
5134: AND p_description <> nvl(l_budget_line_rec.description,FND_API.G_MISS_CHAR)

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

5127: --dbms_output.put_line('Statement: '||substr(l_statement,101,100));
5128: --dbms_output.put_line('Statement: '||substr(l_statement,201,100));
5129:
5130: l_cursor_id := DBMS_SQL.open_cursor;
5131: DBMS_SQL.parse(l_cursor_id, l_statement, DBMS_SQL.native);
5132:
5133: IF p_description IS NOT NULL
5134: AND p_description <> nvl(l_budget_line_rec.description,FND_API.G_MISS_CHAR)
5135: THEN

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

5133: IF p_description IS NOT NULL
5134: AND p_description <> nvl(l_budget_line_rec.description,FND_API.G_MISS_CHAR)
5135: THEN
5136: IF p_description = FND_API.G_MISS_CHAR THEN
5137: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', TO_CHAR(NULL));
5138: ELSE
5139: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', p_description);
5140: END IF;
5141: END IF;

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

5135: THEN
5136: IF p_description = FND_API.G_MISS_CHAR THEN
5137: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', TO_CHAR(NULL));
5138: ELSE
5139: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xDescription', p_description);
5140: END IF;
5141: END IF;
5142:
5143: IF p_raw_cost IS NOT NULL

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

5143: IF p_raw_cost IS NOT NULL
5144: AND p_raw_cost <> nvl(l_budget_line_rec.raw_cost,FND_API.G_MISS_NUM)
5145: THEN
5146: IF p_raw_cost = FND_API.G_MISS_NUM THEN
5147: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCost', TO_NUMBER(NULL));
5148: ELSE
5149: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCost', p_raw_cost);
5150: END IF;
5151: END IF;

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

5145: THEN
5146: IF p_raw_cost = FND_API.G_MISS_NUM THEN
5147: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCost', TO_NUMBER(NULL));
5148: ELSE
5149: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCost', p_raw_cost);
5150: END IF;
5151: END IF;
5152:
5153: IF l_burdened_cost_flag = 'N' -- added for burden_distributed_cost ='N'

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

5156: IF p_raw_cost IS NOT NULL
5157: AND p_raw_cost <> nvl(l_budget_line_rec.burdened_cost,FND_API.G_MISS_NUM)
5158: THEN
5159: IF p_raw_cost = FND_API.G_MISS_NUM THEN
5160: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCostForB', TO_NUMBER(NULL));
5161: ELSE
5162: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCostForB', p_raw_cost);
5163: END IF;
5164: END IF;

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

5158: THEN
5159: IF p_raw_cost = FND_API.G_MISS_NUM THEN
5160: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCostForB', TO_NUMBER(NULL));
5161: ELSE
5162: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRawCostForB', p_raw_cost);
5163: END IF;
5164: END IF;
5165:
5166: ELSE

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

5168: IF p_burdened_cost IS NOT NULL
5169: AND p_burdened_cost <> nvl(l_budget_line_rec.burdened_cost,FND_API.G_MISS_NUM)
5170: THEN
5171: IF p_burdened_cost = FND_API.G_MISS_NUM THEN
5172: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBurdenedCost', TO_NUMBER(NULL));
5173: ELSE
5174: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBurdenedCost', p_burdened_cost);
5175: END IF;
5176: END IF;

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

5170: THEN
5171: IF p_burdened_cost = FND_API.G_MISS_NUM THEN
5172: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBurdenedCost', TO_NUMBER(NULL));
5173: ELSE
5174: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xBurdenedCost', p_burdened_cost);
5175: END IF;
5176: END IF;
5177:
5178: END IF;--l_burdened_cost_flag = 'N'

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

5180: IF p_revenue IS NOT NULL
5181: AND p_revenue <> nvl(l_budget_line_rec.revenue,FND_API.G_MISS_NUM)
5182: THEN
5183: IF p_revenue = FND_API.G_MISS_NUM THEN
5184: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRevenue',TO_NUMBER(NULL));
5185: ELSE
5186: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRevenue',p_revenue);
5187: END IF;
5188: END IF;

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

5182: THEN
5183: IF p_revenue = FND_API.G_MISS_NUM THEN
5184: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRevenue',TO_NUMBER(NULL));
5185: ELSE
5186: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xRevenue',p_revenue);
5187: END IF;
5188: END IF;
5189:
5190: IF p_quantity IS NOT NULL

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

5190: IF p_quantity IS NOT NULL
5191: AND p_quantity <> nvl(l_budget_line_rec.quantity,FND_API.G_MISS_NUM)
5192: THEN
5193: IF p_quantity = FND_API.G_MISS_NUM THEN
5194: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xQuantity',TO_NUMBER(NULL));
5195: ELSE
5196: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xQuantity',p_quantity);
5197: END IF;
5198: END IF;

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

5192: THEN
5193: IF p_quantity = FND_API.G_MISS_NUM THEN
5194: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xQuantity',TO_NUMBER(NULL));
5195: ELSE
5196: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xQuantity',p_quantity);
5197: END IF;
5198: END IF;
5199:
5200: IF p_change_reason_code IS NOT NULL

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

5200: IF p_change_reason_code IS NOT NULL
5201: AND p_change_reason_code <> nvl(l_budget_line_rec.change_reason_code,FND_API.G_MISS_CHAR)
5202: THEN
5203: IF p_change_reason_code = FND_API.G_MISS_CHAR THEN
5204: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', TO_CHAR(NULL));
5205: ELSE
5206: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', p_change_reason_code);
5207: END IF;
5208: END IF;

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

5202: THEN
5203: IF p_change_reason_code = FND_API.G_MISS_CHAR THEN
5204: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', TO_CHAR(NULL));
5205: ELSE
5206: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xChangeReasonCode', p_change_reason_code);
5207: END IF;
5208: END IF;
5209:
5210: IF p_attribute_category IS NOT NULL

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

5210: IF p_attribute_category IS NOT NULL
5211: AND p_attribute_category <> nvl(l_budget_line_rec.attribute_category,FND_API.G_MISS_CHAR)
5212: THEN
5213: IF p_attribute_category = FND_API.G_MISS_CHAR THEN
5214: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttributeCategory', TO_CHAR(NULL));
5215: ELSE
5216: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttributeCategory', p_attribute_category);
5217: END IF;
5218: END IF;

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

5212: THEN
5213: IF p_attribute_category = FND_API.G_MISS_CHAR THEN
5214: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttributeCategory', TO_CHAR(NULL));
5215: ELSE
5216: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttributeCategory', p_attribute_category);
5217: END IF;
5218: END IF;
5219:
5220: IF p_attribute1 IS NOT NULL

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

5220: IF p_attribute1 IS NOT NULL
5221: AND p_attribute1 <> nvl(l_budget_line_rec.attribute1,FND_API.G_MISS_CHAR)
5222: THEN
5223: IF p_attribute1 = FND_API.G_MISS_CHAR THEN
5224: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute1', TO_CHAR(NULL));
5225: ELSE
5226: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute1', p_attribute1);
5227: END IF;
5228: END IF;

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

5222: THEN
5223: IF p_attribute1 = FND_API.G_MISS_CHAR THEN
5224: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute1', TO_CHAR(NULL));
5225: ELSE
5226: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute1', p_attribute1);
5227: END IF;
5228: END IF;
5229:
5230: IF p_attribute2 IS NOT NULL

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

5230: IF p_attribute2 IS NOT NULL
5231: AND p_attribute2 <> nvl(l_budget_line_rec.attribute2,FND_API.G_MISS_CHAR)
5232: THEN
5233: IF p_attribute2 = FND_API.G_MISS_CHAR THEN
5234: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute2', TO_CHAR(NULL));
5235: ELSE
5236: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute2', p_attribute2);
5237: END IF;
5238: END IF;

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

5232: THEN
5233: IF p_attribute2 = FND_API.G_MISS_CHAR THEN
5234: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute2', TO_CHAR(NULL));
5235: ELSE
5236: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute2', p_attribute2);
5237: END IF;
5238: END IF;
5239:
5240: IF p_attribute3 IS NOT NULL

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

5240: IF p_attribute3 IS NOT NULL
5241: AND p_attribute3 <> nvl(l_budget_line_rec.attribute3,FND_API.G_MISS_CHAR)
5242: THEN
5243: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
5244: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute3', TO_CHAR(NULL));
5245: ELSE
5246: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute3', p_attribute3);
5247: END IF;
5248: END IF;

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

5242: THEN
5243: IF p_attribute3 = FND_API.G_MISS_CHAR THEN
5244: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute3', TO_CHAR(NULL));
5245: ELSE
5246: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute3', p_attribute3);
5247: END IF;
5248: END IF;
5249:
5250: IF p_attribute4 IS NOT NULL

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

5250: IF p_attribute4 IS NOT NULL
5251: AND p_attribute4 <> nvl(l_budget_line_rec.attribute4,FND_API.G_MISS_CHAR)
5252: THEN
5253: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
5254: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute4', TO_CHAR(NULL));
5255: ELSE
5256: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute4', p_attribute4);
5257: END IF;
5258: END IF;

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

5252: THEN
5253: IF p_attribute4 = FND_API.G_MISS_CHAR THEN
5254: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute4', TO_CHAR(NULL));
5255: ELSE
5256: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute4', p_attribute4);
5257: END IF;
5258: END IF;
5259:
5260: IF p_attribute5 IS NOT NULL

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

5260: IF p_attribute5 IS NOT NULL
5261: AND p_attribute5 <> nvl(l_budget_line_rec.attribute5,FND_API.G_MISS_CHAR)
5262: THEN
5263: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
5264: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute5', TO_CHAR(NULL));
5265: ELSE
5266: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute5', p_attribute5);
5267: END IF;
5268: END IF;

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

5262: THEN
5263: IF p_attribute5 = FND_API.G_MISS_CHAR THEN
5264: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute5', TO_CHAR(NULL));
5265: ELSE
5266: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute5', p_attribute5);
5267: END IF;
5268: END IF;
5269:
5270: IF p_attribute6 IS NOT NULL

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

5270: IF p_attribute6 IS NOT NULL
5271: AND p_attribute6 <> nvl(l_budget_line_rec.attribute6,FND_API.G_MISS_CHAR)
5272: THEN
5273: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
5274: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute6', TO_CHAR(NULL));
5275: ELSE
5276: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute6', p_attribute6);
5277: END IF;
5278: END IF;

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

5272: THEN
5273: IF p_attribute6 = FND_API.G_MISS_CHAR THEN
5274: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute6', TO_CHAR(NULL));
5275: ELSE
5276: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute6', p_attribute6);
5277: END IF;
5278: END IF;
5279:
5280: IF p_attribute7 IS NOT NULL

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

5280: IF p_attribute7 IS NOT NULL
5281: AND p_attribute7 <> nvl(l_budget_line_rec.attribute7,FND_API.G_MISS_CHAR)
5282: THEN
5283: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
5284: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute7', TO_CHAR(NULL));
5285: ELSE
5286: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute7', p_attribute7);
5287: END IF;
5288: END IF;

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

5282: THEN
5283: IF p_attribute7 = FND_API.G_MISS_CHAR THEN
5284: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute7', TO_CHAR(NULL));
5285: ELSE
5286: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute7', p_attribute7);
5287: END IF;
5288: END IF;
5289:
5290: IF p_attribute8 IS NOT NULL

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

5290: IF p_attribute8 IS NOT NULL
5291: AND p_attribute8 <> nvl(l_budget_line_rec.attribute8,FND_API.G_MISS_CHAR)
5292: THEN
5293: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
5294: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute8', TO_CHAR(NULL));
5295: ELSE
5296: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute8', p_attribute8);
5297: END IF;
5298: END IF;

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

5292: THEN
5293: IF p_attribute8 = FND_API.G_MISS_CHAR THEN
5294: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute8', TO_CHAR(NULL));
5295: ELSE
5296: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute8', p_attribute8);
5297: END IF;
5298: END IF;
5299:
5300: IF p_attribute9 IS NOT NULL

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

5300: IF p_attribute9 IS NOT NULL
5301: AND p_attribute9 <> nvl(l_budget_line_rec.attribute9,FND_API.G_MISS_CHAR)
5302: THEN
5303: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
5304: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute9', TO_CHAR(NULL));
5305: ELSE
5306: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute9', p_attribute9);
5307: END IF;
5308: END IF;

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

5302: THEN
5303: IF p_attribute9 = FND_API.G_MISS_CHAR THEN
5304: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute9', TO_CHAR(NULL));
5305: ELSE
5306: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute9', p_attribute9);
5307: END IF;
5308: END IF;
5309:
5310: IF p_attribute10 IS NOT NULL

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

5310: IF p_attribute10 IS NOT NULL
5311: AND p_attribute10 <> nvl(l_budget_line_rec.attribute10,FND_API.G_MISS_CHAR)
5312: THEN
5313: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
5314: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute10', TO_CHAR(NULL));
5315: ELSE
5316: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute10', p_attribute10);
5317: END IF;
5318: END IF;

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

5312: THEN
5313: IF p_attribute10 = FND_API.G_MISS_CHAR THEN
5314: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute10', TO_CHAR(NULL));
5315: ELSE
5316: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute10', p_attribute10);
5317: END IF;
5318: END IF;
5319:
5320: IF p_attribute11 IS NOT NULL

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

5320: IF p_attribute11 IS NOT NULL
5321: AND p_attribute11 <> nvl(l_budget_line_rec.attribute11,FND_API.G_MISS_CHAR)
5322: THEN
5323: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
5324: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute11', TO_CHAR(NULL));
5325: ELSE
5326: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute11', p_attribute11);
5327: END IF;
5328: END IF;

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

5322: THEN
5323: IF p_attribute11 = FND_API.G_MISS_CHAR THEN
5324: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute11', TO_CHAR(NULL));
5325: ELSE
5326: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute11', p_attribute11);
5327: END IF;
5328: END IF;
5329:
5330: IF p_attribute12 IS NOT NULL

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

5330: IF p_attribute12 IS NOT NULL
5331: AND p_attribute12 <> nvl(l_budget_line_rec.attribute12,FND_API.G_MISS_CHAR)
5332: THEN
5333: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
5334: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute12', TO_CHAR(NULL));
5335: ELSE
5336: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute12', p_attribute12);
5337: END IF;
5338: END IF;

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

5332: THEN
5333: IF p_attribute12 = FND_API.G_MISS_CHAR THEN
5334: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute12', TO_CHAR(NULL));
5335: ELSE
5336: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute12', p_attribute12);
5337: END IF;
5338: END IF;
5339:
5340: IF p_attribute13 IS NOT NULL

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

5340: IF p_attribute13 IS NOT NULL
5341: AND p_attribute13 <> nvl(l_budget_line_rec.attribute13,FND_API.G_MISS_CHAR)
5342: THEN
5343: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
5344: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute13', TO_CHAR(NULL));
5345: ELSE
5346: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute13', p_attribute13);
5347: END IF;
5348: END IF;

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

5342: THEN
5343: IF p_attribute13 = FND_API.G_MISS_CHAR THEN
5344: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute13', TO_CHAR(NULL));
5345: ELSE
5346: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute13', p_attribute13);
5347: END IF;
5348: END IF;
5349:
5350: IF p_attribute14 IS NOT NULL

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

5350: IF p_attribute14 IS NOT NULL
5351: AND p_attribute14 <> nvl(l_budget_line_rec.attribute14,FND_API.G_MISS_CHAR)
5352: THEN
5353: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
5354: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute14', TO_CHAR(NULL));
5355: ELSE
5356: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute14', p_attribute14);
5357: END IF;
5358: END IF;

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

5352: THEN
5353: IF p_attribute14 = FND_API.G_MISS_CHAR THEN
5354: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute14', TO_CHAR(NULL));
5355: ELSE
5356: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute14', p_attribute14);
5357: END IF;
5358: END IF;
5359:
5360: IF p_attribute15 IS NOT NULL

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

5360: IF p_attribute15 IS NOT NULL
5361: AND p_attribute15 <> nvl(l_budget_line_rec.attribute15,FND_API.G_MISS_CHAR)
5362: THEN
5363: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
5364: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute15', TO_CHAR(NULL));
5365: ELSE
5366: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute15', p_attribute15);
5367: END IF;
5368: END IF;

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

5362: THEN
5363: IF p_attribute15 = FND_API.G_MISS_CHAR THEN
5364: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute15', TO_CHAR(NULL));
5365: ELSE
5366: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xAttribute15', p_attribute15);
5367: END IF;
5368: END IF;
5369:
5370: --Dates should always be bound instead of concatenating them as strings to

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

5368: END IF;
5369:
5370: --Dates should always be bound instead of concatenating them as strings to
5371: --avoid conversion problems.
5372: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xLastUpdateDate', SYSDATE);
5373: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xStartDate', p_start_date);
5374:
5375:
5376: l_rows := DBMS_SQL.execute(l_cursor_id);

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

5369:
5370: --Dates should always be bound instead of concatenating them as strings to
5371: --avoid conversion problems.
5372: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xLastUpdateDate', SYSDATE);
5373: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xStartDate', p_start_date);
5374:
5375:
5376: l_rows := DBMS_SQL.execute(l_cursor_id);
5377:

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

5372: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xLastUpdateDate', SYSDATE);
5373: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':xStartDate', p_start_date);
5374:
5375:
5376: l_rows := DBMS_SQL.execute(l_cursor_id);
5377:
5378: --dbms_output.put_line('# rows processed: '||l_rows);
5379:
5380: IF DBMS_SQL.is_open (l_cursor_id)

Line 5380: IF DBMS_SQL.is_open (l_cursor_id)

5376: l_rows := DBMS_SQL.execute(l_cursor_id);
5377:
5378: --dbms_output.put_line('# rows processed: '||l_rows);
5379:
5380: IF DBMS_SQL.is_open (l_cursor_id)
5381: THEN
5382: DBMS_SQL.close_cursor (l_cursor_id);
5383: END IF;
5384:

Line 5382: DBMS_SQL.close_cursor (l_cursor_id);

5378: --dbms_output.put_line('# rows processed: '||l_rows);
5379:
5380: IF DBMS_SQL.is_open (l_cursor_id)
5381: THEN
5382: DBMS_SQL.close_cursor (l_cursor_id);
5383: END IF;
5384:
5385: /* FPB2: MRC */
5386: BEGIN