[Home] [Help]
4412:
4413: /*--------------------------------------------------------------------------
4414: | Begin Procedure get_src_to_dstn_profiles added for supporting Multiple
4415: | allocation enh -3940999 Inserts values of profiles at source in table
4416: | msc_atp_src_profile_temp..
4417: +-------------------------------------------------------------------------*/
4418: PROCEDURE put_src_to_dstn_profiles(
4419: p_session_id IN NUMBER,
4420: x_return_status OUT NoCopy VARCHAR2
4438: msc_sch_wb.atp_debug('put_src_to_dstn_profiles: ' || 'p_session_id := ' || p_session_id);
4439: msc_sch_wb.atp_debug('put_src_to_dstn_profiles: ' || 'l_user_id := ' || l_user_id);
4440: END IF;
4441:
4442: -- Delete records from msc_atp_src_profile_temp in case there are any records
4443: -- with similar session id.
4444: Delete from msc_atp_src_profile_temp where session_id = p_session_id;
4445:
4446: IF PG_DEBUG in ('Y', 'C') THEN
4440: END IF;
4441:
4442: -- Delete records from msc_atp_src_profile_temp in case there are any records
4443: -- with similar session id.
4444: Delete from msc_atp_src_profile_temp where session_id = p_session_id;
4445:
4446: IF PG_DEBUG in ('Y', 'C') THEN
4447: msc_sch_wb.atp_debug('***** After Deleting data for old session ****');
4448: msc_sch_wb.atp_debug('put_src_to_dstn_profiles: ' || 'Number of rows deleted ' || SQL%ROWCOUNT);
4459: l_profile_name(8) := 'MSC_ZERO_ALLOC_PERC'; --6359986
4460: l_profile_name(9) := 'MSC_ATP_CHECK_INT_SALES_ORDERS'; --6485306
4461:
4462: FOR j in 1..l_count LOOP
4463: INSERT INTO msc_atp_src_profile_temp
4464: (
4465: session_id,
4466: profile_name,
4467: profile_value,
4500:
4501: /*--------------------------------------------------------------------------
4502: | Begin Procedure get_src_to_dstn_profiles added for supporting Multiple
4503: | allocation enh -3940999 Inserts values of profiles at destination by
4504: | reading them from table msc_atp_src_profile_temp at source.
4505: +-------------------------------------------------------------------------*/
4506:
4507: PROCEDURE get_src_to_dstn_profiles(
4508: p_dblink IN VARCHAR2,
4528:
4529: l_dynstring := '@'||p_dblink;
4530: l_user_id := FND_GLOBAL.USER_ID;
4531:
4532: -- Delete records from msc_atp_src_profile_temp in case there are any records
4533: -- with similar session id.
4534: Delete from msc_atp_src_profile_temp where session_id = p_session_id;
4535:
4536: IF PG_DEBUG in ('Y', 'C') THEN
4530: l_user_id := FND_GLOBAL.USER_ID;
4531:
4532: -- Delete records from msc_atp_src_profile_temp in case there are any records
4533: -- with similar session id.
4534: Delete from msc_atp_src_profile_temp where session_id = p_session_id;
4535:
4536: IF PG_DEBUG in ('Y', 'C') THEN
4537: msc_sch_wb.atp_debug('***** After Deleting data for old session ****');
4538: msc_sch_wb.atp_debug('get_src_to_dstn_profiles: ' || 'Number of rows deleted ' || SQL%ROWCOUNT);
4538: msc_sch_wb.atp_debug('get_src_to_dstn_profiles: ' || 'Number of rows deleted ' || SQL%ROWCOUNT);
4539: END IF;
4540:
4541: l_sql_stmt :=
4542: 'Insert into msc_atp_src_profile_temp
4543: (session_id,
4544: profile_name,
4545: profile_value,
4546: creation_date,
4559: last_update_date,
4560: last_updated_by,
4561: last_update_login';
4562:
4563: l_sql_stmt := l_sql_stmt || ' from msc_atp_src_profile_temp' || l_dynstring ||
4564: ' where session_id = :p_session_id';
4565:
4566: EXECUTE IMMEDIATE l_sql_stmt USING p_session_id;
4567:
4565:
4566: EXECUTE IMMEDIATE l_sql_stmt USING p_session_id;
4567:
4568: IF PG_DEBUG in ('Y', 'C') THEN
4569: msc_sch_wb.atp_debug('After Inserting the profiles in msc_atp_src_profile_temp');
4570: msc_sch_wb.atp_debug('l_sql_stmt= ' || l_sql_stmt);
4571: msc_sch_wb.atp_debug('rows inserted = ' || SQL%ROWCOUNT);
4572: END IF;
4573: