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 3666: l_cursor := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 3718: dbms_sql.close_cursor(l_cursor);

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

Line 4363: l_cursor_name := dbms_sql.open_cursor;

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

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

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

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

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

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

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

Line 4529: l_cursor_name := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4733: l_cursor_name := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4747: dbms_sql.define_column(l_cursor_name, 7,

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

Line 4749: dbms_sql.define_column(l_cursor_name, 8,

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 4759: dbms_sql.define_column(l_cursor_name, 15,

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

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

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

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

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

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

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

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

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

Line 4765: dbms_sql.define_column(l_cursor_name, 20,

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

Line 4767: dbms_sql.define_column(l_cursor_name, 21,

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

Line 4769: dbms_sql.define_column(l_cursor_name, 22,

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

Line 4771: dbms_sql.define_column(l_cursor_name, 23,

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

Line 4773: dbms_sql.define_column(l_cursor_name, 24,

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

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

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

Line 4776: dbms_sql.define_column(l_cursor_name, 26,

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

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

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

Line 4779: dbms_sql.define_column(l_cursor_name, 28,

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

Line 4781: dbms_sql.define_column(l_cursor_name, 29,

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

Line 4783: dbms_sql.define_column(l_cursor_name, 30,

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

Line 4785: dbms_sql.define_column(l_cursor_name, 31,

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

Line 4787: dbms_sql.define_column(l_cursor_name, 32,

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

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

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

Line 4790: dbms_sql.define_column(l_cursor_name, 34,

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

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

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

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

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

Line 4794: dbms_sql.define_column(l_cursor_name, 37,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5062: l_cursor_name := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 6630: dbms_sql.column_value(l_cursor, 20,

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

Line 6632: dbms_sql.column_value(l_cursor, 21,

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

Line 6634: dbms_sql.column_value(l_cursor, 22,

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

Line 6636: dbms_sql.column_value(l_cursor, 23,

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

Line 6638: dbms_sql.column_value(l_cursor, 24,

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

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

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

Line 6641: dbms_sql.column_value(l_cursor, 26,

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

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

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

Line 6644: dbms_sql.column_value(l_cursor, 28,

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

Line 6646: dbms_sql.column_value(l_cursor, 29,

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

Line 6648: dbms_sql.column_value(l_cursor, 30,

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

Line 6650: dbms_sql.column_value(l_cursor, 31,

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

Line 6652: dbms_sql.column_value(l_cursor, 32,

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

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

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

Line 6655: dbms_sql.column_value(l_cursor, 34,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

7110: RAISE unexpected_error;
7111: END IF;
7112:
7113: LOOP
7114: l_rows := dbms_sql.fetch_rows(l_cursor);
7115: IF l_rows > 0 THEN
7116: dbms_sql.column_value(l_cursor, 1, l_flow_schedule_rec.wip_entity_id);
7117: END IF;
7118: EXIT WHEN l_rows = 0;

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

7112:
7113: LOOP
7114: l_rows := dbms_sql.fetch_rows(l_cursor);
7115: IF l_rows > 0 THEN
7116: dbms_sql.column_value(l_cursor, 1, l_flow_schedule_rec.wip_entity_id);
7117: END IF;
7118: EXIT WHEN l_rows = 0;
7119: UPDATE wip_flow_schedules SET status = 2,
7120: date_closed = flm_timezone.sysdate00_in_server --fix bug#3170105

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

7123: l_flow_schedule_rec.wip_entity_id));
7124: END LOOP;
7125: END IF;
7126:
7127: IF (dbms_sql.is_open(l_cursor)) THEN
7128: dbms_sql.close_cursor(l_cursor);
7129: END IF;
7130: IF p_spread_qty = 3 THEN
7131: RETURN;

Line 7128: dbms_sql.close_cursor(l_cursor);

7124: END LOOP;
7125: END IF;
7126:
7127: IF (dbms_sql.is_open(l_cursor)) THEN
7128: dbms_sql.close_cursor(l_cursor);
7129: END IF;
7130: IF p_spread_qty = 3 THEN
7131: RETURN;
7132: END IF;