APPS.MSC_IMPORT_UTIL dependencies on MSC_GET_NAME

Line 659: msc_Get_name.execute_dsql(l_update_stmt);

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');
663: l_cust_val := nvl(to_char(l_cust_id),'null');

Line 717: msc_Get_name.execute_dsql(l_insert_stmt);

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;
721: commit;

Line 872: msc_get_name.execute_dsql(l_sql);

868: 1||','||
869: 'sysdate'||','||
870: 1||')';
871:
872: msc_get_name.execute_dsql(l_sql);
873: commit;
874: else -- update existing row
875:
876: l_sql := 'select '||p_attr_name||',updated_columns_count from msc_item_attributes where rowid='||''''||l_rowid||'''';

Line 890: msc_get_name.execute_dsql(l_sql);

886:
887: l_sql := 'update msc_item_attributes set '||p_attr_name||'='||l_attr_val||',updated_columns_count='||l_upd_count||
888: ' where rowid='||''''||l_rowid||'''';
889:
890: msc_get_name.execute_dsql(l_sql);
891: commit;
892:
893: end if;
894:

Line 924: msc_get_name.execute_dsql(l_sql);

920:
921: l_sql := 'update msc_system_items set '||p_attr_name||'='||l_attr_val||
922: ' where plan_id='||p_plan_id||' and inventory_item_id ='||p_item_id||' and organization_id='||p_org_id||' and sr_instance_id='||p_sr_instance_id;
923:
924: msc_get_name.execute_dsql(l_sql);
925:
926: l_sql := 'update msc_supplies set applied=2,status=0'||
927: ' where plan_id='||p_plan_id||' and inventory_item_id ='||p_item_id||' and organization_id='||p_org_id||' and sr_instance_id='||p_sr_instance_id;
928:

Line 929: msc_get_name.execute_dsql(l_sql);

925:
926: l_sql := 'update msc_supplies set applied=2,status=0'||
927: ' where plan_id='||p_plan_id||' and inventory_item_id ='||p_item_id||' and organization_id='||p_org_id||' and sr_instance_id='||p_sr_instance_id;
928:
929: msc_get_name.execute_dsql(l_sql);
930:
931: l_sql := 'update msc_demands set applied=2,status=0'||
932: ' where plan_id='||p_plan_id||' and inventory_item_id ='||p_item_id||' and organization_id='||p_org_id||' and sr_instance_id='||p_sr_instance_id;
933:

Line 934: msc_get_name.execute_dsql(l_sql);

930:
931: l_sql := 'update msc_demands set applied=2,status=0'||
932: ' where plan_id='||p_plan_id||' and inventory_item_id ='||p_item_id||' and organization_id='||p_org_id||' and sr_instance_id='||p_sr_instance_id;
933:
934: msc_get_name.execute_dsql(l_sql);
935:
936: l_sql := 'update msc_supplier_capacities set applied=2,status=0'||
937: ' where plan_id='||p_plan_id||' and inventory_item_id ='||p_item_id||' and organization_id='||p_org_id||' and sr_instance_id='||p_sr_instance_id;
938:

Line 939: msc_get_name.execute_dsql(l_sql);

935:
936: l_sql := 'update msc_supplier_capacities set applied=2,status=0'||
937: ' where plan_id='||p_plan_id||' and inventory_item_id ='||p_item_id||' and organization_id='||p_org_id||' and sr_instance_id='||p_sr_instance_id;
938:
939: msc_get_name.execute_dsql(l_sql);
940: commit;
941:
942:
943: end modify_plan_item_attr;