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

Line 3663: l_cursor := dbms_sql.open_cursor;

3659: flm_util.add_bind(':start_date', l_start_date);
3660: flm_util.add_bind(':end_date', l_end_date+1-1/(24*60*60));
3661: --end of fix bug#3170105
3662: -- get the cursor
3663: l_cursor := dbms_sql.open_cursor;
3664:
3665: -- parse the sql statement
3666: dbms_sql.parse(l_cursor, l_sql_stmt, dbms_sql.native);
3667: flm_util.do_binds(l_cursor);

Line 3666: dbms_sql.parse(l_cursor, l_sql_stmt, dbms_sql.native);

3662: -- get the cursor
3663: l_cursor := dbms_sql.open_cursor;
3664:
3665: -- parse the sql statement
3666: dbms_sql.parse(l_cursor, l_sql_stmt, dbms_sql.native);
3667: flm_util.do_binds(l_cursor);
3668:
3669:
3670: -- define column

Line 3671: dbms_sql.define_column(l_cursor, 1, l_wip_entity_id);

3667: flm_util.do_binds(l_cursor);
3668:
3669:
3670: -- define column
3671: dbms_sql.define_column(l_cursor, 1, l_wip_entity_id);
3672: dbms_sql.define_column(l_cursor, 2, l_demand_source_line, 30);
3673: dbms_sql.define_column(l_cursor, 3, l_replenish_to_order_flag, 1);
3674: dbms_sql.define_column(l_cursor, 4, l_build_in_wip_flag, 1);
3675:

Line 3672: dbms_sql.define_column(l_cursor, 2, l_demand_source_line, 30);

3668:
3669:
3670: -- define column
3671: dbms_sql.define_column(l_cursor, 1, l_wip_entity_id);
3672: dbms_sql.define_column(l_cursor, 2, l_demand_source_line, 30);
3673: dbms_sql.define_column(l_cursor, 3, l_replenish_to_order_flag, 1);
3674: dbms_sql.define_column(l_cursor, 4, l_build_in_wip_flag, 1);
3675:
3676: -- execute the sql statement

Line 3673: dbms_sql.define_column(l_cursor, 3, l_replenish_to_order_flag, 1);

3669:
3670: -- define column
3671: dbms_sql.define_column(l_cursor, 1, l_wip_entity_id);
3672: dbms_sql.define_column(l_cursor, 2, l_demand_source_line, 30);
3673: dbms_sql.define_column(l_cursor, 3, l_replenish_to_order_flag, 1);
3674: dbms_sql.define_column(l_cursor, 4, l_build_in_wip_flag, 1);
3675:
3676: -- execute the sql statement
3677: l_dummy := dbms_sql.execute(l_cursor);

Line 3674: dbms_sql.define_column(l_cursor, 4, l_build_in_wip_flag, 1);

3670: -- define column
3671: dbms_sql.define_column(l_cursor, 1, l_wip_entity_id);
3672: dbms_sql.define_column(l_cursor, 2, l_demand_source_line, 30);
3673: dbms_sql.define_column(l_cursor, 3, l_replenish_to_order_flag, 1);
3674: dbms_sql.define_column(l_cursor, 4, l_build_in_wip_flag, 1);
3675:
3676: -- execute the sql statement
3677: l_dummy := dbms_sql.execute(l_cursor);
3678:

Line 3677: l_dummy := dbms_sql.execute(l_cursor);

3673: dbms_sql.define_column(l_cursor, 3, l_replenish_to_order_flag, 1);
3674: dbms_sql.define_column(l_cursor, 4, l_build_in_wip_flag, 1);
3675:
3676: -- execute the sql statement
3677: l_dummy := dbms_sql.execute(l_cursor);
3678:
3679: WHILE dbms_sql.fetch_rows(l_cursor) > 0 LOOP
3680: dbms_sql.column_value(l_cursor,1, l_wip_entity_id);
3681: dbms_sql.column_value(l_cursor,2, l_demand_source_line);

Line 3679: WHILE dbms_sql.fetch_rows(l_cursor) > 0 LOOP

3675:
3676: -- execute the sql statement
3677: l_dummy := dbms_sql.execute(l_cursor);
3678:
3679: WHILE dbms_sql.fetch_rows(l_cursor) > 0 LOOP
3680: dbms_sql.column_value(l_cursor,1, l_wip_entity_id);
3681: dbms_sql.column_value(l_cursor,2, l_demand_source_line);
3682: dbms_sql.column_value(l_cursor,3, l_replenish_to_order_flag);
3683: dbms_sql.column_value(l_cursor,4, l_build_in_wip_flag);

Line 3680: dbms_sql.column_value(l_cursor,1, l_wip_entity_id);

3676: -- execute the sql statement
3677: l_dummy := dbms_sql.execute(l_cursor);
3678:
3679: WHILE dbms_sql.fetch_rows(l_cursor) > 0 LOOP
3680: dbms_sql.column_value(l_cursor,1, l_wip_entity_id);
3681: dbms_sql.column_value(l_cursor,2, l_demand_source_line);
3682: dbms_sql.column_value(l_cursor,3, l_replenish_to_order_flag);
3683: dbms_sql.column_value(l_cursor,4, l_build_in_wip_flag);
3684:

Line 3681: dbms_sql.column_value(l_cursor,2, l_demand_source_line);

3677: l_dummy := dbms_sql.execute(l_cursor);
3678:
3679: WHILE dbms_sql.fetch_rows(l_cursor) > 0 LOOP
3680: dbms_sql.column_value(l_cursor,1, l_wip_entity_id);
3681: dbms_sql.column_value(l_cursor,2, l_demand_source_line);
3682: dbms_sql.column_value(l_cursor,3, l_replenish_to_order_flag);
3683: dbms_sql.column_value(l_cursor,4, l_build_in_wip_flag);
3684:
3685: -- Added to support component picking. It will cancel the move order when the flow

Line 3682: dbms_sql.column_value(l_cursor,3, l_replenish_to_order_flag);

3678:
3679: WHILE dbms_sql.fetch_rows(l_cursor) > 0 LOOP
3680: dbms_sql.column_value(l_cursor,1, l_wip_entity_id);
3681: dbms_sql.column_value(l_cursor,2, l_demand_source_line);
3682: dbms_sql.column_value(l_cursor,3, l_replenish_to_order_flag);
3683: dbms_sql.column_value(l_cursor,4, l_build_in_wip_flag);
3684:
3685: -- Added to support component picking. It will cancel the move order when the flow
3686: -- schedule is to be deleted.

Line 3683: dbms_sql.column_value(l_cursor,4, l_build_in_wip_flag);

3679: WHILE dbms_sql.fetch_rows(l_cursor) > 0 LOOP
3680: dbms_sql.column_value(l_cursor,1, l_wip_entity_id);
3681: dbms_sql.column_value(l_cursor,2, l_demand_source_line);
3682: dbms_sql.column_value(l_cursor,3, l_replenish_to_order_flag);
3683: dbms_sql.column_value(l_cursor,4, l_build_in_wip_flag);
3684:
3685: -- Added to support component picking. It will cancel the move order when the flow
3686: -- schedule is to be deleted.
3687: wip_picking_pvt.cancel_allocations(l_wip_entity_id, 4, null, l_return_status, l_msg_data);

Line 3715: dbms_sql.close_cursor(l_cursor);

3711:
3712: END LOOP;
3713:
3714: -- close the cursor
3715: dbms_sql.close_cursor(l_cursor);
3716:
3717: FND_MESSAGE.set_name('MRP','MRP_ROWS_DELETED');
3718: FND_MESSAGE.set_token('ROW_COUNT',l_rows_processed);
3719: ERRBUF := FND_MESSAGE.get;

Line 4360: l_cursor_name := dbms_sql.open_cursor;

4356:
4357: flm_util.add_bind(':organization_id', p_organization_id);
4358:
4359: -- get the cursor
4360: l_cursor_name := dbms_sql.open_cursor;
4361:
4362: -- parse the sql statement
4363: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4364: flm_util.do_binds(l_cursor_name);

Line 4363: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);

4359: -- get the cursor
4360: l_cursor_name := dbms_sql.open_cursor;
4361:
4362: -- parse the sql statement
4363: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4364: flm_util.do_binds(l_cursor_name);
4365:
4366: dbms_sql.define_column(l_cursor_name, 1, l_flow_schedule_rec.wip_entity_id);
4367:

Line 4366: dbms_sql.define_column(l_cursor_name, 1, l_flow_schedule_rec.wip_entity_id);

4362: -- parse the sql statement
4363: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4364: flm_util.do_binds(l_cursor_name);
4365:
4366: dbms_sql.define_column(l_cursor_name, 1, l_flow_schedule_rec.wip_entity_id);
4367:
4368:
4369: -- execute the sql statement
4370: -- execute will return zero rows processed since this is just a select

Line 4372: l_rows_processed := dbms_sql.execute(l_cursor_name);

4368:
4369: -- execute the sql statement
4370: -- execute will return zero rows processed since this is just a select
4371: -- statement. Need a variable for the return value.
4372: l_rows_processed := dbms_sql.execute(l_cursor_name);
4373:
4374: return(l_cursor_name);
4375: EXCEPTION
4376: WHEN NO_DATA_FOUND THEN

Line 4526: l_cursor_name := dbms_sql.open_cursor;

4522: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
4523: --end of fix bug#3170105
4524:
4525: -- get the cursor
4526: l_cursor_name := dbms_sql.open_cursor;
4527:
4528: -- parse the sql statement
4529: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4530: flm_util.do_binds(l_cursor_name);

Line 4529: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);

4525: -- get the cursor
4526: l_cursor_name := dbms_sql.open_cursor;
4527:
4528: -- parse the sql statement
4529: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4530: flm_util.do_binds(l_cursor_name);
4531:
4532: -- define columns
4533: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);

Line 4533: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);

4529: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4530: flm_util.do_binds(l_cursor_name);
4531:
4532: -- define columns
4533: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4534: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4535: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4536: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.item, 2000);
4537: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_group_id);

Line 4534: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);

4530: flm_util.do_binds(l_cursor_name);
4531:
4532: -- define columns
4533: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4534: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4535: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4536: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.item, 2000);
4537: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_group_id);
4538: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.planned_quantity);

Line 4535: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);

4531:
4532: -- define columns
4533: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4534: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4535: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4536: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.item, 2000);
4537: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_group_id);
4538: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.planned_quantity);
4539: dbms_sql.define_column(l_cursor_name, 7, fs_report_rec.quantity_completed);

Line 4536: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.item, 2000);

4532: -- define columns
4533: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4534: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4535: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4536: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.item, 2000);
4537: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_group_id);
4538: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.planned_quantity);
4539: dbms_sql.define_column(l_cursor_name, 7, fs_report_rec.quantity_completed);
4540:

Line 4537: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_group_id);

4533: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4534: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4535: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4536: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.item, 2000);
4537: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_group_id);
4538: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.planned_quantity);
4539: dbms_sql.define_column(l_cursor_name, 7, fs_report_rec.quantity_completed);
4540:
4541:

Line 4538: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.planned_quantity);

4534: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4535: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4536: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.item, 2000);
4537: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_group_id);
4538: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.planned_quantity);
4539: dbms_sql.define_column(l_cursor_name, 7, fs_report_rec.quantity_completed);
4540:
4541:
4542: -- execute the sql statement

Line 4539: dbms_sql.define_column(l_cursor_name, 7, fs_report_rec.quantity_completed);

4535: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4536: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.item, 2000);
4537: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_group_id);
4538: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.planned_quantity);
4539: dbms_sql.define_column(l_cursor_name, 7, fs_report_rec.quantity_completed);
4540:
4541:
4542: -- execute the sql statement
4543: -- execute will return zero rows processed since this is just a select

Line 4545: l_rows_processed := dbms_sql.execute(l_cursor_name);

4541:
4542: -- execute the sql statement
4543: -- execute will return zero rows processed since this is just a select
4544: -- statement. Need a variable for the return value.
4545: l_rows_processed := dbms_sql.execute(l_cursor_name);
4546:
4547: -- return cursor name
4548: return(l_cursor_name);
4549:

Line 4730: l_cursor_name := dbms_sql.open_cursor;

4726: and added a new order by above
4727: */
4728: --MRP_UTIL.MRP_LOG(l_sql_stmt);
4729: -- get the cursor
4730: l_cursor_name := dbms_sql.open_cursor;
4731:
4732: -- parse the sql statement
4733: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4734: flm_util.do_binds(l_cursor_name);

Line 4733: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);

4729: -- get the cursor
4730: l_cursor_name := dbms_sql.open_cursor;
4731:
4732: -- parse the sql statement
4733: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
4734: flm_util.do_binds(l_cursor_name);
4735:
4736:
4737: -- define columns

Line 4738: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);

4734: flm_util.do_binds(l_cursor_name);
4735:
4736:
4737: -- define columns
4738: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4739: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4740: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4741: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.schedule_group_id);
4742: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_number,30);

Line 4739: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);

4735:
4736:
4737: -- define columns
4738: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4739: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4740: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4741: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.schedule_group_id);
4742: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_number,30);
4743: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.build_sequence);

Line 4740: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);

4736:
4737: -- define columns
4738: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4739: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4740: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4741: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.schedule_group_id);
4742: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_number,30);
4743: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.build_sequence);
4744: dbms_sql.define_column(l_cursor_name, 7,

Line 4741: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.schedule_group_id);

4737: -- define columns
4738: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4739: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4740: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4741: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.schedule_group_id);
4742: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_number,30);
4743: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.build_sequence);
4744: dbms_sql.define_column(l_cursor_name, 7,
4745: fs_report_rec.demand_source_header_id);

Line 4742: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_number,30);

4738: dbms_sql.define_column(l_cursor_name, 1, fs_report_rec.line_id);
4739: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4740: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4741: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.schedule_group_id);
4742: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_number,30);
4743: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.build_sequence);
4744: dbms_sql.define_column(l_cursor_name, 7,
4745: fs_report_rec.demand_source_header_id);
4746: dbms_sql.define_column(l_cursor_name, 8,

Line 4743: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.build_sequence);

4739: dbms_sql.define_column(l_cursor_name, 2, fs_report_rec.line_code, 10);
4740: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4741: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.schedule_group_id);
4742: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_number,30);
4743: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.build_sequence);
4744: dbms_sql.define_column(l_cursor_name, 7,
4745: fs_report_rec.demand_source_header_id);
4746: dbms_sql.define_column(l_cursor_name, 8,
4747: fs_report_rec.demand_source_line,30);

Line 4744: dbms_sql.define_column(l_cursor_name, 7,

4740: dbms_sql.define_column(l_cursor_name, 3, fs_report_rec.primary_item_id);
4741: dbms_sql.define_column(l_cursor_name, 4, fs_report_rec.schedule_group_id);
4742: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_number,30);
4743: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.build_sequence);
4744: dbms_sql.define_column(l_cursor_name, 7,
4745: fs_report_rec.demand_source_header_id);
4746: dbms_sql.define_column(l_cursor_name, 8,
4747: fs_report_rec.demand_source_line,30);
4748: dbms_sql.define_column(l_cursor_name, 9,fs_report_rec.demand_source_delivery,

Line 4746: dbms_sql.define_column(l_cursor_name, 8,

4742: dbms_sql.define_column(l_cursor_name, 5, fs_report_rec.schedule_number,30);
4743: dbms_sql.define_column(l_cursor_name, 6, fs_report_rec.build_sequence);
4744: dbms_sql.define_column(l_cursor_name, 7,
4745: fs_report_rec.demand_source_header_id);
4746: dbms_sql.define_column(l_cursor_name, 8,
4747: fs_report_rec.demand_source_line,30);
4748: dbms_sql.define_column(l_cursor_name, 9,fs_report_rec.demand_source_delivery,
4749: 30);
4750: dbms_sql.define_column(l_cursor_name, 10,fs_report_rec.demand_source_type);

Line 4748: dbms_sql.define_column(l_cursor_name, 9,fs_report_rec.demand_source_delivery,

4744: dbms_sql.define_column(l_cursor_name, 7,
4745: fs_report_rec.demand_source_header_id);
4746: dbms_sql.define_column(l_cursor_name, 8,
4747: fs_report_rec.demand_source_line,30);
4748: dbms_sql.define_column(l_cursor_name, 9,fs_report_rec.demand_source_delivery,
4749: 30);
4750: dbms_sql.define_column(l_cursor_name, 10,fs_report_rec.demand_source_type);
4751: dbms_sql.define_column(l_cursor_name, 11,fs_report_rec.demand_class,30);
4752: dbms_sql.define_column(l_cursor_name, 12, fs_report_rec.item, 2000);

Line 4750: dbms_sql.define_column(l_cursor_name, 10,fs_report_rec.demand_source_type);

4746: dbms_sql.define_column(l_cursor_name, 8,
4747: fs_report_rec.demand_source_line,30);
4748: dbms_sql.define_column(l_cursor_name, 9,fs_report_rec.demand_source_delivery,
4749: 30);
4750: dbms_sql.define_column(l_cursor_name, 10,fs_report_rec.demand_source_type);
4751: dbms_sql.define_column(l_cursor_name, 11,fs_report_rec.demand_class,30);
4752: dbms_sql.define_column(l_cursor_name, 12, fs_report_rec.item, 2000);
4753: dbms_sql.define_column(l_cursor_name, 13, fs_report_rec.planned_quantity);
4754: dbms_sql.define_column(l_cursor_name, 14, fs_report_rec.quantity_completed);

Line 4751: dbms_sql.define_column(l_cursor_name, 11,fs_report_rec.demand_class,30);

4747: fs_report_rec.demand_source_line,30);
4748: dbms_sql.define_column(l_cursor_name, 9,fs_report_rec.demand_source_delivery,
4749: 30);
4750: dbms_sql.define_column(l_cursor_name, 10,fs_report_rec.demand_source_type);
4751: dbms_sql.define_column(l_cursor_name, 11,fs_report_rec.demand_class,30);
4752: dbms_sql.define_column(l_cursor_name, 12, fs_report_rec.item, 2000);
4753: dbms_sql.define_column(l_cursor_name, 13, fs_report_rec.planned_quantity);
4754: dbms_sql.define_column(l_cursor_name, 14, fs_report_rec.quantity_completed);
4755: -- execute the sql statement

Line 4752: dbms_sql.define_column(l_cursor_name, 12, fs_report_rec.item, 2000);

4748: dbms_sql.define_column(l_cursor_name, 9,fs_report_rec.demand_source_delivery,
4749: 30);
4750: dbms_sql.define_column(l_cursor_name, 10,fs_report_rec.demand_source_type);
4751: dbms_sql.define_column(l_cursor_name, 11,fs_report_rec.demand_class,30);
4752: dbms_sql.define_column(l_cursor_name, 12, fs_report_rec.item, 2000);
4753: dbms_sql.define_column(l_cursor_name, 13, fs_report_rec.planned_quantity);
4754: dbms_sql.define_column(l_cursor_name, 14, fs_report_rec.quantity_completed);
4755: -- execute the sql statement
4756: dbms_sql.define_column(l_cursor_name, 15,

Line 4753: dbms_sql.define_column(l_cursor_name, 13, fs_report_rec.planned_quantity);

4749: 30);
4750: dbms_sql.define_column(l_cursor_name, 10,fs_report_rec.demand_source_type);
4751: dbms_sql.define_column(l_cursor_name, 11,fs_report_rec.demand_class,30);
4752: dbms_sql.define_column(l_cursor_name, 12, fs_report_rec.item, 2000);
4753: dbms_sql.define_column(l_cursor_name, 13, fs_report_rec.planned_quantity);
4754: dbms_sql.define_column(l_cursor_name, 14, fs_report_rec.quantity_completed);
4755: -- execute the sql statement
4756: dbms_sql.define_column(l_cursor_name, 15,
4757: fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);

Line 4754: dbms_sql.define_column(l_cursor_name, 14, fs_report_rec.quantity_completed);

4750: dbms_sql.define_column(l_cursor_name, 10,fs_report_rec.demand_source_type);
4751: dbms_sql.define_column(l_cursor_name, 11,fs_report_rec.demand_class,30);
4752: dbms_sql.define_column(l_cursor_name, 12, fs_report_rec.item, 2000);
4753: dbms_sql.define_column(l_cursor_name, 13, fs_report_rec.planned_quantity);
4754: dbms_sql.define_column(l_cursor_name, 14, fs_report_rec.quantity_completed);
4755: -- execute the sql statement
4756: dbms_sql.define_column(l_cursor_name, 15,
4757: fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
4758: dbms_sql.define_column(l_cursor_name, 16, fs_report_rec.MPS_NET_QUANTITY);

Line 4756: dbms_sql.define_column(l_cursor_name, 15,

4752: dbms_sql.define_column(l_cursor_name, 12, fs_report_rec.item, 2000);
4753: dbms_sql.define_column(l_cursor_name, 13, fs_report_rec.planned_quantity);
4754: dbms_sql.define_column(l_cursor_name, 14, fs_report_rec.quantity_completed);
4755: -- execute the sql statement
4756: dbms_sql.define_column(l_cursor_name, 15,
4757: fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
4758: dbms_sql.define_column(l_cursor_name, 16, fs_report_rec.MPS_NET_QUANTITY);
4759: dbms_sql.define_column(l_cursor_name, 17, fs_report_rec.BOM_REVISION,3);
4760: dbms_sql.define_column(l_cursor_name, 18, fs_report_rec.ROUTING_REVISION,3);

Line 4758: dbms_sql.define_column(l_cursor_name, 16, fs_report_rec.MPS_NET_QUANTITY);

4754: dbms_sql.define_column(l_cursor_name, 14, fs_report_rec.quantity_completed);
4755: -- execute the sql statement
4756: dbms_sql.define_column(l_cursor_name, 15,
4757: fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
4758: dbms_sql.define_column(l_cursor_name, 16, fs_report_rec.MPS_NET_QUANTITY);
4759: dbms_sql.define_column(l_cursor_name, 17, fs_report_rec.BOM_REVISION,3);
4760: dbms_sql.define_column(l_cursor_name, 18, fs_report_rec.ROUTING_REVISION,3);
4761: dbms_sql.define_column(l_cursor_name, 19, fs_report_rec.BOM_REVISION_DATE);
4762: dbms_sql.define_column(l_cursor_name, 20,

Line 4759: dbms_sql.define_column(l_cursor_name, 17, fs_report_rec.BOM_REVISION,3);

4755: -- execute the sql statement
4756: dbms_sql.define_column(l_cursor_name, 15,
4757: fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
4758: dbms_sql.define_column(l_cursor_name, 16, fs_report_rec.MPS_NET_QUANTITY);
4759: dbms_sql.define_column(l_cursor_name, 17, fs_report_rec.BOM_REVISION,3);
4760: dbms_sql.define_column(l_cursor_name, 18, fs_report_rec.ROUTING_REVISION,3);
4761: dbms_sql.define_column(l_cursor_name, 19, fs_report_rec.BOM_REVISION_DATE);
4762: dbms_sql.define_column(l_cursor_name, 20,
4763: fs_report_rec.ROUTING_REVISION_DATE);

Line 4760: dbms_sql.define_column(l_cursor_name, 18, fs_report_rec.ROUTING_REVISION,3);

4756: dbms_sql.define_column(l_cursor_name, 15,
4757: fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
4758: dbms_sql.define_column(l_cursor_name, 16, fs_report_rec.MPS_NET_QUANTITY);
4759: dbms_sql.define_column(l_cursor_name, 17, fs_report_rec.BOM_REVISION,3);
4760: dbms_sql.define_column(l_cursor_name, 18, fs_report_rec.ROUTING_REVISION,3);
4761: dbms_sql.define_column(l_cursor_name, 19, fs_report_rec.BOM_REVISION_DATE);
4762: dbms_sql.define_column(l_cursor_name, 20,
4763: fs_report_rec.ROUTING_REVISION_DATE);
4764: dbms_sql.define_column(l_cursor_name, 21,

Line 4761: dbms_sql.define_column(l_cursor_name, 19, fs_report_rec.BOM_REVISION_DATE);

4757: fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
4758: dbms_sql.define_column(l_cursor_name, 16, fs_report_rec.MPS_NET_QUANTITY);
4759: dbms_sql.define_column(l_cursor_name, 17, fs_report_rec.BOM_REVISION,3);
4760: dbms_sql.define_column(l_cursor_name, 18, fs_report_rec.ROUTING_REVISION,3);
4761: dbms_sql.define_column(l_cursor_name, 19, fs_report_rec.BOM_REVISION_DATE);
4762: dbms_sql.define_column(l_cursor_name, 20,
4763: fs_report_rec.ROUTING_REVISION_DATE);
4764: dbms_sql.define_column(l_cursor_name, 21,
4765: fs_report_rec.ALTERNATE_BOM_DESIGNATOR,10);

Line 4762: dbms_sql.define_column(l_cursor_name, 20,

4758: dbms_sql.define_column(l_cursor_name, 16, fs_report_rec.MPS_NET_QUANTITY);
4759: dbms_sql.define_column(l_cursor_name, 17, fs_report_rec.BOM_REVISION,3);
4760: dbms_sql.define_column(l_cursor_name, 18, fs_report_rec.ROUTING_REVISION,3);
4761: dbms_sql.define_column(l_cursor_name, 19, fs_report_rec.BOM_REVISION_DATE);
4762: dbms_sql.define_column(l_cursor_name, 20,
4763: fs_report_rec.ROUTING_REVISION_DATE);
4764: dbms_sql.define_column(l_cursor_name, 21,
4765: fs_report_rec.ALTERNATE_BOM_DESIGNATOR,10);
4766: dbms_sql.define_column(l_cursor_name, 22,

Line 4764: dbms_sql.define_column(l_cursor_name, 21,

4760: dbms_sql.define_column(l_cursor_name, 18, fs_report_rec.ROUTING_REVISION,3);
4761: dbms_sql.define_column(l_cursor_name, 19, fs_report_rec.BOM_REVISION_DATE);
4762: dbms_sql.define_column(l_cursor_name, 20,
4763: fs_report_rec.ROUTING_REVISION_DATE);
4764: dbms_sql.define_column(l_cursor_name, 21,
4765: fs_report_rec.ALTERNATE_BOM_DESIGNATOR,10);
4766: dbms_sql.define_column(l_cursor_name, 22,
4767: fs_report_rec.ALTERNATE_ROUTING_DESIGNATOR,10);
4768: dbms_sql.define_column(l_cursor_name, 23,

Line 4766: dbms_sql.define_column(l_cursor_name, 22,

4762: dbms_sql.define_column(l_cursor_name, 20,
4763: fs_report_rec.ROUTING_REVISION_DATE);
4764: dbms_sql.define_column(l_cursor_name, 21,
4765: fs_report_rec.ALTERNATE_BOM_DESIGNATOR,10);
4766: dbms_sql.define_column(l_cursor_name, 22,
4767: fs_report_rec.ALTERNATE_ROUTING_DESIGNATOR,10);
4768: dbms_sql.define_column(l_cursor_name, 23,
4769: fs_report_rec.COMPLETION_SUBINVENTORY,10);
4770: dbms_sql.define_column(l_cursor_name, 24,

Line 4768: dbms_sql.define_column(l_cursor_name, 23,

4764: dbms_sql.define_column(l_cursor_name, 21,
4765: fs_report_rec.ALTERNATE_BOM_DESIGNATOR,10);
4766: dbms_sql.define_column(l_cursor_name, 22,
4767: fs_report_rec.ALTERNATE_ROUTING_DESIGNATOR,10);
4768: dbms_sql.define_column(l_cursor_name, 23,
4769: fs_report_rec.COMPLETION_SUBINVENTORY,10);
4770: dbms_sql.define_column(l_cursor_name, 24,
4771: fs_report_rec.COMPLETION_LOCATOR_ID);
4772: dbms_sql.define_column(l_cursor_name, 25, fs_report_rec.MATERIAL_ACCOUNT);

Line 4770: dbms_sql.define_column(l_cursor_name, 24,

4766: dbms_sql.define_column(l_cursor_name, 22,
4767: fs_report_rec.ALTERNATE_ROUTING_DESIGNATOR,10);
4768: dbms_sql.define_column(l_cursor_name, 23,
4769: fs_report_rec.COMPLETION_SUBINVENTORY,10);
4770: dbms_sql.define_column(l_cursor_name, 24,
4771: fs_report_rec.COMPLETION_LOCATOR_ID);
4772: dbms_sql.define_column(l_cursor_name, 25, fs_report_rec.MATERIAL_ACCOUNT);
4773: dbms_sql.define_column(l_cursor_name, 26,
4774: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);

Line 4772: dbms_sql.define_column(l_cursor_name, 25, fs_report_rec.MATERIAL_ACCOUNT);

4768: dbms_sql.define_column(l_cursor_name, 23,
4769: fs_report_rec.COMPLETION_SUBINVENTORY,10);
4770: dbms_sql.define_column(l_cursor_name, 24,
4771: fs_report_rec.COMPLETION_LOCATOR_ID);
4772: dbms_sql.define_column(l_cursor_name, 25, fs_report_rec.MATERIAL_ACCOUNT);
4773: dbms_sql.define_column(l_cursor_name, 26,
4774: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);
4775: dbms_sql.define_column(l_cursor_name, 27, fs_report_rec.RESOURCE_ACCOUNT);
4776: dbms_sql.define_column(l_cursor_name, 28,

Line 4773: dbms_sql.define_column(l_cursor_name, 26,

4769: fs_report_rec.COMPLETION_SUBINVENTORY,10);
4770: dbms_sql.define_column(l_cursor_name, 24,
4771: fs_report_rec.COMPLETION_LOCATOR_ID);
4772: dbms_sql.define_column(l_cursor_name, 25, fs_report_rec.MATERIAL_ACCOUNT);
4773: dbms_sql.define_column(l_cursor_name, 26,
4774: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);
4775: dbms_sql.define_column(l_cursor_name, 27, fs_report_rec.RESOURCE_ACCOUNT);
4776: dbms_sql.define_column(l_cursor_name, 28,
4777: fs_report_rec.OUTSIDE_PROCESSING_ACCOUNT);

Line 4775: dbms_sql.define_column(l_cursor_name, 27, fs_report_rec.RESOURCE_ACCOUNT);

4771: fs_report_rec.COMPLETION_LOCATOR_ID);
4772: dbms_sql.define_column(l_cursor_name, 25, fs_report_rec.MATERIAL_ACCOUNT);
4773: dbms_sql.define_column(l_cursor_name, 26,
4774: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);
4775: dbms_sql.define_column(l_cursor_name, 27, fs_report_rec.RESOURCE_ACCOUNT);
4776: dbms_sql.define_column(l_cursor_name, 28,
4777: fs_report_rec.OUTSIDE_PROCESSING_ACCOUNT);
4778: dbms_sql.define_column(l_cursor_name, 29,
4779: fs_report_rec.MATERIAL_VARIANCE_ACCOUNT);

Line 4776: dbms_sql.define_column(l_cursor_name, 28,

4772: dbms_sql.define_column(l_cursor_name, 25, fs_report_rec.MATERIAL_ACCOUNT);
4773: dbms_sql.define_column(l_cursor_name, 26,
4774: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);
4775: dbms_sql.define_column(l_cursor_name, 27, fs_report_rec.RESOURCE_ACCOUNT);
4776: dbms_sql.define_column(l_cursor_name, 28,
4777: fs_report_rec.OUTSIDE_PROCESSING_ACCOUNT);
4778: dbms_sql.define_column(l_cursor_name, 29,
4779: fs_report_rec.MATERIAL_VARIANCE_ACCOUNT);
4780: dbms_sql.define_column(l_cursor_name, 30,

Line 4778: dbms_sql.define_column(l_cursor_name, 29,

4774: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);
4775: dbms_sql.define_column(l_cursor_name, 27, fs_report_rec.RESOURCE_ACCOUNT);
4776: dbms_sql.define_column(l_cursor_name, 28,
4777: fs_report_rec.OUTSIDE_PROCESSING_ACCOUNT);
4778: dbms_sql.define_column(l_cursor_name, 29,
4779: fs_report_rec.MATERIAL_VARIANCE_ACCOUNT);
4780: dbms_sql.define_column(l_cursor_name, 30,
4781: fs_report_rec.RESOURCE_VARIANCE_ACCOUNT);
4782: dbms_sql.define_column(l_cursor_name, 31,

Line 4780: dbms_sql.define_column(l_cursor_name, 30,

4776: dbms_sql.define_column(l_cursor_name, 28,
4777: fs_report_rec.OUTSIDE_PROCESSING_ACCOUNT);
4778: dbms_sql.define_column(l_cursor_name, 29,
4779: fs_report_rec.MATERIAL_VARIANCE_ACCOUNT);
4780: dbms_sql.define_column(l_cursor_name, 30,
4781: fs_report_rec.RESOURCE_VARIANCE_ACCOUNT);
4782: dbms_sql.define_column(l_cursor_name, 31,
4783: fs_report_rec.OUTSIDE_PROC_VARIANCE_ACCOUNT);
4784: dbms_sql.define_column(l_cursor_name, 32,

Line 4782: dbms_sql.define_column(l_cursor_name, 31,

4778: dbms_sql.define_column(l_cursor_name, 29,
4779: fs_report_rec.MATERIAL_VARIANCE_ACCOUNT);
4780: dbms_sql.define_column(l_cursor_name, 30,
4781: fs_report_rec.RESOURCE_VARIANCE_ACCOUNT);
4782: dbms_sql.define_column(l_cursor_name, 31,
4783: fs_report_rec.OUTSIDE_PROC_VARIANCE_ACCOUNT);
4784: dbms_sql.define_column(l_cursor_name, 32,
4785: fs_report_rec.STD_COST_ADJUSTMENT_ACCOUNT);
4786: dbms_sql.define_column(l_cursor_name, 33, fs_report_rec.OVERHEAD_ACCOUNT);

Line 4784: dbms_sql.define_column(l_cursor_name, 32,

4780: dbms_sql.define_column(l_cursor_name, 30,
4781: fs_report_rec.RESOURCE_VARIANCE_ACCOUNT);
4782: dbms_sql.define_column(l_cursor_name, 31,
4783: fs_report_rec.OUTSIDE_PROC_VARIANCE_ACCOUNT);
4784: dbms_sql.define_column(l_cursor_name, 32,
4785: fs_report_rec.STD_COST_ADJUSTMENT_ACCOUNT);
4786: dbms_sql.define_column(l_cursor_name, 33, fs_report_rec.OVERHEAD_ACCOUNT);
4787: dbms_sql.define_column(l_cursor_name, 34,
4788: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);

Line 4786: dbms_sql.define_column(l_cursor_name, 33, fs_report_rec.OVERHEAD_ACCOUNT);

4782: dbms_sql.define_column(l_cursor_name, 31,
4783: fs_report_rec.OUTSIDE_PROC_VARIANCE_ACCOUNT);
4784: dbms_sql.define_column(l_cursor_name, 32,
4785: fs_report_rec.STD_COST_ADJUSTMENT_ACCOUNT);
4786: dbms_sql.define_column(l_cursor_name, 33, fs_report_rec.OVERHEAD_ACCOUNT);
4787: dbms_sql.define_column(l_cursor_name, 34,
4788: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
4789: dbms_sql.define_column(l_cursor_name, 35, fs_report_rec.PROJECT_ID);
4790: dbms_sql.define_column(l_cursor_name, 36, fs_report_rec.TASK_ID);

Line 4787: dbms_sql.define_column(l_cursor_name, 34,

4783: fs_report_rec.OUTSIDE_PROC_VARIANCE_ACCOUNT);
4784: dbms_sql.define_column(l_cursor_name, 32,
4785: fs_report_rec.STD_COST_ADJUSTMENT_ACCOUNT);
4786: dbms_sql.define_column(l_cursor_name, 33, fs_report_rec.OVERHEAD_ACCOUNT);
4787: dbms_sql.define_column(l_cursor_name, 34,
4788: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
4789: dbms_sql.define_column(l_cursor_name, 35, fs_report_rec.PROJECT_ID);
4790: dbms_sql.define_column(l_cursor_name, 36, fs_report_rec.TASK_ID);
4791: dbms_sql.define_column(l_cursor_name, 37,

Line 4789: dbms_sql.define_column(l_cursor_name, 35, fs_report_rec.PROJECT_ID);

4785: fs_report_rec.STD_COST_ADJUSTMENT_ACCOUNT);
4786: dbms_sql.define_column(l_cursor_name, 33, fs_report_rec.OVERHEAD_ACCOUNT);
4787: dbms_sql.define_column(l_cursor_name, 34,
4788: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
4789: dbms_sql.define_column(l_cursor_name, 35, fs_report_rec.PROJECT_ID);
4790: dbms_sql.define_column(l_cursor_name, 36, fs_report_rec.TASK_ID);
4791: dbms_sql.define_column(l_cursor_name, 37,
4792: fs_report_rec.ATTRIBUTE_CATEGORY,30);
4793: dbms_sql.define_column(l_cursor_name, 38, fs_report_rec.ATTRIBUTE1,30);

Line 4790: dbms_sql.define_column(l_cursor_name, 36, fs_report_rec.TASK_ID);

4786: dbms_sql.define_column(l_cursor_name, 33, fs_report_rec.OVERHEAD_ACCOUNT);
4787: dbms_sql.define_column(l_cursor_name, 34,
4788: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
4789: dbms_sql.define_column(l_cursor_name, 35, fs_report_rec.PROJECT_ID);
4790: dbms_sql.define_column(l_cursor_name, 36, fs_report_rec.TASK_ID);
4791: dbms_sql.define_column(l_cursor_name, 37,
4792: fs_report_rec.ATTRIBUTE_CATEGORY,30);
4793: dbms_sql.define_column(l_cursor_name, 38, fs_report_rec.ATTRIBUTE1,30);
4794: dbms_sql.define_column(l_cursor_name, 39, fs_report_rec.ATTRIBUTE2,150);

Line 4791: dbms_sql.define_column(l_cursor_name, 37,

4787: dbms_sql.define_column(l_cursor_name, 34,
4788: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
4789: dbms_sql.define_column(l_cursor_name, 35, fs_report_rec.PROJECT_ID);
4790: dbms_sql.define_column(l_cursor_name, 36, fs_report_rec.TASK_ID);
4791: dbms_sql.define_column(l_cursor_name, 37,
4792: fs_report_rec.ATTRIBUTE_CATEGORY,30);
4793: dbms_sql.define_column(l_cursor_name, 38, fs_report_rec.ATTRIBUTE1,30);
4794: dbms_sql.define_column(l_cursor_name, 39, fs_report_rec.ATTRIBUTE2,150);
4795: dbms_sql.define_column(l_cursor_name, 40, fs_report_rec.ATTRIBUTE3,150);

Line 4793: dbms_sql.define_column(l_cursor_name, 38, fs_report_rec.ATTRIBUTE1,30);

4789: dbms_sql.define_column(l_cursor_name, 35, fs_report_rec.PROJECT_ID);
4790: dbms_sql.define_column(l_cursor_name, 36, fs_report_rec.TASK_ID);
4791: dbms_sql.define_column(l_cursor_name, 37,
4792: fs_report_rec.ATTRIBUTE_CATEGORY,30);
4793: dbms_sql.define_column(l_cursor_name, 38, fs_report_rec.ATTRIBUTE1,30);
4794: dbms_sql.define_column(l_cursor_name, 39, fs_report_rec.ATTRIBUTE2,150);
4795: dbms_sql.define_column(l_cursor_name, 40, fs_report_rec.ATTRIBUTE3,150);
4796: dbms_sql.define_column(l_cursor_name, 41, fs_report_rec.ATTRIBUTE4,150);
4797: dbms_sql.define_column(l_cursor_name, 42, fs_report_rec.ATTRIBUTE5,150);

Line 4794: dbms_sql.define_column(l_cursor_name, 39, fs_report_rec.ATTRIBUTE2,150);

4790: dbms_sql.define_column(l_cursor_name, 36, fs_report_rec.TASK_ID);
4791: dbms_sql.define_column(l_cursor_name, 37,
4792: fs_report_rec.ATTRIBUTE_CATEGORY,30);
4793: dbms_sql.define_column(l_cursor_name, 38, fs_report_rec.ATTRIBUTE1,30);
4794: dbms_sql.define_column(l_cursor_name, 39, fs_report_rec.ATTRIBUTE2,150);
4795: dbms_sql.define_column(l_cursor_name, 40, fs_report_rec.ATTRIBUTE3,150);
4796: dbms_sql.define_column(l_cursor_name, 41, fs_report_rec.ATTRIBUTE4,150);
4797: dbms_sql.define_column(l_cursor_name, 42, fs_report_rec.ATTRIBUTE5,150);
4798: dbms_sql.define_column(l_cursor_name, 43, fs_report_rec.ATTRIBUTE6,150);

Line 4795: dbms_sql.define_column(l_cursor_name, 40, fs_report_rec.ATTRIBUTE3,150);

4791: dbms_sql.define_column(l_cursor_name, 37,
4792: fs_report_rec.ATTRIBUTE_CATEGORY,30);
4793: dbms_sql.define_column(l_cursor_name, 38, fs_report_rec.ATTRIBUTE1,30);
4794: dbms_sql.define_column(l_cursor_name, 39, fs_report_rec.ATTRIBUTE2,150);
4795: dbms_sql.define_column(l_cursor_name, 40, fs_report_rec.ATTRIBUTE3,150);
4796: dbms_sql.define_column(l_cursor_name, 41, fs_report_rec.ATTRIBUTE4,150);
4797: dbms_sql.define_column(l_cursor_name, 42, fs_report_rec.ATTRIBUTE5,150);
4798: dbms_sql.define_column(l_cursor_name, 43, fs_report_rec.ATTRIBUTE6,150);
4799: dbms_sql.define_column(l_cursor_name, 44, fs_report_rec.ATTRIBUTE7,150);

Line 4796: dbms_sql.define_column(l_cursor_name, 41, fs_report_rec.ATTRIBUTE4,150);

4792: fs_report_rec.ATTRIBUTE_CATEGORY,30);
4793: dbms_sql.define_column(l_cursor_name, 38, fs_report_rec.ATTRIBUTE1,30);
4794: dbms_sql.define_column(l_cursor_name, 39, fs_report_rec.ATTRIBUTE2,150);
4795: dbms_sql.define_column(l_cursor_name, 40, fs_report_rec.ATTRIBUTE3,150);
4796: dbms_sql.define_column(l_cursor_name, 41, fs_report_rec.ATTRIBUTE4,150);
4797: dbms_sql.define_column(l_cursor_name, 42, fs_report_rec.ATTRIBUTE5,150);
4798: dbms_sql.define_column(l_cursor_name, 43, fs_report_rec.ATTRIBUTE6,150);
4799: dbms_sql.define_column(l_cursor_name, 44, fs_report_rec.ATTRIBUTE7,150);
4800: dbms_sql.define_column(l_cursor_name, 45, fs_report_rec.ATTRIBUTE8,150);

Line 4797: dbms_sql.define_column(l_cursor_name, 42, fs_report_rec.ATTRIBUTE5,150);

4793: dbms_sql.define_column(l_cursor_name, 38, fs_report_rec.ATTRIBUTE1,30);
4794: dbms_sql.define_column(l_cursor_name, 39, fs_report_rec.ATTRIBUTE2,150);
4795: dbms_sql.define_column(l_cursor_name, 40, fs_report_rec.ATTRIBUTE3,150);
4796: dbms_sql.define_column(l_cursor_name, 41, fs_report_rec.ATTRIBUTE4,150);
4797: dbms_sql.define_column(l_cursor_name, 42, fs_report_rec.ATTRIBUTE5,150);
4798: dbms_sql.define_column(l_cursor_name, 43, fs_report_rec.ATTRIBUTE6,150);
4799: dbms_sql.define_column(l_cursor_name, 44, fs_report_rec.ATTRIBUTE7,150);
4800: dbms_sql.define_column(l_cursor_name, 45, fs_report_rec.ATTRIBUTE8,150);
4801: dbms_sql.define_column(l_cursor_name, 46, fs_report_rec.ATTRIBUTE9,150);

Line 4798: dbms_sql.define_column(l_cursor_name, 43, fs_report_rec.ATTRIBUTE6,150);

4794: dbms_sql.define_column(l_cursor_name, 39, fs_report_rec.ATTRIBUTE2,150);
4795: dbms_sql.define_column(l_cursor_name, 40, fs_report_rec.ATTRIBUTE3,150);
4796: dbms_sql.define_column(l_cursor_name, 41, fs_report_rec.ATTRIBUTE4,150);
4797: dbms_sql.define_column(l_cursor_name, 42, fs_report_rec.ATTRIBUTE5,150);
4798: dbms_sql.define_column(l_cursor_name, 43, fs_report_rec.ATTRIBUTE6,150);
4799: dbms_sql.define_column(l_cursor_name, 44, fs_report_rec.ATTRIBUTE7,150);
4800: dbms_sql.define_column(l_cursor_name, 45, fs_report_rec.ATTRIBUTE8,150);
4801: dbms_sql.define_column(l_cursor_name, 46, fs_report_rec.ATTRIBUTE9,150);
4802: dbms_sql.define_column(l_cursor_name, 47, fs_report_rec.ATTRIBUTE10,150);

Line 4799: dbms_sql.define_column(l_cursor_name, 44, fs_report_rec.ATTRIBUTE7,150);

4795: dbms_sql.define_column(l_cursor_name, 40, fs_report_rec.ATTRIBUTE3,150);
4796: dbms_sql.define_column(l_cursor_name, 41, fs_report_rec.ATTRIBUTE4,150);
4797: dbms_sql.define_column(l_cursor_name, 42, fs_report_rec.ATTRIBUTE5,150);
4798: dbms_sql.define_column(l_cursor_name, 43, fs_report_rec.ATTRIBUTE6,150);
4799: dbms_sql.define_column(l_cursor_name, 44, fs_report_rec.ATTRIBUTE7,150);
4800: dbms_sql.define_column(l_cursor_name, 45, fs_report_rec.ATTRIBUTE8,150);
4801: dbms_sql.define_column(l_cursor_name, 46, fs_report_rec.ATTRIBUTE9,150);
4802: dbms_sql.define_column(l_cursor_name, 47, fs_report_rec.ATTRIBUTE10,150);
4803: dbms_sql.define_column(l_cursor_name, 48, fs_report_rec.ATTRIBUTE11,150);

Line 4800: dbms_sql.define_column(l_cursor_name, 45, fs_report_rec.ATTRIBUTE8,150);

4796: dbms_sql.define_column(l_cursor_name, 41, fs_report_rec.ATTRIBUTE4,150);
4797: dbms_sql.define_column(l_cursor_name, 42, fs_report_rec.ATTRIBUTE5,150);
4798: dbms_sql.define_column(l_cursor_name, 43, fs_report_rec.ATTRIBUTE6,150);
4799: dbms_sql.define_column(l_cursor_name, 44, fs_report_rec.ATTRIBUTE7,150);
4800: dbms_sql.define_column(l_cursor_name, 45, fs_report_rec.ATTRIBUTE8,150);
4801: dbms_sql.define_column(l_cursor_name, 46, fs_report_rec.ATTRIBUTE9,150);
4802: dbms_sql.define_column(l_cursor_name, 47, fs_report_rec.ATTRIBUTE10,150);
4803: dbms_sql.define_column(l_cursor_name, 48, fs_report_rec.ATTRIBUTE11,150);
4804: dbms_sql.define_column(l_cursor_name, 49, fs_report_rec.ATTRIBUTE12,150);

Line 4801: dbms_sql.define_column(l_cursor_name, 46, fs_report_rec.ATTRIBUTE9,150);

4797: dbms_sql.define_column(l_cursor_name, 42, fs_report_rec.ATTRIBUTE5,150);
4798: dbms_sql.define_column(l_cursor_name, 43, fs_report_rec.ATTRIBUTE6,150);
4799: dbms_sql.define_column(l_cursor_name, 44, fs_report_rec.ATTRIBUTE7,150);
4800: dbms_sql.define_column(l_cursor_name, 45, fs_report_rec.ATTRIBUTE8,150);
4801: dbms_sql.define_column(l_cursor_name, 46, fs_report_rec.ATTRIBUTE9,150);
4802: dbms_sql.define_column(l_cursor_name, 47, fs_report_rec.ATTRIBUTE10,150);
4803: dbms_sql.define_column(l_cursor_name, 48, fs_report_rec.ATTRIBUTE11,150);
4804: dbms_sql.define_column(l_cursor_name, 49, fs_report_rec.ATTRIBUTE12,150);
4805: dbms_sql.define_column(l_cursor_name, 50, fs_report_rec.ATTRIBUTE13,150);

Line 4802: dbms_sql.define_column(l_cursor_name, 47, fs_report_rec.ATTRIBUTE10,150);

4798: dbms_sql.define_column(l_cursor_name, 43, fs_report_rec.ATTRIBUTE6,150);
4799: dbms_sql.define_column(l_cursor_name, 44, fs_report_rec.ATTRIBUTE7,150);
4800: dbms_sql.define_column(l_cursor_name, 45, fs_report_rec.ATTRIBUTE8,150);
4801: dbms_sql.define_column(l_cursor_name, 46, fs_report_rec.ATTRIBUTE9,150);
4802: dbms_sql.define_column(l_cursor_name, 47, fs_report_rec.ATTRIBUTE10,150);
4803: dbms_sql.define_column(l_cursor_name, 48, fs_report_rec.ATTRIBUTE11,150);
4804: dbms_sql.define_column(l_cursor_name, 49, fs_report_rec.ATTRIBUTE12,150);
4805: dbms_sql.define_column(l_cursor_name, 50, fs_report_rec.ATTRIBUTE13,150);
4806: dbms_sql.define_column(l_cursor_name, 51, fs_report_rec.ATTRIBUTE14,150);

Line 4803: dbms_sql.define_column(l_cursor_name, 48, fs_report_rec.ATTRIBUTE11,150);

4799: dbms_sql.define_column(l_cursor_name, 44, fs_report_rec.ATTRIBUTE7,150);
4800: dbms_sql.define_column(l_cursor_name, 45, fs_report_rec.ATTRIBUTE8,150);
4801: dbms_sql.define_column(l_cursor_name, 46, fs_report_rec.ATTRIBUTE9,150);
4802: dbms_sql.define_column(l_cursor_name, 47, fs_report_rec.ATTRIBUTE10,150);
4803: dbms_sql.define_column(l_cursor_name, 48, fs_report_rec.ATTRIBUTE11,150);
4804: dbms_sql.define_column(l_cursor_name, 49, fs_report_rec.ATTRIBUTE12,150);
4805: dbms_sql.define_column(l_cursor_name, 50, fs_report_rec.ATTRIBUTE13,150);
4806: dbms_sql.define_column(l_cursor_name, 51, fs_report_rec.ATTRIBUTE14,150);
4807: dbms_sql.define_column(l_cursor_name, 52, fs_report_rec.ATTRIBUTE15,150);

Line 4804: dbms_sql.define_column(l_cursor_name, 49, fs_report_rec.ATTRIBUTE12,150);

4800: dbms_sql.define_column(l_cursor_name, 45, fs_report_rec.ATTRIBUTE8,150);
4801: dbms_sql.define_column(l_cursor_name, 46, fs_report_rec.ATTRIBUTE9,150);
4802: dbms_sql.define_column(l_cursor_name, 47, fs_report_rec.ATTRIBUTE10,150);
4803: dbms_sql.define_column(l_cursor_name, 48, fs_report_rec.ATTRIBUTE11,150);
4804: dbms_sql.define_column(l_cursor_name, 49, fs_report_rec.ATTRIBUTE12,150);
4805: dbms_sql.define_column(l_cursor_name, 50, fs_report_rec.ATTRIBUTE13,150);
4806: dbms_sql.define_column(l_cursor_name, 51, fs_report_rec.ATTRIBUTE14,150);
4807: dbms_sql.define_column(l_cursor_name, 52, fs_report_rec.ATTRIBUTE15,150);
4808: dbms_sql.define_column(l_cursor_name, 53, fs_report_rec.KANBAN_CARD_ID);

Line 4805: dbms_sql.define_column(l_cursor_name, 50, fs_report_rec.ATTRIBUTE13,150);

4801: dbms_sql.define_column(l_cursor_name, 46, fs_report_rec.ATTRIBUTE9,150);
4802: dbms_sql.define_column(l_cursor_name, 47, fs_report_rec.ATTRIBUTE10,150);
4803: dbms_sql.define_column(l_cursor_name, 48, fs_report_rec.ATTRIBUTE11,150);
4804: dbms_sql.define_column(l_cursor_name, 49, fs_report_rec.ATTRIBUTE12,150);
4805: dbms_sql.define_column(l_cursor_name, 50, fs_report_rec.ATTRIBUTE13,150);
4806: dbms_sql.define_column(l_cursor_name, 51, fs_report_rec.ATTRIBUTE14,150);
4807: dbms_sql.define_column(l_cursor_name, 52, fs_report_rec.ATTRIBUTE15,150);
4808: dbms_sql.define_column(l_cursor_name, 53, fs_report_rec.KANBAN_CARD_ID);
4809: dbms_sql.define_column(l_cursor_name, 54, fs_report_rec.END_ITEM_UNIT_NUMBER,30);

Line 4806: dbms_sql.define_column(l_cursor_name, 51, fs_report_rec.ATTRIBUTE14,150);

4802: dbms_sql.define_column(l_cursor_name, 47, fs_report_rec.ATTRIBUTE10,150);
4803: dbms_sql.define_column(l_cursor_name, 48, fs_report_rec.ATTRIBUTE11,150);
4804: dbms_sql.define_column(l_cursor_name, 49, fs_report_rec.ATTRIBUTE12,150);
4805: dbms_sql.define_column(l_cursor_name, 50, fs_report_rec.ATTRIBUTE13,150);
4806: dbms_sql.define_column(l_cursor_name, 51, fs_report_rec.ATTRIBUTE14,150);
4807: dbms_sql.define_column(l_cursor_name, 52, fs_report_rec.ATTRIBUTE15,150);
4808: dbms_sql.define_column(l_cursor_name, 53, fs_report_rec.KANBAN_CARD_ID);
4809: dbms_sql.define_column(l_cursor_name, 54, fs_report_rec.END_ITEM_UNIT_NUMBER,30);
4810: dbms_sql.define_column(l_cursor_name, 55, fs_report_rec.CURRENT_LINE_OPERATION);

Line 4807: dbms_sql.define_column(l_cursor_name, 52, fs_report_rec.ATTRIBUTE15,150);

4803: dbms_sql.define_column(l_cursor_name, 48, fs_report_rec.ATTRIBUTE11,150);
4804: dbms_sql.define_column(l_cursor_name, 49, fs_report_rec.ATTRIBUTE12,150);
4805: dbms_sql.define_column(l_cursor_name, 50, fs_report_rec.ATTRIBUTE13,150);
4806: dbms_sql.define_column(l_cursor_name, 51, fs_report_rec.ATTRIBUTE14,150);
4807: dbms_sql.define_column(l_cursor_name, 52, fs_report_rec.ATTRIBUTE15,150);
4808: dbms_sql.define_column(l_cursor_name, 53, fs_report_rec.KANBAN_CARD_ID);
4809: dbms_sql.define_column(l_cursor_name, 54, fs_report_rec.END_ITEM_UNIT_NUMBER,30);
4810: dbms_sql.define_column(l_cursor_name, 55, fs_report_rec.CURRENT_LINE_OPERATION);
4811: dbms_sql.define_column(l_cursor_name, 56, fs_report_rec.WIP_ENTITY_ID);

Line 4808: dbms_sql.define_column(l_cursor_name, 53, fs_report_rec.KANBAN_CARD_ID);

4804: dbms_sql.define_column(l_cursor_name, 49, fs_report_rec.ATTRIBUTE12,150);
4805: dbms_sql.define_column(l_cursor_name, 50, fs_report_rec.ATTRIBUTE13,150);
4806: dbms_sql.define_column(l_cursor_name, 51, fs_report_rec.ATTRIBUTE14,150);
4807: dbms_sql.define_column(l_cursor_name, 52, fs_report_rec.ATTRIBUTE15,150);
4808: dbms_sql.define_column(l_cursor_name, 53, fs_report_rec.KANBAN_CARD_ID);
4809: dbms_sql.define_column(l_cursor_name, 54, fs_report_rec.END_ITEM_UNIT_NUMBER,30);
4810: dbms_sql.define_column(l_cursor_name, 55, fs_report_rec.CURRENT_LINE_OPERATION);
4811: dbms_sql.define_column(l_cursor_name, 56, fs_report_rec.WIP_ENTITY_ID);
4812: -- execute will return zero rows processed since this is just a select

Line 4809: dbms_sql.define_column(l_cursor_name, 54, fs_report_rec.END_ITEM_UNIT_NUMBER,30);

4805: dbms_sql.define_column(l_cursor_name, 50, fs_report_rec.ATTRIBUTE13,150);
4806: dbms_sql.define_column(l_cursor_name, 51, fs_report_rec.ATTRIBUTE14,150);
4807: dbms_sql.define_column(l_cursor_name, 52, fs_report_rec.ATTRIBUTE15,150);
4808: dbms_sql.define_column(l_cursor_name, 53, fs_report_rec.KANBAN_CARD_ID);
4809: dbms_sql.define_column(l_cursor_name, 54, fs_report_rec.END_ITEM_UNIT_NUMBER,30);
4810: dbms_sql.define_column(l_cursor_name, 55, fs_report_rec.CURRENT_LINE_OPERATION);
4811: dbms_sql.define_column(l_cursor_name, 56, fs_report_rec.WIP_ENTITY_ID);
4812: -- execute will return zero rows processed since this is just a select
4813: -- statement. Need a variable for the return value.

Line 4810: dbms_sql.define_column(l_cursor_name, 55, fs_report_rec.CURRENT_LINE_OPERATION);

4806: dbms_sql.define_column(l_cursor_name, 51, fs_report_rec.ATTRIBUTE14,150);
4807: dbms_sql.define_column(l_cursor_name, 52, fs_report_rec.ATTRIBUTE15,150);
4808: dbms_sql.define_column(l_cursor_name, 53, fs_report_rec.KANBAN_CARD_ID);
4809: dbms_sql.define_column(l_cursor_name, 54, fs_report_rec.END_ITEM_UNIT_NUMBER,30);
4810: dbms_sql.define_column(l_cursor_name, 55, fs_report_rec.CURRENT_LINE_OPERATION);
4811: dbms_sql.define_column(l_cursor_name, 56, fs_report_rec.WIP_ENTITY_ID);
4812: -- execute will return zero rows processed since this is just a select
4813: -- statement. Need a variable for the return value.
4814: l_rows_processed := dbms_sql.execute(l_cursor_name);

Line 4811: dbms_sql.define_column(l_cursor_name, 56, fs_report_rec.WIP_ENTITY_ID);

4807: dbms_sql.define_column(l_cursor_name, 52, fs_report_rec.ATTRIBUTE15,150);
4808: dbms_sql.define_column(l_cursor_name, 53, fs_report_rec.KANBAN_CARD_ID);
4809: dbms_sql.define_column(l_cursor_name, 54, fs_report_rec.END_ITEM_UNIT_NUMBER,30);
4810: dbms_sql.define_column(l_cursor_name, 55, fs_report_rec.CURRENT_LINE_OPERATION);
4811: dbms_sql.define_column(l_cursor_name, 56, fs_report_rec.WIP_ENTITY_ID);
4812: -- execute will return zero rows processed since this is just a select
4813: -- statement. Need a variable for the return value.
4814: l_rows_processed := dbms_sql.execute(l_cursor_name);
4815:

Line 4814: l_rows_processed := dbms_sql.execute(l_cursor_name);

4810: dbms_sql.define_column(l_cursor_name, 55, fs_report_rec.CURRENT_LINE_OPERATION);
4811: dbms_sql.define_column(l_cursor_name, 56, fs_report_rec.WIP_ENTITY_ID);
4812: -- execute will return zero rows processed since this is just a select
4813: -- statement. Need a variable for the return value.
4814: l_rows_processed := dbms_sql.execute(l_cursor_name);
4815:
4816: -- return cursor name
4817: return(l_cursor_name);
4818:

Line 5059: l_cursor_name := dbms_sql.open_cursor;

5055: flm_util.add_bind(':from_end_date', p_from_end_date+1-1/(24*60*60));
5056: --end of fix bug#3170105x
5057:
5058: -- get the cursor
5059: l_cursor_name := dbms_sql.open_cursor;
5060:
5061: -- parse the sql statement
5062: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
5063: flm_util.do_binds(l_cursor_name);

Line 5062: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);

5058: -- get the cursor
5059: l_cursor_name := dbms_sql.open_cursor;
5060:
5061: -- parse the sql statement
5062: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
5063: flm_util.do_binds(l_cursor_name);
5064:
5065: -- define columns
5066: dbms_sql.define_column(l_cursor_name, 1, l_wip_entity_id);

Line 5066: dbms_sql.define_column(l_cursor_name, 1, l_wip_entity_id);

5062: dbms_sql.parse(l_cursor_name, l_sql_stmt, dbms_sql.native);
5063: flm_util.do_binds(l_cursor_name);
5064:
5065: -- define columns
5066: dbms_sql.define_column(l_cursor_name, 1, l_wip_entity_id);
5067:
5068:
5069: -- execute the sql statement
5070: -- execute will return zero rows processed since this is just a select

Line 5072: l_rows_processed := dbms_sql.execute(l_cursor_name);

5068:
5069: -- execute the sql statement
5070: -- execute will return zero rows processed since this is just a select
5071: -- statement. Need a variable for the return value.
5072: l_rows_processed := dbms_sql.execute(l_cursor_name);
5073:
5074: -- return cursor name
5075: return(l_cursor_name);
5076:

Line 6184: l_rows := dbms_sql.fetch_rows(l_cursor);

6180: RAISE unexpected_error;
6181: END IF;
6182:
6183: LOOP
6184: l_rows := dbms_sql.fetch_rows(l_cursor);
6185: IF l_rows = 0 THEN
6186: EXIT;
6187: END IF;
6188: IF l_rows > 0 THEN

Line 6189: dbms_sql.column_value(l_cursor, 1, l_wip_entity_id2);

6185: IF l_rows = 0 THEN
6186: EXIT;
6187: END IF;
6188: IF l_rows > 0 THEN
6189: dbms_sql.column_value(l_cursor, 1, l_wip_entity_id2);
6190: END IF;
6191: Relieve_Rolled_Schedules(l_wip_entity_id2);
6192: END LOOP;
6193: END IF;

Line 6209: l_rows := dbms_sql.fetch_rows(l_cursor);

6205: RAISE unexpected_error;
6206: END IF;
6207:
6208: LOOP
6209: l_rows := dbms_sql.fetch_rows(l_cursor);
6210: IF l_rows = 0 THEN
6211: EXIT;
6212: END IF;
6213: IF l_rows > 0 THEN

Line 6214: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);

6210: IF l_rows = 0 THEN
6211: EXIT;
6212: END IF;
6213: IF l_rows > 0 THEN
6214: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6215: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6216: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6217: dbms_sql.column_value(l_cursor, 4, fs_report_rec.item);
6218: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_group_id);

Line 6215: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);

6211: EXIT;
6212: END IF;
6213: IF l_rows > 0 THEN
6214: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6215: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6216: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6217: dbms_sql.column_value(l_cursor, 4, fs_report_rec.item);
6218: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_group_id);
6219: dbms_sql.column_value(l_cursor, 6, fs_report_rec.planned_quantity);

Line 6216: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);

6212: END IF;
6213: IF l_rows > 0 THEN
6214: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6215: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6216: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6217: dbms_sql.column_value(l_cursor, 4, fs_report_rec.item);
6218: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_group_id);
6219: dbms_sql.column_value(l_cursor, 6, fs_report_rec.planned_quantity);
6220: dbms_sql.column_value(l_cursor, 7, fs_report_rec.quantity_completed);

Line 6217: dbms_sql.column_value(l_cursor, 4, fs_report_rec.item);

6213: IF l_rows > 0 THEN
6214: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6215: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6216: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6217: dbms_sql.column_value(l_cursor, 4, fs_report_rec.item);
6218: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_group_id);
6219: dbms_sql.column_value(l_cursor, 6, fs_report_rec.planned_quantity);
6220: dbms_sql.column_value(l_cursor, 7, fs_report_rec.quantity_completed);
6221: END IF;

Line 6218: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_group_id);

6214: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6215: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6216: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6217: dbms_sql.column_value(l_cursor, 4, fs_report_rec.item);
6218: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_group_id);
6219: dbms_sql.column_value(l_cursor, 6, fs_report_rec.planned_quantity);
6220: dbms_sql.column_value(l_cursor, 7, fs_report_rec.quantity_completed);
6221: END IF;
6222:

Line 6219: dbms_sql.column_value(l_cursor, 6, fs_report_rec.planned_quantity);

6215: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6216: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6217: dbms_sql.column_value(l_cursor, 4, fs_report_rec.item);
6218: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_group_id);
6219: dbms_sql.column_value(l_cursor, 6, fs_report_rec.planned_quantity);
6220: dbms_sql.column_value(l_cursor, 7, fs_report_rec.quantity_completed);
6221: END IF;
6222:
6223: -- If there is a variance, then process record

Line 6220: dbms_sql.column_value(l_cursor, 7, fs_report_rec.quantity_completed);

6216: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6217: dbms_sql.column_value(l_cursor, 4, fs_report_rec.item);
6218: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_group_id);
6219: dbms_sql.column_value(l_cursor, 6, fs_report_rec.planned_quantity);
6220: dbms_sql.column_value(l_cursor, 7, fs_report_rec.quantity_completed);
6221: END IF;
6222:
6223: -- If there is a variance, then process record
6224: IF (fs_report_rec.planned_quantity

Line 6603: l_rows := dbms_sql.fetch_rows(l_cursor);

6599: RAISE unexpected_error;
6600: END IF;
6601:
6602: LOOP
6603: l_rows := dbms_sql.fetch_rows(l_cursor);
6604: IF l_rows > 0 THEN
6605: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6606: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6607: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);

Line 6605: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);

6601:
6602: LOOP
6603: l_rows := dbms_sql.fetch_rows(l_cursor);
6604: IF l_rows > 0 THEN
6605: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6606: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6607: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6608: dbms_sql.column_value(l_cursor, 4, fs_report_rec.schedule_group_id);
6609: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_number);

Line 6606: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);

6602: LOOP
6603: l_rows := dbms_sql.fetch_rows(l_cursor);
6604: IF l_rows > 0 THEN
6605: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6606: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6607: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6608: dbms_sql.column_value(l_cursor, 4, fs_report_rec.schedule_group_id);
6609: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_number);
6610: dbms_sql.column_value(l_cursor, 6, fs_report_rec.build_sequence);

Line 6607: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);

6603: l_rows := dbms_sql.fetch_rows(l_cursor);
6604: IF l_rows > 0 THEN
6605: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6606: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6607: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6608: dbms_sql.column_value(l_cursor, 4, fs_report_rec.schedule_group_id);
6609: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_number);
6610: dbms_sql.column_value(l_cursor, 6, fs_report_rec.build_sequence);
6611: dbms_sql.column_value(l_cursor, 7, fs_report_rec.

Line 6608: dbms_sql.column_value(l_cursor, 4, fs_report_rec.schedule_group_id);

6604: IF l_rows > 0 THEN
6605: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6606: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6607: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6608: dbms_sql.column_value(l_cursor, 4, fs_report_rec.schedule_group_id);
6609: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_number);
6610: dbms_sql.column_value(l_cursor, 6, fs_report_rec.build_sequence);
6611: dbms_sql.column_value(l_cursor, 7, fs_report_rec.
6612: demand_source_header_id);

Line 6609: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_number);

6605: dbms_sql.column_value(l_cursor, 1, fs_report_rec.line_id);
6606: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6607: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6608: dbms_sql.column_value(l_cursor, 4, fs_report_rec.schedule_group_id);
6609: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_number);
6610: dbms_sql.column_value(l_cursor, 6, fs_report_rec.build_sequence);
6611: dbms_sql.column_value(l_cursor, 7, fs_report_rec.
6612: demand_source_header_id);
6613: dbms_sql.column_value(l_cursor, 8, fs_report_rec.demand_source_line);

Line 6610: dbms_sql.column_value(l_cursor, 6, fs_report_rec.build_sequence);

6606: dbms_sql.column_value(l_cursor, 2, fs_report_rec.line_code);
6607: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6608: dbms_sql.column_value(l_cursor, 4, fs_report_rec.schedule_group_id);
6609: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_number);
6610: dbms_sql.column_value(l_cursor, 6, fs_report_rec.build_sequence);
6611: dbms_sql.column_value(l_cursor, 7, fs_report_rec.
6612: demand_source_header_id);
6613: dbms_sql.column_value(l_cursor, 8, fs_report_rec.demand_source_line);
6614: dbms_sql.column_value(l_cursor, 9, fs_report_rec.

Line 6611: dbms_sql.column_value(l_cursor, 7, fs_report_rec.

6607: dbms_sql.column_value(l_cursor, 3, fs_report_rec.primary_item_id);
6608: dbms_sql.column_value(l_cursor, 4, fs_report_rec.schedule_group_id);
6609: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_number);
6610: dbms_sql.column_value(l_cursor, 6, fs_report_rec.build_sequence);
6611: dbms_sql.column_value(l_cursor, 7, fs_report_rec.
6612: demand_source_header_id);
6613: dbms_sql.column_value(l_cursor, 8, fs_report_rec.demand_source_line);
6614: dbms_sql.column_value(l_cursor, 9, fs_report_rec.
6615: demand_source_delivery);

Line 6613: dbms_sql.column_value(l_cursor, 8, fs_report_rec.demand_source_line);

6609: dbms_sql.column_value(l_cursor, 5, fs_report_rec.schedule_number);
6610: dbms_sql.column_value(l_cursor, 6, fs_report_rec.build_sequence);
6611: dbms_sql.column_value(l_cursor, 7, fs_report_rec.
6612: demand_source_header_id);
6613: dbms_sql.column_value(l_cursor, 8, fs_report_rec.demand_source_line);
6614: dbms_sql.column_value(l_cursor, 9, fs_report_rec.
6615: demand_source_delivery);
6616: dbms_sql.column_value(l_cursor, 10, fs_report_rec.demand_source_type);
6617: dbms_sql.column_value(l_cursor, 11, fs_report_rec.demand_class);

Line 6614: dbms_sql.column_value(l_cursor, 9, fs_report_rec.

6610: dbms_sql.column_value(l_cursor, 6, fs_report_rec.build_sequence);
6611: dbms_sql.column_value(l_cursor, 7, fs_report_rec.
6612: demand_source_header_id);
6613: dbms_sql.column_value(l_cursor, 8, fs_report_rec.demand_source_line);
6614: dbms_sql.column_value(l_cursor, 9, fs_report_rec.
6615: demand_source_delivery);
6616: dbms_sql.column_value(l_cursor, 10, fs_report_rec.demand_source_type);
6617: dbms_sql.column_value(l_cursor, 11, fs_report_rec.demand_class);
6618: dbms_sql.column_value(l_cursor, 12, fs_report_rec.item);

Line 6616: dbms_sql.column_value(l_cursor, 10, fs_report_rec.demand_source_type);

6612: demand_source_header_id);
6613: dbms_sql.column_value(l_cursor, 8, fs_report_rec.demand_source_line);
6614: dbms_sql.column_value(l_cursor, 9, fs_report_rec.
6615: demand_source_delivery);
6616: dbms_sql.column_value(l_cursor, 10, fs_report_rec.demand_source_type);
6617: dbms_sql.column_value(l_cursor, 11, fs_report_rec.demand_class);
6618: dbms_sql.column_value(l_cursor, 12, fs_report_rec.item);
6619: dbms_sql.column_value(l_cursor, 13, fs_report_rec.planned_quantity);
6620: dbms_sql.column_value(l_cursor, 14, fs_report_rec.quantity_completed);

Line 6617: dbms_sql.column_value(l_cursor, 11, fs_report_rec.demand_class);

6613: dbms_sql.column_value(l_cursor, 8, fs_report_rec.demand_source_line);
6614: dbms_sql.column_value(l_cursor, 9, fs_report_rec.
6615: demand_source_delivery);
6616: dbms_sql.column_value(l_cursor, 10, fs_report_rec.demand_source_type);
6617: dbms_sql.column_value(l_cursor, 11, fs_report_rec.demand_class);
6618: dbms_sql.column_value(l_cursor, 12, fs_report_rec.item);
6619: dbms_sql.column_value(l_cursor, 13, fs_report_rec.planned_quantity);
6620: dbms_sql.column_value(l_cursor, 14, fs_report_rec.quantity_completed);
6621:

Line 6618: dbms_sql.column_value(l_cursor, 12, fs_report_rec.item);

6614: dbms_sql.column_value(l_cursor, 9, fs_report_rec.
6615: demand_source_delivery);
6616: dbms_sql.column_value(l_cursor, 10, fs_report_rec.demand_source_type);
6617: dbms_sql.column_value(l_cursor, 11, fs_report_rec.demand_class);
6618: dbms_sql.column_value(l_cursor, 12, fs_report_rec.item);
6619: dbms_sql.column_value(l_cursor, 13, fs_report_rec.planned_quantity);
6620: dbms_sql.column_value(l_cursor, 14, fs_report_rec.quantity_completed);
6621:
6622: dbms_sql.column_value(l_cursor, 15, fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);

Line 6619: dbms_sql.column_value(l_cursor, 13, fs_report_rec.planned_quantity);

6615: demand_source_delivery);
6616: dbms_sql.column_value(l_cursor, 10, fs_report_rec.demand_source_type);
6617: dbms_sql.column_value(l_cursor, 11, fs_report_rec.demand_class);
6618: dbms_sql.column_value(l_cursor, 12, fs_report_rec.item);
6619: dbms_sql.column_value(l_cursor, 13, fs_report_rec.planned_quantity);
6620: dbms_sql.column_value(l_cursor, 14, fs_report_rec.quantity_completed);
6621:
6622: dbms_sql.column_value(l_cursor, 15, fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
6623: dbms_sql.column_value(l_cursor, 16, fs_report_rec.MPS_NET_QUANTITY);

Line 6620: dbms_sql.column_value(l_cursor, 14, fs_report_rec.quantity_completed);

6616: dbms_sql.column_value(l_cursor, 10, fs_report_rec.demand_source_type);
6617: dbms_sql.column_value(l_cursor, 11, fs_report_rec.demand_class);
6618: dbms_sql.column_value(l_cursor, 12, fs_report_rec.item);
6619: dbms_sql.column_value(l_cursor, 13, fs_report_rec.planned_quantity);
6620: dbms_sql.column_value(l_cursor, 14, fs_report_rec.quantity_completed);
6621:
6622: dbms_sql.column_value(l_cursor, 15, fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
6623: dbms_sql.column_value(l_cursor, 16, fs_report_rec.MPS_NET_QUANTITY);
6624: dbms_sql.column_value(l_cursor, 17, fs_report_rec.BOM_REVISION);

Line 6622: dbms_sql.column_value(l_cursor, 15, fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);

6618: dbms_sql.column_value(l_cursor, 12, fs_report_rec.item);
6619: dbms_sql.column_value(l_cursor, 13, fs_report_rec.planned_quantity);
6620: dbms_sql.column_value(l_cursor, 14, fs_report_rec.quantity_completed);
6621:
6622: dbms_sql.column_value(l_cursor, 15, fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
6623: dbms_sql.column_value(l_cursor, 16, fs_report_rec.MPS_NET_QUANTITY);
6624: dbms_sql.column_value(l_cursor, 17, fs_report_rec.BOM_REVISION);
6625: dbms_sql.column_value(l_cursor, 18, fs_report_rec.ROUTING_REVISION);
6626: dbms_sql.column_value(l_cursor, 19, fs_report_rec.BOM_REVISION_DATE);

Line 6623: dbms_sql.column_value(l_cursor, 16, fs_report_rec.MPS_NET_QUANTITY);

6619: dbms_sql.column_value(l_cursor, 13, fs_report_rec.planned_quantity);
6620: dbms_sql.column_value(l_cursor, 14, fs_report_rec.quantity_completed);
6621:
6622: dbms_sql.column_value(l_cursor, 15, fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
6623: dbms_sql.column_value(l_cursor, 16, fs_report_rec.MPS_NET_QUANTITY);
6624: dbms_sql.column_value(l_cursor, 17, fs_report_rec.BOM_REVISION);
6625: dbms_sql.column_value(l_cursor, 18, fs_report_rec.ROUTING_REVISION);
6626: dbms_sql.column_value(l_cursor, 19, fs_report_rec.BOM_REVISION_DATE);
6627: dbms_sql.column_value(l_cursor, 20,

Line 6624: dbms_sql.column_value(l_cursor, 17, fs_report_rec.BOM_REVISION);

6620: dbms_sql.column_value(l_cursor, 14, fs_report_rec.quantity_completed);
6621:
6622: dbms_sql.column_value(l_cursor, 15, fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
6623: dbms_sql.column_value(l_cursor, 16, fs_report_rec.MPS_NET_QUANTITY);
6624: dbms_sql.column_value(l_cursor, 17, fs_report_rec.BOM_REVISION);
6625: dbms_sql.column_value(l_cursor, 18, fs_report_rec.ROUTING_REVISION);
6626: dbms_sql.column_value(l_cursor, 19, fs_report_rec.BOM_REVISION_DATE);
6627: dbms_sql.column_value(l_cursor, 20,
6628: fs_report_rec.ROUTING_REVISION_DATE);

Line 6625: dbms_sql.column_value(l_cursor, 18, fs_report_rec.ROUTING_REVISION);

6621:
6622: dbms_sql.column_value(l_cursor, 15, fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
6623: dbms_sql.column_value(l_cursor, 16, fs_report_rec.MPS_NET_QUANTITY);
6624: dbms_sql.column_value(l_cursor, 17, fs_report_rec.BOM_REVISION);
6625: dbms_sql.column_value(l_cursor, 18, fs_report_rec.ROUTING_REVISION);
6626: dbms_sql.column_value(l_cursor, 19, fs_report_rec.BOM_REVISION_DATE);
6627: dbms_sql.column_value(l_cursor, 20,
6628: fs_report_rec.ROUTING_REVISION_DATE);
6629: dbms_sql.column_value(l_cursor, 21,

Line 6626: dbms_sql.column_value(l_cursor, 19, fs_report_rec.BOM_REVISION_DATE);

6622: dbms_sql.column_value(l_cursor, 15, fs_report_rec.MPS_SCHEDULED_COMPLETION_DATE);
6623: dbms_sql.column_value(l_cursor, 16, fs_report_rec.MPS_NET_QUANTITY);
6624: dbms_sql.column_value(l_cursor, 17, fs_report_rec.BOM_REVISION);
6625: dbms_sql.column_value(l_cursor, 18, fs_report_rec.ROUTING_REVISION);
6626: dbms_sql.column_value(l_cursor, 19, fs_report_rec.BOM_REVISION_DATE);
6627: dbms_sql.column_value(l_cursor, 20,
6628: fs_report_rec.ROUTING_REVISION_DATE);
6629: dbms_sql.column_value(l_cursor, 21,
6630: fs_report_rec.ALTERNATE_BOM_DESIGNATOR);

Line 6627: dbms_sql.column_value(l_cursor, 20,

6623: dbms_sql.column_value(l_cursor, 16, fs_report_rec.MPS_NET_QUANTITY);
6624: dbms_sql.column_value(l_cursor, 17, fs_report_rec.BOM_REVISION);
6625: dbms_sql.column_value(l_cursor, 18, fs_report_rec.ROUTING_REVISION);
6626: dbms_sql.column_value(l_cursor, 19, fs_report_rec.BOM_REVISION_DATE);
6627: dbms_sql.column_value(l_cursor, 20,
6628: fs_report_rec.ROUTING_REVISION_DATE);
6629: dbms_sql.column_value(l_cursor, 21,
6630: fs_report_rec.ALTERNATE_BOM_DESIGNATOR);
6631: dbms_sql.column_value(l_cursor, 22,

Line 6629: dbms_sql.column_value(l_cursor, 21,

6625: dbms_sql.column_value(l_cursor, 18, fs_report_rec.ROUTING_REVISION);
6626: dbms_sql.column_value(l_cursor, 19, fs_report_rec.BOM_REVISION_DATE);
6627: dbms_sql.column_value(l_cursor, 20,
6628: fs_report_rec.ROUTING_REVISION_DATE);
6629: dbms_sql.column_value(l_cursor, 21,
6630: fs_report_rec.ALTERNATE_BOM_DESIGNATOR);
6631: dbms_sql.column_value(l_cursor, 22,
6632: fs_report_rec.ALTERNATE_ROUTING_DESIGNATOR);
6633: dbms_sql.column_value(l_cursor, 23,

Line 6631: dbms_sql.column_value(l_cursor, 22,

6627: dbms_sql.column_value(l_cursor, 20,
6628: fs_report_rec.ROUTING_REVISION_DATE);
6629: dbms_sql.column_value(l_cursor, 21,
6630: fs_report_rec.ALTERNATE_BOM_DESIGNATOR);
6631: dbms_sql.column_value(l_cursor, 22,
6632: fs_report_rec.ALTERNATE_ROUTING_DESIGNATOR);
6633: dbms_sql.column_value(l_cursor, 23,
6634: fs_report_rec.COMPLETION_SUBINVENTORY);
6635: dbms_sql.column_value(l_cursor, 24,

Line 6633: dbms_sql.column_value(l_cursor, 23,

6629: dbms_sql.column_value(l_cursor, 21,
6630: fs_report_rec.ALTERNATE_BOM_DESIGNATOR);
6631: dbms_sql.column_value(l_cursor, 22,
6632: fs_report_rec.ALTERNATE_ROUTING_DESIGNATOR);
6633: dbms_sql.column_value(l_cursor, 23,
6634: fs_report_rec.COMPLETION_SUBINVENTORY);
6635: dbms_sql.column_value(l_cursor, 24,
6636: fs_report_rec.COMPLETION_LOCATOR_ID);
6637: dbms_sql.column_value(l_cursor, 25, fs_report_rec.MATERIAL_ACCOUNT);

Line 6635: dbms_sql.column_value(l_cursor, 24,

6631: dbms_sql.column_value(l_cursor, 22,
6632: fs_report_rec.ALTERNATE_ROUTING_DESIGNATOR);
6633: dbms_sql.column_value(l_cursor, 23,
6634: fs_report_rec.COMPLETION_SUBINVENTORY);
6635: dbms_sql.column_value(l_cursor, 24,
6636: fs_report_rec.COMPLETION_LOCATOR_ID);
6637: dbms_sql.column_value(l_cursor, 25, fs_report_rec.MATERIAL_ACCOUNT);
6638: dbms_sql.column_value(l_cursor, 26,
6639: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);

Line 6637: dbms_sql.column_value(l_cursor, 25, fs_report_rec.MATERIAL_ACCOUNT);

6633: dbms_sql.column_value(l_cursor, 23,
6634: fs_report_rec.COMPLETION_SUBINVENTORY);
6635: dbms_sql.column_value(l_cursor, 24,
6636: fs_report_rec.COMPLETION_LOCATOR_ID);
6637: dbms_sql.column_value(l_cursor, 25, fs_report_rec.MATERIAL_ACCOUNT);
6638: dbms_sql.column_value(l_cursor, 26,
6639: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);
6640: dbms_sql.column_value(l_cursor, 27, fs_report_rec.RESOURCE_ACCOUNT);
6641: dbms_sql.column_value(l_cursor, 28,

Line 6638: dbms_sql.column_value(l_cursor, 26,

6634: fs_report_rec.COMPLETION_SUBINVENTORY);
6635: dbms_sql.column_value(l_cursor, 24,
6636: fs_report_rec.COMPLETION_LOCATOR_ID);
6637: dbms_sql.column_value(l_cursor, 25, fs_report_rec.MATERIAL_ACCOUNT);
6638: dbms_sql.column_value(l_cursor, 26,
6639: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);
6640: dbms_sql.column_value(l_cursor, 27, fs_report_rec.RESOURCE_ACCOUNT);
6641: dbms_sql.column_value(l_cursor, 28,
6642: fs_report_rec.OUTSIDE_PROCESSING_ACCOUNT);

Line 6640: dbms_sql.column_value(l_cursor, 27, fs_report_rec.RESOURCE_ACCOUNT);

6636: fs_report_rec.COMPLETION_LOCATOR_ID);
6637: dbms_sql.column_value(l_cursor, 25, fs_report_rec.MATERIAL_ACCOUNT);
6638: dbms_sql.column_value(l_cursor, 26,
6639: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);
6640: dbms_sql.column_value(l_cursor, 27, fs_report_rec.RESOURCE_ACCOUNT);
6641: dbms_sql.column_value(l_cursor, 28,
6642: fs_report_rec.OUTSIDE_PROCESSING_ACCOUNT);
6643: dbms_sql.column_value(l_cursor, 29,
6644: fs_report_rec.MATERIAL_VARIANCE_ACCOUNT);

Line 6641: dbms_sql.column_value(l_cursor, 28,

6637: dbms_sql.column_value(l_cursor, 25, fs_report_rec.MATERIAL_ACCOUNT);
6638: dbms_sql.column_value(l_cursor, 26,
6639: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);
6640: dbms_sql.column_value(l_cursor, 27, fs_report_rec.RESOURCE_ACCOUNT);
6641: dbms_sql.column_value(l_cursor, 28,
6642: fs_report_rec.OUTSIDE_PROCESSING_ACCOUNT);
6643: dbms_sql.column_value(l_cursor, 29,
6644: fs_report_rec.MATERIAL_VARIANCE_ACCOUNT);
6645: dbms_sql.column_value(l_cursor, 30,

Line 6643: dbms_sql.column_value(l_cursor, 29,

6639: fs_report_rec.MATERIAL_OVERHEAD_ACCOUNT);
6640: dbms_sql.column_value(l_cursor, 27, fs_report_rec.RESOURCE_ACCOUNT);
6641: dbms_sql.column_value(l_cursor, 28,
6642: fs_report_rec.OUTSIDE_PROCESSING_ACCOUNT);
6643: dbms_sql.column_value(l_cursor, 29,
6644: fs_report_rec.MATERIAL_VARIANCE_ACCOUNT);
6645: dbms_sql.column_value(l_cursor, 30,
6646: fs_report_rec.RESOURCE_VARIANCE_ACCOUNT);
6647: dbms_sql.column_value(l_cursor, 31,

Line 6645: dbms_sql.column_value(l_cursor, 30,

6641: dbms_sql.column_value(l_cursor, 28,
6642: fs_report_rec.OUTSIDE_PROCESSING_ACCOUNT);
6643: dbms_sql.column_value(l_cursor, 29,
6644: fs_report_rec.MATERIAL_VARIANCE_ACCOUNT);
6645: dbms_sql.column_value(l_cursor, 30,
6646: fs_report_rec.RESOURCE_VARIANCE_ACCOUNT);
6647: dbms_sql.column_value(l_cursor, 31,
6648: fs_report_rec.OUTSIDE_PROC_VARIANCE_ACCOUNT);
6649: dbms_sql.column_value(l_cursor, 32,

Line 6647: dbms_sql.column_value(l_cursor, 31,

6643: dbms_sql.column_value(l_cursor, 29,
6644: fs_report_rec.MATERIAL_VARIANCE_ACCOUNT);
6645: dbms_sql.column_value(l_cursor, 30,
6646: fs_report_rec.RESOURCE_VARIANCE_ACCOUNT);
6647: dbms_sql.column_value(l_cursor, 31,
6648: fs_report_rec.OUTSIDE_PROC_VARIANCE_ACCOUNT);
6649: dbms_sql.column_value(l_cursor, 32,
6650: fs_report_rec.STD_COST_ADJUSTMENT_ACCOUNT);
6651: dbms_sql.column_value(l_cursor, 33, fs_report_rec.OVERHEAD_ACCOUNT);

Line 6649: dbms_sql.column_value(l_cursor, 32,

6645: dbms_sql.column_value(l_cursor, 30,
6646: fs_report_rec.RESOURCE_VARIANCE_ACCOUNT);
6647: dbms_sql.column_value(l_cursor, 31,
6648: fs_report_rec.OUTSIDE_PROC_VARIANCE_ACCOUNT);
6649: dbms_sql.column_value(l_cursor, 32,
6650: fs_report_rec.STD_COST_ADJUSTMENT_ACCOUNT);
6651: dbms_sql.column_value(l_cursor, 33, fs_report_rec.OVERHEAD_ACCOUNT);
6652: dbms_sql.column_value(l_cursor, 34,
6653: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);

Line 6651: dbms_sql.column_value(l_cursor, 33, fs_report_rec.OVERHEAD_ACCOUNT);

6647: dbms_sql.column_value(l_cursor, 31,
6648: fs_report_rec.OUTSIDE_PROC_VARIANCE_ACCOUNT);
6649: dbms_sql.column_value(l_cursor, 32,
6650: fs_report_rec.STD_COST_ADJUSTMENT_ACCOUNT);
6651: dbms_sql.column_value(l_cursor, 33, fs_report_rec.OVERHEAD_ACCOUNT);
6652: dbms_sql.column_value(l_cursor, 34,
6653: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
6654: dbms_sql.column_value(l_cursor, 35, fs_report_rec.PROJECT_ID);
6655: dbms_sql.column_value(l_cursor, 36, fs_report_rec.TASK_ID);

Line 6652: dbms_sql.column_value(l_cursor, 34,

6648: fs_report_rec.OUTSIDE_PROC_VARIANCE_ACCOUNT);
6649: dbms_sql.column_value(l_cursor, 32,
6650: fs_report_rec.STD_COST_ADJUSTMENT_ACCOUNT);
6651: dbms_sql.column_value(l_cursor, 33, fs_report_rec.OVERHEAD_ACCOUNT);
6652: dbms_sql.column_value(l_cursor, 34,
6653: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
6654: dbms_sql.column_value(l_cursor, 35, fs_report_rec.PROJECT_ID);
6655: dbms_sql.column_value(l_cursor, 36, fs_report_rec.TASK_ID);
6656: dbms_sql.column_value(l_cursor, 37, fs_report_rec.ATTRIBUTE_CATEGORY);

Line 6654: dbms_sql.column_value(l_cursor, 35, fs_report_rec.PROJECT_ID);

6650: fs_report_rec.STD_COST_ADJUSTMENT_ACCOUNT);
6651: dbms_sql.column_value(l_cursor, 33, fs_report_rec.OVERHEAD_ACCOUNT);
6652: dbms_sql.column_value(l_cursor, 34,
6653: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
6654: dbms_sql.column_value(l_cursor, 35, fs_report_rec.PROJECT_ID);
6655: dbms_sql.column_value(l_cursor, 36, fs_report_rec.TASK_ID);
6656: dbms_sql.column_value(l_cursor, 37, fs_report_rec.ATTRIBUTE_CATEGORY);
6657: dbms_sql.column_value(l_cursor, 38, fs_report_rec.ATTRIBUTE1);
6658: dbms_sql.column_value(l_cursor, 39, fs_report_rec.ATTRIBUTE2);

Line 6655: dbms_sql.column_value(l_cursor, 36, fs_report_rec.TASK_ID);

6651: dbms_sql.column_value(l_cursor, 33, fs_report_rec.OVERHEAD_ACCOUNT);
6652: dbms_sql.column_value(l_cursor, 34,
6653: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
6654: dbms_sql.column_value(l_cursor, 35, fs_report_rec.PROJECT_ID);
6655: dbms_sql.column_value(l_cursor, 36, fs_report_rec.TASK_ID);
6656: dbms_sql.column_value(l_cursor, 37, fs_report_rec.ATTRIBUTE_CATEGORY);
6657: dbms_sql.column_value(l_cursor, 38, fs_report_rec.ATTRIBUTE1);
6658: dbms_sql.column_value(l_cursor, 39, fs_report_rec.ATTRIBUTE2);
6659: dbms_sql.column_value(l_cursor, 40, fs_report_rec.ATTRIBUTE3);

Line 6656: dbms_sql.column_value(l_cursor, 37, fs_report_rec.ATTRIBUTE_CATEGORY);

6652: dbms_sql.column_value(l_cursor, 34,
6653: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
6654: dbms_sql.column_value(l_cursor, 35, fs_report_rec.PROJECT_ID);
6655: dbms_sql.column_value(l_cursor, 36, fs_report_rec.TASK_ID);
6656: dbms_sql.column_value(l_cursor, 37, fs_report_rec.ATTRIBUTE_CATEGORY);
6657: dbms_sql.column_value(l_cursor, 38, fs_report_rec.ATTRIBUTE1);
6658: dbms_sql.column_value(l_cursor, 39, fs_report_rec.ATTRIBUTE2);
6659: dbms_sql.column_value(l_cursor, 40, fs_report_rec.ATTRIBUTE3);
6660: dbms_sql.column_value(l_cursor, 41, fs_report_rec.ATTRIBUTE4);

Line 6657: dbms_sql.column_value(l_cursor, 38, fs_report_rec.ATTRIBUTE1);

6653: fs_report_rec.OVERHEAD_VARIANCE_ACCOUNT);
6654: dbms_sql.column_value(l_cursor, 35, fs_report_rec.PROJECT_ID);
6655: dbms_sql.column_value(l_cursor, 36, fs_report_rec.TASK_ID);
6656: dbms_sql.column_value(l_cursor, 37, fs_report_rec.ATTRIBUTE_CATEGORY);
6657: dbms_sql.column_value(l_cursor, 38, fs_report_rec.ATTRIBUTE1);
6658: dbms_sql.column_value(l_cursor, 39, fs_report_rec.ATTRIBUTE2);
6659: dbms_sql.column_value(l_cursor, 40, fs_report_rec.ATTRIBUTE3);
6660: dbms_sql.column_value(l_cursor, 41, fs_report_rec.ATTRIBUTE4);
6661: dbms_sql.column_value(l_cursor, 42, fs_report_rec.ATTRIBUTE5);

Line 6658: dbms_sql.column_value(l_cursor, 39, fs_report_rec.ATTRIBUTE2);

6654: dbms_sql.column_value(l_cursor, 35, fs_report_rec.PROJECT_ID);
6655: dbms_sql.column_value(l_cursor, 36, fs_report_rec.TASK_ID);
6656: dbms_sql.column_value(l_cursor, 37, fs_report_rec.ATTRIBUTE_CATEGORY);
6657: dbms_sql.column_value(l_cursor, 38, fs_report_rec.ATTRIBUTE1);
6658: dbms_sql.column_value(l_cursor, 39, fs_report_rec.ATTRIBUTE2);
6659: dbms_sql.column_value(l_cursor, 40, fs_report_rec.ATTRIBUTE3);
6660: dbms_sql.column_value(l_cursor, 41, fs_report_rec.ATTRIBUTE4);
6661: dbms_sql.column_value(l_cursor, 42, fs_report_rec.ATTRIBUTE5);
6662: dbms_sql.column_value(l_cursor, 43, fs_report_rec.ATTRIBUTE6);

Line 6659: dbms_sql.column_value(l_cursor, 40, fs_report_rec.ATTRIBUTE3);

6655: dbms_sql.column_value(l_cursor, 36, fs_report_rec.TASK_ID);
6656: dbms_sql.column_value(l_cursor, 37, fs_report_rec.ATTRIBUTE_CATEGORY);
6657: dbms_sql.column_value(l_cursor, 38, fs_report_rec.ATTRIBUTE1);
6658: dbms_sql.column_value(l_cursor, 39, fs_report_rec.ATTRIBUTE2);
6659: dbms_sql.column_value(l_cursor, 40, fs_report_rec.ATTRIBUTE3);
6660: dbms_sql.column_value(l_cursor, 41, fs_report_rec.ATTRIBUTE4);
6661: dbms_sql.column_value(l_cursor, 42, fs_report_rec.ATTRIBUTE5);
6662: dbms_sql.column_value(l_cursor, 43, fs_report_rec.ATTRIBUTE6);
6663: dbms_sql.column_value(l_cursor, 44, fs_report_rec.ATTRIBUTE7);

Line 6660: dbms_sql.column_value(l_cursor, 41, fs_report_rec.ATTRIBUTE4);

6656: dbms_sql.column_value(l_cursor, 37, fs_report_rec.ATTRIBUTE_CATEGORY);
6657: dbms_sql.column_value(l_cursor, 38, fs_report_rec.ATTRIBUTE1);
6658: dbms_sql.column_value(l_cursor, 39, fs_report_rec.ATTRIBUTE2);
6659: dbms_sql.column_value(l_cursor, 40, fs_report_rec.ATTRIBUTE3);
6660: dbms_sql.column_value(l_cursor, 41, fs_report_rec.ATTRIBUTE4);
6661: dbms_sql.column_value(l_cursor, 42, fs_report_rec.ATTRIBUTE5);
6662: dbms_sql.column_value(l_cursor, 43, fs_report_rec.ATTRIBUTE6);
6663: dbms_sql.column_value(l_cursor, 44, fs_report_rec.ATTRIBUTE7);
6664: dbms_sql.column_value(l_cursor, 45, fs_report_rec.ATTRIBUTE8);

Line 6661: dbms_sql.column_value(l_cursor, 42, fs_report_rec.ATTRIBUTE5);

6657: dbms_sql.column_value(l_cursor, 38, fs_report_rec.ATTRIBUTE1);
6658: dbms_sql.column_value(l_cursor, 39, fs_report_rec.ATTRIBUTE2);
6659: dbms_sql.column_value(l_cursor, 40, fs_report_rec.ATTRIBUTE3);
6660: dbms_sql.column_value(l_cursor, 41, fs_report_rec.ATTRIBUTE4);
6661: dbms_sql.column_value(l_cursor, 42, fs_report_rec.ATTRIBUTE5);
6662: dbms_sql.column_value(l_cursor, 43, fs_report_rec.ATTRIBUTE6);
6663: dbms_sql.column_value(l_cursor, 44, fs_report_rec.ATTRIBUTE7);
6664: dbms_sql.column_value(l_cursor, 45, fs_report_rec.ATTRIBUTE8);
6665: dbms_sql.column_value(l_cursor, 46, fs_report_rec.ATTRIBUTE9);

Line 6662: dbms_sql.column_value(l_cursor, 43, fs_report_rec.ATTRIBUTE6);

6658: dbms_sql.column_value(l_cursor, 39, fs_report_rec.ATTRIBUTE2);
6659: dbms_sql.column_value(l_cursor, 40, fs_report_rec.ATTRIBUTE3);
6660: dbms_sql.column_value(l_cursor, 41, fs_report_rec.ATTRIBUTE4);
6661: dbms_sql.column_value(l_cursor, 42, fs_report_rec.ATTRIBUTE5);
6662: dbms_sql.column_value(l_cursor, 43, fs_report_rec.ATTRIBUTE6);
6663: dbms_sql.column_value(l_cursor, 44, fs_report_rec.ATTRIBUTE7);
6664: dbms_sql.column_value(l_cursor, 45, fs_report_rec.ATTRIBUTE8);
6665: dbms_sql.column_value(l_cursor, 46, fs_report_rec.ATTRIBUTE9);
6666: dbms_sql.column_value(l_cursor, 47, fs_report_rec.ATTRIBUTE10);

Line 6663: dbms_sql.column_value(l_cursor, 44, fs_report_rec.ATTRIBUTE7);

6659: dbms_sql.column_value(l_cursor, 40, fs_report_rec.ATTRIBUTE3);
6660: dbms_sql.column_value(l_cursor, 41, fs_report_rec.ATTRIBUTE4);
6661: dbms_sql.column_value(l_cursor, 42, fs_report_rec.ATTRIBUTE5);
6662: dbms_sql.column_value(l_cursor, 43, fs_report_rec.ATTRIBUTE6);
6663: dbms_sql.column_value(l_cursor, 44, fs_report_rec.ATTRIBUTE7);
6664: dbms_sql.column_value(l_cursor, 45, fs_report_rec.ATTRIBUTE8);
6665: dbms_sql.column_value(l_cursor, 46, fs_report_rec.ATTRIBUTE9);
6666: dbms_sql.column_value(l_cursor, 47, fs_report_rec.ATTRIBUTE10);
6667: dbms_sql.column_value(l_cursor, 48, fs_report_rec.ATTRIBUTE11);

Line 6664: dbms_sql.column_value(l_cursor, 45, fs_report_rec.ATTRIBUTE8);

6660: dbms_sql.column_value(l_cursor, 41, fs_report_rec.ATTRIBUTE4);
6661: dbms_sql.column_value(l_cursor, 42, fs_report_rec.ATTRIBUTE5);
6662: dbms_sql.column_value(l_cursor, 43, fs_report_rec.ATTRIBUTE6);
6663: dbms_sql.column_value(l_cursor, 44, fs_report_rec.ATTRIBUTE7);
6664: dbms_sql.column_value(l_cursor, 45, fs_report_rec.ATTRIBUTE8);
6665: dbms_sql.column_value(l_cursor, 46, fs_report_rec.ATTRIBUTE9);
6666: dbms_sql.column_value(l_cursor, 47, fs_report_rec.ATTRIBUTE10);
6667: dbms_sql.column_value(l_cursor, 48, fs_report_rec.ATTRIBUTE11);
6668: dbms_sql.column_value(l_cursor, 49, fs_report_rec.ATTRIBUTE12);

Line 6665: dbms_sql.column_value(l_cursor, 46, fs_report_rec.ATTRIBUTE9);

6661: dbms_sql.column_value(l_cursor, 42, fs_report_rec.ATTRIBUTE5);
6662: dbms_sql.column_value(l_cursor, 43, fs_report_rec.ATTRIBUTE6);
6663: dbms_sql.column_value(l_cursor, 44, fs_report_rec.ATTRIBUTE7);
6664: dbms_sql.column_value(l_cursor, 45, fs_report_rec.ATTRIBUTE8);
6665: dbms_sql.column_value(l_cursor, 46, fs_report_rec.ATTRIBUTE9);
6666: dbms_sql.column_value(l_cursor, 47, fs_report_rec.ATTRIBUTE10);
6667: dbms_sql.column_value(l_cursor, 48, fs_report_rec.ATTRIBUTE11);
6668: dbms_sql.column_value(l_cursor, 49, fs_report_rec.ATTRIBUTE12);
6669: dbms_sql.column_value(l_cursor, 50, fs_report_rec.ATTRIBUTE13);

Line 6666: dbms_sql.column_value(l_cursor, 47, fs_report_rec.ATTRIBUTE10);

6662: dbms_sql.column_value(l_cursor, 43, fs_report_rec.ATTRIBUTE6);
6663: dbms_sql.column_value(l_cursor, 44, fs_report_rec.ATTRIBUTE7);
6664: dbms_sql.column_value(l_cursor, 45, fs_report_rec.ATTRIBUTE8);
6665: dbms_sql.column_value(l_cursor, 46, fs_report_rec.ATTRIBUTE9);
6666: dbms_sql.column_value(l_cursor, 47, fs_report_rec.ATTRIBUTE10);
6667: dbms_sql.column_value(l_cursor, 48, fs_report_rec.ATTRIBUTE11);
6668: dbms_sql.column_value(l_cursor, 49, fs_report_rec.ATTRIBUTE12);
6669: dbms_sql.column_value(l_cursor, 50, fs_report_rec.ATTRIBUTE13);
6670: dbms_sql.column_value(l_cursor, 51, fs_report_rec.ATTRIBUTE14);

Line 6667: dbms_sql.column_value(l_cursor, 48, fs_report_rec.ATTRIBUTE11);

6663: dbms_sql.column_value(l_cursor, 44, fs_report_rec.ATTRIBUTE7);
6664: dbms_sql.column_value(l_cursor, 45, fs_report_rec.ATTRIBUTE8);
6665: dbms_sql.column_value(l_cursor, 46, fs_report_rec.ATTRIBUTE9);
6666: dbms_sql.column_value(l_cursor, 47, fs_report_rec.ATTRIBUTE10);
6667: dbms_sql.column_value(l_cursor, 48, fs_report_rec.ATTRIBUTE11);
6668: dbms_sql.column_value(l_cursor, 49, fs_report_rec.ATTRIBUTE12);
6669: dbms_sql.column_value(l_cursor, 50, fs_report_rec.ATTRIBUTE13);
6670: dbms_sql.column_value(l_cursor, 51, fs_report_rec.ATTRIBUTE14);
6671: dbms_sql.column_value(l_cursor, 52, fs_report_rec.ATTRIBUTE15);

Line 6668: dbms_sql.column_value(l_cursor, 49, fs_report_rec.ATTRIBUTE12);

6664: dbms_sql.column_value(l_cursor, 45, fs_report_rec.ATTRIBUTE8);
6665: dbms_sql.column_value(l_cursor, 46, fs_report_rec.ATTRIBUTE9);
6666: dbms_sql.column_value(l_cursor, 47, fs_report_rec.ATTRIBUTE10);
6667: dbms_sql.column_value(l_cursor, 48, fs_report_rec.ATTRIBUTE11);
6668: dbms_sql.column_value(l_cursor, 49, fs_report_rec.ATTRIBUTE12);
6669: dbms_sql.column_value(l_cursor, 50, fs_report_rec.ATTRIBUTE13);
6670: dbms_sql.column_value(l_cursor, 51, fs_report_rec.ATTRIBUTE14);
6671: dbms_sql.column_value(l_cursor, 52, fs_report_rec.ATTRIBUTE15);
6672: dbms_sql.column_value(l_cursor, 53, fs_report_rec.KANBAN_CARD_ID);

Line 6669: dbms_sql.column_value(l_cursor, 50, fs_report_rec.ATTRIBUTE13);

6665: dbms_sql.column_value(l_cursor, 46, fs_report_rec.ATTRIBUTE9);
6666: dbms_sql.column_value(l_cursor, 47, fs_report_rec.ATTRIBUTE10);
6667: dbms_sql.column_value(l_cursor, 48, fs_report_rec.ATTRIBUTE11);
6668: dbms_sql.column_value(l_cursor, 49, fs_report_rec.ATTRIBUTE12);
6669: dbms_sql.column_value(l_cursor, 50, fs_report_rec.ATTRIBUTE13);
6670: dbms_sql.column_value(l_cursor, 51, fs_report_rec.ATTRIBUTE14);
6671: dbms_sql.column_value(l_cursor, 52, fs_report_rec.ATTRIBUTE15);
6672: dbms_sql.column_value(l_cursor, 53, fs_report_rec.KANBAN_CARD_ID);
6673: dbms_sql.column_value(l_cursor, 54, fs_report_rec.END_ITEM_UNIT_NUMBER);

Line 6670: dbms_sql.column_value(l_cursor, 51, fs_report_rec.ATTRIBUTE14);

6666: dbms_sql.column_value(l_cursor, 47, fs_report_rec.ATTRIBUTE10);
6667: dbms_sql.column_value(l_cursor, 48, fs_report_rec.ATTRIBUTE11);
6668: dbms_sql.column_value(l_cursor, 49, fs_report_rec.ATTRIBUTE12);
6669: dbms_sql.column_value(l_cursor, 50, fs_report_rec.ATTRIBUTE13);
6670: dbms_sql.column_value(l_cursor, 51, fs_report_rec.ATTRIBUTE14);
6671: dbms_sql.column_value(l_cursor, 52, fs_report_rec.ATTRIBUTE15);
6672: dbms_sql.column_value(l_cursor, 53, fs_report_rec.KANBAN_CARD_ID);
6673: dbms_sql.column_value(l_cursor, 54, fs_report_rec.END_ITEM_UNIT_NUMBER);
6674: dbms_sql.column_value(l_cursor, 55, fs_report_rec.CURRENT_LINE_OPERATION);

Line 6671: dbms_sql.column_value(l_cursor, 52, fs_report_rec.ATTRIBUTE15);

6667: dbms_sql.column_value(l_cursor, 48, fs_report_rec.ATTRIBUTE11);
6668: dbms_sql.column_value(l_cursor, 49, fs_report_rec.ATTRIBUTE12);
6669: dbms_sql.column_value(l_cursor, 50, fs_report_rec.ATTRIBUTE13);
6670: dbms_sql.column_value(l_cursor, 51, fs_report_rec.ATTRIBUTE14);
6671: dbms_sql.column_value(l_cursor, 52, fs_report_rec.ATTRIBUTE15);
6672: dbms_sql.column_value(l_cursor, 53, fs_report_rec.KANBAN_CARD_ID);
6673: dbms_sql.column_value(l_cursor, 54, fs_report_rec.END_ITEM_UNIT_NUMBER);
6674: dbms_sql.column_value(l_cursor, 55, fs_report_rec.CURRENT_LINE_OPERATION);
6675: dbms_sql.column_value(l_cursor, 56, fs_report_rec.WIP_ENTITY_ID);

Line 6672: dbms_sql.column_value(l_cursor, 53, fs_report_rec.KANBAN_CARD_ID);

6668: dbms_sql.column_value(l_cursor, 49, fs_report_rec.ATTRIBUTE12);
6669: dbms_sql.column_value(l_cursor, 50, fs_report_rec.ATTRIBUTE13);
6670: dbms_sql.column_value(l_cursor, 51, fs_report_rec.ATTRIBUTE14);
6671: dbms_sql.column_value(l_cursor, 52, fs_report_rec.ATTRIBUTE15);
6672: dbms_sql.column_value(l_cursor, 53, fs_report_rec.KANBAN_CARD_ID);
6673: dbms_sql.column_value(l_cursor, 54, fs_report_rec.END_ITEM_UNIT_NUMBER);
6674: dbms_sql.column_value(l_cursor, 55, fs_report_rec.CURRENT_LINE_OPERATION);
6675: dbms_sql.column_value(l_cursor, 56, fs_report_rec.WIP_ENTITY_ID);
6676:

Line 6673: dbms_sql.column_value(l_cursor, 54, fs_report_rec.END_ITEM_UNIT_NUMBER);

6669: dbms_sql.column_value(l_cursor, 50, fs_report_rec.ATTRIBUTE13);
6670: dbms_sql.column_value(l_cursor, 51, fs_report_rec.ATTRIBUTE14);
6671: dbms_sql.column_value(l_cursor, 52, fs_report_rec.ATTRIBUTE15);
6672: dbms_sql.column_value(l_cursor, 53, fs_report_rec.KANBAN_CARD_ID);
6673: dbms_sql.column_value(l_cursor, 54, fs_report_rec.END_ITEM_UNIT_NUMBER);
6674: dbms_sql.column_value(l_cursor, 55, fs_report_rec.CURRENT_LINE_OPERATION);
6675: dbms_sql.column_value(l_cursor, 56, fs_report_rec.WIP_ENTITY_ID);
6676:
6677: END IF;

Line 6674: dbms_sql.column_value(l_cursor, 55, fs_report_rec.CURRENT_LINE_OPERATION);

6670: dbms_sql.column_value(l_cursor, 51, fs_report_rec.ATTRIBUTE14);
6671: dbms_sql.column_value(l_cursor, 52, fs_report_rec.ATTRIBUTE15);
6672: dbms_sql.column_value(l_cursor, 53, fs_report_rec.KANBAN_CARD_ID);
6673: dbms_sql.column_value(l_cursor, 54, fs_report_rec.END_ITEM_UNIT_NUMBER);
6674: dbms_sql.column_value(l_cursor, 55, fs_report_rec.CURRENT_LINE_OPERATION);
6675: dbms_sql.column_value(l_cursor, 56, fs_report_rec.WIP_ENTITY_ID);
6676:
6677: END IF;
6678:

Line 6675: dbms_sql.column_value(l_cursor, 56, fs_report_rec.WIP_ENTITY_ID);

6671: dbms_sql.column_value(l_cursor, 52, fs_report_rec.ATTRIBUTE15);
6672: dbms_sql.column_value(l_cursor, 53, fs_report_rec.KANBAN_CARD_ID);
6673: dbms_sql.column_value(l_cursor, 54, fs_report_rec.END_ITEM_UNIT_NUMBER);
6674: dbms_sql.column_value(l_cursor, 55, fs_report_rec.CURRENT_LINE_OPERATION);
6675: dbms_sql.column_value(l_cursor, 56, fs_report_rec.WIP_ENTITY_ID);
6676:
6677: END IF;
6678:
6679: /*---------------------------------------------------------+

Line 7089: l_rows := dbms_sql.fetch_rows(l_cursor);

7085: RAISE unexpected_error;
7086: END IF;
7087:
7088: LOOP
7089: l_rows := dbms_sql.fetch_rows(l_cursor);
7090: IF l_rows > 0 THEN
7091: dbms_sql.column_value(l_cursor, 1, l_flow_schedule_rec.wip_entity_id);
7092: END IF;
7093: EXIT WHEN l_rows = 0;

Line 7091: dbms_sql.column_value(l_cursor, 1, l_flow_schedule_rec.wip_entity_id);

7087:
7088: LOOP
7089: l_rows := dbms_sql.fetch_rows(l_cursor);
7090: IF l_rows > 0 THEN
7091: dbms_sql.column_value(l_cursor, 1, l_flow_schedule_rec.wip_entity_id);
7092: END IF;
7093: EXIT WHEN l_rows = 0;
7094: UPDATE wip_flow_schedules SET status = 2,
7095: date_closed = flm_timezone.sysdate00_in_server --fix bug#3170105

Line 7102: IF (dbms_sql.is_open(l_cursor)) THEN

7098: l_flow_schedule_rec.wip_entity_id));
7099: END LOOP;
7100: END IF;
7101:
7102: IF (dbms_sql.is_open(l_cursor)) THEN
7103: dbms_sql.close_cursor(l_cursor);
7104: END IF;
7105: IF p_spread_qty = 3 THEN
7106: RETURN;

Line 7103: dbms_sql.close_cursor(l_cursor);

7099: END LOOP;
7100: END IF;
7101:
7102: IF (dbms_sql.is_open(l_cursor)) THEN
7103: dbms_sql.close_cursor(l_cursor);
7104: END IF;
7105: IF p_spread_qty = 3 THEN
7106: RETURN;
7107: END IF;