[Home] [Help]
1126: l_avail_res_seq number;
1127:
1128: CURSOR res_seq IS
1129: Select distinct mors.resource_seq_num
1130: from msc_operation_resource_seqs mors
1131: where mors.plan_id = p_plan_id
1132: and mors.routing_sequence_id = l_rout_seq
1133: and mors.operation_sequence_id = l_op_seq
1134: and mors.sr_instance_id = p_instance_id
1216:
1217: -- find the activity_group_id
1218: select activity_group_id
1219: into l_act_group
1220: from msc_operation_resource_seqs
1221: where plan_id = p_plan_id
1222: and routing_sequence_id = l_rout_seq
1223: and operation_sequence_id = l_op_seq
1224: and resource_seq_num = l_res_seq
1239: select count(*)
1240: into l_avail_res_seq
1241: from (
1242: select distinct mors.resource_seq_num
1243: from msc_operation_resource_seqs mors,
1244: msc_operation_resources mor
1245: where mors.plan_id = p_plan_id
1246: and mors.sr_instance_id = p_instance_id
1247: and mors.operation_sequence_id = l_op_seq
1640: CURSOR activity_c IS
1641: select mors.activity_group_id,
1642: mrr.routing_sequence_id, mrr.operation_sequence_id,
1643: mrr.resource_seq_num
1644: from msc_operation_resource_seqs mors,
1645: msc_resource_requirements mrr
1646: where mrr.plan_id = p_plan_id
1647: and mrr.transaction_id = p_transaction_id
1648: and mrr.sr_instance_id = p_instance_id
1673: if l_act_group is not null then
1674: select count(*)
1675: into l_total_seqs
1676: from (Select distinct mors.resource_seq_num
1677: from msc_operation_resource_seqs mors
1678: where mors.plan_id = p_plan_id
1679: and mors.routing_sequence_id = l_rout_seq
1680: and mors.operation_sequence_id = l_op_seq
1681: and mors.sr_instance_id = p_instance_id
1695: select count(*)
1696: into l_avail_seqs
1697: from (
1698: select distinct mors.resource_seq_num
1699: from msc_operation_resource_seqs mors,
1700: msc_operation_resources mor
1701: where mors.plan_id = p_plan_id
1702: and mors.sr_instance_id = p_instance_id
1703: and mors.operation_sequence_id = l_op_seq