APPS.MSC_GET_GANTT_DATA dependencies on MSC_FORM_QUERY_S

Line 3117: select msc_form_query_s.nextval

3113: if g_find_query_id is not null then
3114: delete msc_form_query
3115: where query_id = g_find_query_id;
3116: else
3117: select msc_form_query_s.nextval
3118: into g_find_query_id
3119: from dual;
3120: end if;
3121: OPEN resource_cursor FOR sql_statement

Line 3990: select msc_form_query_s.nextval

3986: -- find the end_pegging_id
3987:
3988: if g_end_demand_id is not null then
3989:
3990: select msc_form_query_s.nextval
3991: into p_end_peg_query_id
3992: from dual;
3993:
3994: insert into msc_form_query

Line 4048: select msc_form_query_s.nextval

4044: end if;
4045: -- populate op seq num from msc_resource_requirements to msc_form_query
4046:
4047: if p_op_seq_query_id is null then
4048: select msc_form_query_s.nextval
4049: into p_op_seq_query_id
4050: from dual;
4051: end if;
4052: if p_critical <> -1 then

Line 4162: select msc_form_query_s.nextval

4158:
4159: -- populate the children to msc_form_query
4160:
4161: if p_query_id is null then
4162: select msc_form_query_s.nextval
4163: into p_query_id
4164: from dual;
4165: end if;
4166:

Line 4170: select msc_form_query_s.nextval

4166:
4167: -- get the end_pegging_id
4168: if g_end_demand_id is null then
4169:
4170: select msc_form_query_s.nextval
4171: into p_end_peg_query_id
4172: from dual;
4173:
4174: insert into msc_form_query

Line 5036: select msc_form_query_s.nextval

5032: if g_supply_query_id is not null then
5033: delete msc_form_query
5034: where query_id = g_supply_query_id;
5035: else
5036: select msc_form_query_s.nextval
5037: into g_supply_query_id
5038: from dual;
5039: end if;
5040:

Line 5045: select msc_form_query_s.nextval

5041: if g_res_query_id is not null then
5042: delete msc_form_query
5043: where query_id = g_res_query_id;
5044: else
5045: select msc_form_query_s.nextval
5046: into g_res_query_id
5047: from dual;
5048: end if;
5049:

Line 5831: select msc_form_query_s.nextval

5827: if g_supply_query_id is not null then
5828: delete msc_form_query
5829: where query_id = g_supply_query_id;
5830: else
5831: select msc_form_query_s.nextval
5832: into g_supply_query_id
5833: from dual;
5834: end if;
5835: -- for resource centric view

Line 5840: select msc_form_query_s.nextval

5836: if g_res_query_id is not null then
5837: delete msc_form_query
5838: where query_id = g_res_query_id;
5839: else
5840: select msc_form_query_s.nextval
5841: into g_res_query_id
5842: from dual;
5843: end if;
5844: -- for supplier list

Line 5849: select msc_form_query_s.nextval

5845: if g_supplier_query_id is not null then
5846: delete msc_form_query
5847: where query_id = g_supplier_query_id;
5848: else
5849: select msc_form_query_s.nextval
5850: into g_supplier_query_id
5851: from dual;
5852: end if;
5853: