APPS.MSC_GANTT_UTILS dependencies on MSC_EXCEPTION_DETAILS

Line 1033: from msc_exception_details

1029: p_transaction_id number) return number is
1030:
1031: cursor c_53 is
1032: select 'EXISTS'
1033: from msc_exception_details
1034: where number1 = p_transaction_id
1035: and sr_instance_id = p_instance_id
1036: and plan_id = p_plan_id
1037: and exception_type = 53

Line 1077: from msc_exception_details

1073: -- one exception in any date-range)
1074: --------------------------------------------------------
1075: cursor resource_constraint_cur is
1076: select 'EXISTS'
1077: from msc_exception_details
1078: where number1 = p_transaction_id
1079: and sr_instance_id = p_instance_id
1080: and plan_id = p_plan_id
1081: and exception_type =36

Line 1109: from msc_exception_details

1105: p_department_id number, p_resource_id number, p_exception_type number) return number is
1106:
1107: cursor c_excp is
1108: select 'EXISTS'
1109: from msc_exception_details
1110: where plan_id = p_plan_id
1111: and sr_instance_id = p_instance_id
1112: and organization_id = p_organization_id
1113: and department_id = p_department_id

Line 1661: from msc_exception_details

1657: p_inventory_item_id number, p_transaction_id number) return number is
1658:
1659: cursor c is
1660: select 1
1661: from msc_exception_details
1662: where number1 = p_transaction_id
1663: and sr_instance_id = p_instance_id
1664: and plan_id = p_plan_id
1665: and exception_type =36

Line 4899: ' msc_exception_details med '||

4895: elsif p_from_block = 'EXCEPTION' then
4896: sql_stat := 'SELECT mrr.sr_instance_id, '||
4897: ' mrr.transaction_id '||
4898: ' FROM msc_supplies mrr, '||
4899: ' msc_exception_details med '||
4900: ' WHERE mrr.plan_id = '||p_plan_id ||
4901: ' and mrr.plan_id = med.plan_id '||
4902: ' and ( (mrr.transaction_id = med.number1 and '||
4903: ' med.exception_type in (6,7,8,9,10,32,34,53,54,58))'||

Line 4909: ' msc_exception_details med '||

4905: ' med.exception_type = 37)) '|| p_where ||
4906: ' union select mrr.sr_instance_id, '||
4907: ' mrr.supply_id transaction_id '||
4908: ' FROM msc_resource_requirements mrr, '||
4909: ' msc_exception_details med '||
4910: ' where med.exception_type in (21,22,36,45,46) '||
4911: ' AND med.plan_id = mrr.plan_id ' ||
4912: ' AND med.organization_id = mrr.organization_id ' ||
4913: ' AND med.sr_instance_id = mrr.sr_instance_id ' ||

Line 4961: ' msc_exception_details med ' ||

4957: ' mrr.department_id, '||
4958: ' mrr.resource_id '||
4959: ' FROM msc_resource_requirements mrr, ' ||
4960: ' msc_department_resources mdr, ' ||
4961: ' msc_exception_details med ' ||
4962: ' WHERE mrr.plan_id = :1 '||
4963: ' AND mdr.plan_id = mrr.plan_id '||
4964: ' AND mdr.organization_id = mrr.organization_id ' ||
4965: ' AND mdr.sr_instance_id = mrr.sr_instance_id'||