APPS.MSC_ATP_PUB dependencies on MSC_ATP_SRC_PROFILE_TEMP

Line 2227: DELETE msc_atp_src_profile_temp

2223: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);
2224: END IF;
2225:
2226: --bug3940999 Delete temp records before exiting
2227: DELETE msc_atp_src_profile_temp
2228: WHERE session_id = p_session_id;
2229:
2230: IF PG_DEBUG in ('Y', 'C') THEN
2231: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_atp_src_profile_temp : '||sql%rowcount);

Line 2231: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_atp_src_profile_temp : '||sql%rowcount);

2227: DELETE msc_atp_src_profile_temp
2228: WHERE session_id = p_session_id;
2229:
2230: IF PG_DEBUG in ('Y', 'C') THEN
2231: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_atp_src_profile_temp : '||sql%rowcount);
2232: END IF;
2233:
2234: -- No ATP needed as No ATPable item or CTO model in the ATP request from source.
2235:

Line 2671: delete from msc_atp_src_profile_temp where session_id = p_session_id;

2667: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2668: END IF;
2669:
2670: --bug3940999 Delete temp records before exiting
2671: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2672:
2673: IF PG_DEBUG in ('Y', 'C') THEN
2674: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2675: msc_sch_wb.atp_debug('End Call_ATP_No_Commit');

Line 2674: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);

2670: --bug3940999 Delete temp records before exiting
2671: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2672:
2673: IF PG_DEBUG in ('Y', 'C') THEN
2674: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2675: msc_sch_wb.atp_debug('End Call_ATP_No_Commit');
2676: END IF;
2677:
2678: IF G_CALL_ATP = 2 THEN --4421391

Line 2741: delete from msc_atp_src_profile_temp where session_id = p_session_id;

2737: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2738: END IF;
2739:
2740: --bug3940999 Delete temp records before exiting
2741: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2742: IF PG_DEBUG in ('Y', 'C') THEN
2743: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2744: END IF;
2745:

Line 2743: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);

2739:
2740: --bug3940999 Delete temp records before exiting
2741: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2742: IF PG_DEBUG in ('Y', 'C') THEN
2743: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2744: END IF;
2745:
2746: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2747: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Call_ATP_No_Commit');

Line 2794: delete from msc_atp_src_profile_temp where session_id = p_session_id;

2790: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2791: END IF;
2792:
2793: --bug3940999 Delete temp records before exiting
2794: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2795: IF PG_DEBUG in ('Y', 'C') THEN
2796: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2797: END IF;
2798:

Line 2796: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);

2792:
2793: --bug3940999 Delete temp records before exiting
2794: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2795: IF PG_DEBUG in ('Y', 'C') THEN
2796: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2797: END IF;
2798:
2799: --ATP Debug Workflow, atp debug changes.
2800: