APPS.MSC_IMPORT_UTIL dependencies on MSC_UTIL

Line 255: -- msc_util.msc_debug('in init i='||i);

251:
252: i := 8;
253: loop
254: l_count:=0;
255: -- msc_util.msc_debug('in init i='||i);
256: open c_lov_type_count(g_attr_name(i));
257: fetch c_lov_type_count into l_count;
258: close c_lov_type_count;
259: -- msc_util.msc_debug('l_count:'||l_count);

Line 259: -- msc_util.msc_debug('l_count:'||l_count);

255: -- msc_util.msc_debug('in init i='||i);
256: open c_lov_type_count(g_attr_name(i));
257: fetch c_lov_type_count into l_count;
258: close c_lov_type_count;
259: -- msc_util.msc_debug('l_count:'||l_count);
260: if l_count=0 then
261: g_attr_type(i) := 2;
262: g_sql_stmt(i) := null;
263: else

Line 497: msc_util.msc_debug('In update proc.. '||g_attr_val(1)||'-'||g_attr_val(2));

493:
494: i number;
495: l_upd_attr_count number :=0;
496: begin
497: msc_util.msc_debug('In update proc.. '||g_attr_val(1)||'-'||g_attr_val(2));
498: open c_get_simset_id(g_attr_val(1));
499: fetch c_get_simset_id into l_sim_set_id;
500: close c_get_simset_id;
501: msc_util.msc_debug('sim set id'||l_sim_set_id);

Line 501: msc_util.msc_debug('sim set id'||l_sim_set_id);

497: msc_util.msc_debug('In update proc.. '||g_attr_val(1)||'-'||g_attr_val(2));
498: open c_get_simset_id(g_attr_val(1));
499: fetch c_get_simset_id into l_sim_set_id;
500: close c_get_simset_id;
501: msc_util.msc_debug('sim set id'||l_sim_set_id);
502: if l_sim_set_id is null then
503: msc_util.msc_debug('Simulation Set Name:'||g_attr_val(1)||' doesnt exist');
504: return;
505: end if;

Line 503: msc_util.msc_debug('Simulation Set Name:'||g_attr_val(1)||' doesnt exist');

499: fetch c_get_simset_id into l_sim_set_id;
500: close c_get_simset_id;
501: msc_util.msc_debug('sim set id'||l_sim_set_id);
502: if l_sim_set_id is null then
503: msc_util.msc_debug('Simulation Set Name:'||g_attr_val(1)||' doesnt exist');
504: return;
505: end if;
506:
507: open c_get_org_id(g_attr_val(3));

Line 510: msc_util.msc_debug('org id'||l_org_id);

506:
507: open c_get_org_id(g_attr_val(3));
508: fetch c_get_org_id into l_org_id;
509: close c_get_org_id;
510: msc_util.msc_debug('org id'||l_org_id);
511: if l_org_id is null then
512: msc_util.msc_debug('Organization Code:'||g_attr_val(3)||' doesnt exist');
513: return;
514: end if;

Line 512: msc_util.msc_debug('Organization Code:'||g_attr_val(3)||' doesnt exist');

508: fetch c_get_org_id into l_org_id;
509: close c_get_org_id;
510: msc_util.msc_debug('org id'||l_org_id);
511: if l_org_id is null then
512: msc_util.msc_debug('Organization Code:'||g_attr_val(3)||' doesnt exist');
513: return;
514: end if;
515:
516: open c_get_inst_id(g_attr_val(4));

Line 521: msc_util.msc_debug('Sr Instance Code:'||g_attr_val(4)||' doesnt exist');

517: fetch c_get_inst_id into l_inst_id;
518: close c_get_inst_id;
519:
520: if l_inst_id is null then
521: msc_util.msc_debug('Sr Instance Code:'||g_attr_val(4)||' doesnt exist');
522: return;
523: end if;
524:
525: open c_get_item_id(g_attr_val(2),l_org_id,l_inst_id);

Line 528: msc_util.msc_debug('item id'||l_item_id);

524:
525: open c_get_item_id(g_attr_val(2),l_org_id,l_inst_id);
526: fetch c_get_item_id into l_item_id;
527: close c_get_item_id;
528: msc_util.msc_debug('item id'||l_item_id);
529: if l_item_id is null then
530: msc_util.msc_debug('Item name:'||g_attr_val(2)||' doesnt exist');
531: return;
532: end if;

Line 530: msc_util.msc_debug('Item name:'||g_attr_val(2)||' doesnt exist');

526: fetch c_get_item_id into l_item_id;
527: close c_get_item_id;
528: msc_util.msc_debug('item id'||l_item_id);
529: if l_item_id is null then
530: msc_util.msc_debug('Item name:'||g_attr_val(2)||' doesnt exist');
531: return;
532: end if;
533:
534: open c_get_zone_id(g_attr_val(5),l_inst_id);

Line 537: msc_util.msc_debug('zone id:'||l_zone_id);

533:
534: open c_get_zone_id(g_attr_val(5),l_inst_id);
535: fetch c_get_zone_id into l_zone_id;
536: close c_get_zone_id;
537: msc_util.msc_debug('zone id:'||l_zone_id);
538:
539: open c_get_customer_id(g_attr_val(6),l_inst_id);
540: fetch c_get_customer_id into l_cust_id;
541: close c_get_customer_id;

Line 542: msc_util.msc_debug('cust id:'||l_cust_id);

538:
539: open c_get_customer_id(g_attr_val(6),l_inst_id);
540: fetch c_get_customer_id into l_cust_id;
541: close c_get_customer_id;
542: msc_util.msc_debug('cust id:'||l_cust_id);
543:
544: open c_get_cust_site_id(l_cust_id,l_inst_id,g_attr_val(7));
545: fetch c_get_cust_site_id into l_site_id;
546: close c_get_cust_site_id;

Line 547: msc_util.msc_debug('site id:'||l_site_id);

543:
544: open c_get_cust_site_id(l_cust_id,l_inst_id,g_attr_val(7));
545: fetch c_get_cust_site_id into l_site_id;
546: close c_get_cust_site_id;
547: msc_util.msc_debug('site id:'||l_site_id);
548:
549: if(l_zone_id is not null and l_cust_id is not null) then
550: msc_util.msc_debug('Both zone and customer value were provided for record with simulation set name,item name:'||g_attr_val(1)||','||g_attr_val(2));
551: return;

Line 550: msc_util.msc_debug('Both zone and customer value were provided for record with simulation set name,item name:'||g_attr_val(1)||','||g_attr_val(2));

546: close c_get_cust_site_id;
547: msc_util.msc_debug('site id:'||l_site_id);
548:
549: if(l_zone_id is not null and l_cust_id is not null) then
550: msc_util.msc_debug('Both zone and customer value were provided for record with simulation set name,item name:'||g_attr_val(1)||','||g_attr_val(2));
551: return;
552: end if;
553:
554: if(l_zone_id is not null) then

Line 560: msc_util.msc_debug('Attribute '||g_attr_name(i)||' is not updateable at zone level.');

556: if g_attr_val(i) is not null then
557: Open c_chk_attr('MSC_REGION_UPDATE_ATTRIBUTES',g_attr_name(i));
558: fetch c_chk_attr into l_temp;
559: if c_chk_attr%notfound then
560: msc_util.msc_debug('Attribute '||g_attr_name(i)||' is not updateable at zone level.');
561: close c_chk_attr;
562: return;
563: end if;
564: close c_chk_attr;

Line 576: msc_util.msc_debug('Attribute '||g_attr_name(i)||' is not updateable at Customer level.');

572: if g_attr_val(i) is not null then
573: Open c_chk_attr('MSC_CUST_UPDATE_ATTRIBUTES',g_attr_name(i));
574: fetch c_chk_attr into l_temp;
575: if c_chk_attr%notfound then
576: msc_util.msc_debug('Attribute '||g_attr_name(i)||' is not updateable at Customer level.');
577: close c_chk_attr;
578: return;
579: end if;
580: close c_chk_attr;

Line 593: msc_util.msc_debug('l_dest_row_id:'||l_dest_rowid);

589: fetch c_get_dest_rowid into l_dest_rowid;
590: close c_get_dest_rowid;
591: end if;
592:
593: msc_util.msc_debug('l_dest_row_id:'||l_dest_rowid);
594: l_first := 1;
595: if l_dest_rowid is not null then -- row exists in msc_item_attributes
596:
597: l_update_stmt := 'update msc_item_attributes set ';

Line 598: msc_util.msc_debug('l_update_stmt:'||l_update_stmt);

594: l_first := 1;
595: if l_dest_rowid is not null then -- row exists in msc_item_attributes
596:
597: l_update_stmt := 'update msc_item_attributes set ';
598: msc_util.msc_debug('l_update_stmt:'||l_update_stmt);
599: i := 8;
600: loop
601: l_hidden := null;
602:

Line 603: -- -- msc_util.msc_debug('i,count'||i||':'||g_attr_name.count);

599: i := 8;
600: loop
601: l_hidden := null;
602:
603: -- -- msc_util.msc_debug('i,count'||i||':'||g_attr_name.count);
604: -- -- msc_util.msc_debug('type,val'||g_attr_type(i)||','||g_attr_val(i));
605: if(g_attr_val(i) is not null) then
606: if g_attr_type(i) in ( 1,6) then -- number,date
607: l_hidden := to_char(g_attr_val(i));

Line 604: -- -- msc_util.msc_debug('type,val'||g_attr_type(i)||','||g_attr_val(i));

600: loop
601: l_hidden := null;
602:
603: -- -- msc_util.msc_debug('i,count'||i||':'||g_attr_name.count);
604: -- -- msc_util.msc_debug('type,val'||g_attr_type(i)||','||g_attr_val(i));
605: if(g_attr_val(i) is not null) then
606: if g_attr_type(i) in ( 1,6) then -- number,date
607: l_hidden := to_char(g_attr_val(i));
608: if g_attr_type(i) = 6 THEN

Line 616: msc_util.msc_debug('sql stmt:'||l_sql);

612: elsif g_attr_type(i) = 2 then --char
613: if g_sql_stmt(i) is not null then
614: l_sql := 'select hidden,displayed from ('||g_sql_stmt(i)||') where displayed='||''''||g_attr_val(i)||'''';
615: l_sql := replace(l_sql,' display ',' displayed ');
616: msc_util.msc_debug('sql stmt:'||l_sql);
617: open c_attr_sql for l_sql;
618: fetch c_attr_sql into l_hidden,l_meaning;
619: close c_attr_sql;
620: else

Line 627: --msc_util.msc_debug('l_hidden,l_meaning:'||l_hidden||','||l_meaning);

623: -- following attributes are char columns in msc_item_attributes so add quotes to the value.
624: if g_attr_name(i) in ('PLANNING_EXCEPTION_SET','WEIGHT_UOM','VOLUME_UOM','ATP_FLAG','ATP_COMPONENTS_FLAG','ABC_CLASS_NAME','PLANNER_CODE','RELIABILITY','FAILURE_IMPACT','INTERARRIVAL_DIST_METHOD') then
625: l_hidden := ''''||l_hidden||'''';
626: end if;
627: --msc_util.msc_debug('l_hidden,l_meaning:'||l_hidden||','||l_meaning);
628:
629: else
630: null;
631: end if;

Line 634: msc_util.msc_debug('l_sql:'||l_sql);

630: null;
631: end if;
632: l_sql := 'select '||g_attr_name(i)||' from msc_item_attributes where rowid='||''''||l_dest_rowid||'''';
633:
634: msc_util.msc_debug('l_sql:'||l_sql);
635: open c_attr_sql for l_sql;
636: fetch c_attr_sql into l_old_val;
637: close c_attr_sql;
638:

Line 650: -- msc_util.msc_debug('l_update_stmt:'||l_update_stmt);

646: if l_old_val is null then
647: l_upd_attr_count := l_upd_attr_count+1;
648: end if;
649: end if;
650: -- msc_util.msc_debug('l_update_stmt:'||l_update_stmt);
651: if i=g_attr_name.count then
652: exit;
653: end if;
654: i:=i+1;

Line 658: msc_util.msc_debug('update stmt:'||l_update_stmt);

654: i:=i+1;
655: end loop;
656: l_update_stmt := l_update_stmt||',updated_columns_count=updated_columns_count+'||l_upd_attr_count;
657: l_update_stmt := l_update_stmt||' where rowid='||''''||l_dest_rowid||'''';
658: msc_util.msc_debug('update stmt:'||l_update_stmt);
659: msc_Get_name.execute_dsql(l_update_stmt);
660:
661: else -- dest row id is null so insert row into msc_item_attributes
662: l_zone_val := nvl(to_char(l_zone_id),'null');

Line 674: -- msc_util.msc_debug('i,count'||i||':'||g_attr_name.count);

670: i := 8;
671:
672: loop
673: l_hidden := null;
674: -- msc_util.msc_debug('i,count'||i||':'||g_attr_name.count);
675: -- msc_util.msc_debug('type,val'||g_attr_type(i)||','||g_attr_val(i));
676: if g_attr_val(i) is not null then
677: if g_attr_type(i) in ( 1,6) then -- number,date
678: l_hidden := g_attr_val(i);

Line 675: -- msc_util.msc_debug('type,val'||g_attr_type(i)||','||g_attr_val(i));

671:
672: loop
673: l_hidden := null;
674: -- msc_util.msc_debug('i,count'||i||':'||g_attr_name.count);
675: -- msc_util.msc_debug('type,val'||g_attr_type(i)||','||g_attr_val(i));
676: if g_attr_val(i) is not null then
677: if g_attr_type(i) in ( 1,6) then -- number,date
678: l_hidden := g_attr_val(i);
679: if g_attr_type(i) = 6 THEN

Line 688: msc_util.msc_debug('sql stmt:'||l_sql);

684: --build a dynamic sql attaching meaning and get hidden value
685: if g_sql_stmt(i) is not null then
686: l_sql := 'select hidden,displayed from ('||g_sql_stmt(i)||') where displayed='||''''||g_attr_val(i)||'''';
687: l_sql := replace(l_sql,' display ',' displayed ');
688: msc_util.msc_debug('sql stmt:'||l_sql);
689: open c_attr_sql for l_sql;
690: fetch c_attr_sql into l_hidden,l_meaning;
691: close c_attr_sql;
692: else

Line 700: --msc_util.msc_debug('l_hidden,l_meaning:'||l_hidden||','||l_meaning);

696: if g_attr_name(i) in ('PLANNING_EXCEPTION_SET','WEIGHT_UOM','VOLUME_UOM','ATP_FLAG','ATP_COMPONENTS_FLAG','ABC_CLASS_NAME',
697: 'PLANNER_CODE','RELIABILITY','FAILURE_IMPACT','INTERARRIVAL_DIST_METHOD') then
698: l_hidden := ''''||l_hidden||'''';
699: end if;
700: --msc_util.msc_debug('l_hidden,l_meaning:'||l_hidden||','||l_meaning);
701:
702: else
703: null;
704: end if;

Line 709: -- msc_util.msc_debug('l_insert_stmt:'||l_insert_stmt);

705: l_insert_cols := l_insert_cols||','||g_attr_name(i);
706: l_insert_vals := l_insert_vals||','||l_hidden;
707: l_upd_attr_count := l_upd_attr_count+1;
708: end if;
709: -- msc_util.msc_debug('l_insert_stmt:'||l_insert_stmt);
710: if i=g_attr_name.count then
711: exit;
712: end if;
713: i:=i+1;

Line 716: msc_util.msc_debug('insert stmt:'||l_insert_stmt);

712: end if;
713: i:=i+1;
714: end loop;
715: l_insert_stmt := l_insert_stmt||'('||l_insert_cols||',updated_columns_count) values ('||l_insert_vals||','||l_upd_attr_count||')';
716: msc_util.msc_debug('insert stmt:'||l_insert_stmt);
717: msc_Get_name.execute_dsql(l_insert_stmt);
718: end if;
719:
720: delete from msc_st_item_attributes where rowid=stg_rec_rowid;

Line 1092: msc_util.msc_debug('Staging table name:'||stg_tbl);

1088:
1089: exc_load_fail EXCEPTION;
1090:
1091: BEGIN
1092: msc_util.msc_debug('Staging table name:'||stg_tbl);
1093: msc_util.msc_debug('Req Id of File Loader is:'||req_id);
1094:
1095: if stg_tbl='MSC_ST_ITEM_ATTRIBUTES' then
1096: open c_max_req_id;

Line 1093: msc_util.msc_debug('Req Id of File Loader is:'||req_id);

1089: exc_load_fail EXCEPTION;
1090:
1091: BEGIN
1092: msc_util.msc_debug('Staging table name:'||stg_tbl);
1093: msc_util.msc_debug('Req Id of File Loader is:'||req_id);
1094:
1095: if stg_tbl='MSC_ST_ITEM_ATTRIBUTES' then
1096: open c_max_req_id;
1097: fetch c_max_req_id into l_req_id;

Line 1101: msc_util.msc_debug('No records in staging table MSC_ST_ITEM_ATTRIBUTES');

1097: fetch c_max_req_id into l_req_id;
1098: close c_max_req_id;
1099:
1100: if l_req_id is null then
1101: msc_util.msc_debug('No records in staging table MSC_ST_ITEM_ATTRIBUTES');
1102: return;
1103: end if;
1104:
1105: open c_imm_stg_rec_count(l_req_id);

Line 1109: msc_util.msc_debug('No. of records in staging table:'||l_stg_rec_count);

1105: open c_imm_stg_rec_count(l_req_id);
1106: fetch c_imm_stg_rec_count into l_stg_rec_count;
1107: close c_imm_stg_rec_count;
1108:
1109: msc_util.msc_debug('No. of records in staging table:'||l_stg_rec_count);
1110:
1111: if l_stg_rec_count = 0 then
1112: msc_util.msc_debug('No rows available in MSC_ST_ITEM_ATTRIBUTES');
1113: raise exc_load_fail;

Line 1112: msc_util.msc_debug('No rows available in MSC_ST_ITEM_ATTRIBUTES');

1108:
1109: msc_util.msc_debug('No. of records in staging table:'||l_stg_rec_count);
1110:
1111: if l_stg_rec_count = 0 then
1112: msc_util.msc_debug('No rows available in MSC_ST_ITEM_ATTRIBUTES');
1113: raise exc_load_fail;
1114: end if;
1115: init; -- This will prepare attribute_names, lov_type, sql_stmt list
1116:

Line 1129: --msc_util.msc_debug('l_sql_stmt='||l_sql_stmt);

1125: i:=i+1;
1126: end loop;
1127:
1128: l_sql_stmt := l_sql_stmt||' from msc_st_item_attributes' ;
1129: --msc_util.msc_debug('l_sql_stmt='||l_sql_stmt);
1130: */
1131:
1132:
1133: msc_util.msc_debug('Max Request Id :'||l_req_id);

Line 1133: msc_util.msc_debug('Max Request Id :'||l_req_id);

1129: --msc_util.msc_debug('l_sql_stmt='||l_sql_stmt);
1130: */
1131:
1132:
1133: msc_util.msc_debug('Max Request Id :'||l_req_id);
1134:
1135: open c_imm_stg(l_req_id);
1136: loop
1137: fetch c_imm_stg into l_imm_stg_rec;

Line 1139: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);

1135: open c_imm_stg(l_req_id);
1136: loop
1137: fetch c_imm_stg into l_imm_stg_rec;
1138: exit when c_imm_stg%NOTFOUND;
1139: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1140: set_attr_val(l_imm_stg_rec); -- This copies the attribute values of a record into g_attr_val list
1141: msc_util.msc_debug('after set_attr_val');
1142: update_record_to_db(l_imm_stg_rec.rowid);
1143: msc_util.msc_debug('after update_record_to_db');

Line 1141: msc_util.msc_debug('after set_attr_val');

1137: fetch c_imm_stg into l_imm_stg_rec;
1138: exit when c_imm_stg%NOTFOUND;
1139: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1140: set_attr_val(l_imm_stg_rec); -- This copies the attribute values of a record into g_attr_val list
1141: msc_util.msc_debug('after set_attr_val');
1142: update_record_to_db(l_imm_stg_rec.rowid);
1143: msc_util.msc_debug('after update_record_to_db');
1144: commit;
1145: --msc_util.msc_debug('Fetching values---------------');

Line 1143: msc_util.msc_debug('after update_record_to_db');

1139: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1140: set_attr_val(l_imm_stg_rec); -- This copies the attribute values of a record into g_attr_val list
1141: msc_util.msc_debug('after set_attr_val');
1142: update_record_to_db(l_imm_stg_rec.rowid);
1143: msc_util.msc_debug('after update_record_to_db');
1144: commit;
1145: --msc_util.msc_debug('Fetching values---------------');
1146: --msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1147: end loop;

Line 1145: --msc_util.msc_debug('Fetching values---------------');

1141: msc_util.msc_debug('after set_attr_val');
1142: update_record_to_db(l_imm_stg_rec.rowid);
1143: msc_util.msc_debug('after update_record_to_db');
1144: commit;
1145: --msc_util.msc_debug('Fetching values---------------');
1146: --msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1147: end loop;
1148: close c_imm_stg;
1149:

Line 1146: --msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);

1142: update_record_to_db(l_imm_stg_rec.rowid);
1143: msc_util.msc_debug('after update_record_to_db');
1144: commit;
1145: --msc_util.msc_debug('Fetching values---------------');
1146: --msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1147: end loop;
1148: close c_imm_stg;
1149:
1150: msc_util.msc_debug('=============================================');

Line 1150: msc_util.msc_debug('=============================================');

1146: --msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1147: end loop;
1148: close c_imm_stg;
1149:
1150: msc_util.msc_debug('=============================================');
1151: msc_util.msc_debug(l_stg_rec_count||' records inserted into staging table');
1152:
1153: open c_imm_stg_rec_count(l_req_id);
1154: fetch c_imm_stg_rec_count into l_stg_rec_count;

Line 1151: msc_util.msc_debug(l_stg_rec_count||' records inserted into staging table');

1147: end loop;
1148: close c_imm_stg;
1149:
1150: msc_util.msc_debug('=============================================');
1151: msc_util.msc_debug(l_stg_rec_count||' records inserted into staging table');
1152:
1153: open c_imm_stg_rec_count(l_req_id);
1154: fetch c_imm_stg_rec_count into l_stg_rec_count;
1155: close c_imm_stg_rec_count;

Line 1157: msc_util.msc_debug(l_stg_rec_count||' records not processed properly and not inserted/updated to IMM');

1153: open c_imm_stg_rec_count(l_req_id);
1154: fetch c_imm_stg_rec_count into l_stg_rec_count;
1155: close c_imm_stg_rec_count;
1156:
1157: msc_util.msc_debug(l_stg_rec_count||' records not processed properly and not inserted/updated to IMM');
1158: -- msc_util.msc_debug('Use the following sql to find out which rows are not processed and inserted/updated to IMM');
1159:
1160: /* open c_imm_stg_tbl for l_sql_stmt;
1161: loop

Line 1158: -- msc_util.msc_debug('Use the following sql to find out which rows are not processed and inserted/updated to IMM');

1154: fetch c_imm_stg_rec_count into l_stg_rec_count;
1155: close c_imm_stg_rec_count;
1156:
1157: msc_util.msc_debug(l_stg_rec_count||' records not processed properly and not inserted/updated to IMM');
1158: -- msc_util.msc_debug('Use the following sql to find out which rows are not processed and inserted/updated to IMM');
1159:
1160: /* open c_imm_stg_tbl for l_sql_stmt;
1161: loop
1162: fetch c_imm_stg_tbl into l_imm_stg_rec;

Line 1164: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);

1160: /* open c_imm_stg_tbl for l_sql_stmt;
1161: loop
1162: fetch c_imm_stg_tbl into l_imm_stg_rec;
1163: exit when c_imm_stg%NOTFOUND;
1164: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1165: set_attr_val(l_imm_stg_rec); -- This copies the attribute values of a record into g_attr_val list
1166: msc_util.msc_debug('after set_attr_val');
1167: update_record_to_db(l_imm_stg_rec.rowid);
1168: msc_util.msc_debug('after update_record_to_db');

Line 1166: msc_util.msc_debug('after set_attr_val');

1162: fetch c_imm_stg_tbl into l_imm_stg_rec;
1163: exit when c_imm_stg%NOTFOUND;
1164: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1165: set_attr_val(l_imm_stg_rec); -- This copies the attribute values of a record into g_attr_val list
1166: msc_util.msc_debug('after set_attr_val');
1167: update_record_to_db(l_imm_stg_rec.rowid);
1168: msc_util.msc_debug('after update_record_to_db');
1169: commit;
1170: msc_util.msc_debug('Fetching values---------------');

Line 1168: msc_util.msc_debug('after update_record_to_db');

1164: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1165: set_attr_val(l_imm_stg_rec); -- This copies the attribute values of a record into g_attr_val list
1166: msc_util.msc_debug('after set_attr_val');
1167: update_record_to_db(l_imm_stg_rec.rowid);
1168: msc_util.msc_debug('after update_record_to_db');
1169: commit;
1170: msc_util.msc_debug('Fetching values---------------');
1171: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1172: end loop;

Line 1170: msc_util.msc_debug('Fetching values---------------');

1166: msc_util.msc_debug('after set_attr_val');
1167: update_record_to_db(l_imm_stg_rec.rowid);
1168: msc_util.msc_debug('after update_record_to_db');
1169: commit;
1170: msc_util.msc_debug('Fetching values---------------');
1171: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1172: end loop;
1173: close c_imm_stg_tbl;
1174: */

Line 1171: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);

1167: update_record_to_db(l_imm_stg_rec.rowid);
1168: msc_util.msc_debug('after update_record_to_db');
1169: commit;
1170: msc_util.msc_debug('Fetching values---------------');
1171: msc_util.msc_debug(l_imm_stg_rec.simulation_set_name);
1172: end loop;
1173: close c_imm_stg_tbl;
1174: */
1175: end if;