[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);
4460: l_profile_name(9) := 'MSC_ATP_CHECK_INT_SALES_ORDERS'; --6485306
4461: l_profile_name(10) := 'MSC_ENHANCED_FORWARD_ATP'; --optional_fw
4462:
4463: FOR j in 1..l_count LOOP
4464: INSERT INTO msc_atp_src_profile_temp
4465: (
4466: session_id,
4467: profile_name,
4468: profile_value,
4501:
4502: /*--------------------------------------------------------------------------
4503: | Begin Procedure get_src_to_dstn_profiles added for supporting Multiple
4504: | allocation enh -3940999 Inserts values of profiles at destination by
4505: | reading them from table msc_atp_src_profile_temp at source.
4506: +-------------------------------------------------------------------------*/
4507:
4508: PROCEDURE get_src_to_dstn_profiles(
4509: p_dblink IN VARCHAR2,
4529:
4530: l_dynstring := '@'||p_dblink;
4531: l_user_id := FND_GLOBAL.USER_ID;
4532:
4533: -- Delete records from msc_atp_src_profile_temp in case there are any records
4534: -- with similar session id.
4535: Delete from msc_atp_src_profile_temp where session_id = p_session_id;
4536:
4537: IF PG_DEBUG in ('Y', 'C') THEN
4531: l_user_id := FND_GLOBAL.USER_ID;
4532:
4533: -- Delete records from msc_atp_src_profile_temp in case there are any records
4534: -- with similar session id.
4535: Delete from msc_atp_src_profile_temp where session_id = p_session_id;
4536:
4537: IF PG_DEBUG in ('Y', 'C') THEN
4538: msc_sch_wb.atp_debug('***** After Deleting data for old session ****');
4539: msc_sch_wb.atp_debug('get_src_to_dstn_profiles: ' || 'Number of rows deleted ' || SQL%ROWCOUNT);
4539: msc_sch_wb.atp_debug('get_src_to_dstn_profiles: ' || 'Number of rows deleted ' || SQL%ROWCOUNT);
4540: END IF;
4541:
4542: l_sql_stmt :=
4543: 'Insert into msc_atp_src_profile_temp
4544: (session_id,
4545: profile_name,
4546: profile_value,
4547: creation_date,
4560: last_update_date,
4561: last_updated_by,
4562: last_update_login';
4563:
4564: l_sql_stmt := l_sql_stmt || ' from msc_atp_src_profile_temp' || l_dynstring ||
4565: ' where session_id = :p_session_id';
4566:
4567: EXECUTE IMMEDIATE l_sql_stmt USING p_session_id;
4568:
4566:
4567: EXECUTE IMMEDIATE l_sql_stmt USING p_session_id;
4568:
4569: IF PG_DEBUG in ('Y', 'C') THEN
4570: msc_sch_wb.atp_debug('After Inserting the profiles in msc_atp_src_profile_temp');
4571: msc_sch_wb.atp_debug('l_sql_stmt= ' || l_sql_stmt);
4572: msc_sch_wb.atp_debug('rows inserted = ' || SQL%ROWCOUNT);
4573: END IF;
4574: