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.

[Home] [Help]

APPS.CSE_ASSET_CREATION_PKG dependencies on DBMS_SQL

Line 956: l_cursor_id := dbms_sql.open_cursor;

952:
953: debug('fa query : '||l_stmt);
954:
955: -- open cursor and parse
956: l_cursor_id := dbms_sql.open_cursor;
957: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
958:
959: -- bind variables
960: IF p_fa_query_rec.inventory_item_id is not null THEN

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

953: debug('fa query : '||l_stmt);
954:
955: -- open cursor and parse
956: l_cursor_id := dbms_sql.open_cursor;
957: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
958:
959: -- bind variables
960: IF p_fa_query_rec.inventory_item_id is not null THEN
961: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);

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

957: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
958:
959: -- bind variables
960: IF p_fa_query_rec.inventory_item_id is not null THEN
961: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);
962: END IF;
963:
964: IF p_fa_query_rec.book_type_code is not null THEN
965: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);

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

961: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);
962: END IF;
963:
964: IF p_fa_query_rec.book_type_code is not null THEN
965: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);
966: END IF;
967:
968: IF p_fa_query_rec.asset_category_id is not null THEN
969: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);

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

965: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);
966: END IF;
967:
968: IF p_fa_query_rec.asset_category_id is not null THEN
969: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);
970: END IF;
971:
972: IF p_fa_query_rec.date_placed_in_service IS not null THEN
973: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);

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

969: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);
970: END IF;
971:
972: IF p_fa_query_rec.date_placed_in_service IS not null THEN
973: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);
974: END IF;
975:
976: IF p_fa_query_rec.serial_number IS not null THEN
977: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);

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

973: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);
974: END IF;
975:
976: IF p_fa_query_rec.serial_number IS not null THEN
977: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);
978: END IF;
979:
980: IF p_fa_query_rec.model_number IS not null THEN
981: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);

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

977: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);
978: END IF;
979:
980: IF p_fa_query_rec.model_number IS not null THEN
981: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);
982: END IF;
983:
984: IF p_fa_query_rec.tag_nuber IS not null THEN
985: dbms_sql.bind_variable(l_cursor_id, ':tag_nuber', p_fa_query_rec.tag_nuber);

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

981: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);
982: END IF;
983:
984: IF p_fa_query_rec.tag_nuber IS not null THEN
985: dbms_sql.bind_variable(l_cursor_id, ':tag_nuber', p_fa_query_rec.tag_nuber);
986: END IF;
987:
988: IF p_fa_query_rec.manufacturer_name IS not null THEN
989: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);

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

985: dbms_sql.bind_variable(l_cursor_id, ':tag_nuber', p_fa_query_rec.tag_nuber);
986: END IF;
987:
988: IF p_fa_query_rec.manufacturer_name IS not null THEN
989: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);
990: END IF;
991:
992: IF p_fa_query_rec.asset_key_ccid IS not null THEN
993: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);

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

989: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);
990: END IF;
991:
992: IF p_fa_query_rec.asset_key_ccid IS not null THEN
993: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);
994: END IF;
995:
996: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
997: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);

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

992: IF p_fa_query_rec.asset_key_ccid IS not null THEN
993: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);
994: END IF;
995:
996: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
997: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
998: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
999: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1000: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);

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

993: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);
994: END IF;
995:
996: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
997: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
998: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
999: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1000: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1001: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);

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

994: END IF;
995:
996: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
997: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
998: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
999: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1000: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1001: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1002: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);

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

995:
996: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
997: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
998: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
999: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1000: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1001: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1002: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1003: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);

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

996: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.asset_id);
997: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
998: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
999: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1000: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1001: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1002: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1003: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1004: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);

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

997: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.asset_number, 30);
998: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
999: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1000: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1001: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1002: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1003: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1004: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1005: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);

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

998: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.asset_category_id);
999: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1000: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1001: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1002: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1003: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1004: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1005: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1006: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);

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

999: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1000: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1001: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1002: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1003: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1004: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1005: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1006: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1007: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);

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

1000: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.tag_number, 30);
1001: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1002: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1003: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1004: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1005: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1006: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1007: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1008: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);

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

1001: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.asset_description, 240);
1002: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1003: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1004: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1005: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1006: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1007: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1008: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1009: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);

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

1002: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.manufacturer_name, 30);
1003: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1004: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1005: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1006: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1007: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1008: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1009: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1010:

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

1003: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.serial_number, 80);
1004: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1005: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1006: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1007: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1008: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1009: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1010:
1011: l_rows_returned := dbms_sql.execute(l_cursor_id);

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

1004: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.model_number, 80);
1005: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1006: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1007: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1008: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1009: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1010:
1011: l_rows_returned := dbms_sql.execute(l_cursor_id);
1012: LOOP

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

1005: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.current_units);
1006: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.book_type_code, 30);
1007: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1008: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1009: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1010:
1011: l_rows_returned := dbms_sql.execute(l_cursor_id);
1012: LOOP
1013: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;

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

1007: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1008: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.asset_cost);
1009: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1010:
1011: l_rows_returned := dbms_sql.execute(l_cursor_id);
1012: LOOP
1013: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1014:
1015: l_ind := l_ind + 1;

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

1009: dbms_sql.define_column(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1010:
1011: l_rows_returned := dbms_sql.execute(l_cursor_id);
1012: LOOP
1013: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1014:
1015: l_ind := l_ind + 1;
1016:
1017: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);

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

1013: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1014:
1015: l_ind := l_ind + 1;
1016:
1017: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);
1018: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1019: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1020: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1021: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);

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

1014:
1015: l_ind := l_ind + 1;
1016:
1017: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);
1018: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1019: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1020: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1021: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1022: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);

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

1015: l_ind := l_ind + 1;
1016:
1017: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);
1018: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1019: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1020: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1021: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1022: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1023: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);

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

1016:
1017: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);
1018: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1019: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1020: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1021: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1022: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1023: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1024: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);

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

1017: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.asset_id);
1018: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1019: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1020: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1021: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1022: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1023: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1024: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1025: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);

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

1018: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.asset_number);
1019: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1020: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1021: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1022: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1023: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1024: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1025: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1026: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);

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

1019: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.asset_category_id);
1020: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1021: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1022: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1023: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1024: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1025: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1026: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1027: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);

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

1020: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.asset_key_ccid);
1021: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1022: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1023: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1024: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1025: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1026: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1027: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1028: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);

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

1021: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.tag_number);
1022: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1023: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1024: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1025: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1026: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1027: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1028: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1029: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);

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

1022: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.asset_description);
1023: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1024: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1025: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1026: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1027: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1028: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1029: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);
1030: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);

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

1023: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.manufacturer_name);
1024: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1025: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1026: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1027: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1028: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1029: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);
1030: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1031:

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

1024: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.serial_number);
1025: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1026: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1027: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1028: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1029: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);
1030: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1031:
1032: exit;

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

1025: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.model_number);
1026: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1027: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1028: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1029: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);
1030: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1031:
1032: exit;
1033:

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

1026: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.current_units);
1027: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.book_type_code);
1028: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.date_placed_in_service);
1029: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.asset_cost);
1030: dbms_sql.column_value(l_cursor_id, 14, l_asset_rec.instance_asset_id);
1031:
1032: exit;
1033:
1034: END LOOP;

Line 1036: dbms_sql.close_cursor(l_cursor_id);

1032: exit;
1033:
1034: END LOOP;
1035:
1036: dbms_sql.close_cursor(l_cursor_id);
1037:
1038: x_fixed_asset_rec := l_asset_rec;
1039:
1040: END get_fixed_assets;

Line 1212: l_cursor_id := dbms_sql.open_cursor;

1208: l_stmt := l_stmt||l_where_clause||l_and_clause;
1209:
1210: debug('fma query : '||l_stmt);
1211:
1212: l_cursor_id := dbms_sql.open_cursor;
1213: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
1214:
1215: -- bind variables
1216: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);

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

1209:
1210: debug('fma query : '||l_stmt);
1211:
1212: l_cursor_id := dbms_sql.open_cursor;
1213: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
1214:
1215: -- bind variables
1216: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);
1217: dbms_sql.bind_variable(l_cursor_id, ':split_merged_code', l_split_merged_code);

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

1212: l_cursor_id := dbms_sql.open_cursor;
1213: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
1214:
1215: -- bind variables
1216: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);
1217: dbms_sql.bind_variable(l_cursor_id, ':split_merged_code', l_split_merged_code);
1218:
1219: IF p_fa_query_rec.book_type_code is not null THEN
1220: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);

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

1213: dbms_sql.parse(l_cursor_id, l_stmt , dbms_sql.native);
1214:
1215: -- bind variables
1216: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);
1217: dbms_sql.bind_variable(l_cursor_id, ':split_merged_code', l_split_merged_code);
1218:
1219: IF p_fa_query_rec.book_type_code is not null THEN
1220: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);
1221: END IF;

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

1216: dbms_sql.bind_variable(l_cursor_id, ':posting_status', l_posting_status);
1217: dbms_sql.bind_variable(l_cursor_id, ':split_merged_code', l_split_merged_code);
1218:
1219: IF p_fa_query_rec.book_type_code is not null THEN
1220: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);
1221: END IF;
1222:
1223: IF p_fa_query_rec.asset_category_id is not null THEN
1224: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);

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

1220: dbms_sql.bind_variable(l_cursor_id, ':book_type_code', p_fa_query_rec.book_type_code);
1221: END IF;
1222:
1223: IF p_fa_query_rec.asset_category_id is not null THEN
1224: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);
1225: END IF;
1226:
1227: IF p_fa_query_rec.asset_description IS not null THEN
1228: dbms_sql.bind_variable(l_cursor_id, ':asset_description', p_fa_query_rec.asset_description);

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

1224: dbms_sql.bind_variable(l_cursor_id, ':asset_category_id', p_fa_query_rec.asset_category_id);
1225: END IF;
1226:
1227: IF p_fa_query_rec.asset_description IS not null THEN
1228: dbms_sql.bind_variable(l_cursor_id, ':asset_description', p_fa_query_rec.asset_description);
1229: END IF;
1230:
1231: IF p_fa_query_rec.serial_number IS not null THEN
1232: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);

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

1228: dbms_sql.bind_variable(l_cursor_id, ':asset_description', p_fa_query_rec.asset_description);
1229: END IF;
1230:
1231: IF p_fa_query_rec.serial_number IS not null THEN
1232: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);
1233: END IF;
1234:
1235: IF p_fa_query_rec.date_placed_in_service IS not null THEN
1236: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);

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

1232: dbms_sql.bind_variable(l_cursor_id, ':serial_number', p_fa_query_rec.serial_number);
1233: END IF;
1234:
1235: IF p_fa_query_rec.date_placed_in_service IS not null THEN
1236: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);
1237: END IF;
1238:
1239: IF p_fa_query_rec.model_number IS not null THEN
1240: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);

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

1236: dbms_sql.bind_variable(l_cursor_id, ':dpi', p_fa_query_rec.date_placed_in_service);
1237: END IF;
1238:
1239: IF p_fa_query_rec.model_number IS not null THEN
1240: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);
1241: END IF;
1242:
1243: IF p_fa_query_rec.tag_nuber IS not null THEN
1244: dbms_sql.bind_variable(l_cursor_id, ':tag_nuber', p_fa_query_rec.tag_nuber);

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

1240: dbms_sql.bind_variable(l_cursor_id, ':model_number', p_fa_query_rec.model_number);
1241: END IF;
1242:
1243: IF p_fa_query_rec.tag_nuber IS not null THEN
1244: dbms_sql.bind_variable(l_cursor_id, ':tag_nuber', p_fa_query_rec.tag_nuber);
1245: END IF;
1246:
1247: IF p_fa_query_rec.manufacturer_name IS not null THEN
1248: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);

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

1244: dbms_sql.bind_variable(l_cursor_id, ':tag_nuber', p_fa_query_rec.tag_nuber);
1245: END IF;
1246:
1247: IF p_fa_query_rec.manufacturer_name IS not null THEN
1248: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);
1249: END IF;
1250:
1251: IF p_fa_query_rec.asset_key_ccid IS not null THEN
1252: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);

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

1248: dbms_sql.bind_variable(l_cursor_id, ':manufacturer_name', p_fa_query_rec.manufacturer_name);
1249: END IF;
1250:
1251: IF p_fa_query_rec.asset_key_ccid IS not null THEN
1252: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);
1253: END IF;
1254:
1255: IF p_fa_query_rec.inventory_item_id IS not null THEN
1256: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);

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

1252: dbms_sql.bind_variable(l_cursor_id, ':asset_key_ccid', p_fa_query_rec.asset_key_ccid);
1253: END IF;
1254:
1255: IF p_fa_query_rec.inventory_item_id IS not null THEN
1256: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);
1257: END IF;
1258:
1259: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1260: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);

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

1255: IF p_fa_query_rec.inventory_item_id IS not null THEN
1256: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);
1257: END IF;
1258:
1259: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1260: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1261: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1262: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1263: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);

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

1256: dbms_sql.bind_variable(l_cursor_id, ':inventory_item_id', p_fa_query_rec.inventory_item_id);
1257: END IF;
1258:
1259: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1260: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1261: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1262: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1263: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1264: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);

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

1257: END IF;
1258:
1259: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1260: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1261: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1262: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1263: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1264: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1265: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);

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

1258:
1259: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1260: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1261: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1262: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1263: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1264: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1265: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1266: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);

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

1259: dbms_sql.define_column(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1260: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1261: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1262: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1263: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1264: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1265: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1266: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1267: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);

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

1260: dbms_sql.define_column(l_cursor_id, 2, l_asset_rec.model_number, 80);
1261: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1262: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1263: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1264: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1265: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1266: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1267: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1268: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);

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

1261: dbms_sql.define_column(l_cursor_id, 3, l_asset_rec.serial_number, 80);
1262: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1263: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1264: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1265: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1266: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1267: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1268: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1269: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);

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

1262: dbms_sql.define_column(l_cursor_id, 4, l_asset_rec.manufacturer_name, 30);
1263: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1264: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1265: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1266: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1267: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1268: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1269: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1270: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);

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

1263: dbms_sql.define_column(l_cursor_id, 5, l_asset_rec.asset_description, 240);
1264: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1265: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1266: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1267: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1268: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1269: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1270: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1271: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);

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

1264: dbms_sql.define_column(l_cursor_id, 6, l_asset_rec.tag_number, 30);
1265: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1266: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1267: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1268: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1269: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1270: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1271: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1272:

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

1265: dbms_sql.define_column(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1266: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1267: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1268: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1269: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1270: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1271: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1272:
1273: l_rows_returned := dbms_sql.execute(l_cursor_id);

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

1266: dbms_sql.define_column(l_cursor_id, 8, l_asset_rec.asset_category_id);
1267: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1268: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1269: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1270: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1271: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1272:
1273: l_rows_returned := dbms_sql.execute(l_cursor_id);
1274:

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

1267: dbms_sql.define_column(l_cursor_id, 9, l_asset_rec.asset_number, 30);
1268: dbms_sql.define_column(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1269: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1270: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1271: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1272:
1273: l_rows_returned := dbms_sql.execute(l_cursor_id);
1274:
1275: LOOP

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

1269: dbms_sql.define_column(l_cursor_id, 11, l_asset_rec.reviewer_comments, 240);
1270: dbms_sql.define_column(l_cursor_id, 12, l_asset_rec.feeder_system_name, 40);
1271: dbms_sql.define_column(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1272:
1273: l_rows_returned := dbms_sql.execute(l_cursor_id);
1274:
1275: LOOP
1276:
1277: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;

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

1273: l_rows_returned := dbms_sql.execute(l_cursor_id);
1274:
1275: LOOP
1276:
1277: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1278: l_ind := l_ind + 1;
1279:
1280: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1281: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);

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

1276:
1277: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1278: l_ind := l_ind + 1;
1279:
1280: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1281: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1282: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1283: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1284: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);

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

1277: exit when dbms_sql.fetch_rows(l_cursor_id) = 0;
1278: l_ind := l_ind + 1;
1279:
1280: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1281: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1282: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1283: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1284: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1285: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);

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

1278: l_ind := l_ind + 1;
1279:
1280: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1281: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1282: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1283: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1284: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1285: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1286: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);

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

1279:
1280: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1281: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1282: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1283: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1284: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1285: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1286: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1287: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);

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

1280: dbms_sql.column_value(l_cursor_id, 1, l_asset_rec.mass_addition_id);
1281: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1282: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1283: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1284: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1285: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1286: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1287: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1288: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);

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

1281: dbms_sql.column_value(l_cursor_id, 2, l_asset_rec.model_number);
1282: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1283: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1284: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1285: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1286: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1287: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1288: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1289: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);

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

1282: dbms_sql.column_value(l_cursor_id, 3, l_asset_rec.serial_number);
1283: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1284: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1285: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1286: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1287: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1288: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1289: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1290: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);

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

1283: dbms_sql.column_value(l_cursor_id, 4, l_asset_rec.manufacturer_name);
1284: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1285: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1286: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1287: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1288: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1289: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1290: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1291: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);

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

1284: dbms_sql.column_value(l_cursor_id, 5, l_asset_rec.asset_description);
1285: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1286: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1287: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1288: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1289: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1290: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1291: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);
1292: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);

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

1285: dbms_sql.column_value(l_cursor_id, 6, l_asset_rec.tag_number);
1286: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1287: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1288: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1289: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1290: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1291: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);
1292: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1293:

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

1286: dbms_sql.column_value(l_cursor_id, 7, l_asset_rec.asset_key_ccid);
1287: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1288: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1289: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1290: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1291: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);
1292: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1293:
1294: exit;

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

1287: dbms_sql.column_value(l_cursor_id, 8, l_asset_rec.asset_category_id);
1288: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1289: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1290: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1291: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);
1292: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1293:
1294: exit;
1295:

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

1288: dbms_sql.column_value(l_cursor_id, 9, l_asset_rec.asset_number);
1289: dbms_sql.column_value(l_cursor_id, 10, l_asset_rec.date_placed_in_service);
1290: dbms_sql.column_value(l_cursor_id, 11, l_asset_rec.reviewer_comments);
1291: dbms_sql.column_value(l_cursor_id, 12, l_asset_rec.feeder_system_name);
1292: dbms_sql.column_value(l_cursor_id, 13, l_asset_rec.instance_asset_id);
1293:
1294: exit;
1295:
1296: END LOOP;

Line 1298: dbms_sql.close_cursor(l_cursor_id);

1294: exit;
1295:
1296: END LOOP;
1297:
1298: dbms_sql.close_cursor(l_cursor_id);
1299:
1300: x_fixed_asset_rec := l_asset_rec;
1301:
1302: END get_pending_additions;