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

Line 580: dbms_sql.column_value(p_get_asset_cursor_id, 1, x_inst_asset_rec.instance_asset_id);

576: x_inst_asset_rec OUT NOCOPY csi_datastructures_pub.instance_asset_header_rec
577: )IS
578: BEGIN
579:
580: dbms_sql.column_value(p_get_asset_cursor_id, 1, x_inst_asset_rec.instance_asset_id);
581: dbms_sql.column_value(p_get_asset_cursor_id, 2, x_inst_asset_rec.instance_id);
582: dbms_sql.column_value(p_get_asset_cursor_id, 3, x_inst_asset_rec.fa_asset_id);
583: dbms_sql.column_value(p_get_asset_cursor_id, 4, x_inst_asset_rec.fa_book_type_code );
584: dbms_sql.column_value(p_get_asset_cursor_id, 5, x_inst_asset_rec.fa_location_id);

Line 581: dbms_sql.column_value(p_get_asset_cursor_id, 2, x_inst_asset_rec.instance_id);

577: )IS
578: BEGIN
579:
580: dbms_sql.column_value(p_get_asset_cursor_id, 1, x_inst_asset_rec.instance_asset_id);
581: dbms_sql.column_value(p_get_asset_cursor_id, 2, x_inst_asset_rec.instance_id);
582: dbms_sql.column_value(p_get_asset_cursor_id, 3, x_inst_asset_rec.fa_asset_id);
583: dbms_sql.column_value(p_get_asset_cursor_id, 4, x_inst_asset_rec.fa_book_type_code );
584: dbms_sql.column_value(p_get_asset_cursor_id, 5, x_inst_asset_rec.fa_location_id);
585: dbms_sql.column_value(p_get_asset_cursor_id, 6, x_inst_asset_rec.asset_quantity);

Line 582: dbms_sql.column_value(p_get_asset_cursor_id, 3, x_inst_asset_rec.fa_asset_id);

578: BEGIN
579:
580: dbms_sql.column_value(p_get_asset_cursor_id, 1, x_inst_asset_rec.instance_asset_id);
581: dbms_sql.column_value(p_get_asset_cursor_id, 2, x_inst_asset_rec.instance_id);
582: dbms_sql.column_value(p_get_asset_cursor_id, 3, x_inst_asset_rec.fa_asset_id);
583: dbms_sql.column_value(p_get_asset_cursor_id, 4, x_inst_asset_rec.fa_book_type_code );
584: dbms_sql.column_value(p_get_asset_cursor_id, 5, x_inst_asset_rec.fa_location_id);
585: dbms_sql.column_value(p_get_asset_cursor_id, 6, x_inst_asset_rec.asset_quantity);
586: dbms_sql.column_value(p_get_asset_cursor_id, 7, x_inst_asset_rec.update_status);

Line 583: dbms_sql.column_value(p_get_asset_cursor_id, 4, x_inst_asset_rec.fa_book_type_code );

579:
580: dbms_sql.column_value(p_get_asset_cursor_id, 1, x_inst_asset_rec.instance_asset_id);
581: dbms_sql.column_value(p_get_asset_cursor_id, 2, x_inst_asset_rec.instance_id);
582: dbms_sql.column_value(p_get_asset_cursor_id, 3, x_inst_asset_rec.fa_asset_id);
583: dbms_sql.column_value(p_get_asset_cursor_id, 4, x_inst_asset_rec.fa_book_type_code );
584: dbms_sql.column_value(p_get_asset_cursor_id, 5, x_inst_asset_rec.fa_location_id);
585: dbms_sql.column_value(p_get_asset_cursor_id, 6, x_inst_asset_rec.asset_quantity);
586: dbms_sql.column_value(p_get_asset_cursor_id, 7, x_inst_asset_rec.update_status);
587: dbms_sql.column_value(p_get_asset_cursor_id, 8, x_inst_asset_rec.active_start_date);

Line 584: dbms_sql.column_value(p_get_asset_cursor_id, 5, x_inst_asset_rec.fa_location_id);

580: dbms_sql.column_value(p_get_asset_cursor_id, 1, x_inst_asset_rec.instance_asset_id);
581: dbms_sql.column_value(p_get_asset_cursor_id, 2, x_inst_asset_rec.instance_id);
582: dbms_sql.column_value(p_get_asset_cursor_id, 3, x_inst_asset_rec.fa_asset_id);
583: dbms_sql.column_value(p_get_asset_cursor_id, 4, x_inst_asset_rec.fa_book_type_code );
584: dbms_sql.column_value(p_get_asset_cursor_id, 5, x_inst_asset_rec.fa_location_id);
585: dbms_sql.column_value(p_get_asset_cursor_id, 6, x_inst_asset_rec.asset_quantity);
586: dbms_sql.column_value(p_get_asset_cursor_id, 7, x_inst_asset_rec.update_status);
587: dbms_sql.column_value(p_get_asset_cursor_id, 8, x_inst_asset_rec.active_start_date);
588: dbms_sql.column_value(p_get_asset_cursor_id, 9, x_inst_asset_rec.active_end_date);

Line 585: dbms_sql.column_value(p_get_asset_cursor_id, 6, x_inst_asset_rec.asset_quantity);

581: dbms_sql.column_value(p_get_asset_cursor_id, 2, x_inst_asset_rec.instance_id);
582: dbms_sql.column_value(p_get_asset_cursor_id, 3, x_inst_asset_rec.fa_asset_id);
583: dbms_sql.column_value(p_get_asset_cursor_id, 4, x_inst_asset_rec.fa_book_type_code );
584: dbms_sql.column_value(p_get_asset_cursor_id, 5, x_inst_asset_rec.fa_location_id);
585: dbms_sql.column_value(p_get_asset_cursor_id, 6, x_inst_asset_rec.asset_quantity);
586: dbms_sql.column_value(p_get_asset_cursor_id, 7, x_inst_asset_rec.update_status);
587: dbms_sql.column_value(p_get_asset_cursor_id, 8, x_inst_asset_rec.active_start_date);
588: dbms_sql.column_value(p_get_asset_cursor_id, 9, x_inst_asset_rec.active_end_date);
589: dbms_sql.column_value(p_get_asset_cursor_id, 10, x_inst_asset_rec.object_version_number);

Line 586: dbms_sql.column_value(p_get_asset_cursor_id, 7, x_inst_asset_rec.update_status);

582: dbms_sql.column_value(p_get_asset_cursor_id, 3, x_inst_asset_rec.fa_asset_id);
583: dbms_sql.column_value(p_get_asset_cursor_id, 4, x_inst_asset_rec.fa_book_type_code );
584: dbms_sql.column_value(p_get_asset_cursor_id, 5, x_inst_asset_rec.fa_location_id);
585: dbms_sql.column_value(p_get_asset_cursor_id, 6, x_inst_asset_rec.asset_quantity);
586: dbms_sql.column_value(p_get_asset_cursor_id, 7, x_inst_asset_rec.update_status);
587: dbms_sql.column_value(p_get_asset_cursor_id, 8, x_inst_asset_rec.active_start_date);
588: dbms_sql.column_value(p_get_asset_cursor_id, 9, x_inst_asset_rec.active_end_date);
589: dbms_sql.column_value(p_get_asset_cursor_id, 10, x_inst_asset_rec.object_version_number);
590:

Line 587: dbms_sql.column_value(p_get_asset_cursor_id, 8, x_inst_asset_rec.active_start_date);

583: dbms_sql.column_value(p_get_asset_cursor_id, 4, x_inst_asset_rec.fa_book_type_code );
584: dbms_sql.column_value(p_get_asset_cursor_id, 5, x_inst_asset_rec.fa_location_id);
585: dbms_sql.column_value(p_get_asset_cursor_id, 6, x_inst_asset_rec.asset_quantity);
586: dbms_sql.column_value(p_get_asset_cursor_id, 7, x_inst_asset_rec.update_status);
587: dbms_sql.column_value(p_get_asset_cursor_id, 8, x_inst_asset_rec.active_start_date);
588: dbms_sql.column_value(p_get_asset_cursor_id, 9, x_inst_asset_rec.active_end_date);
589: dbms_sql.column_value(p_get_asset_cursor_id, 10, x_inst_asset_rec.object_version_number);
590:
591: END Get_Asset_Column_Values;

Line 588: dbms_sql.column_value(p_get_asset_cursor_id, 9, x_inst_asset_rec.active_end_date);

584: dbms_sql.column_value(p_get_asset_cursor_id, 5, x_inst_asset_rec.fa_location_id);
585: dbms_sql.column_value(p_get_asset_cursor_id, 6, x_inst_asset_rec.asset_quantity);
586: dbms_sql.column_value(p_get_asset_cursor_id, 7, x_inst_asset_rec.update_status);
587: dbms_sql.column_value(p_get_asset_cursor_id, 8, x_inst_asset_rec.active_start_date);
588: dbms_sql.column_value(p_get_asset_cursor_id, 9, x_inst_asset_rec.active_end_date);
589: dbms_sql.column_value(p_get_asset_cursor_id, 10, x_inst_asset_rec.object_version_number);
590:
591: END Get_Asset_Column_Values;
592:

Line 589: dbms_sql.column_value(p_get_asset_cursor_id, 10, x_inst_asset_rec.object_version_number);

585: dbms_sql.column_value(p_get_asset_cursor_id, 6, x_inst_asset_rec.asset_quantity);
586: dbms_sql.column_value(p_get_asset_cursor_id, 7, x_inst_asset_rec.update_status);
587: dbms_sql.column_value(p_get_asset_cursor_id, 8, x_inst_asset_rec.active_start_date);
588: dbms_sql.column_value(p_get_asset_cursor_id, 9, x_inst_asset_rec.active_end_date);
589: dbms_sql.column_value(p_get_asset_cursor_id, 10, x_inst_asset_rec.object_version_number);
590:
591: END Get_Asset_Column_Values;
592:
593:

Line 609: dbms_sql.define_column(p_get_asset_cursor_id, 1, l_inst_asset_rec.instance_asset_id);

605: l_inst_asset_rec csi_datastructures_pub.instance_asset_header_rec;
606:
607: BEGIN
608:
609: dbms_sql.define_column(p_get_asset_cursor_id, 1, l_inst_asset_rec.instance_asset_id);
610: dbms_sql.define_column(p_get_asset_cursor_id, 2, l_inst_asset_rec.instance_id);
611: dbms_sql.define_column(p_get_asset_cursor_id, 3, l_inst_asset_rec.fa_asset_id);
612: dbms_sql.define_column(p_get_asset_cursor_id, 4, l_inst_asset_rec.fa_book_type_code,30 );
613: dbms_sql.define_column(p_get_asset_cursor_id, 5, l_inst_asset_rec.fa_location_id);

Line 610: dbms_sql.define_column(p_get_asset_cursor_id, 2, l_inst_asset_rec.instance_id);

606:
607: BEGIN
608:
609: dbms_sql.define_column(p_get_asset_cursor_id, 1, l_inst_asset_rec.instance_asset_id);
610: dbms_sql.define_column(p_get_asset_cursor_id, 2, l_inst_asset_rec.instance_id);
611: dbms_sql.define_column(p_get_asset_cursor_id, 3, l_inst_asset_rec.fa_asset_id);
612: dbms_sql.define_column(p_get_asset_cursor_id, 4, l_inst_asset_rec.fa_book_type_code,30 );
613: dbms_sql.define_column(p_get_asset_cursor_id, 5, l_inst_asset_rec.fa_location_id);
614: dbms_sql.define_column(p_get_asset_cursor_id, 6, l_inst_asset_rec.asset_quantity);

Line 611: dbms_sql.define_column(p_get_asset_cursor_id, 3, l_inst_asset_rec.fa_asset_id);

607: BEGIN
608:
609: dbms_sql.define_column(p_get_asset_cursor_id, 1, l_inst_asset_rec.instance_asset_id);
610: dbms_sql.define_column(p_get_asset_cursor_id, 2, l_inst_asset_rec.instance_id);
611: dbms_sql.define_column(p_get_asset_cursor_id, 3, l_inst_asset_rec.fa_asset_id);
612: dbms_sql.define_column(p_get_asset_cursor_id, 4, l_inst_asset_rec.fa_book_type_code,30 );
613: dbms_sql.define_column(p_get_asset_cursor_id, 5, l_inst_asset_rec.fa_location_id);
614: dbms_sql.define_column(p_get_asset_cursor_id, 6, l_inst_asset_rec.asset_quantity);
615: dbms_sql.define_column(p_get_asset_cursor_id, 7, l_inst_asset_rec.update_status,30);

Line 612: dbms_sql.define_column(p_get_asset_cursor_id, 4, l_inst_asset_rec.fa_book_type_code,30 );

608:
609: dbms_sql.define_column(p_get_asset_cursor_id, 1, l_inst_asset_rec.instance_asset_id);
610: dbms_sql.define_column(p_get_asset_cursor_id, 2, l_inst_asset_rec.instance_id);
611: dbms_sql.define_column(p_get_asset_cursor_id, 3, l_inst_asset_rec.fa_asset_id);
612: dbms_sql.define_column(p_get_asset_cursor_id, 4, l_inst_asset_rec.fa_book_type_code,30 );
613: dbms_sql.define_column(p_get_asset_cursor_id, 5, l_inst_asset_rec.fa_location_id);
614: dbms_sql.define_column(p_get_asset_cursor_id, 6, l_inst_asset_rec.asset_quantity);
615: dbms_sql.define_column(p_get_asset_cursor_id, 7, l_inst_asset_rec.update_status,30);
616: dbms_sql.define_column(p_get_asset_cursor_id, 8, l_inst_asset_rec.active_start_date);

Line 613: dbms_sql.define_column(p_get_asset_cursor_id, 5, l_inst_asset_rec.fa_location_id);

609: dbms_sql.define_column(p_get_asset_cursor_id, 1, l_inst_asset_rec.instance_asset_id);
610: dbms_sql.define_column(p_get_asset_cursor_id, 2, l_inst_asset_rec.instance_id);
611: dbms_sql.define_column(p_get_asset_cursor_id, 3, l_inst_asset_rec.fa_asset_id);
612: dbms_sql.define_column(p_get_asset_cursor_id, 4, l_inst_asset_rec.fa_book_type_code,30 );
613: dbms_sql.define_column(p_get_asset_cursor_id, 5, l_inst_asset_rec.fa_location_id);
614: dbms_sql.define_column(p_get_asset_cursor_id, 6, l_inst_asset_rec.asset_quantity);
615: dbms_sql.define_column(p_get_asset_cursor_id, 7, l_inst_asset_rec.update_status,30);
616: dbms_sql.define_column(p_get_asset_cursor_id, 8, l_inst_asset_rec.active_start_date);
617: dbms_sql.define_column(p_get_asset_cursor_id, 9, l_inst_asset_rec.active_end_date);

Line 614: dbms_sql.define_column(p_get_asset_cursor_id, 6, l_inst_asset_rec.asset_quantity);

610: dbms_sql.define_column(p_get_asset_cursor_id, 2, l_inst_asset_rec.instance_id);
611: dbms_sql.define_column(p_get_asset_cursor_id, 3, l_inst_asset_rec.fa_asset_id);
612: dbms_sql.define_column(p_get_asset_cursor_id, 4, l_inst_asset_rec.fa_book_type_code,30 );
613: dbms_sql.define_column(p_get_asset_cursor_id, 5, l_inst_asset_rec.fa_location_id);
614: dbms_sql.define_column(p_get_asset_cursor_id, 6, l_inst_asset_rec.asset_quantity);
615: dbms_sql.define_column(p_get_asset_cursor_id, 7, l_inst_asset_rec.update_status,30);
616: dbms_sql.define_column(p_get_asset_cursor_id, 8, l_inst_asset_rec.active_start_date);
617: dbms_sql.define_column(p_get_asset_cursor_id, 9, l_inst_asset_rec.active_end_date);
618: dbms_sql.define_column(p_get_asset_cursor_id, 10, l_inst_asset_rec.object_version_number);

Line 615: dbms_sql.define_column(p_get_asset_cursor_id, 7, l_inst_asset_rec.update_status,30);

611: dbms_sql.define_column(p_get_asset_cursor_id, 3, l_inst_asset_rec.fa_asset_id);
612: dbms_sql.define_column(p_get_asset_cursor_id, 4, l_inst_asset_rec.fa_book_type_code,30 );
613: dbms_sql.define_column(p_get_asset_cursor_id, 5, l_inst_asset_rec.fa_location_id);
614: dbms_sql.define_column(p_get_asset_cursor_id, 6, l_inst_asset_rec.asset_quantity);
615: dbms_sql.define_column(p_get_asset_cursor_id, 7, l_inst_asset_rec.update_status,30);
616: dbms_sql.define_column(p_get_asset_cursor_id, 8, l_inst_asset_rec.active_start_date);
617: dbms_sql.define_column(p_get_asset_cursor_id, 9, l_inst_asset_rec.active_end_date);
618: dbms_sql.define_column(p_get_asset_cursor_id, 10, l_inst_asset_rec.object_version_number);
619:

Line 616: dbms_sql.define_column(p_get_asset_cursor_id, 8, l_inst_asset_rec.active_start_date);

612: dbms_sql.define_column(p_get_asset_cursor_id, 4, l_inst_asset_rec.fa_book_type_code,30 );
613: dbms_sql.define_column(p_get_asset_cursor_id, 5, l_inst_asset_rec.fa_location_id);
614: dbms_sql.define_column(p_get_asset_cursor_id, 6, l_inst_asset_rec.asset_quantity);
615: dbms_sql.define_column(p_get_asset_cursor_id, 7, l_inst_asset_rec.update_status,30);
616: dbms_sql.define_column(p_get_asset_cursor_id, 8, l_inst_asset_rec.active_start_date);
617: dbms_sql.define_column(p_get_asset_cursor_id, 9, l_inst_asset_rec.active_end_date);
618: dbms_sql.define_column(p_get_asset_cursor_id, 10, l_inst_asset_rec.object_version_number);
619:
620: END Define_Asset_Columns;

Line 617: dbms_sql.define_column(p_get_asset_cursor_id, 9, l_inst_asset_rec.active_end_date);

613: dbms_sql.define_column(p_get_asset_cursor_id, 5, l_inst_asset_rec.fa_location_id);
614: dbms_sql.define_column(p_get_asset_cursor_id, 6, l_inst_asset_rec.asset_quantity);
615: dbms_sql.define_column(p_get_asset_cursor_id, 7, l_inst_asset_rec.update_status,30);
616: dbms_sql.define_column(p_get_asset_cursor_id, 8, l_inst_asset_rec.active_start_date);
617: dbms_sql.define_column(p_get_asset_cursor_id, 9, l_inst_asset_rec.active_end_date);
618: dbms_sql.define_column(p_get_asset_cursor_id, 10, l_inst_asset_rec.object_version_number);
619:
620: END Define_Asset_Columns;
621:

Line 618: dbms_sql.define_column(p_get_asset_cursor_id, 10, l_inst_asset_rec.object_version_number);

614: dbms_sql.define_column(p_get_asset_cursor_id, 6, l_inst_asset_rec.asset_quantity);
615: dbms_sql.define_column(p_get_asset_cursor_id, 7, l_inst_asset_rec.update_status,30);
616: dbms_sql.define_column(p_get_asset_cursor_id, 8, l_inst_asset_rec.active_start_date);
617: dbms_sql.define_column(p_get_asset_cursor_id, 9, l_inst_asset_rec.active_end_date);
618: dbms_sql.define_column(p_get_asset_cursor_id, 10, l_inst_asset_rec.object_version_number);
619:
620: END Define_Asset_Columns;
621:
622: /*----------------------------------------------------------*/

Line 637: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':instance_asset_id', p_inst_asset_query_rec.instance_asset_id);

633:
634: BEGIN
635: IF( (p_inst_asset_query_rec.instance_asset_id IS NOT NULL)
636: AND (p_inst_asset_query_rec.instance_asset_id <> FND_API.G_MISS_NUM)) THEN
637: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':instance_asset_id', p_inst_asset_query_rec.instance_asset_id);
638: END IF;
639:
640: IF( (p_inst_asset_query_rec.instance_id IS NOT NULL)
641: AND (p_inst_asset_query_rec.instance_id <> FND_API.G_MISS_NUM)) THEN

Line 642: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':instance_id', p_inst_asset_query_rec.instance_id);

638: END IF;
639:
640: IF( (p_inst_asset_query_rec.instance_id IS NOT NULL)
641: AND (p_inst_asset_query_rec.instance_id <> FND_API.G_MISS_NUM)) THEN
642: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':instance_id', p_inst_asset_query_rec.instance_id);
643: END IF;
644:
645: IF( (p_inst_asset_query_rec.fa_asset_id IS NOT NULL)
646: AND (p_inst_asset_query_rec.fa_asset_id <> FND_API.G_MISS_NUM)) THEN

Line 647: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_asset_id', p_inst_asset_query_rec.fa_asset_id);

643: END IF;
644:
645: IF( (p_inst_asset_query_rec.fa_asset_id IS NOT NULL)
646: AND (p_inst_asset_query_rec.fa_asset_id <> FND_API.G_MISS_NUM)) THEN
647: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_asset_id', p_inst_asset_query_rec.fa_asset_id);
648: END IF;
649:
650: IF( (p_inst_asset_query_rec.fa_book_type_code IS NOT NULL)
651: AND (p_inst_asset_query_rec.fa_book_type_code <> FND_API.G_MISS_CHAR)) THEN

Line 652: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_book_type_code', p_inst_asset_query_rec.fa_book_type_code);

648: END IF;
649:
650: IF( (p_inst_asset_query_rec.fa_book_type_code IS NOT NULL)
651: AND (p_inst_asset_query_rec.fa_book_type_code <> FND_API.G_MISS_CHAR)) THEN
652: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_book_type_code', p_inst_asset_query_rec.fa_book_type_code);
653: END IF;
654:
655: IF( (p_inst_asset_query_rec.fa_location_id IS NOT NULL)
656: AND (p_inst_asset_query_rec.fa_location_id <> FND_API.G_MISS_NUM)) THEN

Line 657: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_location_id', p_inst_asset_query_rec.fa_location_id);

653: END IF;
654:
655: IF( (p_inst_asset_query_rec.fa_location_id IS NOT NULL)
656: AND (p_inst_asset_query_rec.fa_location_id <> FND_API.G_MISS_NUM)) THEN
657: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_location_id', p_inst_asset_query_rec.fa_location_id);
658: END IF;
659: IF( (p_inst_asset_query_rec.update_status IS NOT NULL)
660: AND (p_inst_asset_query_rec.update_status <> FND_API.G_MISS_CHAR)) THEN
661: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':update_status', p_inst_asset_query_rec.update_status);

Line 661: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':update_status', p_inst_asset_query_rec.update_status);

657: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':fa_location_id', p_inst_asset_query_rec.fa_location_id);
658: END IF;
659: IF( (p_inst_asset_query_rec.update_status IS NOT NULL)
660: AND (p_inst_asset_query_rec.update_status <> FND_API.G_MISS_CHAR)) THEN
661: DBMS_SQL.BIND_VARIABLE(p_get_asset_cursor_id, ':update_status', p_inst_asset_query_rec.update_status);
662: END IF;
663:
664: END Bind_asset_variable;
665:

Line 870: l_get_inst_asset_cursor_id := dbms_sql.open_cursor;

866: -- Build the select statement
867: l_select_stmt := l_select_stmt || ' where '||l_where_clause;
868:
869: -- Open the cursor
870: l_get_inst_asset_cursor_id := dbms_sql.open_cursor;
871:
872: --Parse the select statement
873: dbms_sql.parse(l_get_inst_asset_cursor_id, l_select_stmt , dbms_sql.native);
874:

Line 873: dbms_sql.parse(l_get_inst_asset_cursor_id, l_select_stmt , dbms_sql.native);

869: -- Open the cursor
870: l_get_inst_asset_cursor_id := dbms_sql.open_cursor;
871:
872: --Parse the select statement
873: dbms_sql.parse(l_get_inst_asset_cursor_id, l_select_stmt , dbms_sql.native);
874:
875: -- Bind the variables
876: Bind_asset_variable(p_instance_asset_query_rec, l_get_inst_asset_cursor_id);
877:

Line 882: l_rows_processed := dbms_sql.execute(l_get_inst_asset_cursor_id);

878: -- Define output variables
879: Define_Asset_Columns(l_get_inst_asset_cursor_id);
880:
881: -- execute the select statement
882: l_rows_processed := dbms_sql.execute(l_get_inst_asset_cursor_id);
883:
884: LOOP
885: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_inst_asset_cursor_id) = 0;
886: Get_asset_Column_Values(l_get_inst_asset_cursor_id, l_inst_asset_rec);

Line 885: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_inst_asset_cursor_id) = 0;

881: -- execute the select statement
882: l_rows_processed := dbms_sql.execute(l_get_inst_asset_cursor_id);
883:
884: LOOP
885: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_inst_asset_cursor_id) = 0;
886: Get_asset_Column_Values(l_get_inst_asset_cursor_id, l_inst_asset_rec);
887: l_count := l_count + 1;
888: x_instance_asset_tbl(l_count) := l_inst_asset_rec;
889: END LOOP;

Line 892: DBMS_SQL.CLOSE_CURSOR(l_get_inst_asset_cursor_id);

888: x_instance_asset_tbl(l_count) := l_inst_asset_rec;
889: END LOOP;
890:
891: -- Close the cursor
892: DBMS_SQL.CLOSE_CURSOR(l_get_inst_asset_cursor_id);
893:
894: IF (p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE) THEN
895: IF p_time_stamp <= sysdate THEN
896: Construct_asset_from_hist(x_instance_asset_tbl, p_time_stamp);

Line 966: IF DBMS_SQL.IS_OPEN(l_get_inst_asset_cursor_id) THEN

962: THEN
963: ROLLBACK TO get_instance_asset_pvt;
964: END IF;
965: */
966: IF DBMS_SQL.IS_OPEN(l_get_inst_asset_cursor_id) THEN
967: DBMS_SQL.CLOSE_CURSOR(l_get_inst_asset_cursor_id);
968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
970: IF FND_MSG_PUB.Check_Msg_Level

Line 967: DBMS_SQL.CLOSE_CURSOR(l_get_inst_asset_cursor_id);

963: ROLLBACK TO get_instance_asset_pvt;
964: END IF;
965: */
966: IF DBMS_SQL.IS_OPEN(l_get_inst_asset_cursor_id) THEN
967: DBMS_SQL.CLOSE_CURSOR(l_get_inst_asset_cursor_id);
968: END IF;
969: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
970: IF FND_MSG_PUB.Check_Msg_Level
971: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)