APPS.MSC_GANTT_PKG dependencies on MSC_GANTT_DTL_QUERY

Line 1921: msc_gantt_dtl_query mgdq,

1917: if (l_row_type = mbp_null_value) then
1918: select distinct mrr.sr_instance_id, mrr.organization_id, mrr.supply_id
1919: bulk collect into v_inst_id, v_org_id, v_trx_id
1920: from msc_gantt_query mgq,
1921: msc_gantt_dtl_query mgdq,
1922: msc_resource_requirements mrr
1923: where mgq.query_id = p_from_query_id
1924: and mgq.row_index = p_from_index
1925: and mgq.query_id = mgdq.query_id

Line 1939: msc_gantt_dtl_query mgdq,

1935: else
1936: select distinct mrir.sr_instance_id, mrir.organization_id, mrir.supply_id
1937: bulk collect into v_inst_id, v_org_id, v_trx_id
1938: from msc_gantt_query mgq,
1939: msc_gantt_dtl_query mgdq,
1940: msc_resource_instance_reqs mrir
1941: where mgq.query_id = p_from_query_id
1942: and mgq.row_index = p_from_index
1943: and mgq.query_id = mgdq.query_id

Line 1962: msc_gantt_dtl_query mgdq,

1958:
1959: select distinct mrr.sr_instance_id, mrr.organization_id, mrr.supply_id
1960: bulk collect into v_inst_id, v_org_id, v_trx_id
1961: from msc_gantt_query mgq,
1962: msc_gantt_dtl_query mgdq,
1963: msc_resource_requirements mrr
1964: where mgq.query_id = p_from_query_id
1965: and mgq.row_index = p_from_index
1966: and mgq.query_id = mgdq.query_id

Line 2079: delete from msc_gantt_dtl_query

2075: set is_fetched = SYS_NO,
2076: row_flag = SYS_NO
2077: where query_id = p_query_id;
2078:
2079: delete from msc_gantt_dtl_query
2080: where query_id = p_query_id;
2081:
2082: else
2083: update msc_gantt_query

Line 2088: delete from msc_gantt_dtl_query

2084: set is_fetched = SYS_NO,
2085: row_flag = SYS_NO
2086: where query_id = p_query_id;
2087:
2088: delete from msc_gantt_dtl_query
2089: where query_id = p_query_id;
2090:
2091: end if; -- }
2092:

Line 2163: delete from msc_gantt_dtl_query

2159: set is_fetched = SYS_NO,
2160: row_flag = SYS_NO
2161: where query_id = p_query_id;
2162:
2163: delete from msc_gantt_dtl_query
2164: where query_id = p_query_id;
2165: else
2166: update msc_gantt_query
2167: set is_fetched = SYS_NO,

Line 2171: delete from msc_gantt_dtl_query

2167: set is_fetched = SYS_NO,
2168: row_flag = SYS_NO
2169: where query_id = p_query_id;
2170:
2171: delete from msc_gantt_dtl_query
2172: where query_id = p_query_id;
2173: end if; -- }
2174:
2175: msc_gantt_utils.sendSupplierNames(p_query_id, p_from_index, p_to_index, p_name_data,