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.CSE_ASSET_CREATION_PKG dependencies on DBMS_SQL

Line 997: l_cursor_id := dbms_sql.open_cursor;

993:
994: debug('fa query : '||l_stmt);
995:
996: -- open cursor and parse
997: l_cursor_id := dbms_sql.open_cursor;
998: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
999:
1000: -- bind variables
1001: IF p_fa_query_rec.inventory_item_id is not null THEN

Line 998: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);

994: debug('fa query : '||l_stmt);
995:
996: -- open cursor and parse
997: l_cursor_id := dbms_sql.open_cursor;
998: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
999:
1000: -- bind variables
1001: IF p_fa_query_rec.inventory_item_id is not null THEN
1002: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);

Line 1002: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);

998: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
999:
1000: -- bind variables
1001: IF p_fa_query_rec.inventory_item_id is not null THEN
1002: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);
1003: END IF;
1004:
1005: IF p_fa_query_rec.book_type_code is not null THEN
1006: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);

Line 1006: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);

1002: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);
1003: END IF;
1004:
1005: IF p_fa_query_rec.book_type_code is not null THEN
1006: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);
1007: END IF;
1008:
1009: IF p_fa_query_rec.asset_category_id is not null THEN
1010: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);

Line 1010: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);

1006: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);
1007: END IF;
1008:
1009: IF p_fa_query_rec.asset_category_id is not null THEN
1010: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);
1011: END IF;
1012:
1013: IF p_fa_query_rec.date_placed_in_service IS not null THEN
1014: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);

Line 1014: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);

1010: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);
1011: END IF;
1012:
1013: IF p_fa_query_rec.date_placed_in_service IS not null THEN
1014: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);
1015: END IF;
1016:
1017: IF p_fa_query_rec.serial_number IS not null THEN
1018: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);

Line 1018: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);

1014: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);
1015: END IF;
1016:
1017: IF p_fa_query_rec.serial_number IS not null THEN
1018: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);
1019: END IF;
1020:
1021: IF p_fa_query_rec.model_number IS not null THEN
1022: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);

Line 1022: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);

1018: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);
1019: END IF;
1020:
1021: IF p_fa_query_rec.model_number IS not null THEN
1022: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);
1023: END IF;
1024:
1025: IF p_fa_query_rec.tag_nuber IS not null THEN
1026: dbms_sql.bind_variable(l_cursor_id, ':tag_number', p_fa_query_rec.tag_nuber);

Line 1026: dbms_sql.bind_variable(l_cursor_id, ':tag_number', p_fa_query_rec.tag_nuber);

1022: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);
1023: END IF;
1024:
1025: IF p_fa_query_rec.tag_nuber IS not null THEN
1026: dbms_sql.bind_variable(l_cursor_id, ':tag_number', p_fa_query_rec.tag_nuber);
1027: END IF;
1028:
1029: IF p_fa_query_rec.manufacturer_name IS not null THEN
1030: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);

Line 1030: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);

1026: dbms_sql.bind_variable(l_cursor_id, ':tag_number', p_fa_query_rec.tag_nuber);
1027: END IF;
1028:
1029: IF p_fa_query_rec.manufacturer_name IS not null THEN
1030: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);
1031: END IF;
1032:
1033: IF p_fa_query_rec.asset_key_ccid IS not null THEN
1034: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);

Line 1034: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);

1030: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);
1031: END IF;
1032:
1033: IF p_fa_query_rec.asset_key_ccid IS not null THEN
1034: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);
1035: END IF;
1036:
1037: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
1038: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);

Line 1037: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);

1033: IF p_fa_query_rec.asset_key_ccid IS not null THEN
1034: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);
1035: END IF;
1036:
1037: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
1038: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
1039: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
1040: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1041: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);

Line 1038: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);

1034: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);
1035: END IF;
1036:
1037: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
1038: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
1039: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
1040: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1041: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1042: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);

Line 1039: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);

1035: END IF;
1036:
1037: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
1038: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
1039: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
1040: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1041: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1042: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1043: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);

Line 1040: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);

1036:
1037: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
1038: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
1039: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
1040: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1041: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1042: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1043: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1044: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);

Line 1041: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);

1037: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
1038: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
1039: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
1040: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1041: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1042: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1043: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1044: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1045: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);

Line 1042: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);

1038: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
1039: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
1040: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1041: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1042: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1043: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1044: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1045: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1046: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);

Line 1043: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);

1039: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
1040: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1041: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1042: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1043: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1044: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1045: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1046: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1047: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);

Line 1044: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);

1040: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1041: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1042: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1043: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1044: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1045: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1046: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1047: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1048: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);

Line 1045: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);

1041: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1042: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1043: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1044: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1045: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1046: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1047: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1048: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1049: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);

Line 1046: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);

1042: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1043: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1044: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1045: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1046: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1047: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1048: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1049: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1050: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);

Line 1047: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);

1043: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1044: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1045: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1046: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1047: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1048: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1049: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1050: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1051:

Line 1048: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);

1044: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1045: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1046: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1047: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1048: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1049: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1050: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1051:
1052: l_rows_returned := dbms_sql.execute(l_cursor_id);

Line 1049: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);

1045: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1046: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1047: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1048: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1049: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1050: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1051:
1052: l_rows_returned := dbms_sql.execute(l_cursor_id);
1053: LOOP

Line 1050: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);

1046: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1047: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1048: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1049: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1050: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1051:
1052: l_rows_returned := dbms_sql.execute(l_cursor_id);
1053: LOOP
1054: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;

Line 1052: l_rows_returned := dbms_sql.execute(l_cursor_id);

1048: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1049: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1050: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1051:
1052: l_rows_returned := dbms_sql.execute(l_cursor_id);
1053: LOOP
1054: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1055:
1056: l_ind := l_ind + 1;

Line 1054: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;

1050: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1051:
1052: l_rows_returned := dbms_sql.execute(l_cursor_id);
1053: LOOP
1054: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1055:
1056: l_ind := l_ind + 1;
1057:
1058: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);

Line 1058: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);

1054: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1055:
1056: l_ind := l_ind + 1;
1057:
1058: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);
1059: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1060: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1061: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1062: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);

Line 1059: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);

1055:
1056: l_ind := l_ind + 1;
1057:
1058: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);
1059: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1060: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1061: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1062: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1063: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);

Line 1060: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);

1056: l_ind := l_ind + 1;
1057:
1058: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);
1059: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1060: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1061: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1062: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1063: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1064: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);

Line 1061: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);

1057:
1058: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);
1059: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1060: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1061: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1062: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1063: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1064: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1065: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);

Line 1062: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);

1058: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);
1059: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1060: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1061: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1062: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1063: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1064: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1065: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1066: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);

Line 1063: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);

1059: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1060: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1061: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1062: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1063: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1064: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1065: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1066: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1067: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);

Line 1064: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);

1060: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1061: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1062: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1063: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1064: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1065: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1066: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1067: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1068: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);

Line 1065: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);

1061: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1062: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1063: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1064: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1065: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1066: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1067: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1068: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1069: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);

Line 1066: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);

1062: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1063: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1064: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1065: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1066: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1067: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1068: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1069: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1070: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);

Line 1067: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);

1063: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1064: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1065: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1066: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1067: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1068: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1069: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1070: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);
1071: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);

Line 1068: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);

1064: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1065: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1066: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1067: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1068: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1069: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1070: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);
1071: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1072:

Line 1069: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);

1065: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1066: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1067: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1068: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1069: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1070: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);
1071: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1072:
1073: exit;

Line 1070: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);

1066: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1067: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1068: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1069: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1070: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);
1071: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1072:
1073: exit;
1074:

Line 1071: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);

1067: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1068: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1069: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1070: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);
1071: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1072:
1073: exit;
1074:
1075: END LOOP;

Line 1077: dbms_sql.close_cursor(l_cursor_id);

1073: exit;
1074:
1075: END LOOP;
1076:
1077: dbms_sql.close_cursor(l_cursor_id);
1078:
1079: x_fixed_asset_rec := l_asset_rec;
1080:
1081: END get_fixed_assets;

Line 1253: l_cursor_id := dbms_sql.open_cursor;

1249: l_stmt := l_stmt||l_where_clause||l_and_clause;
1250:
1251: debug('fma query : '||l_stmt);
1252:
1253: l_cursor_id := dbms_sql.open_cursor;
1254: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
1255:
1256: -- bind variables
1257: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);

Line 1254: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);

1250:
1251: debug('fma query : '||l_stmt);
1252:
1253: l_cursor_id := dbms_sql.open_cursor;
1254: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
1255:
1256: -- bind variables
1257: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);
1258: dbms_sql.bind_variable(l_cursor_id, ':split_merged_code', l_split_merged_code);

Line 1257: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);

1253: l_cursor_id := dbms_sql.open_cursor;
1254: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
1255:
1256: -- bind variables
1257: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);
1258: dbms_sql.bind_variable(l_cursor_id, ':split_merged_code', l_split_merged_code);
1259:
1260: IF p_fa_query_rec.book_type_code is not null THEN
1261: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);

Line 1258: dbms_sql.bind_variable(l_cursor_id, ':split_merged_code', l_split_merged_code);

1254: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
1255:
1256: -- bind variables
1257: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);
1258: dbms_sql.bind_variable(l_cursor_id, ':split_merged_code', l_split_merged_code);
1259:
1260: IF p_fa_query_rec.book_type_code is not null THEN
1261: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);
1262: END IF;

Line 1261: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);

1257: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);
1258: dbms_sql.bind_variable(l_cursor_id, ':split_merged_code', l_split_merged_code);
1259:
1260: IF p_fa_query_rec.book_type_code is not null THEN
1261: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);
1262: END IF;
1263:
1264: IF p_fa_query_rec.asset_category_id is not null THEN
1265: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);

Line 1265: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);

1261: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);
1262: END IF;
1263:
1264: IF p_fa_query_rec.asset_category_id is not null THEN
1265: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);
1266: END IF;
1267:
1268: IF p_fa_query_rec.asset_description IS not null THEN
1269: dbms_sql.bind_variable(l_cursor_id, ':asset_description', p_fa_query_rec.asset_description);

Line 1269: dbms_sql.bind_variable(l_cursor_id, ':asset_description', p_fa_query_rec.asset_description);

1265: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);
1266: END IF;
1267:
1268: IF p_fa_query_rec.asset_description IS not null THEN
1269: dbms_sql.bind_variable(l_cursor_id, ':asset_description', p_fa_query_rec.asset_description);
1270: END IF;
1271:
1272: IF p_fa_query_rec.serial_number IS not null THEN
1273: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);

Line 1273: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);

1269: dbms_sql.bind_variable(l_cursor_id, ':asset_description', p_fa_query_rec.asset_description);
1270: END IF;
1271:
1272: IF p_fa_query_rec.serial_number IS not null THEN
1273: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);
1274: END IF;
1275:
1276: IF p_fa_query_rec.date_placed_in_service IS not null THEN
1277: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);

Line 1277: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);

1273: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);
1274: END IF;
1275:
1276: IF p_fa_query_rec.date_placed_in_service IS not null THEN
1277: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);
1278: END IF;
1279:
1280: IF p_fa_query_rec.model_number IS not null THEN
1281: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);

Line 1281: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);

1277: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);
1278: END IF;
1279:
1280: IF p_fa_query_rec.model_number IS not null THEN
1281: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);
1282: END IF;
1283:
1284: IF p_fa_query_rec.tag_nuber IS not null THEN
1285: dbms_sql.bind_variable(l_cursor_id, ':tag_nuber', p_fa_query_rec.tag_nuber);

Line 1285: dbms_sql.bind_variable(l_cursor_id, ':tag_nuber', p_fa_query_rec.tag_nuber);

1281: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);
1282: END IF;
1283:
1284: IF p_fa_query_rec.tag_nuber IS not null THEN
1285: dbms_sql.bind_variable(l_cursor_id, ':tag_nuber', p_fa_query_rec.tag_nuber);
1286: END IF;
1287:
1288: IF p_fa_query_rec.manufacturer_name IS not null THEN
1289: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);

Line 1289: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);

1285: dbms_sql.bind_variable(l_cursor_id, ':tag_nuber', p_fa_query_rec.tag_nuber);
1286: END IF;
1287:
1288: IF p_fa_query_rec.manufacturer_name IS not null THEN
1289: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);
1290: END IF;
1291:
1292: IF p_fa_query_rec.asset_key_ccid IS not null THEN
1293: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);

Line 1293: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);

1289: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);
1290: END IF;
1291:
1292: IF p_fa_query_rec.asset_key_ccid IS not null THEN
1293: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);
1294: END IF;
1295:
1296: IF p_fa_query_rec.inventory_item_id IS not null THEN
1297: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);

Line 1297: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);

1293: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);
1294: END IF;
1295:
1296: IF p_fa_query_rec.inventory_item_id IS not null THEN
1297: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);
1298: END IF;
1299:
1300: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1301: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);

Line 1300: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);

1296: IF p_fa_query_rec.inventory_item_id IS not null THEN
1297: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);
1298: END IF;
1299:
1300: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1301: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1302: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1303: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1304: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);

Line 1301: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);

1297: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);
1298: END IF;
1299:
1300: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1301: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1302: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1303: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1304: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1305: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);

Line 1302: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);

1298: END IF;
1299:
1300: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1301: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1302: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1303: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1304: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1305: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1306: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);

Line 1303: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);

1299:
1300: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1301: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1302: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1303: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1304: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1305: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1306: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1307: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);

Line 1304: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);

1300: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1301: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1302: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1303: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1304: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1305: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1306: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1307: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1308: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);

Line 1305: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);

1301: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1302: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1303: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1304: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1305: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1306: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1307: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1308: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1309: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);

Line 1306: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);

1302: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1303: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1304: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1305: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1306: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1307: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1308: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1309: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1310: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);

Line 1307: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);

1303: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1304: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1305: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1306: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1307: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1308: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1309: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1310: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1311: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);

Line 1308: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);

1304: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1305: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1306: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1307: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1308: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1309: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1310: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1311: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1312: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);

Line 1309: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);

1305: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1306: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1307: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1308: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1309: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1310: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1311: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1312: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1313:

Line 1310: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);

1306: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1307: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1308: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1309: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1310: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1311: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1312: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1313:
1314: l_rows_returned := dbms_sql.execute(l_cursor_id);

Line 1311: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);

1307: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1308: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1309: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1310: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1311: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1312: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1313:
1314: l_rows_returned := dbms_sql.execute(l_cursor_id);
1315:

Line 1312: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);

1308: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1309: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1310: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1311: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1312: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1313:
1314: l_rows_returned := dbms_sql.execute(l_cursor_id);
1315:
1316: LOOP

Line 1314: l_rows_returned := dbms_sql.execute(l_cursor_id);

1310: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1311: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1312: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1313:
1314: l_rows_returned := dbms_sql.execute(l_cursor_id);
1315:
1316: LOOP
1317:
1318: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;

Line 1318: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;

1314: l_rows_returned := dbms_sql.execute(l_cursor_id);
1315:
1316: LOOP
1317:
1318: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1319: l_ind := l_ind + 1;
1320:
1321: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1322: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);

Line 1321: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);

1317:
1318: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1319: l_ind := l_ind + 1;
1320:
1321: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1322: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1323: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1324: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1325: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);

Line 1322: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);

1318: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1319: l_ind := l_ind + 1;
1320:
1321: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1322: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1323: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1324: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1325: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1326: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);

Line 1323: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);

1319: l_ind := l_ind + 1;
1320:
1321: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1322: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1323: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1324: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1325: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1326: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1327: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);

Line 1324: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);

1320:
1321: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1322: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1323: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1324: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1325: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1326: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1327: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1328: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);

Line 1325: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);

1321: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1322: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1323: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1324: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1325: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1326: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1327: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1328: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1329: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);

Line 1326: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);

1322: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1323: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1324: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1325: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1326: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1327: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1328: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1329: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1330: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);

Line 1327: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);

1323: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1324: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1325: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1326: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1327: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1328: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1329: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1330: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1331: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);

Line 1328: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);

1324: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1325: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1326: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1327: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1328: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1329: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1330: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1331: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1332: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);

Line 1329: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);

1325: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1326: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1327: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1328: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1329: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1330: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1331: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1332: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);
1333: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);

Line 1330: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);

1326: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1327: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1328: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1329: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1330: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1331: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1332: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);
1333: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1334:

Line 1331: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);

1327: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1328: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1329: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1330: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1331: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1332: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);
1333: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1334:
1335: exit;

Line 1332: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);

1328: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1329: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1330: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1331: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1332: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);
1333: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1334:
1335: exit;
1336:

Line 1333: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);

1329: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1330: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1331: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1332: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);
1333: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1334:
1335: exit;
1336:
1337: END LOOP;

Line 1339: dbms_sql.close_cursor(l_cursor_id);

1335: exit;
1336:
1337: END LOOP;
1338:
1339: dbms_sql.close_cursor(l_cursor_id);
1340:
1341: x_fixed_asset_rec := l_asset_rec;
1342:
1343: END get_pending_additions;