DBA Data[Home] [Help]

APPS.MSC_ATP_PUB dependencies on MSC_ATP_SRC_PROFILE_TEMP

Line 2198: DELETE msc_atp_src_profile_temp

2194: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_regions_temp : '||sql%rowcount);
2195: END IF;
2196:
2197: --bug3940999 Delete temp records before exiting
2198: DELETE msc_atp_src_profile_temp
2199: WHERE session_id = p_session_id;
2200:
2201: IF PG_DEBUG in ('Y', 'C') THEN
2202: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_atp_src_profile_temp : '||sql%rowcount);

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

2198: DELETE msc_atp_src_profile_temp
2199: WHERE session_id = p_session_id;
2200:
2201: IF PG_DEBUG in ('Y', 'C') THEN
2202: msc_sch_wb.atp_debug('Call_ATP_No_Commit: ' || 'Rows deleted from msc_atp_src_profile_temp : '||sql%rowcount);
2203: END IF;
2204:
2205: -- No ATP needed as No ATPable item or CTO model in the ATP request from source.
2206:

Line 2637: delete from msc_atp_src_profile_temp where session_id = p_session_id;

2633: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2634: END IF;
2635:
2636: --bug3940999 Delete temp records before exiting
2637: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2638:
2639: IF PG_DEBUG in ('Y', 'C') THEN
2640: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2641: msc_sch_wb.atp_debug('End Call_ATP_No_Commit');

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

2636: --bug3940999 Delete temp records before exiting
2637: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2638:
2639: IF PG_DEBUG in ('Y', 'C') THEN
2640: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2641: msc_sch_wb.atp_debug('End Call_ATP_No_Commit');
2642: END IF;
2643:
2644: IF G_CALL_ATP = 2 THEN --4421391

Line 2707: delete from msc_atp_src_profile_temp where session_id = p_session_id;

2703: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2704: END IF;
2705:
2706: --bug3940999 Delete temp records before exiting
2707: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2708: IF PG_DEBUG in ('Y', 'C') THEN
2709: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2710: END IF;
2711:

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

2705:
2706: --bug3940999 Delete temp records before exiting
2707: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2708: IF PG_DEBUG in ('Y', 'C') THEN
2709: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2710: END IF;
2711:
2712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2713: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME , 'Call_ATP_No_Commit');

Line 2760: delete from msc_atp_src_profile_temp where session_id = p_session_id;

2756: msc_sch_wb.atp_debug('Rows deleted from msc_regions_temp:'|| sql%rowcount);
2757: END IF;
2758:
2759: --bug3940999 Delete temp records before exiting
2760: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2761: IF PG_DEBUG in ('Y', 'C') THEN
2762: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2763: END IF;
2764:

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

2758:
2759: --bug3940999 Delete temp records before exiting
2760: delete from msc_atp_src_profile_temp where session_id = p_session_id;
2761: IF PG_DEBUG in ('Y', 'C') THEN
2762: msc_sch_wb.atp_debug('Rows deleted from msc_atp_src_profile_temp:'|| sql%rowcount);
2763: END IF;
2764:
2765: --ATP Debug Workflow, atp debug changes.
2766: