DBA Data[Home] [Help]

APPS.MSC_ATP_PUB dependencies on MRP_AP_REFRESH_S

Line 1223: SELECT mrp_ap_refresh_s.nextval

1219:
1220: END IF;
1221:
1222: MSC_ATP_PVT.G_CALLING_MODULE := NVL(l_atp_rec.Calling_Module(1), -99);
1223: SELECT mrp_ap_refresh_s.nextval
1224: INTO l_refresh_number
1225: FROM dual;
1226:
1227: --s_cto_rearch: 24x7

Line 2294: /* SELECT mrp_ap_refresh_s.nextval

2290:
2291: RETURN;
2292: END IF;
2293:
2294: /* SELECT mrp_ap_refresh_s.nextval
2295: INTO l_refresh_number
2296: FROM dual;
2297:
2298: --s_cto_rearch: 24x7

Line 2614: SELECT DECODE( NVL(l_summary_flag, 'N'), 'Y', mrp_ap_refresh_s.nextval, (NVL(lrn, -1) +1))

2610: IF p_atp_rec.calling_module.count > 0 and
2611: nvl(p_atp_rec.attribute_02(1), -1) <> 3 and
2612: nvl(p_atp_rec.calling_module(1), -1) <> 724 THEN --web service call
2613:
2614: SELECT DECODE( NVL(l_summary_flag, 'N'), 'Y', mrp_ap_refresh_s.nextval, (NVL(lrn, -1) +1))
2615: INTO l_end_refresh_number
2616: FROM mrp_ap_apps_instances;
2617: END IF;
2618: