[Home] [Help]
1159:
1160: l_error_exists boolean := false;
1161: l_maximum_assigned_units number;
1162: l_dummy2 VARCHAR2(1);
1163: l_params wip_logger.param_tbl_t;
1164: l_check NUMBER:=0;
1165:
1166: cursor c_invalid_rows is
1167: select interface_id
1232: end if;
1233: end if;
1234: EXCEPTION
1235: WHEN NO_DATA_FOUND THEN
1236: wip_logger.log('Error in the call to WOR',l_dummy2);
1237: for wor_rec in (select * from wip_operation_resources where wip_entity_id = p_wip_entity_id
1238: and organization_id = p_organization_id order by operation_seq_num,resource_seq_num) loop
1239: wip_logger.log('Operation Seq_num: '||wor_rec.operation_seq_num||',resource_seq_num='||wor_rec.resource_seq_num||',maximum_assigned_units= '||wor_rec.maximum_assigned_units,l_dummy2);
1240: end loop;
1235: WHEN NO_DATA_FOUND THEN
1236: wip_logger.log('Error in the call to WOR',l_dummy2);
1237: for wor_rec in (select * from wip_operation_resources where wip_entity_id = p_wip_entity_id
1238: and organization_id = p_organization_id order by operation_seq_num,resource_seq_num) loop
1239: wip_logger.log('Operation Seq_num: '||wor_rec.operation_seq_num||',resource_seq_num='||wor_rec.resource_seq_num||',maximum_assigned_units= '||wor_rec.maximum_assigned_units,l_dummy2);
1240: end loop;
1241: raise;
1242: END;
1243: */
1760: l_sub_group_num number;
1761: l_repl_group_num number;
1762: l_dummy2 VARCHAR2(1);
1763: l_logLevel number;
1764: l_params wip_logger.param_tbl_t;
1765:
1766: CURSOR res_info (p_group_id number,
1767: p_wip_entity_id number,
1768: p_organization_id number,
2851: sub_group NUMBER;
2852: repl_group NUMBER;
2853: l_res_sub number := 0;
2854: l_dummy2 VARCHAR2(1);
2855: l_params wip_logger.param_tbl_t;
2856: BEGIN
2857:
2858: for sched_row in sched_rows loop
2859: