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

Line 5296: l_cursor := dbms_sql.open_cursor;

5292:
5293:
5294:
5295: --Create and execute UPDATE statement
5296: l_cursor := dbms_sql.open_cursor;
5297: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
5298:
5299: --Populate Bind Variables if used
5300: IF b_pm_asset_reference IS NOT NULL THEN

Line 5297: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);

5293:
5294:
5295: --Create and execute UPDATE statement
5296: l_cursor := dbms_sql.open_cursor;
5297: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
5298:
5299: --Populate Bind Variables if used
5300: IF b_pm_asset_reference IS NOT NULL THEN
5301: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_pm_asset_reference', RTRIM(b_pm_asset_reference));

Line 5301: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_pm_asset_reference', RTRIM(b_pm_asset_reference));

5297: dbms_sql.parse(l_cursor, l_statement, dbms_sql.native);
5298:
5299: --Populate Bind Variables if used
5300: IF b_pm_asset_reference IS NOT NULL THEN
5301: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_pm_asset_reference', RTRIM(b_pm_asset_reference));
5302: END IF;
5303:
5304: IF b_pa_asset_name IS NOT NULL THEN
5305: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_pa_asset_name', RTRIM(b_pa_asset_name));

Line 5305: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_pa_asset_name', RTRIM(b_pa_asset_name));

5301: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_pm_asset_reference', RTRIM(b_pm_asset_reference));
5302: END IF;
5303:
5304: IF b_pa_asset_name IS NOT NULL THEN
5305: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_pa_asset_name', RTRIM(b_pa_asset_name));
5306: END IF;
5307:
5308: IF b_asset_description IS NOT NULL THEN
5309: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_description', RTRIM(b_asset_description));

Line 5309: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_description', RTRIM(b_asset_description));

5305: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_pa_asset_name', RTRIM(b_pa_asset_name));
5306: END IF;
5307:
5308: IF b_asset_description IS NOT NULL THEN
5309: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_description', RTRIM(b_asset_description));
5310: END IF;
5311:
5312: IF b_date_placed_in_service IS NOT NULL THEN
5313: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_date_placed_in_service', b_date_placed_in_service);

Line 5313: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_date_placed_in_service', b_date_placed_in_service);

5309: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_description', RTRIM(b_asset_description));
5310: END IF;
5311:
5312: IF b_date_placed_in_service IS NOT NULL THEN
5313: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_date_placed_in_service', b_date_placed_in_service);
5314: END IF;
5315:
5316: IF b_project_asset_type IS NOT NULL THEN
5317: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_project_asset_type', RTRIM(b_project_asset_type));

Line 5317: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_project_asset_type', RTRIM(b_project_asset_type));

5313: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_date_placed_in_service', b_date_placed_in_service);
5314: END IF;
5315:
5316: IF b_project_asset_type IS NOT NULL THEN
5317: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_project_asset_type', RTRIM(b_project_asset_type));
5318: END IF;
5319:
5320: IF b_asset_number IS NOT NULL THEN
5321: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_number', RTRIM(b_asset_number));

Line 5321: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_number', RTRIM(b_asset_number));

5317: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_project_asset_type', RTRIM(b_project_asset_type));
5318: END IF;
5319:
5320: IF b_asset_number IS NOT NULL THEN
5321: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_number', RTRIM(b_asset_number));
5322: END IF;
5323:
5324: IF b_location_id IS NOT NULL THEN
5325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_location_id', b_location_id);

Line 5325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_location_id', b_location_id);

5321: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_number', RTRIM(b_asset_number));
5322: END IF;
5323:
5324: IF b_location_id IS NOT NULL THEN
5325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_location_id', b_location_id);
5326: END IF;
5327:
5328: IF b_assigned_to_person_id IS NOT NULL THEN
5329: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_assigned_to_person_id', b_assigned_to_person_id);

Line 5329: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_assigned_to_person_id', b_assigned_to_person_id);

5325: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_location_id', b_location_id);
5326: END IF;
5327:
5328: IF b_assigned_to_person_id IS NOT NULL THEN
5329: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_assigned_to_person_id', b_assigned_to_person_id);
5330: END IF;
5331:
5332: IF b_book_type_code IS NOT NULL THEN
5333: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_book_type_code', RTRIM(b_book_type_code));

Line 5333: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_book_type_code', RTRIM(b_book_type_code));

5329: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_assigned_to_person_id', b_assigned_to_person_id);
5330: END IF;
5331:
5332: IF b_book_type_code IS NOT NULL THEN
5333: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_book_type_code', RTRIM(b_book_type_code));
5334: END IF;
5335:
5336: IF b_parent_asset_id IS NOT NULL THEN
5337: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_parent_asset_id', b_parent_asset_id);

Line 5337: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_parent_asset_id', b_parent_asset_id);

5333: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_book_type_code', RTRIM(b_book_type_code));
5334: END IF;
5335:
5336: IF b_parent_asset_id IS NOT NULL THEN
5337: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_parent_asset_id', b_parent_asset_id);
5338: END IF;
5339:
5340: IF b_asset_category_id IS NOT NULL THEN
5341: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_category_id', b_asset_category_id);

Line 5341: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_category_id', b_asset_category_id);

5337: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_parent_asset_id', b_parent_asset_id);
5338: END IF;
5339:
5340: IF b_asset_category_id IS NOT NULL THEN
5341: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_category_id', b_asset_category_id);
5342: END IF;
5343:
5344: IF b_amortize_flag IS NOT NULL THEN
5345: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_amortize_flag', RTRIM(b_amortize_flag));

Line 5345: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_amortize_flag', RTRIM(b_amortize_flag));

5341: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_category_id', b_asset_category_id);
5342: END IF;
5343:
5344: IF b_amortize_flag IS NOT NULL THEN
5345: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_amortize_flag', RTRIM(b_amortize_flag));
5346: END IF;
5347:
5348: IF b_depreciate_flag IS NOT NULL THEN
5349: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_depreciate_flag', RTRIM(b_depreciate_flag));

Line 5349: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_depreciate_flag', RTRIM(b_depreciate_flag));

5345: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_amortize_flag', RTRIM(b_amortize_flag));
5346: END IF;
5347:
5348: IF b_depreciate_flag IS NOT NULL THEN
5349: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_depreciate_flag', RTRIM(b_depreciate_flag));
5350: END IF;
5351:
5352: IF b_depreciation_expense_ccid IS NOT NULL THEN
5353: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_depreciation_expense_ccid', b_depreciation_expense_ccid);

Line 5353: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_depreciation_expense_ccid', b_depreciation_expense_ccid);

5349: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_depreciate_flag', RTRIM(b_depreciate_flag));
5350: END IF;
5351:
5352: IF b_depreciation_expense_ccid IS NOT NULL THEN
5353: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_depreciation_expense_ccid', b_depreciation_expense_ccid);
5354: END IF;
5355:
5356: IF b_asset_key_ccid IS NOT NULL THEN
5357: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_key_ccid', b_asset_key_ccid);

Line 5357: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_key_ccid', b_asset_key_ccid);

5353: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_depreciation_expense_ccid', b_depreciation_expense_ccid);
5354: END IF;
5355:
5356: IF b_asset_key_ccid IS NOT NULL THEN
5357: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_key_ccid', b_asset_key_ccid);
5358: END IF;
5359:
5360: IF b_ret_target_asset_id IS NOT NULL THEN
5361: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_ret_target_asset_id', b_ret_target_asset_id);

Line 5361: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_ret_target_asset_id', b_ret_target_asset_id);

5357: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_key_ccid', b_asset_key_ccid);
5358: END IF;
5359:
5360: IF b_ret_target_asset_id IS NOT NULL THEN
5361: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_ret_target_asset_id', b_ret_target_asset_id);
5362: END IF;
5363:
5364: IF b_asset_units IS NOT NULL THEN
5365: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_units', b_asset_units);

Line 5365: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_units', b_asset_units);

5361: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_ret_target_asset_id', b_ret_target_asset_id);
5362: END IF;
5363:
5364: IF b_asset_units IS NOT NULL THEN
5365: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_units', b_asset_units);
5366: END IF;
5367: --Added for bug 4744574
5368: IF b_estimated_in_service_date IS NOT NULL THEN
5369: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_estimated_in_service_date', b_estimated_in_service_date);

Line 5369: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_estimated_in_service_date', b_estimated_in_service_date);

5365: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_asset_units', b_asset_units);
5366: END IF;
5367: --Added for bug 4744574
5368: IF b_estimated_in_service_date IS NOT NULL THEN
5369: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_estimated_in_service_date', b_estimated_in_service_date);
5370: END IF;
5371: --End changes for 4744574
5372:
5373: IF b_estimated_asset_units IS NOT NULL THEN

Line 5374: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_estimated_asset_units', b_estimated_asset_units);

5370: END IF;
5371: --End changes for 4744574
5372:
5373: IF b_estimated_asset_units IS NOT NULL THEN
5374: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_estimated_asset_units', b_estimated_asset_units);
5375: END IF;
5376:
5377: IF b_estimated_cost IS NOT NULL THEN
5378: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_estimated_cost', b_estimated_cost);

Line 5378: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_estimated_cost', b_estimated_cost);

5374: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_estimated_asset_units', b_estimated_asset_units);
5375: END IF;
5376:
5377: IF b_estimated_cost IS NOT NULL THEN
5378: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_estimated_cost', b_estimated_cost);
5379: END IF;
5380:
5381: IF b_manufacturer_name IS NOT NULL THEN
5382: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_manufacturer_name', RTRIM(b_manufacturer_name));

Line 5382: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_manufacturer_name', RTRIM(b_manufacturer_name));

5378: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_estimated_cost', b_estimated_cost);
5379: END IF;
5380:
5381: IF b_manufacturer_name IS NOT NULL THEN
5382: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_manufacturer_name', RTRIM(b_manufacturer_name));
5383: END IF;
5384:
5385: IF b_model_number IS NOT NULL THEN
5386: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_model_number', RTRIM(b_model_number));

Line 5386: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_model_number', RTRIM(b_model_number));

5382: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_manufacturer_name', RTRIM(b_manufacturer_name));
5383: END IF;
5384:
5385: IF b_model_number IS NOT NULL THEN
5386: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_model_number', RTRIM(b_model_number));
5387: END IF;
5388:
5389: IF b_tag_number IS NOT NULL THEN
5390: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_tag_number', RTRIM(b_tag_number));

Line 5390: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_tag_number', RTRIM(b_tag_number));

5386: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_model_number', RTRIM(b_model_number));
5387: END IF;
5388:
5389: IF b_tag_number IS NOT NULL THEN
5390: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_tag_number', RTRIM(b_tag_number));
5391: END IF;
5392:
5393: IF b_serial_number IS NOT NULL THEN
5394: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_serial_number', RTRIM(b_serial_number));

Line 5394: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_serial_number', RTRIM(b_serial_number));

5390: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_tag_number', RTRIM(b_tag_number));
5391: END IF;
5392:
5393: IF b_serial_number IS NOT NULL THEN
5394: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_serial_number', RTRIM(b_serial_number));
5395: END IF;
5396:
5397: IF b_attribute_category IS NOT NULL THEN
5398: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute_category', RTRIM(b_attribute_category));

Line 5398: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute_category', RTRIM(b_attribute_category));

5394: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_serial_number', RTRIM(b_serial_number));
5395: END IF;
5396:
5397: IF b_attribute_category IS NOT NULL THEN
5398: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute_category', RTRIM(b_attribute_category));
5399: END IF;
5400:
5401: IF b_attribute1 IS NOT NULL THEN
5402: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute1', RTRIM(b_attribute1));

Line 5402: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute1', RTRIM(b_attribute1));

5398: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute_category', RTRIM(b_attribute_category));
5399: END IF;
5400:
5401: IF b_attribute1 IS NOT NULL THEN
5402: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute1', RTRIM(b_attribute1));
5403: END IF;
5404:
5405: IF b_attribute2 IS NOT NULL THEN
5406: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute2', RTRIM(b_attribute2));

Line 5406: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute2', RTRIM(b_attribute2));

5402: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute1', RTRIM(b_attribute1));
5403: END IF;
5404:
5405: IF b_attribute2 IS NOT NULL THEN
5406: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute2', RTRIM(b_attribute2));
5407: END IF;
5408:
5409: IF b_attribute3 IS NOT NULL THEN
5410: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute3', RTRIM(b_attribute3));

Line 5410: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute3', RTRIM(b_attribute3));

5406: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute2', RTRIM(b_attribute2));
5407: END IF;
5408:
5409: IF b_attribute3 IS NOT NULL THEN
5410: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute3', RTRIM(b_attribute3));
5411: END IF;
5412:
5413: IF b_attribute4 IS NOT NULL THEN
5414: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute4', RTRIM(b_attribute4));

Line 5414: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute4', RTRIM(b_attribute4));

5410: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute3', RTRIM(b_attribute3));
5411: END IF;
5412:
5413: IF b_attribute4 IS NOT NULL THEN
5414: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute4', RTRIM(b_attribute4));
5415: END IF;
5416:
5417: IF b_attribute5 IS NOT NULL THEN
5418: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute5', RTRIM(b_attribute5));

Line 5418: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute5', RTRIM(b_attribute5));

5414: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute4', RTRIM(b_attribute4));
5415: END IF;
5416:
5417: IF b_attribute5 IS NOT NULL THEN
5418: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute5', RTRIM(b_attribute5));
5419: END IF;
5420:
5421: IF b_attribute6 IS NOT NULL THEN
5422: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute6', RTRIM(b_attribute6));

Line 5422: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute6', RTRIM(b_attribute6));

5418: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute5', RTRIM(b_attribute5));
5419: END IF;
5420:
5421: IF b_attribute6 IS NOT NULL THEN
5422: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute6', RTRIM(b_attribute6));
5423: END IF;
5424:
5425: IF b_attribute7 IS NOT NULL THEN
5426: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute7', RTRIM(b_attribute7));

Line 5426: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute7', RTRIM(b_attribute7));

5422: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute6', RTRIM(b_attribute6));
5423: END IF;
5424:
5425: IF b_attribute7 IS NOT NULL THEN
5426: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute7', RTRIM(b_attribute7));
5427: END IF;
5428:
5429: IF b_attribute8 IS NOT NULL THEN
5430: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute8', RTRIM(b_attribute8));

Line 5430: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute8', RTRIM(b_attribute8));

5426: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute7', RTRIM(b_attribute7));
5427: END IF;
5428:
5429: IF b_attribute8 IS NOT NULL THEN
5430: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute8', RTRIM(b_attribute8));
5431: END IF;
5432:
5433: IF b_attribute9 IS NOT NULL THEN
5434: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute9', RTRIM(b_attribute9));

Line 5434: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute9', RTRIM(b_attribute9));

5430: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute8', RTRIM(b_attribute8));
5431: END IF;
5432:
5433: IF b_attribute9 IS NOT NULL THEN
5434: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute9', RTRIM(b_attribute9));
5435: END IF;
5436:
5437: IF b_attribute10 IS NOT NULL THEN
5438: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute10', RTRIM(b_attribute10));

Line 5438: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute10', RTRIM(b_attribute10));

5434: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute9', RTRIM(b_attribute9));
5435: END IF;
5436:
5437: IF b_attribute10 IS NOT NULL THEN
5438: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute10', RTRIM(b_attribute10));
5439: END IF;
5440:
5441: IF b_attribute11 IS NOT NULL THEN
5442: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute11', RTRIM(b_attribute11));

Line 5442: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute11', RTRIM(b_attribute11));

5438: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute10', RTRIM(b_attribute10));
5439: END IF;
5440:
5441: IF b_attribute11 IS NOT NULL THEN
5442: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute11', RTRIM(b_attribute11));
5443: END IF;
5444:
5445: IF b_attribute12 IS NOT NULL THEN
5446: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute12', RTRIM(b_attribute12));

Line 5446: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute12', RTRIM(b_attribute12));

5442: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute11', RTRIM(b_attribute11));
5443: END IF;
5444:
5445: IF b_attribute12 IS NOT NULL THEN
5446: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute12', RTRIM(b_attribute12));
5447: END IF;
5448:
5449: IF b_attribute13 IS NOT NULL THEN
5450: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute13', RTRIM(b_attribute13));

Line 5450: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute13', RTRIM(b_attribute13));

5446: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute12', RTRIM(b_attribute12));
5447: END IF;
5448:
5449: IF b_attribute13 IS NOT NULL THEN
5450: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute13', RTRIM(b_attribute13));
5451: END IF;
5452:
5453: IF b_attribute14 IS NOT NULL THEN
5454: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute14', RTRIM(b_attribute14));

Line 5454: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute14', RTRIM(b_attribute14));

5450: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute13', RTRIM(b_attribute13));
5451: END IF;
5452:
5453: IF b_attribute14 IS NOT NULL THEN
5454: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute14', RTRIM(b_attribute14));
5455: END IF;
5456:
5457: IF b_attribute15 IS NOT NULL THEN
5458: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute15', RTRIM(b_attribute15));

Line 5458: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute15', RTRIM(b_attribute15));

5454: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute14', RTRIM(b_attribute14));
5455: END IF;
5456:
5457: IF b_attribute15 IS NOT NULL THEN
5458: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute15', RTRIM(b_attribute15));
5459: END IF;
5460:
5461: --Execute SQL Statement
5462: l_rows := dbms_sql.execute(l_cursor);

Line 5462: l_rows := dbms_sql.execute(l_cursor);

5458: DBMS_SQL.BIND_VARIABLE(l_cursor, ':b_attribute15', RTRIM(b_attribute15));
5459: END IF;
5460:
5461: --Execute SQL Statement
5462: l_rows := dbms_sql.execute(l_cursor);
5463:
5464: IF dbms_sql.is_open (l_cursor) THEN
5465: dbms_sql.close_cursor (l_cursor);
5466: END IF;

Line 5464: IF dbms_sql.is_open (l_cursor) THEN

5460:
5461: --Execute SQL Statement
5462: l_rows := dbms_sql.execute(l_cursor);
5463:
5464: IF dbms_sql.is_open (l_cursor) THEN
5465: dbms_sql.close_cursor (l_cursor);
5466: END IF;
5467: END IF; --update flag = yes
5468:

Line 5465: dbms_sql.close_cursor (l_cursor);

5461: --Execute SQL Statement
5462: l_rows := dbms_sql.execute(l_cursor);
5463:
5464: IF dbms_sql.is_open (l_cursor) THEN
5465: dbms_sql.close_cursor (l_cursor);
5466: END IF;
5467: END IF; --update flag = yes
5468:
5469: