[Home] [Help]
55: IS
56: BEGIN
57: printLog('Procedure Clean_log : Begin');
58:
59: DELETE FROM ibe_migration_log
60: WHERE Migration_code = 'IBE_MINISITE_MIGRATION'
61: AND migration_mode = 'EVALUATE';
62:
63: printLog('Procedure Clean_log : End');
386:
387: printLog('Procedure Load_temp_table : p_override_minisite_flag = '||p_override_minisite_flag );
388: printLog('Procedure Load_tem_table: 1 or 3:' || l_append_condition);
389:
390: --Insert into ibe_migration_log
391: IF p_auto_defaulting_flag = '1' OR p_auto_defaulting_flag ='3' THEN
392: printLog('Procedure defaulting_flag : 1 or 3:');
393:
394: IF p_override_minisite_flag = 'Y' then
391: IF p_auto_defaulting_flag = '1' OR p_auto_defaulting_flag ='3' THEN
392: printLog('Procedure defaulting_flag : 1 or 3:');
393:
394: IF p_override_minisite_flag = 'Y' then
395: INSERT INTO IBE_MIGRATION_LOG (
396: mglog_id,
397: migration_code ,
398: migration_mode ,
399: run_sequence,
415: request_id ,
416: program_application_id,
417: program_id ,
418: program_update_date )
419: SELECT IBE_MIGRATION_LOG_S1.nextval,
420: 'IBE_MINISITE_MIGRATION',
421: 'EVALUATE',
422: 0,
423: a.quote_header_id,
459: AND qhdr.party_id = hp.party_id) a
460: where a.rank <= 1;
461: ELSE
462:
463: INSERT INTO IBE_MIGRATION_LOG (
464: mglog_id,
465: migration_code ,
466: migration_mode ,
467: run_sequence,
483: request_id ,
484: program_application_id,
485: program_id ,
486: program_update_date )
487: SELECT IBE_MIGRATION_LOG_S1.nextval,
488: 'IBE_MINISITE_MIGRATION',
489: 'EVALUATE',
490: 0,
491: a.quote_header_id,
534:
535: ELSE
536: IF p_override_minisite_flag = 'Y' then
537:
538: INSERT INTO IBE_MIGRATION_LOG
539: (mglog_id,
540: migration_code ,
541: migration_mode ,
542: run_sequence,
557: request_id ,
558: program_application_id,
559: program_id ,
560: program_update_date )
561: SELECT IBE_MIGRATION_LOG_S1.nextval,
562: 'IBE_MINISITE_MIGRATION',
563: 'EVALUATE',
564: 0,
565: qhdr.quote_header_id,
585: where (qhdr.quote_source_code like 'IStore%' OR qhdr.publish_flag = 'Y')
586: AND qhdr.party_id = hp.party_id ;
587: ELSE
588:
589: INSERT INTO IBE_MIGRATION_LOG
590: (mglog_id,
591: migration_code ,
592: migration_mode ,
593: run_sequence,
608: request_id ,
609: program_application_id,
610: program_id ,
611: program_update_date )
612: SELECT IBE_MIGRATION_LOG_S1.nextval,
613: 'IBE_MINISITE_MIGRATION',
614: 'EVALUATE',
615: 0,
616: qhdr.quote_header_id,
694: OPEN c_msite_org(crec.org_id);
695: FETCH c_msite_org into l_msite_from_org;
696: CLOSE c_msite_org;
697:
698: UPDATE ibe_migration_log
699: SET attribute6 = 'ORG',
700: attribute5 = l_msite_from_org
701: WHERE attribute5 is null
702: AND attribute_idx1 = crec.org_id
763:
764: IF l_msite_prof_check = 'Y' THEN
765:
766: FOR crec in c_get_priclist(p_party_type) LOOP
767: UPDATE ibe_migration_log
768: SET attribute6 = 'PRICE',
769: attribute5 = crec.msite_id
770: WHERE attribute5 IS NULL
771: AND attribute_idx2 = crec.price_list_id
822:
823: FOR i in v_mapping_tab.FIRST .. v_mapping_tab.LAST LOOP
824: IF v_mapping_tab.EXISTS(i) THEN
825:
826: UPDATE ibe_migration_log
827: SET attribute6 = 'MANUAL',
828: attribute5 = v_mapping_tab(i).minisite_id
829: WHERE attribute5 IS NULL
830: AND attribute_idx1 = v_mapping_tab(i).org_id
857: PROCEDURE update_quote (p_batch_size IN NUMBER) IS
858: CURSOR LogCursor IS
859: SELECT to_number(attribute1) header_id,
860: to_number(attribute5) minisite
861: FROM ibe_migration_log
862: WHERE migration_code = 'IBE_MINISITE_MIGRATION'
863: AND migration_mode = 'EVALUATE'
864: AND run_sequence = 0;
865:
966: printLog('Procedure log_updated_rows : Start');
967:
968: -- Delete all records which do not have the "NEW" minisite_id after applying the rules.
969:
970: DELETE FROM ibe_migration_log
971: WHERE attribute5 IS NULL
972: AND migration_code = 'IBE_MINISITE_MIGRATION'
973: AND migration_mode = 'EVALUATE';
974:
971: WHERE attribute5 IS NULL
972: AND migration_code = 'IBE_MINISITE_MIGRATION'
973: AND migration_mode = 'EVALUATE';
974:
975: select ibe_migration_log_s2.nextval into l_next_sequence from dual ;
976:
977: UPDATE ibe_migration_log
978: SET migration_mode = 'EXECUTE',
979: run_sequence = l_next_sequence
973: AND migration_mode = 'EVALUATE';
974:
975: select ibe_migration_log_s2.nextval into l_next_sequence from dual ;
976:
977: UPDATE ibe_migration_log
978: SET migration_mode = 'EXECUTE',
979: run_sequence = l_next_sequence
980: WHERE Migration_code = 'IBE_MINISITE_MIGRATION'
981: AND migration_mode = 'EVALUATE'
1016: l_temp_yesno VARCHAR2(200);
1017:
1018: CURSOR c_get_carts_count IS
1019: SELECT count(mlog.attribute1) cnt_cart,ou.organization_id,ou.name
1020: FROM ibe_migration_log mlog, hr_operating_units ou
1021: WHERE attribute5 is null
1022: AND mlog.attribute_idx1= ou.organization_id
1023: GROUP BY mlog.attribute_idx1, ou.organization_id,ou.name;
1024:
1041: l_cnt_org,
1042: l_cnt_manual,
1043: l_tot_found,
1044: l_tot_left
1045: FROM ibe_migration_log
1046: WHERE Migration_code = 'IBE_MINISITE_MIGRATION'
1047: AND migration_mode = 'EVALUATE'
1048: AND run_sequence = 0;
1049:
1386: END IF;
1387:
1388: IF p_running_mode = 'EVALUATE' THEN
1389: -- clean the temporary log table after reporting
1390: DELETE FROM ibe_migration_log
1391: WHERE Migration_code = 'IBE_MINISITE_MIGRATION'
1392: AND migration_mode = 'EVALUATE'
1393: AND run_sequence = 0
1394: AND attribute5 IS null;